const main = async () => { for (let i = 0; i < tables.length; i++) { const data = await db.select().from(tables[i]); const yaml = YAML.stringify(data); await fs.writeFile(path.join(__dirname, 'seeds', 'data', `${tables[i]}.yml`), yaml); } db.destroy(); }
async tableSelect ({ table }) { const client = await knex({ client: 'pg', connection: config.env.database }); return client.select().table(table); }
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(); }); }); }); });
router.get('/', (req,res) => { const ipFromRequest = requestIp.getClientIp(req).split(':').slice(-1).pop() db.select().from('todo').orderBy('id').then(function(data){ res.send({ip: ipFromRequest, data: data}) }) })
router.get('/', function(req, res) { db.select().from('todo').then(function(data) { res.send(data); }); // SELECT * FROM table_name });
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) }) })
before('fetch list data', done => { db.select().from('lists').where({ id: listId }).then(lists => { data = lists[0]; done(); }); });
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'); // } })
}); it('renders the expected content', done => { db.select('name', 'url').from('lists').where({ display: false, defunct: false }).then(lists => { test().end((err, res) => { expect(res).to.be.html;
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(); }); }); });
}); it('renders the expected information', done => { db.select('id', 'title').from('about').then(sections => { test().end((err, res) => { expect(res).to.be.html;
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(); }); }); });
}); it('renders the expected content', done => { db.select('name', 'url').from('lists').where({ display: true, defunct: false }).then(lists => { test().end((err, res) => { expect(res).to.be.html;