PaintingliteSessionManager

Superclass:
NSObject
Declared In:

Introduction

PaintingliteSessionManager 提供SDK框架中所有的基本操作,开发这可以通过SessionManager获得数据库管理者,提供了大量的数据库操作方式



Methods

-alterTableAddColumnWithTableName: columnName: columnType:

修改表结构

-alterTableAddColumnWithTableName: columnName: columnType: completeHandler:

修改表结构

-alterTableAddColumnWithTableName:columnName:columnType:

修改表结构

-alterTableAddColumnWithTableName:columnName:columnType:completeHandler:

修改表结构

-alterTableForName: newName:

修改表名称

-alterTableForName: newName: completeHandler:

修改表名称

-alterTableForName:newName:

修改表名称

-alterTableForName:newName:completeHandler:

修改表名称

-alterTableForObj:

修改表

-alterTableForObj: completeHandler:

修改表

-alterTableForObj:completeHandler:

修改表

-createTableForName: content:

创建表

-createTableForName: content: completeHandler:

创建表

-createTableForName:content:

创建表

-createTableForName:content:completeHandler:

创建表

-createTableForObj: primaryKeyStyle:

创建表

-createTableForObj: primaryKeyStyle: completeHandler:

创建表

-createTableForObj:primaryKeyStyle:

创建表

-createTableForObj:primaryKeyStyle:completeHandler:

创建表

-databaseInfoDict:

Sqlite3数据库文件夹详细信息

-del:

删除操作

-del: completeHandler:

更新操作

-del:completeHandler:

更新操作

-dictExistsDatabaseList:

指定目录下Sqlite3数据库文件列表

-dropTableForObj:

删除表

-dropTableForObj: completeHandler:

删除表

-dropTableForObj:completeHandler:

删除表

-dropTableForTableName:

删除表

-dropTableForTableName: completeHandler:

删除表

-dropTableForTableName:completeHandler:

删除表

-execPQL:

PQL查询

-execPQL: completeHandler:

PQL查询

-execPQL:completeHandler:

PQL查询

-execPrepareStatementPQL

PQL条件查询

-execPrepareStatementPQLWithCompleteHandler:

PQL条件查询

-execPrepareStatementSql

执行条件查询SQL

-execPrepareStatementSqlCompleteHandler:

执行条件查询SQL

-execPrepareStatementSqlWithObj:

执行条件查询对象

-execPrepareStatementSqlWithObj: completeHandler:

执行条件查询对象

-execPrepareStatementSqlWithObj:completeHandler:

执行条件查询对象

-execQueryLikeSQLWithField: like: obj:

模糊匹配

-execQueryLikeSQLWithField: like: obj: completeHandler:

模糊匹配

-execQueryLikeSQLWithField:like:obj:

模糊匹配

-execQueryLikeSQLWithField:like:obj:completeHandler:

模糊匹配

-execQueryLikeSQLWithTableName: field: like:

模糊匹配

-execQueryLikeSQLWithTableName: field: like: completeHandler:

模糊匹配

-execQueryLikeSQLWithTableName:field:like:

模糊匹配

-execQueryLikeSQLWithTableName:field:like:completeHandler:

模糊匹配

-execQueryLimitSQLWithLimitStart: limitEnd: obj:

限制匹配

-execQueryLimitSQLWithLimitStart: limitEnd: obj: completeHandler:

限制匹配

-execQueryLimitSQLWithLimitStart:limitEnd:obj:

限制匹配

-execQueryLimitSQLWithLimitStart:limitEnd:obj:completeHandler:

限制匹配

-execQueryLimitSQLWithTableName: limitStart: limitEnd:

限制匹配

-execQueryLimitSQLWithTableName: limitStart: limitEnd: completeHandler:

限制匹配

-execQueryLimitSQLWithTableName:limitStart:limitEnd:

限制匹配

-execQueryLimitSQLWithTableName:limitStart:limitEnd:completeHandler:

限制匹配

-execQueryOrderBySQLWithOrderbyContext: orderStyle: obj:

排序查询

-execQueryOrderBySQLWithOrderbyContext: orderStyle: obj: completeHandler:

排序查询

-execQueryOrderBySQLWithOrderbyContext:orderStyle:obj:

排序查询

-execQueryOrderBySQLWithOrderbyContext:orderStyle:obj:completeHandler:

排序查询

-execQueryOrderBySQLWithTableName: orderbyContext: orderStyle:

排序查询

-execQueryOrderBySQLWithTableName: orderbyContext: orderStyle: completeHandler:

排序查询

-execQueryOrderBySQLWithTableName:orderbyContext:orderStyle:

排序查询

-execQueryOrderBySQLWithTableName:orderbyContext:orderStyle:completeHandler:

排序查询

