Knex objection ORM

orm_example.js

'use strict';

// $ npm install knex objection sqlite3

const {Model} = require('objection');
const knex = require('knex')({
    client: 'sqlite3',
    connection: {
        filename: './db.sqlite'
    },
    useNullAsDefault: true
});

class Person extends Model {
    static get tableName() {
        return 'person';
    }
}

async function main() {
    await knex.schema.createTableIfNotExists('person', table => {
        table.increments();
        table.string('firstname');
        table.string('lastname');
        table.timestamps();
    });

    Model.knex(knex);

    const jennifer = await Person.query().insert({firstname: 'Jennifer', lastname: 'Lawrence'});
    console.log(jennifer);
    const entries = await Person.query();
    entries.forEach(row => {
        console.log(row);
    });
    // destroy to stop script execution
    await knex.destroy();
}
main();

// (async () => {
//     await main();
// })();