xc-sqlite3

QuickStart

Development

Deploy

"use strict";
const sqliteDb = require('xc-sqlite3')
 
const db = new sqliteDb('./test1.db');
 
async function test(){
    await db.getConnection();
    await db.createTable(`create table if not exists dlt_test (
    id INTEGER PRIMARY KEY,
    name varchar(255),
    age int(20)
    )`);
    let result = await Promise.all([
        await db.doQueryError(`insert into dlt_test(name,age) values ('小明222',12)`,[],"run"),
        await db.doQueryError(`insert into dlt_test(name,age) values ('小中333',13)`,[],"all")
    ])
    console.log('result',result)
    const queryResult = await db.doQueryError(`select * from dlt_test`,[],"all")
    console.log('queryResult',queryResult)
    console.log(await db.doClose()) ;
}
 
test()

npm scripts

• Use npm run lint to check code style.
• Use npm test to run unit test.
• Use npm run autod to auto detect dependencies upgrade, see autod for more detail.