JCDB
A lightweight iOS database framework based on FMDB and SQLite.
Features
This framework supports the development of iOS 7.0+ in ARC.
- Database table CREATE/DROP/ALERT.
- Database records queries with SELECT.
- Database records INSERT/REPLACE/UPDATE/DELETE.
Create and close database
[[JCDBManager sharedManager] createWithDBName:@"testDB.sqlite"];[[JCDBManager sharedManager] closeDB];Table operation
CREATE table
[JCTestRecord createTable];ALERT table
[JCTestRecord alterTableWithColumn:@"testUnsignedLongLongInt"];DROP table
[JCTestRecord dropTable];Current record operation
INSERT OR REPLACE statement
JCTestRecord *record = [[JCTestRecord alloc] init];
record.testPrimaryKey = [NSString stringWithFormat:@"primaryKeyProperty%@", @(index + 1)];
record.testIgnore = @"ignoreProperty";
record.testMutableString = [[NSMutableString alloc] initWithString:@"mutableStringProperty"];
record.testNumber = @(6.20);
record.testDecimalNumber = [[NSDecimalNumber alloc] initWithString:@"2016"];
record.testDate = [NSDate date];
record.testData = [@"dataProperty" dataUsingEncoding:NSUTF8StringEncoding];
record.testMutableData = [NSMutableData dataWithData:[@"mutableDataProperty" dataUsingEncoding:NSUTF8StringEncoding]];
record.testBOOL = YES;
record.testShort = 6;
record.testInt = 20;
record.testLong = 20160620;
record.testInteger = index + 1;
record.testEnumType = (index + 1) % 3;
record.testInt64 = (index + 1)*24*3600;
record.testUInteger = 201606;
record.testFloat = 10.5;
record.testCGFloat = 1.26;
record.testDouble = 10.52;
record.testTimeInterval = 978307200.0;
record.testLongInt = 10000010;
record.testLongLongInt = 1000000110;
record.testUnsignedLongLongInt = 100000000111;
BOOL result = [record updateRecord];UPDATE statement
result = [record updateRecordColumns:@[@"testBOOL", @"testDate", @"testNumber"]
values:@[@(NO), [NSDate dateWithTimeIntervalSince1970:9], @(6.22)]];DELETE statement
result = [record deleteRecord];Records operation
SELECT records queries
JCTestRecord *record = [JCTestRecord queryRecordWithPrimaryKeyValue:@"primaryKeyProperty2"];NSArray *queryRecords = [JCTestRecord queryRecordsWithConditions:@{@"testEnumType":@(JCTestEnumTypeTwo)}];queryRecords = [JCTestRecord queryRecordsWithConditionalExpression:@"WHERE testEnumType < ?"
arguments:@[@(JCTestEnumTypeTwo)]];queryRecords = [JCTestRecord queryRecordsWithConditionalExpression:@"ORDER BY testEnumType DESC"
arguments:nil];queryRecords = [JCTestRecord queryAllRecords];SELECT record columns queries
NSArray *queryColumns = [JCTestRecord queryColumns:@[@"testPrimaryKey", @"testDate"]
conditionalExpression:@"WHERE testEnumType < ? ORDER BY testInteger DESC"
arguments:@[@(JCTestEnumTypeOne)]];SELECT count queries
uint64_t count = [JCTestRecord countRecordsWithConditions:@{@"testEnumType":@(JCTestEnumTypeTwo)}];count = [JCTestRecord countRecordsWithConditionalExpression:@"WHERE testEnumType < ?"
arguments:@[@(JCTestEnumTypeOne)]];count = [JCTestRecord countAllRecords];DELETE statement
BOOL result = [JCTestRecord deleteRecordsWithConditions:@{@"testEnumType":@(JCTestEnumTypeTwo)}];result = [JCTestRecord deleteRecordsWithConditionalExpression:@"WHERE testEnumType < ?"
arguments:@[@(JCTestEnumTypeOne)]];result = [JCTestRecord deleteAllRecords];CocoaPods
To integrate JCDB into your iOS project, specify it in your Podfile:
pod 'JCDB'
##Contacts If you have any questions or suggestions about the framework, please E-mail to contact me.
Author: Joych E-mail: imjoych@gmail.com
License
JCDB is released under the MIT License.
