pg-nosql v1.0.2

pg-nosql

Installation:

$ npm install pg-nosql

Example:

const pgnosql = require('pg-nosql');
const knex = pgnosql(require('knex'));

async function main() {
    const db = knex({
        client: 'pg',
        connection: {
            user: 'postgres',
            host: 'localhost',
            database: 'dbname',
            password: 'root',
            port: 5432,
        }
    });

    if (!await db.schema.hasTable('tablename')) {
        await db.schema.createTable('tablename', table => {
            table.uuid('id').primary();
            table.jsonb('data');
        });
    }

    // Insert
    db.from('tablename').add({
        id: 0,
        text: 'hello'
    }).then((result) => {
        console.log(result);
    })

    // Find and update
    test.find('id', 0).revise({
        id: 1,
        text: 'Goodbye',
    }).then((result) => {
        console.log(result);
    })
}

main();