-execQueryPQLPrepareStatementPQL:

PQL条件查询

-execQuerySQL:

查询SQL

-execQuerySQL: completeHandler:

查询SQL

-execQuerySQL: obj:

查询SQL

-execQuerySQL: obj: completeHandler:

查询SQL

-execQuerySQL:completeHandler:

查询SQL

-execQuerySQL:obj:

查询SQL

-execQuerySQL:obj:completeHandler:

查询SQL

-execQuerySQLPrepareStatementSql:

查询SQL

-execTableOptForSQL:

调用sql语句

-execTableOptForSQL: completeHandler:

调用sql语句,支持回调操作

-execTableOptForSQL:completeHandler:

调用sql语句,支持回调操作

-getCurrentSession

Sqlite3数据库会语信息

-getSqlite3

当前连接Sqlite3数据库

-getSqlite3Version

当前连接Sqlite3数据库版本

-insert:

插入操作

-insert: completeHandler:

插入操作

-insert:completeHandler:

插入操作

-insertWithObj: completeHandler:

插入操作

-insertWithObj:completeHandler:

插入操作

-isExistsDatabase:

判定Sqlite3数据库是否存在

-openSqlite:

打开数据库

-openSqlite: completeHandler:

打开数据库,支持回调操作

-openSqlite:completeHandler:

打开数据库,支持回调操作

-openSqliteFilePath: completeHandler:

打开数据库,支持回调操作

-openSqliteFilePath:completeHandler:

打开数据库,支持回调操作

-openSqliteWithFilePath:

打开数据库

-readLogFileWithDatabaseName:

读取Sqlite3数据库操作日志

-readLogFileWithDatabaseName: dateTime:

读取Sqlite3数据库操作日志

-readLogFileWithDatabaseName: logStatus:

读取Sqlite3数据库操作日志

-readLogFileWithDatabaseName:dateTime:

读取Sqlite3数据库操作日志

-readLogFileWithDatabaseName:logStatus:

读取Sqlite3数据库操作日志

-releaseSqlite

释放数据库

-releaseSqliteCompleteHandler:

释放数据库,支持回调操作

-removeLogFileWithDatabaseName:

删除Sqlite3数据库操作日志

-setPrepareStatementPQLParameter:

PQL条件查询

-setPrepareStatementPQLParameter: paramter:

PQL条件查询

-setPrepareStatementPQLParameter:paramter:

PQL条件查询

-setPrepareStatementSqlParameter:

查询SQL

-setPrepareStatementSqlParameter: paramter:

查询SQL

-setPrepareStatementSqlParameter:paramter:

查询SQL

+sharePaintingliteSessionManager

单例模式生成PaintingliteSessionManager对象

-systemExec:

原生查询方式

-tableInfoWithTableName:

表结构查询操作

-update:

更新操作

-update: completeHandler:

更新操作

-update:completeHandler:

更新操作

-updateWithObj: condition: completeHandler:

更新操作

-updateWithObj:condition:completeHandler:

更新操作


alterTableAddColumnWithTableName: columnName: columnType:


修改表结构

- (BOOL)alterTableAddColumnWithTableName:(NSString *)tableName 
        columnName:(NSString *__nonnull)columnName columnType:(NSString *__nonnull)columnType; 
Parameters
tableName

表名

columnName

列表名称

columnType

列表类型

Return Value

BOOL

Discussion

修改表结构,添加表列

See Also


alterTableAddColumnWithTableName: columnName: columnType: completeHandler:


修改表结构

- (BOOL)alterTableAddColumnWithTableName:(NSString *)tableName 
        columnName:(NSString *__nonnull)columnName columnType:(NSString *__nonnull)columnType 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
tableName

表名

columnName

列表名称

columnType

列表类型

completeHandler

回调操作

Return Value

BOOL

Discussion

修改表结构,添加表列,支持回调操作

See Also


alterTableAddColumnWithTableName:columnName:columnType:


修改表结构

- (BOOL)alterTableAddColumnWithTableName:(NSString *)tableName 
        columnName:(NSString *__nonnull)columnName columnType:(NSString *__nonnull)columnType; 
Parameters
tableName

表名

columnName

列表名称

columnType

列表类型

Discussion

修改表结构,添加表列

See Also


alterTableAddColumnWithTableName:columnName:columnType:completeHandler:


修改表结构

- (BOOL)alterTableAddColumnWithTableName:(NSString *)tableName 
        columnName:(NSString *__nonnull)columnName columnType:(NSString *__nonnull)columnType 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
tableName

表名

columnName

列表名称

columnType

列表类型

completeHandler

回调操作

Discussion

修改表结构,添加表列,支持回调操作

See Also


alterTableForName: newName:


修改表名称

