PaintingliteDataBaseOptions

Superclass:
NSObject
Declared In:

Introduction

PaintingliteDataBaseOptions 提供SDK框架中Sqlite3库操作



Methods

-alterTableAddColumn: tableName: columnName: columnType:

修改表结构

-alterTableAddColumn: tableName: columnName: columnType: completeHandler:

修改表结构

-alterTableAddColumn:tableName:columnName:columnType:

修改表结构

-alterTableAddColumn:tableName:columnName:columnType:completeHandler:

修改表结构

-alterTableForName: oldName: newName:

修改表名称

-alterTableForName: oldName: newName: completeHandler:

修改表名称

-alterTableForName:oldName:newName:

修改表名称

-alterTableForName:oldName:newName:completeHandler:

修改表名称

-alterTableForObj: obj:

修改表

-alterTableForObj: obj: completeHandler:

修改表

-alterTableForObj:obj:

修改表

-alterTableForObj:obj:completeHandler:

修改表

-createTableForName: tableName: content:

创建表

-createTableForName: tableName: content: completeHandler:

创建表

-createTableForName:tableName:content:

创建表

-createTableForName:tableName:content:completeHandler:

创建表

-createTableForObj: obj: createStyle:

创建表

-createTableForObj: obj: createStyle: completeHandler:

创建表

-createTableForObj:obj:createStyle:

创建表

-createTableForObj:obj:createStyle:completeHandler:

创建表

-dropTableForObj:

删除表

-dropTableForObj: completeHandler:

删除表

-dropTableForObj:obj:

删除表

-dropTableForObj:obj:completeHandler:

删除表

-dropTableForTableName: tableName:

删除表

-dropTableForTableName: tableName: completeHandler:

删除表

-dropTableForTableName:tableName:

删除表

-dropTableForTableName:tableName:completeHandler:

删除表

-execTableOptForSQL: sql:

调用sql语句

-execTableOptForSQL: sql: completeHandler:

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

-execTableOptForSQL:sql:

调用sql语句

-execTableOptForSQL:sql:completeHandler:

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

+sharePaintingliteDataBaseOptions

单例模式生成PaintingliteDataBaseOptions对象


alterTableAddColumn: tableName: columnName: columnType:


修改表结构

- (BOOL)alterTableAddColumn:(sqlite3 *)ppDb tableName:(NSString *)tableName 
        columnName:(NSString *__nonnull)columnName columnType:(NSString *__nonnull)columnType; 
Parameters
ppDb

ppDb

tableName

表名

columnName

列表名称

columnType

列表类型

Return Value

BOOL

Discussion

修改表结构,添加表列

See Also


alterTableAddColumn: tableName: columnName: columnType: completeHandler:


修改表结构

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

ppDb

tableName

表名

columnName

列表名称

columnType

列表类型

completeHandler

回调操作

Return Value

BOOL

Discussion

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

See Also


alterTableAddColumn:tableName:columnName:columnType:


修改表结构

- (BOOL)alterTableAddColumn:(sqlite3 *)ppDb tableName:(NSString *)tableName 
        columnName:(NSString *__nonnull)columnName columnType:(NSString *__nonnull)columnType; 
Parameters
ppDb

ppDb

tableName

表名

columnName

列表名称

columnType

列表类型

Discussion

修改表结构,添加表列

See Also


alterTableAddColumn:tableName:columnName:columnType:completeHandler:


修改表结构

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

ppDb

tableName

表名

columnName

列表名称

columnType

列表类型

completeHandler

回调操作

Discussion

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

See Also


alterTableForName: oldName: newName:


修改表名称

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

ppDb

oldName

原表名称

newName

新表名称

Return Value

BOOL

Discussion

修改表名称

See Also


alterTableForName: oldName: newName: completeHandler:


修改表名称

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

ppDb

oldName

原表名称

newName

新表名称

completeHandler

回调操作

Return Value

BOOL

Discussion

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

See Also


alterTableForName:oldName:newName:


修改表名称

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

ppDb

oldName

原表名称

newName

新表名称

Discussion

修改表名称

See Also


alterTableForName:oldName:newName:completeHandler:


修改表名称

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

ppDb

oldName

原表名称

newName

新表名称

completeHandler

回调操作

Discussion

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

See Also


alterTableForObj: obj:


修改表

- (BOOL)alterTableForObj:(sqlite3 *)ppDb obj:(id)obj; 
Parameters
ppDb

ppDb

obj

对象

Return Value

BOOL

Discussion

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

See Also


alterTableForObj: obj: completeHandler:


修改表

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

ppDb

obj

