OC收山之作： CoreModel Series
##CoreFMDB
.Xcode 5.0, iOS 6.0
.OC,Swift
.Under the MIT License
SERIES
Doesn’t know how to write sql? No worries. Now the second part offers you one key
automatically create table, one key CURD, automatically check model and
dynamically add field, model cascade CURD. All these things are automatic without
one sql code.
Due to my time constraints and ease of use these frames,
the release cycle will be long.
EN：The second part automatically CURD release date: 21/06/2015, so stay tuned or
join our qq group(163865401) to get the latest news, thanks a lot.
EN：I am Charlin Feng, a developer from Chengdu, China. The true spirit of open source is
an attitude and sharing even a challenge to the traditional way. There is no flaunt,
pretentious or money but all my spirits which need your support.
The core purpose of these series frames is replace to Core Data and implement one key Dynamic Cache. This is the first frame with other three followed. You are gonna ask me why make these frame so separately. Even some of my friends blame me at the “chaos” of my projects’ structure. Actually, it’s due to I got a magnificent frame in all my frameworks with a core purpose which is decoupling. Because I believe that I will try my best to separate it if it’s a function module. I feel I benefit from the core idea of decoupling. I hope you guys could understand. Thank you very much.
DEPENDENCE
.FMDB
USAGE
This frame is based on FMDB and it’s static package, all classes method call, thread-safe at the same time.
You don’t need to create datebase object, instance or record. It’s a green, simple and good frame.
1. Introduced header
#import "CoreFMDB.h"
2. the method of the update statement
/**
* 执行一个更新语句
*
* @param sql 更新语句的sql
*
* @return 更新语句的执行结果
*/
+(BOOL)executeUpdate:(NSString *)sql;
3. the method of search statement
/**
* 执行一个查询语句
*
* @param sql 查询语句sql
* @param queryResBlock 查询语句的执行结果
*/
+(void)executeQuery:(NSString *)sql queryResBlock:(void(^)(FMResultSet *set))queryResBlock;
5. Truncate your table
/**
* 清空表（但不清除表结构）
*
* @param table 表名
*
* @return 操作结果
*/
+(BOOL)truncateTable:(NSString *)table;
5. get the recored count of table
/**
* 表记录数计算
*
* @param table 表
*
* @return 记录数
*/
+(NSUInteger)countTable:(NSString *)table;
6. get all the rows of the table
/**
* 查询出指定表的列
*
* @param table table
*
* @return 查询出指定表的列的执行结果
*/
+(NSArray *)executeQueryColumnsInTable:(NSString *)table;
EXAMPLE
BOOL res = [CoreFMDB executeUpdate:@"create table if not exists user(id integer primary key autoIncrement,name text not null default '',age integer not null default 0);"];
if(res){
NSLog(@"创表执行成功 create table succeed");
}else{
NSLog(@"创表执行失败 create table fails");
}
BOOL res2= [CoreFMDB executeUpdate:@"insert into user (name,age) values('jack',27);"];
if(res2){
NSLog(@"添加数据成功 add data succeed");
}else{
NSLog(@"添加数据失败 add data fails");
}
NSArray *columns = [CoreFMDB executeQueryColumnsInTable:@"user"];
NSLog(@"列信息：%@",columns);
[CoreFMDB executeQuery:@"select * from user;" queryResBlock:^(FMResultSet *set) {
while ([set next]) {
NSLog(@"%@-%@",[set stringForColumn:@"name"],[set stringForColumn:@"age"]);
}
}];
NSUInteger count = [CoreFMDB countTable:@"user"];
NSLog(@"当前有%@条记录",@(count));
Career
Charlin's Career
WebSite：http://ios-android.cn
Sina WeiBo：http://weibo.com/charlin2015/
CoreModel Series
One：CoreFMDB https://github.com/nsdictionary/CoreFMDB
Two：CoreArchive https://github.com/nsdictionary/CoreArchive
Three：CoreModel https://github.com/nsdictionary/CoreClass