sql-g

SQLgenerator

函数解析成SQL语句

• 通过JS函数输入输出成SQL语句的简易工具

generator sql string looks like this:

const sqlG = require('sqlG')
sqlG
  .createSelectQuery('table_name')
  .getQuery()

output: 'SELECT * FROM table_name'

API

• 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