Açaí's Framework query builder
一个简单的模块化、可扩展的查询构建器,可让您轻松切换策略,由 Açaí Framework 使用和创建。
Supports
- [x] MySQL
- [x] PostgreSQL
- [ ] mongo
- [ ] sqlite
Installation
npm
npm install --save @acai/query
yarn
yarn add @acai/query
Usage
Setup
您需要做的第一件事是设置您的查询,您可以轻松定义您的默认查询或仅设置一个如下:
import query, { setDefault, addQuery } from "@acai/query";
// Add query of sql type
await addQuery("secondary", "sql", {
/* sql config */
});
const sqlquery = query("secondary");
// or setup a default query so you can easily import
await setDefaultQuery("pg", {
/* Optional sql query settings, if you want to pass any */
});
// now every time you call query without arguments, it will look for the default query
const pgquery = query(); // <-- this is a postgreSQL query builder
Querying
您可以使用查询轻松搜索选择
import query from "@acai/query";
const results = await query()
.table("people")
.where("id", 5)
.get(["name", "age"]);
我们的查询构建器巧妙地构建您的原始字符串查询,这样您就不会不必担心细节,例如:
await query().table("people").where("id", 5).where("name", "Robert").get();
// will output:
// SELECT FROM people WHERE id = 5 AND name = Robert
await query().table("people").where("id", 2).orWhere("name", "Robert").get();
// will output:
// SELECT FROM people WHERE id = 5 OR name = Robert
Inserting
import query from "@acai/query";
await query().table("people").insert({
name: "John",
surname: "Doe",
age: 32,
});
Updating
import query from "@acai/query";
await query().table("people").where("id", 5).update({
name: "John",
});
Deleting
import query from "@acai/query";
await query().table("people").where("id", 5).delete();
Açaí's Framework query builder
A simple modular, scalable query builder that let you toggle strategies to easily, used and created by Açaí Framework.
Supports
- [x] MySQL
- [x] PostgreSQL
- [ ] mongo
- [ ] sqlite
Installation
npm
npm install --save @acai/query
yarn
yarn add @acai/query
Usage
Setup
The first thing you are going to need is setup your query, you can easily define your default query or just setup one as follows:
import query, { setDefault, addQuery } from "@acai/query";
// Add query of sql type
await addQuery("secondary", "sql", {
/* sql config */
});
const sqlquery = query("secondary");
// or setup a default query so you can easily import
await setDefaultQuery("pg", {
/* Optional sql query settings, if you want to pass any */
});
// now every time you call query without arguments, it will look for the default query
const pgquery = query(); // <-- this is a postgreSQL query builder
Querying
You can easily search select using the query
import query from "@acai/query";
const results = await query()
.table("people")
.where("id", 5)
.get(["name", "age"]);
Our query builder smartlys build your raw string query so you don't have to worry about the details, for example:
await query().table("people").where("id", 5).where("name", "Robert").get();
// will output:
// SELECT FROM people WHERE id = 5 AND name = Robert
await query().table("people").where("id", 2).orWhere("name", "Robert").get();
// will output:
// SELECT FROM people WHERE id = 5 OR name = Robert
Inserting
import query from "@acai/query";
await query().table("people").insert({
name: "John",
surname: "Doe",
age: 32,
});
Updating
import query from "@acai/query";
await query().table("people").where("id", 5).update({
name: "John",
});
Deleting
import query from "@acai/query";
await query().table("people").where("id", 5).delete();