PaintingliteTableOptions

Superclass:
NSObject
Declared In:

Introduction

PaintingliteTableOptions 提供SDK框架中表操作



Methods

-del: sql:

删除操作

-del: sql: completeHandler:

更新操作

-del:sql:

删除操作

-del:sql:completeHandler:

更新操作

-execLikeQueryPQL: pql:

PQL模糊查询

-execLikeQueryPQL: pql: completeHandler:

PQL模糊查询

-execLikeQueryPQL:pql:

PQL模糊查询

-execLikeQueryPQL:pql:completeHandler:

PQL模糊查询

-execLikeQuerySQL: field: like: obj:

模糊匹配

-execLikeQuerySQL: field: like: obj: completeHandler:

模糊匹配

-execLikeQuerySQL: tableName: field: like:

模糊匹配

-execLikeQuerySQL:field:like:obj:

模糊匹配

-execLikeQuerySQL:field:like:obj:completeHandler:

模糊匹配

-execLikeQuerySQL:tableName:field:like:

模糊匹配

-execLikeQuerySQL:tableName:field:like:completeHandler:

模糊匹配

-execLimitQueryPQL: pql:

PQL限定查询

-execLimitQueryPQL: pql: completeHandler:

PQL限定查询

-execLimitQueryPQL:pql:

PQL限定查询

-execLimitQueryPQL:pql:completeHandler:

PQL限定查询

-execLimitQuerySQL: limitStart: limitEnd: obj:

限制匹配

-execLimitQuerySQL: limitStart: limitEnd: obj: completeHandler:

限制匹配

-execLimitQuerySQL: tableName: limitStart: limitEnd:

限制匹配

-execLimitQuerySQL: tableName: limitStart: limitEnd: completeHandler:

限制匹配

-execLimitQuerySQL:limitStart:limitEnd:obj:

限制匹配

-execLimitQuerySQL:limitStart:limitEnd:obj:completeHandler:

限制匹配

-execLimitQuerySQL:tableName:limitStart:limitEnd:

限制匹配

-execLimitQuerySQL:tableName:limitStart:limitEnd:completeHandler:

限制匹配

-execOrderByQuerySQL: orderbyContext: orderStyle: obj:

排序查询

-execOrderByQuerySQL: orderbyContext: orderStyle: obj: completeHandler:

排序查询

-execOrderByQuerySQL: tableName: orderbyContext: orderStyle:

排序查询

-execOrderByQuerySQL: tableName: orderbyContext: orderStyle: completeHandler:

排序查询

-execOrderByQuerySQL:orderbyContext:orderStyle:obj:

排序查询

-execOrderByQuerySQL:orderbyContext:orderStyle:obj:completeHandler:

排序查询

-execOrderByQuerySQL:tableName:orderbyContext:orderStyle:

排序查询

-execOrderByQuerySQL:tableName:orderbyContext:orderStyle:completeHandler:

排序查询

-execOrderQueryPQL: pql:

PQL排序查询

-execOrderQueryPQL: pql: completeHandler:

PQL排序查询

-execOrderQueryPQL:pql:

PQL排序查询

-execOrderQueryPQL:pql:completeHandler:

PQL排序查询

-execPQL: pql:

PQL查询

-execPQL: pql:

PQL万能查询

-execPQL: pql: completeHandler:

PQL查询

-execPQL: pql: completeHandler:

PQL万能查询

-execPQL:pql:

PQL万能查询

-execPQL:pql:completeHandler:

PQL万能查询

-execPrepareStatementPQL:

PQL条件查询

-execPrepareStatementPQL: completeHandler:

PQL条件查询

-execPrepareStatementPQL:completeHandler:

PQL条件查询

-execPrepareStatementSql:

执行条件查询SQL

-execPrepareStatementSql: completeHandler:

执行条件查询SQL

-execPrepareStatementSql: obj:

执行条件查询对象

-execPrepareStatementSql: obj: completeHandler:

执行条件查询对象

-execPrepareStatementSql:completeHandler:

执行条件查询SQL

-execPrepareStatementSql:obj:

执行条件查询对象

-execPrepareStatementSql:obj:completeHandler:

执行条件查询对象

