Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // var knex = require('knex')({
- // client: 'mssql',
- // connection: {
- // host : 'mssql.sequelizejs.com',
- // user : 'sequelize',
- // password : 'nEGkLma26gXVHFUAHJxcmsrK',
- // database : 'imperial_icore',
- // port: 1433,
- // pool: {
- // max: 5,
- // idle: 3000
- // }
- // }
- // });
- var knex = require('knex')({
- client: 'mssql',
- connection: 'mssql://SERVER01/GLOBALWANT'
- });
- var Benchmark = require('benchmark');
- var suite = new Benchmark.Suite;
- suite.add('dbo.tblStock', function() {
- // knex.select('*').from('dbo.tblStock').then(function(o) {
- //
- // });
- knex('information_schema.tables').where({TABLE_TYPE:'BASE_TABLE'}).select('*').then(function(o) {
- console.log(o);
- });
- })
- // .add('dbo.tblPayment', function() {
- //
- // })
- // .add('dbo.tblInvoice', function() {
- //
- // })
- .on('complete', function() {
- console.log('Fastest is ' + this.filter('fastest').map('name'));
- })
- .run({ 'async': true });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement