PaintingliteShortcutSQL

Author:
CreaterOS
Version:
1.00 2020/8/27 Creation (此文档的版本信息)

Introduction

PaintingliteShortcutSQL 提供SDK框架中部分操作宏定义



Functions

ALTER_TABLE_ADD_COLUMN(NEW_TABLE_NAME,ADD_COLUMN)

修改表

ALTER_TABLE_NAME(OLD_TABLE_NAME,NEW_TABLE_NAME)

修改表

CREATE_TBALE(TABLE_NAME,TABLE_CONTENT)

创建表

DELETE_TABLE(TABLE_NAME,TABLE_DELETE_WHERE)

删除操作

DROP_TABLE(TABLE_NAME)

删除表

INSERT_TABLE(TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT)

插入操作

UPDATE_TABLE(TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE)

更新操作


ALTER_TABLE_ADD_COLUMN(NEW_TABLE_NAME,ADD_COLUMN)


修改表

#define ALTER_TABLE_ADD_COLUMN(NEW_TABLE_NAME,ADD_COLUMN) [NSString stringWithFormat:@"ALTER TABLE %@ ADD COLUMN %@",NEW_TABLE_NAME,ADD_COLUMN] 
Discussion

修改表[列]

See Also


ALTER_TABLE_NAME(OLD_TABLE_NAME,NEW_TABLE_NAME)


修改表

#define ALTER_TABLE_NAME(OLD_TABLE_NAME,NEW_TABLE_NAME) [NSString stringWithFormat:@"ALTER TABLE %@ RENAME TO %@",OLD_TABLE_NAME,NEW_TABLE_NAME] 
Discussion

修改表[名称]

See Also


CREATE_TBALE(TABLE_NAME,TABLE_CONTENT)


创建表

#define CREATE_TBALE(TABLE_NAME,TABLE_CONTENT) [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(%@)",TABLE_NAME,TABLE_CONTENT] 
Discussion

创建表

See Also


DELETE_TABLE(TABLE_NAME,TABLE_DELETE_WHERE)


删除操作

#define DELETE_TABLE(TABLE_NAME,TABLE_DELETE_WHERE) [NSString stringWithFormat:@"DELETE FROM %@ WHERE %@",TABLE_NAME,TABLE_DELETE_WHERE] 
Discussion

删除操作

See Also


DROP_TABLE(TABLE_NAME)


删除表

#define DROP_TABLE(TABLE_NAME) [NSString stringWithFormat:@"DROP TABLE %@",TABLE_NAME] 
Discussion

删除表

See Also


INSERT_TABLE(TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT)


插入操作

#define INSERT_TABLE(TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT) [NSString stringWithFormat:@"INSERT INTO %@(%@) VALUES %@",TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT] 
Discussion

插入操作

See Also


UPDATE_TABLE(TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE)


更新操作

#define UPDATE_TABLE(TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE) [NSString stringWithFormat:@"UPDATE %@ SET %@ WHERE %@",TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE] 
Discussion

更新操作

See Also


Macro Definitions

ALTER_TABLE_ADD_COLUMN

修改表

ALTER_TABLE_NAME

修改表

COMMIT

提交

CREATE_TBALE

创建表

DELETE_TABLE

删除操作

DROP_TABLE

删除表

INSERT_TABLE

插入操作

ROLLBACK

回滚

TRANSACTION

开启事务

UPDATE_TABLE

更新操作


ALTER_TABLE_ADD_COLUMN


修改表

#define ALTER_TABLE_ADD_COLUMN(NEW_TABLE_NAME,ADD_COLUMN) [NSString stringWithFormat:@"ALTER TABLE %@ ADD COLUMN %@",NEW_TABLE_NAME,ADD_COLUMN] 
Discussion

修改表[列]

See Also


ALTER_TABLE_NAME


修改表

#define ALTER_TABLE_NAME(OLD_TABLE_NAME,NEW_TABLE_NAME) [NSString stringWithFormat:@"ALTER TABLE %@ RENAME TO %@",OLD_TABLE_NAME,NEW_TABLE_NAME] 
Discussion

修改表[名称]

See Also


COMMIT


提交

#define COMMIT @"COMMIT" 
Discussion

提交


CREATE_TBALE


创建表

#define CREATE_TBALE(TABLE_NAME,TABLE_CONTENT) [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(%@)",TABLE_NAME,TABLE_CONTENT] 
Discussion

创建表

See Also


DELETE_TABLE


删除操作

#define DELETE_TABLE(TABLE_NAME,TABLE_DELETE_WHERE) [NSString stringWithFormat:@"DELETE FROM %@ WHERE %@",TABLE_NAME,TABLE_DELETE_WHERE] 
Discussion

删除操作

See Also


DROP_TABLE


删除表

#define DROP_TABLE(TABLE_NAME) [NSString stringWithFormat:@"DROP TABLE %@",TABLE_NAME] 
Discussion

删除表

See Also


INSERT_TABLE


插入操作

#define INSERT_TABLE(TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT) [NSString stringWithFormat:@"INSERT INTO %@(%@) VALUES %@",TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT] 
Discussion

插入操作

See Also


ROLLBACK


回滚

#define ROLLBACK @"ROLLBACK" 
Discussion

回滚


TRANSACTION


开启事务

#define TRANSACTION @"BEGAIN" 
Discussion

开启事务


UPDATE_TABLE


更新操作

#define UPDATE_TABLE(TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE) [NSString stringWithFormat:@"UPDATE %@ SET %@ WHERE %@",TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE] 
Discussion

更新操作

See Also