-execQueryLikeSQLWithTableName: field: like: completeHandler:

模糊匹配

-execQueryPQL:pql:

PQL查询

-execQueryPQL:pql:completeHandler:

PQL查询

-execQueryPQLPrepareStatementPQL:

PQL条件查询

-execQuerySQL: sql:

查询SQL

-execQuerySQL: sql: completeHandler:

查询SQL

-execQuerySQL: sql: obj:

查询SQL

-execQuerySQL: sql: obj: completeHandler:

查询SQL

-execQuerySQL:sql:

查询SQL

-execQuerySQL:sql:completeHandler:

查询SQL

-execQuerySQL:sql:obj:

查询SQL

-execQuerySQL:sql:obj:completeHandler:

查询SQL

-execQuerySQLPrepareStatementSql:

查询SQL

-insert: obj: completeHandler:

插入操作

-insert: sql:

插入操作

-insert: sql: completeHandler:

插入操作

-insert:obj:completeHandler:

插入操作

-insert:sql:

插入操作

-insert:sql:completeHandler:

插入操作

-setPrepareStatementPQLParameter:

PQL条件查询

-setPrepareStatementPQLParameter: paramter:

PQL条件查询

-setPrepareStatementPQLParameter:paramter:

PQL条件查询

-setPrepareStatementSqlParameter:

查询SQL

-setPrepareStatementSqlParameter: paramter:

查询SQL

-setPrepareStatementSqlParameter:paramter:

查询SQL

+sharePaintingliteTableOptions

单例模式生成PaintingliteTableOptions对象

-update: obj: condition: completeHandler:

更新操作

-update: sql:

更新操作

-update: sql: completeHandler:

更新操作

-update:obj:condition:completeHandler:

更新操作

-update:sql:

更新操作

-update:sql:completeHandler:

更新操作


del: sql:


删除操作

- (Boolean)del:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

Return Value

Boolean

Discussion

删除操作

See Also


del: sql: completeHandler:


更新操作

- (Boolean)del:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

completeHandler

回调操作

Return Value

Boolean

Discussion

更新操作,支持回调操作

See Also


del:sql:


删除操作

- (Boolean)del:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

Discussion

删除操作

See Also


del:sql:completeHandler:


更新操作

- (Boolean)del:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

completeHandler

回调操作

Discussion

更新操作,支持回调操作

See Also


execLikeQueryPQL: pql:


PQL模糊查询

- (id)execLikeQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

Return Value

id

Discussion

PQL模糊查询

See Also


execLikeQueryPQL: pql: completeHandler:


PQL模糊查询

- (Boolean)execLikeQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

completeHandler

回调操作

Return Value

Boolean

Discussion

PQL模糊查询,支持回调操作

See Also


execLikeQueryPQL:pql:


PQL模糊查询

- (id)execLikeQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

Discussion

PQL模糊查询

See Also


execLikeQueryPQL:pql:completeHandler:


PQL模糊查询

- (Boolean)execLikeQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

completeHandler

回调操作

Discussion

PQL模糊查询,支持回调操作

See Also


execLikeQuerySQL: field: like: obj:


模糊匹配

- (id)execLikeQuerySQL:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        like:(NSString *__nonnull)like obj:(id)obj; 
Parameters
ppDb

Sqlite3 ppDb

field

表字段

like

模糊匹配条件

obj

对象

Return Value

id

Discussion

模糊匹配,结果集封装成对象

See Also


execLikeQuerySQL: field: like: obj: completeHandler:


模糊匹配

- (Boolean)execLikeQuerySQL:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        like:(NSString *__nonnull)like obj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

表字段

like

模糊匹配条件

obj

对象

completeHandler

回调操作

Return Value

Boolean

Discussion

模糊匹配,结果集封装成对象,支持回调操作

See Also


execLikeQuerySQL: tableName: field: like:


模糊匹配

- (NSMutableArray *)execLikeQuerySQL:(sqlite3 *)ppDb 
        tableName:(NSString *__nonnull)tableName field:(NSString *__nonnull)field 
        like:(NSString *__nonnull)like; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

field

表字段

like

模糊匹配条件

Return Value

