@sundawning/sqlite-database

SQLite 数据库

2022-09-04 16:53:56

安装

pnpm add @sundawning/sqlite-database

使用

const {
  create,
  selects,
  select,
  insert,
  update,
  remove,
  total,
  selectPage,
} = require("@sundawning/sqlite-database");
const path = require("path");
async function index() {
  const database = await create({
    filename: path.resolve(__dirname, "./database.db"),
  }); // 新增数据库
  const table_name = "hello"; // // 表名
  // 新增数据
  const key = await insert({
    database,
    table_name,
    row: { createTime: 1662265343067, title: "title" },
  });
  await insert({
    database,
    table_name,
    row: { deleted: true },
  });
  console.log("key", key);
  console.log("selects", await selects({ database, table_name })); // 查询
  console.log("total", await total({ database, table_name }));
  console.log(
    "selectPage",
    await selectPage({ database, table_name, pageSize: 1, current: 1 })
  ); // 分页查询
  await select({ database, table_name, key }); // 查询
  await update({
    database,
    table_name,
    key,
    row: { title: "content", status: "DONE" },
  }); // 修改
  await update({
    database,
    table_name,
    key,
    row: { KEY: "KEY" },
  }); // 修改“KEY”，会被忽略，因为已经存在key，列名不区分大小写。
  console.log("selects", await selects({ database, table_name })); // 查询
  await remove({ database, table_name, key }); // 删除
  console.log("selects", await selects({ database, table_name })); // 查询
  console.log("total", await total({ database, table_name }));
}
index();

首次执行时：

key 1
selects [
  { key: 1, createTime: '1662265343067', title: 'title' },
  { key: 2, deleted: 'true' }
]
total 2
selectPage [ { key: 1, createTime: '1662265343067', title: 'title' } ]
selects [
  {
    key: 1,
    createTime: '1662265343067',
    title: 'content',
    status: 'DONE'
  },
  { key: 2, deleted: 'true' }
]
selects [ { key: 2, deleted: 'true' } ]
total 1

第二次执行时：

key 3
selects [
  { key: 2, deleted: 'true' },
  { key: 3, createTime: '1662265343067', title: 'title' },
  { key: 4, deleted: 'true' }
]
total 3
selectPage [ { key: 2, deleted: 'true' } ]
selects [
  { key: 2, deleted: 'true' },
  {
    key: 3,
    createTime: '1662265343067',
    title: 'content',
    status: 'DONE'
  },
  { key: 4, deleted: 'true' }
]
selects [ { key: 2, deleted: 'true' }, { key: 4, deleted: 'true' } ]
total 2