- (BOOL)alterTableForName:(NSString *__nonnull)oldName 
        newName:(NSString *__nonnull)newName; 
Parameters
oldName

原表名称

newName

新表名称

Return Value

BOOL

Discussion

修改表名称

See Also


alterTableForName: newName: completeHandler:


修改表名称

- (BOOL)alterTableForName:(NSString *__nonnull)oldName 
        newName:(NSString *__nonnull)newName completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
oldName

原表名称

newName

新表名称

completeHandler

回调操作

Return Value

BOOL

Discussion

修改表名称,支持回调操作

See Also


alterTableForName:newName:


修改表名称

- (BOOL)alterTableForName:(NSString *__nonnull)oldName 
        newName:(NSString *__nonnull)newName; 
Parameters
oldName

原表名称

newName

新表名称

Discussion

修改表名称

See Also


alterTableForName:newName:completeHandler:


修改表名称

- (BOOL)alterTableForName:(NSString *__nonnull)oldName 
        newName:(NSString *__nonnull)newName completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
oldName

原表名称

newName

新表名称

completeHandler

回调操作

Discussion

修改表名称,支持回调操作

See Also


alterTableForObj:


修改表

- (BOOL)alterTableForObj:(id)obj; 
Parameters
obj

对象

Return Value

BOOL

Discussion

修改表,依据对象成员变量修订表结构


alterTableForObj: completeHandler:


修改表

- (BOOL)alterTableForObj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
obj

对象

completeHandler

回调操作

Return Value

BOOL

Discussion

修改表,依据对象成员变量修订表结构,支持回调操作

See Also


alterTableForObj:completeHandler:


修改表

- (BOOL)alterTableForObj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
obj

对象

completeHandler

回调操作

Discussion

修改表,依据对象成员变量修订表结构,支持回调操作

See Also


createTableForName: content:


创建表

- (Boolean)createTableForName:(NSString *)tableName content:(NSString *)content; 
Parameters
tableName

表名

content

创建字段内容

Return Value

Boolean

Discussion

通过表名称创建表

See Also


createTableForName: content: completeHandler:


创建表

- (Boolean)createTableForName:(NSString *)tableName content:(NSString *)content 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
tableName

表名

content

创建字段内容

completeHandler

回调操作

Return Value

Boolean

Discussion

通过表名称创建表,支持回调操作

See Also


createTableForName:content:


创建表

- (Boolean)createTableForName:(NSString *)tableName content:(NSString *)content; 
Parameters
tableName

表名

content

创建字段内容

Discussion

通过表名称创建表

See Also


createTableForName:content:completeHandler:


创建表

- (Boolean)createTableForName:(NSString *)tableName content:(NSString *)content 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
tableName

表名

content

创建字段内容

completeHandler

回调操作

Discussion

通过表名称创建表,支持回调操作

See Also


createTableForObj: primaryKeyStyle:


创建表

- (Boolean)createTableForObj:(id)obj primaryKeyStyle:(PaintingliteDataBaseOptionsPrimaryKeyStyle)primaryKeyStyle; 
Parameters
obj

对象

primaryKeyStyle

主键类型

Return Value

Boolean

Discussion

通过对象创建表

See Also


createTableForObj: primaryKeyStyle: completeHandler:


创建表

- (Boolean)createTableForObj:(id)obj primaryKeyStyle:(PaintingliteDataBaseOptionsPrimaryKeyStyle)primaryKeyStyle 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
obj

对象

primaryKeyStyle

主键类型

completeHandler

回调操作

Return Value

Boolean

Discussion

通过对象创建表,支持回调操作

See Also


createTableForObj:primaryKeyStyle:


创建表

- (Boolean)createTableForObj:(id)obj primaryKeyStyle:(PaintingliteDataBaseOptionsPrimaryKeyStyle)primaryKeyStyle; 
Parameters
obj

对象

primaryKeyStyle

主键类型

Discussion

通过对象创建表

See Also


createTableForObj:primaryKeyStyle:completeHandler:


创建表

- (Boolean)createTableForObj:(id)obj primaryKeyStyle:(PaintingliteDataBaseOptionsPrimaryKeyStyle)primaryKeyStyle 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
obj

对象

primaryKeyStyle

主键类型

completeHandler

回调操作

Discussion

通过对象创建表,支持回调操作

See Also


databaseInfoDict:


Sqlite3数据库文件夹详细信息

- (NSDictionary<NSFileAttributeKey,id> *)databaseInfoDict:(NSString *__nonnull)filePath; 
Parameters
filePath

Sqlite3数据库绝对路径

Return Value

NSDictionary<NSFileAttributeKey,id>

Discussion

获得指定Sqlite3数据库文件夹详细信息


del:


删除操作

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

sql语句

Return Value

Boolean

Discussion

