sqlite3 for xc project
npm install xc-sqlite3``js
"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)
));insert into dlt_test(name,age) values ('小明222',12)
let result = await Promise.all([
await db.doQueryError(,[],"run"),insert into dlt_test(name,age) values ('小中333',13)
await db.doQueryError(,[],"all")select * from dlt_test
])
console.log('result',result)
const queryResult = await db.doQueryError(,[],"all")
console.log('queryResult',queryResult)
console.log(await db.doClose()) ;
}
test()
`
- Use npm run lint to check code style.npm test
- Use to run unit test.npm run autod` to auto detect dependencies upgrade, see autod for more detail.
- Use
[egg]: https://eggjs.org