对象

completeHandler

回调操作

Return Value

BOOL

Discussion

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

See Also


alterTableForObj:obj:


修改表

- (BOOL)alterTableForObj:(sqlite3 *)ppDb obj:(id)obj; 
Parameters
ppDb

ppDb

obj

对象

Discussion

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

See Also


alterTableForObj:obj:completeHandler:


修改表

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

ppDb

obj

对象

completeHandler

回调操作

Discussion

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

See Also


createTableForName: tableName: content:


创建表

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

ppDb

tableName

表名

content

创建字段内容

Return Value

Boolean

Discussion

通过表名称创建表

See Also


createTableForName: tableName: content: completeHandler:


创建表

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

ppDb

tableName

表名

content

创建字段内容

completeHandler

回调操作

Return Value

Boolean

Discussion

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

See Also


createTableForName:tableName:content:


创建表

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

ppDb

tableName

表名

content

创建字段内容

Discussion

通过表名称创建表

See Also


createTableForName:tableName:content:completeHandler:


创建表

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

ppDb

tableName

表名

content

创建字段内容

completeHandler

回调操作

Discussion

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

See Also


createTableForObj: obj: createStyle:


创建表

- (Boolean)createTableForObj:(sqlite3 *)ppDb obj:(id)obj 
        createStyle:(PaintingliteDataBaseOptionsPrimaryKeyStyle)createStyle; 
Parameters
ppDb

ppDb

obj

对象

createStyle

主键类型

Return Value

Boolean

Discussion

通过对象创建表

See Also


createTableForObj: obj: createStyle: completeHandler:


创建表

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

ppDb

obj

对象

createStyle

主键类型

completeHandler

回调操作

Return Value

Boolean

Discussion

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

See Also


createTableForObj:obj:createStyle:


创建表

- (Boolean)createTableForObj:(sqlite3 *)ppDb obj:(id)obj 
        createStyle:(PaintingliteDataBaseOptionsPrimaryKeyStyle)createStyle; 
Parameters
ppDb

ppDb

obj

对象

createStyle

主键类型

Discussion

通过对象创建表

See Also


createTableForObj:obj:createStyle:completeHandler:


创建表

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

ppDb

obj

对象

createStyle

主键类型

completeHandler

回调操作

Discussion

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

See Also


dropTableForObj:


删除表

- (Boolean)dropTableForObj:(sqlite3 *)ppDb obj:(id)obj; 
Parameters
ppDb

ppDb

obj

对象

Return Value

BOOL

Discussion

通过对象删除表

See Also


dropTableForObj: completeHandler:


删除表

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

ppDb

obj

对象

completeHandler

回调操作

Return Value

BOOL

Discussion

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

See Also


dropTableForObj:obj:


删除表

- (Boolean)dropTableForObj:(sqlite3 *)ppDb obj:(id)obj; 
Parameters
ppDb

ppDb

obj

对象

Discussion

通过对象删除表

See Also


dropTableForObj:obj:completeHandler:


删除表

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

ppDb

obj

对象

completeHandler

回调操作

Discussion

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

See Also


dropTableForTableName: tableName:


删除表

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

ppDb

tableName

表名称

Return Value

BOOL

Discussion

通过表名称删除表

See Also


dropTableForTableName: tableName: completeHandler:


删除表

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

ppDb

tableName

表名称

completeHandler

回调操作

Return Value

BOOL

Discussion

通过表名称删除表

See Also


dropTableForTableName:tableName:


删除表

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

ppDb

tableName

表名称

Discussion

通过表名称删除表

See Also


dropTableForTableName:tableName:completeHandler:


删除表

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

ppDb

tableName

表名称

completeHandler

回调操作

Discussion

通过表名称删除表

See Also


execTableOptForSQL: sql:


调用sql语句

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

ppDb

sql

SQL语句

Return Value

Boolean

Discussion

原生调用sql语句

See Also


execTableOptForSQL: sql: completeHandler:


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

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

ppDb

sql

SQL语句

completeHandler

回调操作

Return Value

Boolean

Discussion

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

See Also


execTableOptForSQL:sql:


调用sql语句

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

ppDb

sql

SQL语句

Discussion

原生调用sql语句

See Also


execTableOptForSQL:sql:completeHandler:


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

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

ppDb

sql

SQL语句

completeHandler

回调操作

Discussion

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

See Also


sharePaintingliteDataBaseOptions


单例模式生成PaintingliteDataBaseOptions对象

+ (instancetype)sharePaintingliteDataBaseOptions; 
Return Value

PaintingliteDataBaseOptions

Discussion

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