NSMutableArray<NSDictionary *>

Discussion

模糊匹配

See Also


execLikeQuerySQL:field:like:obj:


模糊匹配

- (id)execLikeQuerySQL:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        like:(NSString *__nonnull)like obj:(id)obj; 
Parameters
ppDb

Sqlite3 ppDb

field

表字段

like

模糊匹配条件

obj

对象

Discussion

模糊匹配,结果集封装成对象

See Also


execLikeQuerySQL:field:like:obj:completeHandler:


模糊匹配

- (Boolean)execLikeQuerySQL:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        like:(NSString *__nonnull)like obj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

表字段

like

模糊匹配条件

obj

对象

completeHandler

回调操作

Discussion

模糊匹配,结果集封装成对象,支持回调操作

See Also


execLikeQuerySQL:tableName:field:like:


模糊匹配

- (NSMutableArray *)execLikeQuerySQL:(sqlite3 *)ppDb 
        tableName:(NSString *__nonnull)tableName field:(NSString *__nonnull)field 
        like:(NSString *__nonnull)like; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

field

表字段

like

模糊匹配条件

Discussion

模糊匹配

See Also


execLikeQuerySQL:tableName:field:like:completeHandler:


模糊匹配

- (Boolean)execLikeQuerySQL:(sqlite3 *)ppDb tableName:(NSString *__nonnull)tableName 
        field:(NSString *__nonnull)field like:(NSString *__nonnull)like 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

field

表字段

like

模糊匹配条件

completeHandler

回调操作

Discussion

模糊匹配

See Also


execLimitQueryPQL: pql:


PQL限定查询

- (id)execLimitQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

Return Value

id

Discussion

PQL限定查询

See Also


execLimitQueryPQL: pql: completeHandler:


PQL限定查询

- (Boolean)execLimitQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

completeHandler

回调操作

Return Value

Boolean

Discussion

PQL限定查询,支持回调操作

See Also


execLimitQueryPQL:pql:


PQL限定查询

- (id)execLimitQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

Discussion

PQL限定查询

See Also


execLimitQueryPQL:pql:completeHandler:


PQL限定查询

- (Boolean)execLimitQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

completeHandler

回调操作

Discussion

PQL限定查询,支持回调操作

See Also


execLimitQuerySQL: limitStart: limitEnd: obj:


限制匹配

- (id)execLimitQuerySQL:(sqlite3 *)ppDb limitStart:(NSUInteger)start 
        limitEnd:(NSUInteger)end obj:(id)obj; 
Parameters
ppDb

Sqlite3 ppDb

start

起始位置

end

结束位置

obj

对象

Return Value

NSMutableArray<id>

Discussion

限制匹配,结果集封装成对象

See Also


execLimitQuerySQL: limitStart: limitEnd: obj: completeHandler:


限制匹配

- (Boolean)execLimitQuerySQL:(sqlite3 *)ppDb limitStart:(NSUInteger)start 
        limitEnd:(NSUInteger)end obj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

start

起始位置

end

结束位置

obj

对象

completeHandler

回调操作

Return Value

Boolean

Discussion

限制匹配,结果集封装成对象

See Also


execLimitQuerySQL: tableName: limitStart: limitEnd:


限制匹配

- (NSMutableArray *)execLimitQuerySQL:(sqlite3 *)ppDb 
        tableName:(NSString *__nonnull)tableName limitStart:(NSUInteger)start 
        limitEnd:(NSUInteger)end; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

start

起始位置

end

结束位置

Return Value

NSMutableArray<NSDictionary *>

Discussion

限制匹配

See Also


execLimitQuerySQL: tableName: limitStart: limitEnd: completeHandler:


限制匹配

- (Boolean)execLimitQuerySQL:(sqlite3 *)ppDb tableName:(NSString *__nonnull)tableName 
        limitStart:(NSUInteger)start limitEnd:(NSUInteger)end 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

start

起始位置

end

结束位置

completeHandler

回调操作

Return Value

Boolean

Discussion

限制匹配,支持回调操作

See Also


execLimitQuerySQL:limitStart:limitEnd:obj:


限制匹配