删除操作


del: completeHandler:


更新操作

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

sql语句

completeHandler

回调操作

Return Value

Boolean

Discussion

更新操作,支持回调操作

See Also


del:completeHandler:


更新操作

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

sql语句

completeHandler

回调操作

Discussion

更新操作,支持回调操作

See Also


dictExistsDatabaseList:


指定目录下Sqlite3数据库文件列表

- (NSArray<NSString *> *)dictExistsDatabaseList:(NSString *__nonnull)fileDict; 
Parameters
fileDict

文件目录绝对路径

Return Value

NSArray<NSString *>

Discussion

列出当前文件列表下的所有Sqlite3数据库文件


dropTableForObj:


删除表

- (Boolean)dropTableForObj:(id)obj; 
Parameters
obj

对象

Return Value

BOOL

Discussion

通过对象删除表


dropTableForObj: completeHandler:


删除表

- (Boolean)dropTableForObj:(id)obj completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
obj

对象

completeHandler

回调操作

Return Value

BOOL

Discussion

通过对象删除表,支持回调操作

See Also


dropTableForObj:completeHandler:


删除表

- (Boolean)dropTableForObj:(id)obj completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
obj

对象

completeHandler

回调操作

Discussion

通过对象删除表,支持回调操作

See Also


dropTableForTableName:


删除表

- (Boolean)dropTableForTableName:(NSString *)tableName; 
Parameters
tableName

表名

Return Value

BOOL

Discussion

通过表名称删除表


dropTableForTableName: completeHandler:


删除表

- (Boolean)dropTableForTableName:(NSString *)tableName 
        completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
tableName

表名

completeHandler

回调操作

Return Value

BOOL

Discussion

通过表名称删除表

See Also


dropTableForTableName:completeHandler:


删除表

- (Boolean)dropTableForTableName:(NSString *)tableName 
        completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
tableName

表名

completeHandler

回调操作

Discussion

通过表名称删除表

See Also


execPQL:


PQL查询

- (NSMutableArray<id> *)execPQL:(NSString *__nonnull)pql; 
Parameters
pql

pql需要遵从PQL语法规则

Return Value

NSMutableArray<id>

Discussion

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


execPQL: completeHandler:


PQL查询

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

pql需要遵从PQL语法规则

completeHandler

回调操作

Return Value

Boolean

Discussion

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

See Also


execPQL:completeHandler:


PQL查询

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

pql需要遵从PQL语法规则

completeHandler

回调操作

Discussion

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

See Also


execPrepareStatementPQL


PQL条件查询

- (id)execPrepareStatementPQL; 
Return Value

id

Discussion

PQL条件查询


execPrepareStatementPQLWithCompleteHandler:


PQL条件查询

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

回调操作

Return Value

Boolean

Discussion

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


execPrepareStatementSql


执行条件查询SQL

- (NSMutableArray<NSDictionary *> *)execPrepareStatementSql; 
Return Value

NSMutableArray<NSDictionary *>

Discussion

执行条件查询SQL


execPrepareStatementSqlCompleteHandler:


执行条件查询SQL

- (Boolean)execPrepareStatementSqlCompleteHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray))completeHandler; 
Parameters
completeHandler

回调操作

Return Value

Boolean

Discussion

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


execPrepareStatementSqlWithObj:


执行条件查询对象

Parameters
obj

对象

Return Value

id

Discussion

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


execPrepareStatementSqlWithObj: completeHandler:


执行条件查询对象

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

对象

completeHandler

回调参数

Return Value

Boolean

Discussion

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

See Also


execPrepareStatementSqlWithObj:completeHandler:


执行条件查询对象

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

对象

completeHandler

回调参数

Discussion

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

See Also


execQueryLikeSQLWithField: like: obj:


模糊匹配

- (NSMutableArray<id> *)execQueryLikeSQLWithField:(NSString *__nonnull)field 
        like:(NSString *__nonnull)like obj:(id)obj; 
Parameters
field

表字段

like

模糊匹配条件

obj

对象

Return Value

NSMutableArray<id>

Discussion

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

See Also


execQueryLikeSQLWithField: like: obj: completeHandler:


模糊匹配

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

表字段

like

模糊匹配条件

obj

对象

completeHandler

回调操作

Return Value

Boolean

Discussion

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

See Also


execQueryLikeSQLWithField:like:obj:


模糊匹配

- (NSMutableArray<id> *)execQueryLikeSQLWithField:(NSString *__nonnull)field 
        like:(NSString *__nonnull)like obj:(id)obj; 
Parameters
field

表字段

like

模糊匹配条件

obj

对象

Discussion

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

See Also


execQueryLikeSQLWithField:like:obj:completeHandler:


模糊匹配

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

表字段

like

