SQLiteBuilder

SQLiteBuilder is a module written in TypeScript using the sqlite & sqlite3 library to simplify the building of new tables!

About

SQLiteBuilder is a very simple module written in TypeScript by Kodeur Kubik.

Installation

NPM

npm install sqlitebuilder

YARN

yarn add sqlitebuilder

PNPM

pnpm add sqlitebuilder

Example usage

const { TableBuilder, DatabaseBuilder } = require('sqlitebuilder');


setInterval(() => { }, 10000); // Keep the program awake

const db = new DatabaseBuilder('./test.sqlite'); // Load the db

db.on('all', (query, result) => { // Log everytime we use db.all
    console.log('.all query: ' + query)
})

db.on('ready', async () => { // Wait until the db is ready
    console.log('DB ready!')

    await db.createTable( // Create a new table
        new TableBuilder('tableName') // Build the table
            .addTextRow(row => row.setName('name'))
            .addIntegerRow(row =>
                row.setName('id')
                    .setPrimaryKey(true)
            )
    )

    // Get everything in the tableName table and log it
    console.log(await db.all('SELECT * FROM tableName;'));
});