- (id)execLimitQuerySQL:(sqlite3 *)ppDb limitStart:(NSUInteger)start 
        limitEnd:(NSUInteger)end obj:(id)obj; 
Parameters
ppDb

Sqlite3 ppDb

start

起始位置

end

结束位置

obj

对象

Discussion

限制匹配,结果集封装成对象

See Also


execLimitQuerySQL:limitStart:limitEnd:obj:completeHandler:


限制匹配

- (Boolean)execLimitQuerySQL:(sqlite3 *)ppDb limitStart:(NSUInteger)start 
        limitEnd:(NSUInteger)end obj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

start

起始位置

end

结束位置

obj

对象

completeHandler

回调操作

Discussion

限制匹配,结果集封装成对象

See Also


execLimitQuerySQL:tableName:limitStart:limitEnd:


限制匹配

- (NSMutableArray *)execLimitQuerySQL:(sqlite3 *)ppDb 
        tableName:(NSString *__nonnull)tableName limitStart:(NSUInteger)start 
        limitEnd:(NSUInteger)end; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

start

起始位置

end

结束位置

Discussion

限制匹配

See Also


execLimitQuerySQL:tableName:limitStart:limitEnd:completeHandler:


限制匹配

- (Boolean)execLimitQuerySQL:(sqlite3 *)ppDb tableName:(NSString *__nonnull)tableName 
        limitStart:(NSUInteger)start limitEnd:(NSUInteger)end 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

start

起始位置

end

结束位置

completeHandler

回调操作

Discussion

限制匹配,支持回调操作

See Also


execOrderByQuerySQL: orderbyContext: orderStyle: obj:


排序查询

- (id)execOrderByQuerySQL:(sqlite3 *)ppDb orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle obj:(id)obj; 
Parameters
ppDb

Sqlite3 ppDb

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

obj

对象

Return Value

NSMutableArray<id>

Discussion

排序查询,结果集封装成对象

See Also


execOrderByQuerySQL: orderbyContext: orderStyle: obj: completeHandler:


排序查询

- (Boolean)execOrderByQuerySQL:(sqlite3 *)ppDb 
        orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle obj:(id)obj 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

obj

对象

completeHandler

回调操作

Return Value

Boolean

Discussion

排序查询,结果集封装成对象,支持回调操作

See Also


execOrderByQuerySQL: tableName: orderbyContext: orderStyle:


排序查询

- (NSMutableArray *)execOrderByQuerySQL:(sqlite3 *)ppDb 
        tableName:(NSString *__nonnull)tableName orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

Return Value

NSMutableArray<NSDictionary *>

Discussion

排序查询

See Also


execOrderByQuerySQL: tableName: orderbyContext: orderStyle: completeHandler:


排序查询

- (Boolean)execOrderByQuerySQL:(sqlite3 *)ppDb tableName:(NSString *__nonnull)tableName 
        orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

completeHandler

回调操作

Return Value

Boolean

Discussion

排序查询,支持回调操作

See Also


execOrderByQuerySQL:orderbyContext:orderStyle:obj:


排序查询

- (id)execOrderByQuerySQL:(sqlite3 *)ppDb orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle obj:(id)obj; 
Parameters
ppDb

Sqlite3 ppDb

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

obj

对象

Discussion

排序查询,结果集封装成对象

See Also


execOrderByQuerySQL:orderbyContext:orderStyle:obj:completeHandler:


排序查询

- (Boolean)execOrderByQuerySQL:(sqlite3 *)ppDb 
        orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle obj:(id)obj 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

obj

对象

completeHandler

回调操作

Discussion

排序查询,结果集封装成对象,支持回调操作

See Also


execOrderByQuerySQL:tableName:orderbyContext:orderStyle:


排序查询

- (NSMutableArray *)execOrderByQuerySQL:(sqlite3 *)ppDb 
        tableName:(NSString *__nonnull)tableName orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

Discussion

排序查询

See Also


execOrderByQuerySQL:tableName:orderbyContext:orderStyle:completeHandler:


排序查询

- (Boolean)execOrderByQuerySQL:(sqlite3 *)ppDb tableName:(NSString *__nonnull)tableName 
        orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

completeHandler

回调操作

Discussion

排序查询,支持回调操作

