- 通过JS函数输入输出成SQL语句的简易工具
generator sql string looks like this:
const sqlG = require('sqlG')
sqlG
.createSelectQuery('table_name')
.getQuery()
output: 'SELECT * FROM table_name'
- createSelectQuery
createSelectQuery(
tableName: string,
tableRename?: string,
)
- createUpdateQuery
createUpdateQuery(
tableName: string,
)
- createDeleteQuery
createDeleteQuery(
tableName: string,
)
- createInsertQuery
createInsertQuery(
tableName: string,
)
- createInsertQuery
createInsertQuery(
tableName: string,
) {}
- select
select(
fields: [string[]]
)
- where
where(
where: [key: string, value: string | number, link?: string]
)
- inWhere
inWhere(
where: string[] | number[],
field: string,
)
- orWhere
orWhere(
...where: [key: string, value: string | number, link?: string]
prefix?: 'AND' | 'OR'
)
- andWhere
andWhere(
...where: [key: string, value: string | number, link?: string]
prefix?: 'AND' | 'OR'
)
- orderBy
orderBy(
field: string,
)
- limit
limit(
start: number,
size: number,
)
- leftJoin
leftJoin(
joinTable: string[],
...condition: string,
type?: string,
autoFill?: boolean
)
- innerJoin
innerJoin(
joinTable: string[],
...condition: string,
type?: string,
autoFill?: boolean
)
- groupBy
groupBy(
field: string,
)
- input
input(str: string): string
- getQuery
getQuery(): string