hdb-mgr
1. 简介
本pacakge
是包含了两个自定义的数据库工具,分别用于操作mysql
和sqlite
2. 安装
npm i hdb-mgr
3. api 说明
配置
使用前可先配置一下,默认配置见包根目录下config.js
,也可见mysql-db
和sqlite-db
下的config.js
DatabaseManager.useDatabase(dbname)
:指定数据库DatabaseManager.useConfig(config:Config)
:重新指定各配置项,Config
格式如下;
数据库操作 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.使用
以查询mysql
为例子
var DatabaseManager DbType = ;DatabaseManager;var db = ;db ;