rikdatabase v0.0.9

Exemples

import as Objection from 'objection'; import { Model, QueryContext } from 'objection'; import as Knex from 'knex';

import { IVersionm, Version} from "rikdatabase";

export class Db {

constructor(config: Knex.Config){          
    const knex = Knex(config);
    Model.knex(knex);
}

public async getDataVersion(): Promise<void> {
    let data = await Version.query().orderBy('id', 'desc').first();

    console.log('\n+------- Versions -------+');
    if(data){
        
        console.log(data);
    }
    else{
        console.log('Table is empty.');
    }
}

public async addNewVersion(version: IVersion): Promise<void> {
    let newVersion = await Version.query().insert(version);
   
    console.log('\nNew version has been added. Version: ', newVersion);
}

public async updateVersion(id: number, version: IVersion): Promise<void> {
    let updateVersion = await Version.query().patchAndFetchById(id, version);
   
    console.log('\nVersion has been updated. Version: ', updateVersion);
}

public async deleteVersionBy(id: number): Promise<void> {
    let deletedVersion = await Version.query().deleteById(id);

    console.log('\nDeleted vesion numbers: ', deletedVersion);
}

}

(async () => {
    try {

        const config = {
            client: 'pg',
            connection: {
                host: 'host',
                user: 'user',
                password: 'password',
                database: 'your database name',
                port: '5432'
            }
        };
        
        let db = new Db(config);
        let version = {
            current_version: '2.2.2.4',
            description: 'fdfdfdfdf'
        }

        await db.getDataVersion();
        //await db.addNewVersion(version)
        //await db.updateVersion(9, version);
        //await db.deleteVersionBy(10);
    } catch (error) {
        console.error(error);
    }
})()