Software: Apache/2.4.41 (Ubuntu). PHP/8.0.30 

uname -a: Linux apirnd 5.4.0-204-generic #224-Ubuntu SMP Thu Dec 5 13:38:28 UTC 2024 x86_64 

uid=33(www-data) gid=33(www-data) groups=33(www-data) 

Safe-mode: OFF (not secure)

/var/www/html/wincloud_gateway/node_modules/knex/scripts/   drwxr-xr-x
Free 12.98 GB of 57.97 GB (22.4%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Self remove    Logout    

Viewing file:     runkit-example.js (709 B)      -rw-r--r--

require('sqlite3');
const Knex = require('knex');

const knexSqlite = Knex({
  client: 'sqlite',
  connection: ':memory:',
});

const knexMysql = Knex({
  client: 'mysql2',
});

const knexPg = Knex({
  client: 'pg',
});

(async function run() {
  await knexSqlite.schema.createTable('test', (t) => {
    t.increments('id').primary();
    t.string('data');
  });

  await knexSqlite('test').insert([{ data: 'foo' }, { data: 'bar' }]);

  console.log('test table data:', await knexSqlite('test'));

  console.log(
    knexPg({ f: 'foo', b: 'bar' })
      .select('foo.*')
      .where('f.name', knexPg.raw('??', ['b.name']))
      .whereIn('something', knexPg('bar').select('id'))
      .toSQL().sql
  );
})();