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(); }); }); }); });
app.on("ready", () => { let mainWindow = new BrowserWindow({ height: 800, width: 800, show: false }) mainWindow.loadURL(url.format({ pathname: path.join(__dirname, 'main.html'), protocol: 'file', slashes: true })); mainWindow.once("ready-to-show", () => { mainWindow.show() }) ipcMain.on("mainWindowLoaded", function () { let result = knex.select("FirstName").from("User") result.then(function(rows){ mainWindow.webContents.send("resultSent", rows); }) }); });
router.get('/user', (req,res) =>{ db.select().from('password').where({username: req.body.username}).first().returning('*').then(data => { if(!data){ res.send({message: "No username " + req.body.username}) } else{ bcrypt.compare(req.body.password, data.password, (err,same) => { res.send({passwordCheck: same, error: err}) }) } }).catch(err => { res.send(err) }) })
app.get('/profile/:id',(req,res) => { const { id } = req.params; db.select('*').from('users').where({id}) .then(user => { if(user.length){ res.json(user[0]) } else { res.status(400).json('Not Found'); } }) .catch(err => res.status(400).json('Not Found')); // if(!found){ // res.status(400).json('Not Found'); // } })
app.post('/signin',(req,res) => { db.select('email','hash').from('login') .where('email','=',req.body.email) .then(data => { const isValid = bcrypt.compareSync(req.body.password,data[0].hash); if(isValid){ return db.select('*').from('users') .where('email','=',req.body.email) .then(user => { res.json(user[0]) }) .catch(err => res.status(400).json('Unable to get user')) } else { res.status(400).json('Wrong credential') } }) .catch(err => res.status(400).json('Empty credential')) // if(req.body.email === database.users[0].email && // req.body.password === database.users[0].password){ // res.json(database.users[0]); // } // else // { // res.status(400).json('error logging in'); // } })
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(); }); }); });
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(); }); }); });