PaintingliteAggregateFunc

Introduction

PaintingliteAggregateFunc 提供SDK框架中PQL语句进行聚合函数操作[COUNT MAX MIN SUM AVG]



Methods

-avg: field: tableName: completeHandler:

平均值聚合函数

-avg: field: tableName: condatation: completeHandler:

条件平均值聚合函数

-avg:field:tableName:completeHandler:

平均值聚合函数

-avg:field:tableName:condatation:completeHandler:

条件平均值聚合函数

-count: tableName: completeHandler:

统计聚合函数

-count: tableName: condatation: completeHandler:

条件统计聚合函数

-count:tableName:completeHandler:

统计聚合函数

-count:tableName:condatation:completeHandler:

条件统计聚合函数

-max: field: tableName: completeHandler:

最大值聚合函数

-max: field: tableName: condatation: completeHandler:

条件最大值聚合函数

-max:field:tableName:completeHandler:

最大值聚合函数

-max:field:tableName:condatation:completeHandler:

条件最大值聚合函数

-min: field: tableName: completeHandler:

最小值聚合函数

-min: field: tableName: condatation: completeHandler:

条件最小值聚合函数

-min:field:tableName:completeHandler:

最小值聚合函数

-min:field:tableName:condatation:completeHandler:

条件最小值聚合函数

+sharePaintingliteAggregateFunc

单例模式生成PaintingliteAggregateFunc对象

-sum: field: tableName: completeHandler:

总和聚合函数

-sum: field: tableName: condatation: completeHandler:

总和聚合函数

-sum:field:tableName:completeHandler:

总和聚合函数

-sum:field:tableName:condatation:completeHandler:

总和聚合函数


avg: field: tableName: completeHandler:


平均值聚合函数

- (Boolean)avg:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double avg))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

completeHandler

回调操作

Return Value

Boolean

Discussion

平均值聚合函数,支持回调操作

See Also


avg: field: tableName: condatation: completeHandler:


条件平均值聚合函数

- (Boolean)avg:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName condatation:(NSString *__nonnull)condatation 
        completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double avg))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

condatation

条件

completeHandler

回调操作

Return Value

Boolean

Discussion

条件平均值聚合函数,支持回调操作

See Also


avg:field:tableName:completeHandler:


平均值聚合函数

- (Boolean)avg:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double avg))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

completeHandler

回调操作

Discussion

平均值聚合函数,支持回调操作

See Also


avg:field:tableName:condatation:completeHandler:


条件平均值聚合函数

- (Boolean)avg:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName condatation:(NSString *__nonnull)condatation 
        completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double avg))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

condatation

条件

completeHandler

回调操作

Discussion

条件平均值聚合函数,支持回调操作

See Also


count: tableName: completeHandler:


统计聚合函数

- (Boolean)count:(sqlite3 *)ppDb tableName:(NSString *)tableName 
        completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, NSUInteger count))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名称

completeHandler

回调操作

Return Value

Boolean

Discussion

统计聚合函数,支持回调操作

See Also


count: tableName: condatation: completeHandler:


条件统计聚合函数

- (Boolean)count:(sqlite3 *)ppDb tableName:(NSString *)tableName 
        condatation:(NSString *__nonnull)condatation completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, NSUInteger count))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名称

condatation

条件

completeHandler

回调操作

Return Value

Boolean

Discussion

统计聚合函数,支持回调操作

See Also


count:tableName:completeHandler:


统计聚合函数

- (Boolean)count:(sqlite3 *)ppDb tableName:(NSString *)tableName 
        completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, NSUInteger count))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名称

completeHandler

回调操作

Discussion

统计聚合函数,支持回调操作

See Also


count:tableName:condatation:completeHandler:


条件统计聚合函数

- (Boolean)count:(sqlite3 *)ppDb tableName:(NSString *)tableName 
        condatation:(NSString *__nonnull)condatation completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, NSUInteger count))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

tableName

表名称

condatation

条件

completeHandler

回调操作

Discussion

统计聚合函数,支持回调操作

See Also


max: field: tableName: completeHandler:


最大值聚合函数

- (Boolean)max:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double max))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

completeHandler

回调操作

Return Value

Boolean

Discussion

最大值聚合函数,支持回调操作

See Also


max: field: tableName: condatation: completeHandler:


条件最大值聚合函数

- (Boolean)max:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName condatation:(NSString *__nonnull)condatation 
        completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double max))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

condatation

条件

completeHandler

回调操作

Return Value

Boolean

Discussion

条件最大值聚合函数,支持回调操作

See Also


max:field:tableName:completeHandler:


最大值聚合函数

- (Boolean)max:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double max))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

completeHandler

回调操作

Discussion

最大值聚合函数,支持回调操作

See Also


max:field:tableName:condatation:completeHandler:


条件最大值聚合函数

- (Boolean)max:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName condatation:(NSString *__nonnull)condatation 
        completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double max))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

condatation

条件

completeHandler

回调操作

Discussion

条件最大值聚合函数,支持回调操作

See Also


min: field: tableName: completeHandler:


最小值聚合函数

- (Boolean)min:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double min))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

completeHandler

回调操作

Return Value

Boolean

Discussion

条件最小值聚合函数,支持回调操作

See Also


min: field: tableName: condatation: completeHandler:


条件最小值聚合函数

- (Boolean)min:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName condatation:(NSString *__nonnull)condatation 
        completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double min))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

condatation

条件

completeHandler

回调操作

Return Value

Boolean

Discussion

条件最小值聚合函数,支持回调操作

See Also


min:field:tableName:completeHandler:


最小值聚合函数

- (Boolean)min:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double min))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

completeHandler

回调操作

Discussion

条件最小值聚合函数,支持回调操作

See Also


min:field:tableName:condatation:completeHandler:


条件最小值聚合函数

- (Boolean)min:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName condatation:(NSString *__nonnull)condatation 
        completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double min))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

condatation

条件

completeHandler

回调操作

Discussion

条件最小值聚合函数,支持回调操作

See Also


sharePaintingliteAggregateFunc


单例模式生成PaintingliteAggregateFunc对象

+ (instancetype)sharePaintingliteAggregateFunc; 
Return Value

PaintingliteAggregateFunc

Discussion

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


sum: field: tableName: completeHandler:


总和聚合函数

- (Boolean)sum:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double sum))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

completeHandler

回调操作

Return Value

Boolean

Discussion

总和聚合函数,支持回调操作

See Also


sum: field: tableName: condatation: completeHandler:


总和聚合函数

- (Boolean)sum:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName condatation:(NSString *__nonnull)condatation 
        completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double sum))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

condatation

条件

completeHandler

回调操作

Return Value

Boolean

Discussion

总和聚合函数,支持回调操作

See Also


sum:field:tableName:completeHandler:


总和聚合函数

- (Boolean)sum:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double sum))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

completeHandler

回调操作

Discussion

总和聚合函数,支持回调操作

See Also


sum:field:tableName:condatation:completeHandler:


总和聚合函数

- (Boolean)sum:(sqlite3 *)ppDb field:(NSString *__nonnull)field 
        tableName:(NSString *__nonnull)tableName condatation:(NSString *__nonnull)condatation 
        completeHandler:(void (^ __nullable)(PaintingliteSessionError *sessionerror, Boolean success, double sum))completeHandler; 
Parameters
ppDb

Sqlite3 ppDb

field

字段

tableName

表名称

condatation

条件

completeHandler

回调操作

Discussion

总和聚合函数,支持回调操作

See Also