PaintingliteIntellegenceSelect

Introduction

PaintingliteIntellegenceSelect 提供SDK框架中智能查询操作,针对多对象的查询分配操作[1.基本查询 2.分页查询 3.排序查询 4.万能查询]



Methods

-limit: start: end: completeHandler: objects:

分页查询

-limit: startAndEnd: completeHandler: objects:

分页查询高级方法

-limit:start:end:completeHandler:objects:

分页查询

-limit:startAndEnd:completeHandler:objects:

分页查询高级方法

-load: completeHandler: objects:

基本查询

-load:completeHandler:objects:

基本查询

-orderBy: orderStyle: condation: completeHandler: objects:

排序查询

-orderBy: orderStyleArray: condation: completeHandler: objects:

排序查询高级

-orderBy:orderStyle:condation:completeHandler:objects:

排序查询

-orderBy:orderStyleArray:condation:completeHandler:objects:

排序查询高级

-query: sql: completeHandler: objects:

万能查询

-query:sql:completeHandler:objects:

万能查询

+sharePaintingliteIntellegenceSelect

单例模式生成PaintingliteIntellegenceSelect对象


limit: start: end: completeHandler: objects:


分页查询

- (Boolean)limit:(sqlite3 *)ppDb start:(NSUInteger)start end:(NSUInteger)end 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *limitArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

start

开始位置,所有查询对象的起始位置数组

end

结束位置,所有查询对象的结束位置数组

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Return Value

Boolean

Discussion

分页查询,支持回调操作

See Also


limit: startAndEnd: completeHandler: objects:


分页查询高级方法

- (Boolean)limit:(sqlite3 *)ppDb startAndEnd:(NSArray<NSArray<NSNumber *> *> *)startAndEnd 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *limitArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

startAndEnd

每个对象的开始和结束组成一个数组[二维数组]

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Return Value

Boolean

Discussion

分页查询高级方法,支持回调操作

See Also


limit:start:end:completeHandler:objects:


分页查询

- (Boolean)limit:(sqlite3 *)ppDb start:(NSUInteger)start end:(NSUInteger)end 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *limitArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

start

开始位置,所有查询对象的起始位置数组

end

结束位置,所有查询对象的结束位置数组

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Discussion

分页查询,支持回调操作

See Also


limit:startAndEnd:completeHandler:objects:


分页查询高级方法

- (Boolean)limit:(sqlite3 *)ppDb startAndEnd:(NSArray<NSArray<NSNumber *> *> *)startAndEnd 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *limitArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

startAndEnd

每个对象的开始和结束组成一个数组[二维数组]

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Discussion

分页查询高级方法,支持回调操作

See Also


load: completeHandler: objects:


基本查询

- (Boolean)load:(sqlite3 *)ppDb completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *loadArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Return Value

Boolean

Discussion

基本查询,支持回调操作

See Also


load:completeHandler:objects:


基本查询

- (Boolean)load:(sqlite3 *)ppDb completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *loadArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Discussion

基本查询,支持回调操作

See Also


orderBy: orderStyle: condation: completeHandler: objects:


排序查询

- (Boolean)orderBy:(sqlite3 *)ppDb orderStyle:(PaintingliteOrderByStyle)orderStyle 
        condation:(NSArray<NSString *> *)condation completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *orderArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

orderStyle

排序方式

condation

每个对象排序字段数组

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Return Value

Boolean

Discussion

排序查询

See Also


orderBy: orderStyleArray: condation: completeHandler: objects:


排序查询高级

- (Boolean)orderBy:(sqlite3 *)ppDb orderStyleArray:(NSArray<NSString *> *)orderStyleArray 
        condation:(NSArray<NSString *> *)condation completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *orderArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

orderStyleArray

每个对象排序方式组成的排序数组

condation

每个对象排序字段数组

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Return Value

Boolean

Discussion

排序查询高级

See Also


orderBy:orderStyle:condation:completeHandler:objects:


排序查询

- (Boolean)orderBy:(sqlite3 *)ppDb orderStyle:(PaintingliteOrderByStyle)orderStyle 
        condation:(NSArray<NSString *> *)condation completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *orderArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

orderStyle

排序方式

condation

每个对象排序字段数组

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Discussion

排序查询

See Also


orderBy:orderStyleArray:condation:completeHandler:objects:


排序查询高级

- (Boolean)orderBy:(sqlite3 *)ppDb orderStyleArray:(NSArray<NSString *> *)orderStyleArray 
        condation:(NSArray<NSString *> *)condation completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *orderArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

orderStyleArray

每个对象排序方式组成的排序数组

condation

每个对象排序字段数组

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Discussion

排序查询高级

See Also


query: sql: completeHandler: objects:


万能查询

- (Boolean)query:(sqlite3 *)ppDb sql:(NSArray<NSString *> *__nonnull)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *orderArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句[数组]

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Return Value

Boolean

Discussion

万能查询

See Also


query:sql:completeHandler:objects:


万能查询

- (Boolean)query:(sqlite3 *)ppDb sql:(NSArray<NSString *> *__nonnull)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray *orderArray))completeHandler 
        objects:(id)objects,... NS_REQUIRES_NIL_TERMINATION; 
Parameters
ppDb

Sqlite3 ppDb

sql

sql语句[数组]

objects

可变参数,传入多个查询对象类型

completeHandler

回调操作

Discussion

万能查询

See Also


sharePaintingliteIntellegenceSelect


单例模式生成PaintingliteIntellegenceSelect对象

+ (instancetype)sharePaintingliteIntellegenceSelect; 
Return Value

PaintingliteIntellegenceSelect

Discussion

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