const Model = require('objection').Model;
const Knex = require('knex');

async function main() {
  await createSchema();
  await Person.query().insertGraph({
    firstName: 'Jennifer',
    lastName: 'Lawrence',
  });

  const jennifer = await Person.query()
    .findOne({ firstName: 'Jennifer' });
  console.error(jennifer);
  await jennifer.$query().patch({ lastName: 'Lopez' });
  console.error(jennifer);
}

const knex = Knex({
  client: 'sqlite3',
  useNullAsDefault: true,
  debug: false,
  connection: {
    filename: ':memory:'
  }
});

Model.knex(knex);

class Person extends Model {
  static tableName = 'Person';
  id!: number;
  firstName!: string;
  lastName!: string;
}

async function createSchema() {
  await knex.schema
    .dropTableIfExists('Person');

  await knex.schema
    .createTable('Person', (table: any) => {
      table.increments('id').primary();
      table.string('firstName');
      table.string('lastName');
    });
}

main()
  .then(() => knex.destroy())
  .catch(err => {
    console.error(err);
    return knex.destroy();
  });