huafua_mysql-db v1.0.2

mysql-db

1. 简介

本pacakge是一套据库工具，用于操作mysql

2. 安装

npm i mysql-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("mysql-db");
DatabaseManager.useConfig({
  host: "localhost",
  port: 3306,
  user: "root",
  password: "xxx",
  dbname: "test"
});
var db = new DatabaseManager();
db.findSync("user")
  .then(function(data) {
    console.log(data);
  })
  .catch(function(err) {
    console.log(err);
  });