模糊匹配条件

obj

对象

completeHandler

回调操作

Discussion

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

See Also


execQueryLikeSQLWithTableName: field: like:


模糊匹配

- (NSMutableArray<NSDictionary *> *)
        execQueryLikeSQLWithTableName:(NSString *__nonnull)tableName 
        field:(NSString *__nonnull)field like:(NSString *__nonnull)like; 
Parameters
tableName

表名

field

表字段

like

模糊匹配条件

Return Value

NSMutableArray<NSDictionary *>

Discussion

模糊匹配

See Also


execQueryLikeSQLWithTableName: field: like: completeHandler:


模糊匹配

- (Boolean)execQueryLikeSQLWithTableName:(NSString *__nonnull)tableName 
        field:(NSString *__nonnull)field like:(NSString *__nonnull)like 
        completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray))completeHandler; 
Parameters
tableName

表名

field

表字段

like

模糊匹配条件

completeHandler

回调操作

Return Value

Boolean

Discussion

模糊匹配

See Also


execQueryLikeSQLWithTableName:field:like:


模糊匹配

- (NSMutableArray<NSDictionary *> *)
        execQueryLikeSQLWithTableName:(NSString *__nonnull)tableName 
        field:(NSString *__nonnull)field like:(NSString *__nonnull)like; 
Parameters
tableName

表名

field

表字段

like

模糊匹配条件

Discussion

模糊匹配

See Also


execQueryLikeSQLWithTableName:field:like:completeHandler:


模糊匹配

- (Boolean)execQueryLikeSQLWithTableName:(NSString *__nonnull)tableName 
        field:(NSString *__nonnull)field like:(NSString *__nonnull)like 
        completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray))completeHandler; 
Parameters
tableName

表名

field

表字段

like

模糊匹配条件

completeHandler

回调操作

Discussion

模糊匹配

See Also


execQueryLimitSQLWithLimitStart: limitEnd: obj:


限制匹配

- (NSMutableArray<id> *)execQueryLimitSQLWithLimitStart:(NSUInteger)start 
        limitEnd:(NSUInteger)end obj:(id)obj; 
Parameters
start

起始位置

end

结束位置

obj

对象

Return Value

NSMutableArray<id>

Discussion

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

See Also


execQueryLimitSQLWithLimitStart: limitEnd: obj: completeHandler:


限制匹配

- (Boolean)execQueryLimitSQLWithLimitStart:(NSUInteger)start 
        limitEnd:(NSUInteger)end obj:(id)obj completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
start

起始位置

end

结束位置

obj

对象

completeHandler

回调操作

Return Value

Boolean

Discussion

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

See Also


execQueryLimitSQLWithLimitStart:limitEnd:obj:


限制匹配

- (NSMutableArray<id> *)execQueryLimitSQLWithLimitStart:(NSUInteger)start 
        limitEnd:(NSUInteger)end obj:(id)obj; 
Parameters
start

起始位置

end

结束位置

obj

对象

Discussion

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

See Also


execQueryLimitSQLWithLimitStart:limitEnd:obj:completeHandler:


限制匹配

- (Boolean)execQueryLimitSQLWithLimitStart:(NSUInteger)start 
        limitEnd:(NSUInteger)end obj:(id)obj completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray,NSMutableArray<id>* resObjList))completeHandler; 
Parameters
start

起始位置

end

结束位置

obj

对象

completeHandler

回调操作

Discussion

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

See Also


execQueryLimitSQLWithTableName: limitStart: limitEnd:


限制匹配

- (NSMutableArray<NSDictionary *> *)
        execQueryLimitSQLWithTableName:(NSString *__nonnull)tableName 
        limitStart:(NSUInteger)start limitEnd:(NSUInteger)end; 
Parameters
tableName

表名

start

起始位置

end

结束位置

Return Value

NSMutableArray<NSDictionary *>

Discussion

限制匹配

See Also


execQueryLimitSQLWithTableName: limitStart: limitEnd: completeHandler:


限制匹配

- (Boolean)execQueryLimitSQLWithTableName:(NSString *__nonnull)tableName 
        limitStart:(NSUInteger)start limitEnd:(NSUInteger)end 
        completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray))completeHandler; 
Parameters
tableName

表名

start

起始位置

end

结束位置

completeHandler

回调操作

Return Value

Boolean

Discussion

限制匹配,支持回调操作

See Also


execQueryLimitSQLWithTableName:limitStart:limitEnd:


限制匹配

- (NSMutableArray<NSDictionary *> *)
        execQueryLimitSQLWithTableName:(NSString *__nonnull)tableName 
        limitStart:(NSUInteger)start limitEnd:(NSUInteger)end; 
Parameters
tableName

表名

start

起始位置

end