See Also


execOrderQueryPQL: pql:


PQL排序查询

- (id)execOrderQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

Return Value

id

Discussion

PQL排序查询

See Also


execOrderQueryPQL: pql: completeHandler:


PQL排序查询

- (Boolean)execOrderQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

completeHandler

回调操作

Return Value

Boolean

Discussion

PQL排序查询,支持回调操作

See Also


execOrderQueryPQL:pql:


PQL排序查询

- (id)execOrderQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

Discussion

PQL排序查询

See Also


execOrderQueryPQL:pql:completeHandler:


PQL排序查询

- (Boolean)execOrderQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

completeHandler

回调操作

Discussion

PQL排序查询,支持回调操作

See Also


execPQL: pql:


PQL查询

- (id)execQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql; 
Parameters
ppDb

Sqlite3 ppDb

pql

pql需要遵从PQL语法规则

Return Value

NSMutableArray<id>

Discussion

PQL查询 FROM + 类名 + [条件]

See Also


execPQL: pql:


PQL万能查询

- (id)execPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

Return Value

id

Discussion

PQL万能查询

See Also


execPQL: pql: completeHandler:


PQL查询

- (Boolean)execQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

pql

pql需要遵从PQL语法规则

completeHandler

回调操作

Return Value

Boolean

Discussion

PQL查询 FROM + 类名 + [条件],支持回调操作

See Also


execPQL: pql: completeHandler:


PQL万能查询

- (Boolean)execPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

completeHandler

回调操作

Return Value

Boolean

Discussion

PQL万能查询,支持回调操作

See Also


execPQL:pql:


PQL万能查询

- (id)execPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

Discussion

PQL万能查询

See Also


execPQL:pql:completeHandler:


PQL万能查询

- (Boolean)execPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

pql

FROM + 类名 + [条件]

completeHandler

回调操作

Discussion

PQL万能查询,支持回调操作

See Also


execPrepareStatementPQL:


PQL条件查询

- (id)execPrepareStatementPQL:(sqlite3 *)ppDb; 
Parameters
ppDb

Sqlite3 ppDb

Return Value

id

Discussion

PQL条件查询


execPrepareStatementPQL: completeHandler:


PQL条件查询

- (Boolean)execPrepareStatementPQL:(sqlite3 *)ppDb 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

completeHandler

回调操作

Return Value

Boolean

Discussion

PQL条件查询,支持回调操作

See Also


execPrepareStatementPQL:completeHandler:


PQL条件查询

- (Boolean)execPrepareStatementPQL:(sqlite3 *)ppDb 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

completeHandler

回调操作

Discussion

PQL条件查询,支持回调操作

See Also


execPrepareStatementSql:


执行条件查询SQL

- (NSMutableArray *)execPrepareStatementSql:(sqlite3 *)ppDb; 
Parameters
ppDb

Sqlite3 ppDb

Return Value

NSMutableArray<NSDictionary *>

Discussion

执行条件查询SQL


execPrepareStatementSql: completeHandler:


执行条件查询SQL

- (Boolean)execPrepareStatementSql:(sqlite3 *)ppDb 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

completeHandler

回调操作

Return Value

Boolean

Discussion

执行条件查询SQL,支持回调操作

See Also


execPrepareStatementSql: obj:


执行条件查询对象

- (id)execPrepareStatementSql:(sqlite3 *)ppDb obj:(id)obj; 
Parameters
ppDb

Sqlite3 ppDb

obj

对象

Return Value

id

Discussion

执行条件查询对象,结果集封装成对象

See Also


execPrepareStatementSql: obj: completeHandler:


执行条件查询对象

- (Boolean)execPrepareStatementSql:(sqlite3 *)ppDb obj:(id)obj 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

obj

对象

completeHandler

回调参数

Return Value

Boolean

Discussion

执行条件查询对象,结果集封装成对象,支持回调操作

See Also


execPrepareStatementSql:completeHandler:


执行条件查询SQL

- (Boolean)execPrepareStatementSql:(sqlite3 *)ppDb 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

completeHandler

回调操作

Discussion

执行条件查询SQL,支持回调操作

See Also


