LeoSQL

LeoSQL

new LeoSQL(request)

Source:

处理请求

Parameters:
Name Type Description
request Object

请求对象,一般为qs.parse(QueryString)

Members

column

Source:
Properties:
Type Description
String | Array

被写入的列的列表,用于UPDATEINSERT方法

count

Source:

COUNTSQL语句

delete

Source:

DELETESQL语句

insert

Source:

INSERTSQL语句

limit

Source:

请求的偏移量,相当于 LIMIT m, nn

limitSql

Source:

LIMITSQL语句片段

method

Source:
Properties:
Type Description
String

SQL操作方法,默认SELECT

offset

Source:

请求的起始位置,相当于 LIMIT m, nm

orderSql

Source:
To Do:
  • 区分先后顺序

ORDER BYSQL语句片段

select

Source:

SELECTSQL语句

table

Source:
Properties:
Type Description
String | Array

表,数据表名称

update

Source:

UPDATESQL语句

value

Source:
Properties:
Type Description
String | Array

被写入的值的列表,用于UPDATEINSERT方法

whereColumn

Source:
Properties:
Type Description
String | Array

条件包含的列名称列表

whereSql

Source:

WHERESQL语句片段