结束位置

Discussion

限制匹配

See Also


execQueryLimitSQLWithTableName:limitStart:limitEnd:completeHandler:


限制匹配

- (Boolean)execQueryLimitSQLWithTableName:(NSString *__nonnull)tableName 
        limitStart:(NSUInteger)start limitEnd:(NSUInteger)end 
        completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray))completeHandler; 
Parameters
tableName

表名

start

起始位置

end

结束位置

completeHandler

回调操作

Discussion

限制匹配,支持回调操作

See Also


execQueryOrderBySQLWithOrderbyContext: orderStyle: obj:


排序查询

- (NSMutableArray<id> *)
        execQueryOrderBySQLWithOrderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle obj:(id)obj; 
Parameters
orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

obj

对象

Return Value

NSMutableArray<id>

Discussion

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

See Also


execQueryOrderBySQLWithOrderbyContext: orderStyle: obj: completeHandler:


排序查询

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

排序内容表字段

orderStyle

排序方式 [升序/降序]

obj

对象

completeHandler

回调操作

Return Value

Boolean

Discussion

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

See Also


execQueryOrderBySQLWithOrderbyContext:orderStyle:obj:


排序查询

- (NSMutableArray<id> *)
        execQueryOrderBySQLWithOrderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle obj:(id)obj; 
Parameters
orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

obj

对象

Discussion

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

See Also


execQueryOrderBySQLWithOrderbyContext:orderStyle:obj:completeHandler:


排序查询

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

排序内容表字段

orderStyle

排序方式 [升序/降序]

obj

对象

completeHandler

回调操作

Discussion

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

See Also


execQueryOrderBySQLWithTableName: orderbyContext: orderStyle:


排序查询

- (NSMutableArray<NSDictionary *> *)
        execQueryOrderBySQLWithTableName:(NSString *__nonnull)tableName 
        orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle; 
Parameters
tableName

表名

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

Return Value

NSMutableArray<NSDictionary *>

Discussion

排序查询

See Also


execQueryOrderBySQLWithTableName: orderbyContext: orderStyle: completeHandler:


排序查询

- (Boolean)execQueryOrderBySQLWithTableName:(NSString *__nonnull)tableName 
        orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle 
        completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray))completeHandler; 
Parameters
tableName

表名

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

completeHandler

回调操作

Return Value

Boolean

Discussion

排序查询,支持回调操作

See Also


execQueryOrderBySQLWithTableName:orderbyContext:orderStyle:


排序查询

- (NSMutableArray<NSDictionary *> *)
        execQueryOrderBySQLWithTableName:(NSString *__nonnull)tableName 
        orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle; 
Parameters
tableName

表名

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

Discussion

排序查询

See Also


execQueryOrderBySQLWithTableName:orderbyContext:orderStyle:completeHandler:


排序查询

- (Boolean)execQueryOrderBySQLWithTableName:(NSString *__nonnull)tableName 
        orderbyContext:(NSString *__nonnull)orderbyContext 
        orderStyle:(PaintingliteOrderByStyle)orderStyle 
        completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray))completeHandler; 
Parameters
tableName

表名

orderbyContext

排序内容表字段

orderStyle

排序方式 [升序/降序]

completeHandler

回调操作

Discussion

排序查询,支持回调操作

See Also


execQueryPQLPrepareStatementPQL:


PQL条件查询

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

PQL条件语句

Discussion

PQL条件查询


execQuerySQL:


查询SQL

- (NSMutableArray<NSDictionary *> *)execQuerySQL:(NSString *__nonnull)sql; 
Parameters
sql

sql语句

Return Value

NSMutableArray<NSDictionary *>

Discussion

查询SQL


execQuerySQL: completeHandler:


查询SQL

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

sql语句

completeHandler

回调操作

Return Value

NSMutableArray<NSDictionary *>

Discussion

查询SQL,支持回调操作

See Also


execQuerySQL: obj:


查询SQL

- (NSMutableArray<id> *)execQuerySQL:(NSString *__nonnull)sql 
        obj:(id)obj; 
Parameters
sql

sql语句

obj

对象

Return Value

NSMutableArray<id>

Discussion

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

See Also


execQuerySQL: obj: completeHandler:


查询SQL

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

sql语句

obj

对象

completeHandler

回调操作

Return Value

Boolean

Discussion

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

See Also


execQuerySQL:completeHandler:


查询SQL

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

sql语句

completeHandler

回调操作

Discussion

查询SQL,支持回调操作

See Also


execQuerySQL:obj:


查询SQL

- (NSMutableArray<id> *)execQuerySQL:(NSString *__nonnull)sql 
        obj:(id)obj; 
Parameters
sql

sql语句

obj

对象

Discussion

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

See Also


