huafua_sqlite-db

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);
  });