| 1 | require('sqlite3');
|
| 2 | const Knex = require('knex');
|
| 3 |
|
| 4 | const knexSqlite = Knex({
|
| 5 | client: 'sqlite',
|
| 6 | connection: ':memory:',
|
| 7 | });
|
| 8 |
|
| 9 | const knexMysql = Knex({
|
| 10 | client: 'mysql2',
|
| 11 | });
|
| 12 |
|
| 13 | const knexPg = Knex({
|
| 14 | client: 'pg',
|
| 15 | });
|
| 16 |
|
| 17 | (async function run() {
|
| 18 | await knexSqlite.schema.createTable('test', (t) => {
|
| 19 | t.increments('id').primary();
|
| 20 | t.string('data');
|
| 21 | });
|
| 22 |
|
| 23 | await knexSqlite('test').insert([{ data: 'foo' }, { data: 'bar' }]);
|
| 24 |
|
| 25 | console.log('test table data:', await knexSqlite('test'));
|
| 26 |
|
| 27 | console.log(
|
| 28 | knexPg({ f: 'foo', b: 'bar' })
|
| 29 | .select('foo.*')
|
| 30 | .where('f.name', knexPg.raw('??', ['b.name']))
|
| 31 | .whereIn('something', knexPg('bar').select('id'))
|
| 32 | .toSQL().sql
|
| 33 | );
|
| 34 | })();
|