PaintingliteSessionManager
IntroductionPaintingliteSessionManager 提供SDK框架中所有的基本操作,开发这可以通过SessionManager获得数据库管理者,提供了大量的数据库操作方式 Methods
alterTableAddColumnWithTableName: columnName: columnType:修改表结构 - (BOOL)alterTableAddColumnWithTableName:(NSString *)tableName columnName:(NSString *__nonnull)columnName columnType:(NSString *__nonnull)columnType; ParametersReturn ValueBOOL 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; ParametersReturn ValueBOOL Discussion修改表结构,添加表列,支持回调操作 See Also alterTableAddColumnWithTableName:columnName:columnType:修改表结构 - (BOOL)alterTableAddColumnWithTableName:(NSString *)tableName columnName:(NSString *__nonnull)columnName columnType:(NSString *__nonnull)columnType; ParametersDiscussion修改表结构,添加表列 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; ParametersDiscussion修改表结构,添加表列,支持回调操作 See Also alterTableForName: newName:修改表名称 - (BOOL)alterTableForName:(NSString *__nonnull)oldName newName:(NSString *__nonnull)newName; ParametersReturn ValueBOOL Discussion修改表名称 See Also alterTableForName: newName: completeHandler:修改表名称 - (BOOL)alterTableForName:(NSString *__nonnull)oldName newName:(NSString *__nonnull)newName completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBOOL Discussion修改表名称,支持回调操作 See Also alterTableForName:newName:修改表名称 - (BOOL)alterTableForName:(NSString *__nonnull)oldName newName:(NSString *__nonnull)newName; ParametersDiscussion修改表名称 See Also alterTableForName:newName:completeHandler:修改表名称 - (BOOL)alterTableForName:(NSString *__nonnull)oldName newName:(NSString *__nonnull)newName completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion修改表名称,支持回调操作 See Also alterTableForObj:修改表 - (BOOL)alterTableForObj:(id)obj; ParametersReturn ValueBOOL Discussion修改表,依据对象成员变量修订表结构 alterTableForObj: completeHandler:修改表 - (BOOL)alterTableForObj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBOOL Discussion修改表,依据对象成员变量修订表结构,支持回调操作 See Also alterTableForObj:completeHandler:修改表 - (BOOL)alterTableForObj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion修改表,依据对象成员变量修订表结构,支持回调操作 See Also createTableForName: content:创建表 - (Boolean)createTableForName:(NSString *)tableName content:(NSString *)content; ParametersReturn ValueBoolean Discussion通过表名称创建表 See Also createTableForName: content: completeHandler:创建表 - (Boolean)createTableForName:(NSString *)tableName content:(NSString *)content completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBoolean Discussion通过表名称创建表,支持回调操作 See Also createTableForName:content:创建表 - (Boolean)createTableForName:(NSString *)tableName content:(NSString *)content; ParametersDiscussion通过表名称创建表 See Also createTableForName:content:completeHandler:创建表 - (Boolean)createTableForName:(NSString *)tableName content:(NSString *)content completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion通过表名称创建表,支持回调操作 See Also createTableForObj: primaryKeyStyle:创建表 - (Boolean)createTableForObj:(id)obj primaryKeyStyle:(PaintingliteDataBaseOptionsPrimaryKeyStyle)primaryKeyStyle; ParametersReturn ValueBoolean Discussion通过对象创建表 See Also createTableForObj: primaryKeyStyle: completeHandler:创建表 - (Boolean)createTableForObj:(id)obj primaryKeyStyle:(PaintingliteDataBaseOptionsPrimaryKeyStyle)primaryKeyStyle completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBoolean Discussion通过对象创建表,支持回调操作 See Also createTableForObj:primaryKeyStyle:创建表 - (Boolean)createTableForObj:(id)obj primaryKeyStyle:(PaintingliteDataBaseOptionsPrimaryKeyStyle)primaryKeyStyle; ParametersDiscussion通过对象创建表 See Also createTableForObj:primaryKeyStyle:completeHandler:创建表 - (Boolean)createTableForObj:(id)obj primaryKeyStyle:(PaintingliteDataBaseOptionsPrimaryKeyStyle)primaryKeyStyle completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion通过对象创建表,支持回调操作 See Also databaseInfoDict:Sqlite3数据库文件夹详细信息 - (NSDictionary<NSFileAttributeKey,id> *)databaseInfoDict:(NSString *__nonnull)filePath; ParametersReturn ValueNSDictionary<NSFileAttributeKey,id> Discussion获得指定Sqlite3数据库文件夹详细信息 del:删除操作 - (Boolean)del:(NSString *__nonnull)sql; ParametersReturn ValueBoolean Discussion删除操作 del: completeHandler:更新操作 - (Boolean)del:(NSString *__nonnull)sql completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBoolean Discussion更新操作,支持回调操作 See Also del:completeHandler:更新操作 - (Boolean)del:(NSString *__nonnull)sql completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion更新操作,支持回调操作 See Also dictExistsDatabaseList:指定目录下Sqlite3数据库文件列表 - (NSArray<NSString *> *)dictExistsDatabaseList:(NSString *__nonnull)fileDict; ParametersReturn ValueNSArray<NSString *> Discussion列出当前文件列表下的所有Sqlite3数据库文件 dropTableForObj:删除表 - (Boolean)dropTableForObj:(id)obj; ParametersReturn ValueBOOL Discussion通过对象删除表 dropTableForObj: completeHandler:删除表 - (Boolean)dropTableForObj:(id)obj completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBOOL Discussion通过对象删除表,支持回调操作 See Also dropTableForObj:completeHandler:删除表 - (Boolean)dropTableForObj:(id)obj completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion通过对象删除表,支持回调操作 See Also dropTableForTableName:删除表 - (Boolean)dropTableForTableName:(NSString *)tableName; ParametersReturn ValueBOOL Discussion通过表名称删除表 dropTableForTableName: completeHandler:删除表 - (Boolean)dropTableForTableName:(NSString *)tableName completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBOOL Discussion通过表名称删除表 See Also dropTableForTableName:completeHandler:删除表 - (Boolean)dropTableForTableName:(NSString *)tableName completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion通过表名称删除表 See Also execPQL:PQL查询 - (NSMutableArray<id> *)execPQL:(NSString *__nonnull)pql; ParametersReturn ValueNSMutableArray<id> DiscussionPQL查询 FROM + 类名 + [条件] execPQL: completeHandler:PQL查询 - (Boolean)execPQL:(NSString *__nonnull)pql completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; ParametersReturn ValueBoolean DiscussionPQL查询 FROM + 类名 + [条件],支持回调操作 See Also execPQL:completeHandler:PQL查询 - (Boolean)execPQL:(NSString *__nonnull)pql completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; ParametersDiscussionPQL查询 FROM + 类名 + [条件],支持回调操作 See Also execPrepareStatementPQLPQL条件查询 - (id)execPrepareStatementPQL; Return Valueid DiscussionPQL条件查询 execPrepareStatementPQLWithCompleteHandler:PQL条件查询 - (Boolean)execPrepareStatementPQLWithCompleteHandler:(void(^)(PaintingliteSessionError *error,Boolean success,NSMutableArray *resArray,NSMutableArray<id>* resObjList))completeHandler; ParametersReturn ValueBoolean DiscussionPQL条件查询,支持回调操作 execPrepareStatementSql执行条件查询SQL - (NSMutableArray<NSDictionary *> *)execPrepareStatementSql; Return ValueNSMutableArray<NSDictionary *> Discussion执行条件查询SQL execPrepareStatementSqlCompleteHandler:执行条件查询SQL - (Boolean)execPrepareStatementSqlCompleteHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray))completeHandler; ParametersReturn ValueBoolean Discussion执行条件查询SQL,支持回调操作 execPrepareStatementSqlWithObj:执行条件查询对象 - (id)execPrepareStatementSqlWithObj:(id)obj; ParametersReturn Valueid Discussion执行条件查询对象,结果集封装成对象 execPrepareStatementSqlWithObj: completeHandler:执行条件查询对象 - (Boolean)execPrepareStatementSqlWithObj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray,NSMutableArray<id>* resObjList))completeHandler; ParametersReturn ValueBoolean Discussion执行条件查询对象,结果集封装成对象,支持回调操作 See Also execPrepareStatementSqlWithObj:completeHandler:执行条件查询对象 - (Boolean)execPrepareStatementSqlWithObj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray,NSMutableArray<id>* resObjList))completeHandler; ParametersDiscussion执行条件查询对象,结果集封装成对象,支持回调操作 See Also execQueryLikeSQLWithField: like: obj:模糊匹配 - (NSMutableArray<id> *)execQueryLikeSQLWithField:(NSString *__nonnull)field like:(NSString *__nonnull)like obj:(id)obj; ParametersReturn ValueNSMutableArray<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; ParametersReturn ValueBoolean Discussion模糊匹配,结果集封装成对象,支持回调操作 See Also execQueryLikeSQLWithField:like:obj:模糊匹配 - (NSMutableArray<id> *)execQueryLikeSQLWithField:(NSString *__nonnull)field like:(NSString *__nonnull)like obj:(id)obj; ParametersDiscussion模糊匹配,结果集封装成对象 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; ParametersDiscussion模糊匹配,结果集封装成对象,支持回调操作 See Also execQueryLikeSQLWithTableName: field: like:模糊匹配 - (NSMutableArray<NSDictionary *> *) execQueryLikeSQLWithTableName:(NSString *__nonnull)tableName field:(NSString *__nonnull)field like:(NSString *__nonnull)like; ParametersReturn ValueNSMutableArray<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; ParametersReturn ValueBoolean Discussion模糊匹配 See Also execQueryLikeSQLWithTableName:field:like:模糊匹配 - (NSMutableArray<NSDictionary *> *) execQueryLikeSQLWithTableName:(NSString *__nonnull)tableName field:(NSString *__nonnull)field like:(NSString *__nonnull)like; ParametersDiscussion模糊匹配 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; ParametersDiscussion模糊匹配 See Also execQueryLimitSQLWithLimitStart: limitEnd: obj:限制匹配 - (NSMutableArray<id> *)execQueryLimitSQLWithLimitStart:(NSUInteger)start limitEnd:(NSUInteger)end obj:(id)obj; ParametersReturn ValueNSMutableArray<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; ParametersReturn ValueBoolean Discussion限制匹配,结果集封装成对象 See Also execQueryLimitSQLWithLimitStart:limitEnd:obj:限制匹配 - (NSMutableArray<id> *)execQueryLimitSQLWithLimitStart:(NSUInteger)start limitEnd:(NSUInteger)end obj:(id)obj; ParametersDiscussion限制匹配,结果集封装成对象 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; ParametersDiscussion限制匹配,结果集封装成对象 See Also execQueryLimitSQLWithTableName: limitStart: limitEnd:限制匹配 - (NSMutableArray<NSDictionary *> *) execQueryLimitSQLWithTableName:(NSString *__nonnull)tableName limitStart:(NSUInteger)start limitEnd:(NSUInteger)end; ParametersReturn ValueNSMutableArray<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; ParametersReturn ValueBoolean Discussion限制匹配,支持回调操作 See Also execQueryLimitSQLWithTableName:limitStart:limitEnd:限制匹配 - (NSMutableArray<NSDictionary *> *) execQueryLimitSQLWithTableName:(NSString *__nonnull)tableName limitStart:(NSUInteger)start limitEnd:(NSUInteger)end; ParametersDiscussion限制匹配 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; ParametersDiscussion限制匹配,支持回调操作 See Also execQueryOrderBySQLWithOrderbyContext: orderStyle: obj:排序查询 - (NSMutableArray<id> *) execQueryOrderBySQLWithOrderbyContext:(NSString *__nonnull)orderbyContext orderStyle:(PaintingliteOrderByStyle)orderStyle obj:(id)obj; ParametersReturn ValueNSMutableArray<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; ParametersReturn ValueBoolean Discussion排序查询,结果集封装成对象,支持回调操作 See Also execQueryOrderBySQLWithOrderbyContext:orderStyle:obj:排序查询 - (NSMutableArray<id> *) execQueryOrderBySQLWithOrderbyContext:(NSString *__nonnull)orderbyContext orderStyle:(PaintingliteOrderByStyle)orderStyle obj:(id)obj; ParametersDiscussion排序查询,结果集封装成对象 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; ParametersDiscussion排序查询,结果集封装成对象,支持回调操作 See Also execQueryOrderBySQLWithTableName: orderbyContext: orderStyle:排序查询 - (NSMutableArray<NSDictionary *> *) execQueryOrderBySQLWithTableName:(NSString *__nonnull)tableName orderbyContext:(NSString *__nonnull)orderbyContext orderStyle:(PaintingliteOrderByStyle)orderStyle; ParametersReturn ValueNSMutableArray<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; ParametersReturn ValueBoolean Discussion排序查询,支持回调操作 See Also execQueryOrderBySQLWithTableName:orderbyContext:orderStyle:排序查询 - (NSMutableArray<NSDictionary *> *) execQueryOrderBySQLWithTableName:(NSString *__nonnull)tableName orderbyContext:(NSString *__nonnull)orderbyContext orderStyle:(PaintingliteOrderByStyle)orderStyle; ParametersDiscussion排序查询 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; ParametersDiscussion排序查询,支持回调操作 See Also execQueryPQLPrepareStatementPQL:PQL条件查询 - (void)execQueryPQLPrepareStatementPQL:(NSString *__nonnull)prepareStatementPQL; ParametersDiscussionPQL条件查询 execQuerySQL:查询SQL - (NSMutableArray<NSDictionary *> *)execQuerySQL:(NSString *__nonnull)sql; ParametersReturn ValueNSMutableArray<NSDictionary *> Discussion查询SQL execQuerySQL: completeHandler:查询SQL - (Boolean)execQuerySQL:(NSString *__nonnull)sql completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray))completeHandler; ParametersReturn ValueNSMutableArray<NSDictionary *> Discussion查询SQL,支持回调操作 See Also execQuerySQL: obj:查询SQL - (NSMutableArray<id> *)execQuerySQL:(NSString *__nonnull)sql obj:(id)obj; ParametersReturn ValueNSMutableArray<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; ParametersReturn ValueBoolean Discussion查询SQL,返回值通过对象进行封装,支持回调操作 See Also execQuerySQL:completeHandler:查询SQL - (Boolean)execQuerySQL:(NSString *__nonnull)sql completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success,NSMutableArray<NSDictionary *> *resArray))completeHandler; ParametersDiscussion查询SQL,支持回调操作 See Also execQuerySQL:obj:查询SQL - (NSMutableArray<id> *)execQuerySQL:(NSString *__nonnull)sql obj:(id)obj; ParametersDiscussion查询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; ParametersDiscussion查询SQL,返回值通过对象进行封装,支持回调操作 See Also execQuerySQLPrepareStatementSql:查询SQL - (void)execQuerySQLPrepareStatementSql:(NSString *__nonnull)prepareStatementSql; ParametersDiscussion查询SQL,通过限定条件查询结果 execTableOptForSQL:调用sql语句 - (Boolean)execTableOptForSQL:(NSString *)sql; ParametersReturn ValueBoolean Discussion原生调用sql语句 execTableOptForSQL: completeHandler:调用sql语句,支持回调操作 - (Boolean)execTableOptForSQL:(NSString *)sql completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBoolean Discussion原生调用sql语句,支持回调操作 See Also execTableOptForSQL:completeHandler:调用sql语句,支持回调操作 - (Boolean)execTableOptForSQL:(NSString *)sql completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion原生调用sql语句,支持回调操作 See Also getCurrentSessionSqlite3数据库会语信息 - (NSString *)getCurrentSession; Return Value当前Session信息 Discussion获得当前Sqlite3数据库会语信息 getSqlite3当前连接Sqlite3数据库 - (sqlite3 *)getSqlite3; Return Valuesqlite3 Discussion获得当前连接Sqlite3数据库 getSqlite3Version当前连接Sqlite3数据库版本 - (NSString *)getSqlite3Version; Return ValueNSString Discussion获得当前连接Sqlite3数据库版本 insert:插入操作 - (Boolean)insert:(NSString *__nonnull)sql; ParametersReturn ValueBoolean Discussion插入操作 insert: completeHandler:插入操作 - (Boolean)insert:(NSString *__nonnull)sql completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBoolean Discussion插入操作,支持回调操作 See Also insert:completeHandler:插入操作 - (Boolean)insert:(NSString *__nonnull)sql completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion插入操作,支持回调操作 See Also insertWithObj: completeHandler:插入操作 - (Boolean)insertWithObj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBoolean Discussion通过对象进行插入操作,支持回调操作 See Also insertWithObj:completeHandler:插入操作 - (Boolean)insertWithObj:(id)obj completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion通过对象进行插入操作,支持回调操作 See Also isExistsDatabase:判定Sqlite3数据库是否存在 - (Boolean)isExistsDatabase:(NSString *__nonnull)filePath; ParametersReturn ValueBoolean Discussion指定Sqlite3数据库绝对路径判断数据库文件是否存在 openSqlite:打开数据库 - (Boolean)openSqlite:(NSString *)fileName; ParametersReturn ValueBoolean Discussion传入数据库的名称,例如"sqlite","db_Paintinglite"等名称 openSqlite: completeHandler:打开数据库,支持回调操作 - (Boolean)openSqlite:(NSString *)fileName completeHandler:(void(^ __nullable)(NSString *filePath,PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBoolean Discussion传入数据库的名称,例如"sqlite","db_Paintinglite"等名称 See Also openSqlite:completeHandler:打开数据库,支持回调操作 - (Boolean)openSqlite:(NSString *)fileName completeHandler:(void(^ __nullable)(NSString *filePath,PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion传入数据库的名称,例如"sqlite","db_Paintinglite"等名称 See Also openSqliteFilePath: completeHandler:打开数据库,支持回调操作 - (Boolean)openSqliteFilePath:(NSString *)filePath completeHandler:(void (^__nullable)(NSString *filePath,Boolean success))completeHandler; ParametersReturn ValueBoolean Discussion传入数据库的绝对路径 See Also openSqliteFilePath:completeHandler:打开数据库,支持回调操作 - (Boolean)openSqliteFilePath:(NSString *)filePath completeHandler:(void (^__nullable)(NSString *filePath,Boolean success))completeHandler; ParametersDiscussion传入数据库的绝对路径 See Also openSqliteWithFilePath:打开数据库 - (Boolean)openSqliteWithFilePath:(NSString *)filePath; ParametersReturn ValueBoolean Discussion传入数据库的绝对路径 readLogFileWithDatabaseName:读取Sqlite3数据库操作日志 - (void)readLogFileWithDatabaseName:(NSString *__nonnull)fileName; ParametersDiscussion读取Sqlite3数据库操作日志 readLogFileWithDatabaseName: dateTime:读取Sqlite3数据库操作日志 - (void)readLogFileWithDatabaseName:(NSString *__nonnull)fileName dateTime:(NSDate *__nonnull)dateTime; ParametersDiscussion读取Sqlite3数据库操作日志,根据指定时间读取操作日志 See Also readLogFileWithDatabaseName: logStatus:读取Sqlite3数据库操作日志 - (void)readLogFileWithDatabaseName:(NSString *__nonnull)fileName logStatus:(PaintingliteLogStatus)logStatus; ParametersDiscussion读取Sqlite3数据库操作日志,根据操作日志状态读取操作日志 See Also readLogFileWithDatabaseName:dateTime:读取Sqlite3数据库操作日志 - (void)readLogFileWithDatabaseName:(NSString *__nonnull)fileName dateTime:(NSDate *__nonnull)dateTime; ParametersDiscussion读取Sqlite3数据库操作日志,根据指定时间读取操作日志 See Also readLogFileWithDatabaseName:logStatus:读取Sqlite3数据库操作日志 - (void)readLogFileWithDatabaseName:(NSString *__nonnull)fileName logStatus:(PaintingliteLogStatus)logStatus; ParametersDiscussion读取Sqlite3数据库操作日志,根据操作日志状态读取操作日志 See Also releaseSqlite释放数据库 - (Boolean)releaseSqlite; Return ValueBoolean Discussion程序运行结束时,调用此方法释放Sqlite3数据库资源 releaseSqliteCompleteHandler:释放数据库,支持回调操作 - (Boolean)releaseSqliteCompleteHandler:(void(^__nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; Return ValueBoolean Discussion程序运行结束时,调用此方法释放Sqlite3数据库资源,并支持回调操作 removeLogFileWithDatabaseName:删除Sqlite3数据库操作日志 - (void)removeLogFileWithDatabaseName:(NSString *__nonnull)fileName; ParametersDiscussion删除Sqlite3数据库操作日志 setPrepareStatementPQLParameter:PQL条件查询 - (void)setPrepareStatementPQLParameter:(NSArray *__nonnull)paramter; ParametersDiscussion配置PQL条件查询 setPrepareStatementPQLParameter: paramter:PQL条件查询 - (void)setPrepareStatementPQLParameter:(NSUInteger)index paramter:(NSString *__nonnull)paramter; ParametersDiscussion配置PQL条件查询 See Also setPrepareStatementPQLParameter:paramter:PQL条件查询 - (void)setPrepareStatementPQLParameter:(NSUInteger)index paramter:(NSString *__nonnull)paramter; ParametersDiscussion配置PQL条件查询 See Also setPrepareStatementSqlParameter:查询SQL - (void)setPrepareStatementSqlParameter:(NSArray *__nonnull)paramter; ParametersDiscussion查询SQL,配置限定条件查询结果 setPrepareStatementSqlParameter: paramter:查询SQL - (void)setPrepareStatementSqlParameter:(NSUInteger)index paramter:(NSString *__nonnull)paramter; ParametersDiscussion查询SQL,配置限定条件查询结果 See Also setPrepareStatementSqlParameter:paramter:查询SQL - (void)setPrepareStatementSqlParameter:(NSUInteger)index paramter:(NSString *__nonnull)paramter; ParametersDiscussion查询SQL,配置限定条件查询结果 See Also sharePaintingliteSessionManager单例模式生成PaintingliteSessionManager对象 + (instancetype)sharePaintingliteSessionManager; Return ValuePaintingliteSessionManager Discussion生成PaintingliteSessionManager在项目工程全局中只生成一个实例对象 systemExec:原生查询方式 - (NSMutableArray<NSMutableArray<NSString *> *> *)systemExec:(NSString *__nonnull)sql; ParametersReturn ValueNSMutableArray<NSMutableArray<NSString *> *> Discussion原生查询方式 tableInfoWithTableName:表结构查询操作 - (NSMutableArray<NSDictionary *> *)tableInfoWithTableName:(NSString *__nonnull)tableName; ParametersReturn ValueNSMutableArray<NSDictionary *> Discussion表结构查询操作 update:更新操作 - (Boolean)update:(NSString *__nonnull)sql; ParametersReturn ValueBoolean Discussion更新操作 update: completeHandler:更新操作 - (Boolean)update:(NSString *__nonnull)sql completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBoolean Discussion更新操作,支持回调操作 See Also update:completeHandler:更新操作 - (Boolean)update:(NSString *__nonnull)sql completeHandler:(void(^)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion更新操作,支持回调操作 See Also updateWithObj: condition: completeHandler:更新操作 - (Boolean)updateWithObj:(id)obj condition:(NSString *__nonnull)condition completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersReturn ValueBoolean Discussion通过对象进行更新操作,支持回调操作 See Also updateWithObj:condition:completeHandler:更新操作 - (Boolean)updateWithObj:(id)obj condition:(NSString *__nonnull)condition completeHandler:(void(^ __nullable)(PaintingliteSessionError *error,Boolean success))completeHandler; ParametersDiscussion通过对象进行更新操作,支持回调操作 See Also Properties
databasePath数据库路径 @property (nonatomic, copy)NSString *databasePath; isOpen判读是否打开Sqlite3数据库,YES/true表示打开数据库,NO/false表示未打开数据库 @property (nonatomic)Boolean isOpen; totalSize记录Sqlite3数据库文件大小(MB) @property (nonatomic, assign)double totalSize; |