execPrepareStatementSql:obj:


执行条件查询对象

- (id)execPrepareStatementSql:(sqlite3 *)ppDb obj:(id)obj; 
Parameters
ppDb

Sqlite3 ppDb

obj

对象

Discussion

执行条件查询对象,结果集封装成对象

See Also


execPrepareStatementSql:obj:completeHandler:


执行条件查询对象

- (Boolean)execPrepareStatementSql:(sqlite3 *)ppDb obj:(id)obj 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

obj

对象

completeHandler

回调参数

Discussion

执行条件查询对象,结果集封装成对象,支持回调操作

See Also


execQueryLikeSQLWithTableName: field: like: completeHandler:


模糊匹配

- (Boolean)execLikeQuerySQL:(sqlite3 *)ppDb tableName:(NSString *__nonnull)tableName 
        field:(NSString *__nonnull)field like:(NSString *__nonnull)like 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名

field

表字段

like

模糊匹配条件

completeHandler

回调操作

Return Value

Boolean

Discussion

模糊匹配

See Also


execQueryPQL:pql:


PQL查询

- (id)execQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql; 
Parameters
ppDb

Sqlite3 ppDb

pql

pql需要遵从PQL语法规则

Discussion

PQL查询 FROM + 类名 + [条件]

See Also


execQueryPQL:pql:completeHandler:


PQL查询

- (Boolean)execQueryPQL:(sqlite3 *)ppDb pql:(NSString *__nonnull)pql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

pql

pql需要遵从PQL语法规则

completeHandler

回调操作

Discussion

PQL查询 FROM + 类名 + [条件],支持回调操作

See Also


execQueryPQLPrepareStatementPQL:


PQL条件查询

- (void)execQueryPQLPrepareStatementPQL:(NSString *__nonnull)prepareStatementPQL; 
Parameters
prepareStatementPQL

PQL条件语句

Discussion

PQL条件查询


execQuerySQL: sql:


查询SQL

- (NSMutableArray *)execQuerySQL:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

Return Value

NSMutableArray<NSDictionary *>

Discussion

查询SQL

See Also


execQuerySQL: sql: completeHandler:


查询SQL

- (Boolean)execQuerySQL:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

completeHandler

回调操作

Return Value

NSMutableArray<NSDictionary *>

Discussion

查询SQL,支持回调操作

See Also


execQuerySQL: sql: obj:


查询SQL

- (id)execQuerySQL:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        obj:(id)obj; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

obj

对象

Return Value

NSMutableArray<id>

Discussion

查询SQL,返回值通过对象进行封装

See Also


execQuerySQL: sql: obj: completeHandler:


查询SQL

- (Boolean)execQuerySQL:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        obj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

obj

对象

completeHandler

回调操作

Return Value

Boolean

Discussion

查询SQL,返回值通过对象进行封装,支持回调操作

See Also


execQuerySQL:sql:


查询SQL

- (NSMutableArray *)execQuerySQL:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

Discussion

查询SQL

See Also


execQuerySQL:sql:completeHandler:


查询SQL

- (Boolean)execQuerySQL:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

completeHandler

回调操作

Discussion

查询SQL,支持回调操作

See Also


execQuerySQL:sql:obj:


查询SQL

- (id)execQuerySQL:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        obj:(id)obj; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

obj

对象

Discussion

查询SQL,返回值通过对象进行封装

See Also


execQuerySQL:sql:obj:completeHandler:


查询SQL

- (Boolean)execQuerySQL:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        obj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

obj

对象

completeHandler

回调操作

Discussion

查询SQL,返回值通过对象进行封装,支持回调操作

See Also


execQuerySQLPrepareStatementSql:


查询SQL

- (void)execQuerySQLPrepareStatementSql:(NSString *__nonnull)prepareStatementSql; 
Parameters
prepareStatementSql

条件语句 SELECT * FROM user WHERE name = ? and age = ?

Discussion

查询SQL,通过限定条件查询结果


insert: obj: completeHandler:


插入操作

- (Boolean)insert:(sqlite3 *)ppDb obj:(id)obj 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

obj

对象

completeHandler

回调操作

Return Value

Boolean

Discussion