execQuerySQL:obj:completeHandler:


查询SQL

- (Boolean)execQuerySQL:(NSString *__nonnull)sql obj:(id)obj 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray,NSMutableArray<id> *resObjList))completeHandler; 
Parameters
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,通过限定条件查询结果


execTableOptForSQL:


调用sql语句

- (Boolean)execTableOptForSQL:(NSString *)sql; 
Parameters
sql

SQL语句

Return Value

Boolean

Discussion

原生调用sql语句


execTableOptForSQL: completeHandler:


调用sql语句,支持回调操作

- (Boolean)execTableOptForSQL:(NSString *)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
sql

SQL语句

completeHandler

回调操作

Return Value

Boolean

Discussion

原生调用sql语句,支持回调操作

See Also


execTableOptForSQL:completeHandler:


调用sql语句,支持回调操作

- (Boolean)execTableOptForSQL:(NSString *)sql 
        completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
sql

SQL语句

completeHandler

回调操作

Discussion

原生调用sql语句,支持回调操作

See Also


getCurrentSession


Sqlite3数据库会语信息

- (NSString *)getCurrentSession; 
Return Value

当前Session信息

Discussion

获得当前Sqlite3数据库会语信息


getSqlite3


当前连接Sqlite3数据库

- (sqlite3 *)getSqlite3; 
Return Value

sqlite3

Discussion

获得当前连接Sqlite3数据库


getSqlite3Version


当前连接Sqlite3数据库版本

- (NSString *)getSqlite3Version; 
Return Value

NSString

Discussion

获得当前连接Sqlite3数据库版本


insert:


插入操作

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

sql语句

Return Value

Boolean

Discussion

插入操作


insert: completeHandler:


插入操作

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

sql语句

completeHandler

回调操作

Return Value

Boolean

Discussion

插入操作,支持回调操作

See Also


insert:completeHandler:


插入操作

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

sql语句

completeHandler

回调操作

Discussion

插入操作,支持回调操作

See Also


insertWithObj: completeHandler:


插入操作

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

对象

completeHandler

回调操作

Return Value

Boolean

Discussion

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

See Also


insertWithObj:completeHandler:


插入操作

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

对象

completeHandler

回调操作

Discussion

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

See Also


isExistsDatabase:


判定Sqlite3数据库是否存在

- (Boolean)isExistsDatabase:(NSString *__nonnull)filePath; 
Parameters
filePath

Sqlite3数据库绝对路径

Return Value

Boolean

Discussion

指定Sqlite3数据库绝对路径判断数据库文件是否存在


openSqlite:


打开数据库

- (Boolean)openSqlite:(NSString *)fileName; 
Parameters
fileName

数据库名称

Return Value

Boolean

Discussion

传入数据库的名称,例如"sqlite","db_Paintinglite"等名称


openSqlite: completeHandler:


打开数据库,支持回调操作

