Skip to content
/ JCDB Public

A lightweight iOS database framework based on FMDB and SQLite.

License

Notifications You must be signed in to change notification settings

imjoych/JCDB

Repository files navigation

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.