通过对象进行插入操作,支持回调操作

See Also


insert: sql:


插入操作

- (Boolean)insert:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

Return Value

Boolean

Discussion

插入操作

See Also


insert: sql: completeHandler:


插入操作

- (Boolean)insert:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

completeHandler

回调操作

Return Value

Boolean

Discussion

插入操作,支持回调操作

See Also


insert:obj:completeHandler:


插入操作

- (Boolean)insert:(sqlite3 *)ppDb obj:(id)obj 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

obj

对象

completeHandler

回调操作

Discussion

通过对象进行插入操作,支持回调操作

See Also


insert:sql:


插入操作

- (Boolean)insert:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

Discussion

插入操作

See Also


insert:sql:completeHandler:


插入操作

- (Boolean)insert:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

completeHandler

回调操作

Discussion

插入操作,支持回调操作

See Also


setPrepareStatementPQLParameter:


PQL条件查询

- (void)setPrepareStatementPQLParameter:(NSMutableArray *__nonnull)paramter; 
Parameters
paramter

下标对应参数[数组]

Discussion

配置PQL条件查询


setPrepareStatementPQLParameter: paramter:


PQL条件查询

- (void)setPrepareStatementPQLParameter:(NSUInteger)index 
        paramter:(NSString *__nonnull)paramter; 
Parameters
index

下标

paramter

下标对应参数[字符串]

Discussion

配置PQL条件查询

See Also


setPrepareStatementPQLParameter:paramter:


PQL条件查询

- (void)setPrepareStatementPQLParameter:(NSUInteger)index 
        paramter:(NSString *__nonnull)paramter; 
Parameters
index

下标

paramter

下标对应参数[字符串]

Discussion

配置PQL条件查询

See Also


setPrepareStatementSqlParameter:


查询SQL

- (void)setPrepareStatementSqlParameter:(NSMutableArray *__nonnull)paramter; 
Parameters
paramter

对应下标参数[数组]

Discussion

查询SQL,配置限定条件查询结果


setPrepareStatementSqlParameter: paramter:


查询SQL

- (void)setPrepareStatementSqlParameter:(NSUInteger)index 
        paramter:(NSString *__nonnull)paramter; 
Parameters
index

对应下标

paramter

对应下标参数[字符串]

Discussion

查询SQL,配置限定条件查询结果

See Also


setPrepareStatementSqlParameter:paramter:


查询SQL

- (void)setPrepareStatementSqlParameter:(NSUInteger)index 
        paramter:(NSString *__nonnull)paramter; 
Parameters
index

对应下标

paramter

对应下标参数[字符串]

Discussion

查询SQL,配置限定条件查询结果

See Also


sharePaintingliteTableOptions


单例模式生成PaintingliteTableOptions对象

+ (instancetype)sharePaintingliteTableOptions; 
Return Value

PaintingliteTableOptions

Discussion

生成PaintingliteTableOptions在项目工程全局中只生成一个实例对象


update: obj: condition: completeHandler:


更新操作

- (Boolean)update:(sqlite3 *)ppDb obj:(id)obj condition:(NSString *__nonnull)condition 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

obj

对象

condition

更新条件字段

completeHandler

回调操作

Return Value

Boolean

Discussion

通过对象进行更新操作,支持回调操作

See Also


update: sql:


更新操作

- (Boolean)update:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

Return Value

Boolean

Discussion

更新操作

See Also


update: sql: completeHandler:


更新操作

- (Boolean)update:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

completeHandler

回调操作

Return Value

Boolean

Discussion

更新操作,支持回调操作

See Also


update:obj:condition:completeHandler:


更新操作

- (Boolean)update:(sqlite3 *)ppDb obj:(id)obj condition:(NSString *__nonnull)condition 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

obj

对象

condition

更新条件字段

completeHandler

回调操作

Discussion

通过对象进行更新操作,支持回调操作

See Also


update:sql:


更新操作

- (Boolean)update:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

Discussion

更新操作

See Also


update:sql:completeHandler:


更新操作

- (Boolean)update:(sqlite3 *)ppDb sql:(NSString *__nonnull)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句

completeHandler

回调操作

Discussion

更新操作,支持回调操作

See Also