- (Boolean)openSqlite:(NSString *)fileName completeHandler:(void(^ __nullable)(NSString *filePath,PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
fileName

数据库名称

completeHandler

回调操作

Return Value

Boolean

Discussion

传入数据库的名称,例如"sqlite","db_Paintinglite"等名称

See Also


openSqlite:completeHandler:


打开数据库,支持回调操作

- (Boolean)openSqlite:(NSString *)fileName completeHandler:(void(^ __nullable)(NSString *filePath,PaintingliteSessionError *error,Boolean success))completeHandler; 
Parameters
fileName

数据库名称

completeHandler

回调操作

Discussion

传入数据库的名称,例如"sqlite","db_Paintinglite"等名称

See Also


openSqliteFilePath: completeHandler:


打开数据库,支持回调操作

- (Boolean)openSqliteFilePath:(NSString *)filePath 
        completeHandler:(void (^__nullable)(NSString *filePath,Boolean success))completeHandler; 
Parameters
filePath

数据库绝对路径

completeHandler

回调操作

Return Value

Boolean

Discussion

传入数据库的绝对路径

See Also


openSqliteFilePath:completeHandler:


打开数据库,支持回调操作

- (Boolean)openSqliteFilePath:(NSString *)filePath 
        completeHandler:(void (^__nullable)(NSString *filePath,Boolean success))completeHandler; 
Parameters
filePath

数据库绝对路径

completeHandler

回调操作

Discussion

传入数据库的绝对路径

See Also


openSqliteWithFilePath:


打开数据库

- (Boolean)openSqliteWithFilePath:(NSString *)filePath; 
Parameters
filePath

数据库绝对路径

Return Value

Boolean

Discussion

传入数据库的绝对路径


readLogFileWithDatabaseName:


读取Sqlite3数据库操作日志

- (void)readLogFileWithDatabaseName:(NSString *__nonnull)fileName; 
Parameters
fileName

Sqlite3数据库名称

Discussion

读取Sqlite3数据库操作日志


readLogFileWithDatabaseName: dateTime:


读取Sqlite3数据库操作日志

- (void)readLogFileWithDatabaseName:(NSString *__nonnull)fileName 
        dateTime:(NSDate *__nonnull)dateTime; 
Parameters
fileName

Sqlite3数据库名称

dateTime

日志指定时间

Discussion

读取Sqlite3数据库操作日志,根据指定时间读取操作日志

See Also


readLogFileWithDatabaseName: logStatus:


读取Sqlite3数据库操作日志

- (void)readLogFileWithDatabaseName:(NSString *__nonnull)fileName 
        logStatus:(PaintingliteLogStatus)logStatus; 
Parameters
fileName

Sqlite3数据库名称

logStatus

操作日志状态

Discussion

读取Sqlite3数据库操作日志,根据操作日志状态读取操作日志

See Also


readLogFileWithDatabaseName:dateTime:


读取Sqlite3数据库操作日志

- (void)readLogFileWithDatabaseName:(NSString *__nonnull)fileName 
        dateTime:(NSDate *__nonnull)dateTime; 
Parameters
fileName

Sqlite3数据库名称

dateTime

日志指定时间

Discussion

读取Sqlite3数据库操作日志,根据指定时间读取操作日志

See Also


readLogFileWithDatabaseName:logStatus:


读取Sqlite3数据库操作日志

- (void)readLogFileWithDatabaseName:(NSString *__nonnull)fileName 
        logStatus:(PaintingliteLogStatus)logStatus; 
Parameters
fileName

Sqlite3数据库名称

logStatus

操作日志状态

Discussion

读取Sqlite3数据库操作日志,根据操作日志状态读取操作日志

See Also


releaseSqlite


释放数据库

- (Boolean)releaseSqlite; 
Return Value

Boolean

Discussion

程序运行结束时,调用此方法释放Sqlite3数据库资源


releaseSqliteCompleteHandler:


释放数据库,支持回调操作

- (Boolean)releaseSqliteCompleteHandler:(void(^__nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; 
Return Value

Boolean

Discussion

程序运行结束时,调用此方法释放Sqlite3数据库资源,并支持回调操作


removeLogFileWithDatabaseName:


删除Sqlite3数据库操作日志

- (void)removeLogFileWithDatabaseName:(NSString *__nonnull)fileName; 
Parameters
fileName

Sqlite3数据库名称

Discussion

删除Sqlite3数据库操作日志


setPrepareStatementPQLParameter:


PQL条件查询

- (void)setPrepareStatementPQLParameter:(NSArray *__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:(NSArray *__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


sharePaintingliteSessionManager


单例模式生成PaintingliteSessionManager对象

+ (instancetype)sharePaintingliteSessionManager; 
Return Value

PaintingliteSessionManager

Discussion

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


systemExec:


原生查询方式

- (NSMutableArray<NSMutableArray<NSString *> *> *)systemExec:(NSString *__nonnull)sql; 
Parameters
sql

sql语句

Return Value

NSMutableArray<NSMutableArray<NSString *> *>

Discussion

原生查询方式


tableInfoWithTableName:


表结构查询操作

- (NSMutableArray<NSDictionary *> *)tableInfoWithTableName:(NSString *__nonnull)tableName; 
Parameters
tableName

表名称

Return Value

NSMutableArray<NSDictionary *>

Discussion

表结构查询操作


update:


更新操作

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

sql语句

Return Value

Boolean

Discussion

更新操作


update: completeHandler:


更新操作

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

sql语句

completeHandler

回调操作

Return Value

Boolean

Discussion

更新操作,支持回调操作

See Also


update:completeHandler:


更新操作

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

sql语句

completeHandler

回调操作

Discussion

更新操作,支持回调操作

See Also


updateWithObj: condition: completeHandler:


更新操作

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

对象

condition

更新条件字段

completeHandler

回调操作

Return Value

Boolean

Discussion

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

See Also


updateWithObj:condition:completeHandler:


更新操作

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

对象

condition

更新条件字段

completeHandler

回调操作

Discussion

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

See Also


Properties

databasePath

数据库路径

isOpen

判读是否打开Sqlite3数据库,YES/true表示打开数据库,NO/false表示未打开数据库

totalSize

记录Sqlite3数据库文件大小(MB)


databasePath


数据库路径

@property (nonatomic,
    copy)NSString *databasePath; 

isOpen


判读是否打开Sqlite3数据库,YES/true表示打开数据库,NO/false表示未打开数据库

@property (nonatomic)Boolean isOpen; 

totalSize


记录Sqlite3数据库文件大小(MB)

@property (nonatomic,
    assign)double totalSize;