async function getUser(query) { const [user] = await knex('users') .select(['id', 'email', 'name', 'created_at']) .where(query) .limit(1); return user; }
describe('legacyListMap', () => { it('converts a legacy ID to the target ID correctly', done => { db.select().from('legacy_ids').limit(1).then(legacy => { const id = legacy[0].id; const target = legacy[0].target; legacyListMap(db, id).then(test => { expect(test).to.equal(target); done(); }); }); }); });
.where({ display: true, defunct: false }) .orderBy('added', 'desc') .limit(4) .then(lists => { test().end((err, res) => {
describe('Legacy list ID with fake token', () => { let id, target, test; before('fetch list data', done => { db.select().from('legacy_ids').limit(1).then(legacy => { id = legacy[0].id; target = legacy[0].target;
describe('GET Legacy ID', () => { let id, target, data; before('fetch list data', done => { db.select().from('legacy_ids').limit(1).then(legacy => { id = legacy[0].id; target = legacy[0].target; db.select().from('lists').where({ id: target }).limit(1).then(lists => { data = lists[0]; done(); }); }); }); it('returns the target list page', done => { const test = () => request().get(`/lists/${id}`); test().end((err, res) => { expect(res).to.have.status(200); expect(res).to.be.html; titleCheck(res, `${data.name} (${data.id}) - ${locale('site_name')} - ${locale('short_desc')}`); done(); }); }); });
if (count) { initData.msgCount = count.msgcount; initData.pageCount = Math.ceil(initData.msgCount / initData.limit); if (initData.currentPage > initData.pageCount) { initData.currentPage = 0; initData.offset = initData.limit * initData.currentPage; if (initData.offset < 0) { initData.offset = 0; initData.offsetEnd = initData.offset + initData.limit; console.timeEnd('init'); console.time('sql'); .limit(initData.limit) .offset(initData.offset) .then(rows => {
async function getUserForLoginData(email, password) { const [user] = await knex('users') .select() .where({ email }) .limit(1); if (!user) { return null; } const isPasswordValid = await bcrypt.compare(password, user.password); if (!isPasswordValid) { return null; } return { id: user.id, username: user.email, created_at: user.created_at, }; }
describe('Valid request', () => { let id, test; before('fetch valid list id', done => { db.select('id').from('lists').limit(1).then(lists => { id = lists[0].id; test = () => ratelimitBypass(request().get(`/api/lists/${id}`));
describe('Valid request (legacy ID)', () => { let id, target, test; before('fetch list data', done => { db.select().from('legacy_ids').limit(1).then(legacy => { id = legacy[0].id; target = legacy[0].target; test = () => ratelimitBypass(request().get(`/api/lists/${id}`)); done(); }); }); it('returns a valid response', done => { test().end((err, res) => { expect(res).to.have.status(200); expect(res).to.be.json; done(); }); }); it('contains the correct target id for the legacy id', done => { test().end((err, res) => { expect(res.body).to.have.property('id', target); done(); }); }); });