sqlite-manager-async

1.0.2 • Public • Published

Example:

const fs=require('fs-extra);
const SqliteManager = require('sqlite-manager-async');

async function main(){
    const dbPath = path.resolve(__dirname, '../.database');
    fs.ensureDirSync(dbPath);
    const db = new SqliteManager(path.resolve(dbPath, 'data.db'));

    await db.run(`
        CREATE TABLE IF NOT EXISTS posts(
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
            status NVARCHAR(20),
            title NVARCHAR(255) NOT NULL)`);
    const res = await db.all(`SELECT * FROM posts`);

    console.log(res);
}
main();

Readme

Keywords

none

Package Sidebar

Install

npm i sqlite-manager-async

Weekly Downloads

2

Version

1.0.2

License

ISC

Unpacked Size

1.98 kB

Total Files

3

Last publish

Collaborators

  • saminn.liu