1.0.2 • Published 4 years ago
huafua_sqlite-db v1.0.2
sqlite-db
1. 简介
本pacakge
是一套据库工具,用于操作sqlite
2. 安装
npm i sqlite-db
,未定
3. api 说明
配置
使用前可先配置一下,默认配置见包根目录下config.js
DatabaseManager.useDatabase(dbname)
:指定数据库DatabaseManager.useConfig(config:Config)
:重新指定各配置项,Config
格式如下;interface Config { host: string; port: nunmber | string; user: string; password: string; dbname: string; }
数据库操作 api
- 查询
find(tablename,where,callback):void
find(tablename,callback):void
whereIn(tablename,condition,callback):void
whereLike(tablename,condition,callback):void
complexQuery(sql,callback):void
findSync(tablename,where):Promise
findSync(tablename):Promise
whereInSync(tablename,condition):Promise
whereLikeSync(tablename,condition):Promise
- 删除
remove(tablename,where,callback):void
remove(tablename,callback):void
removeSync(tablename,where):Promise
removeSync(tablename):Promise
- 更新
update(tablename,where,callback):void
update(tablename,callback):void
updateSync(tablename,where):Promise
updateSync(tablename):Promise
新增
insert(tablename,item,callback):void
multiInsert(tablename,items,callback):void
insertSync(tablename,item):Promise
multiInsertSync(tablename,items):Promise
4.使用
以查询为例
var { DatabaseManager } = require("sqlite-db");
DatabaseManager.useConfig({
dbname: "data.sqlite"
});
var db = new DatabaseManager();
db.findSync("user")
.then(function(data) {
console.log(data);
})
.catch(function(err) {
console.log(err);
});