CTPersistance

iOS Database Persistence Layer with SQLite, your next Persistence Layer!

Description

support:

1. CURD 2. Database Migration 3. Objective data present and Plain data present.

this project is also a demo, check the test case for more detail.

Programming language: Objective-C

License: GNU General Public License v3.0 or later

Tags: Database     Objective C     Sqlite    

README

pod "CTPersistance"

CTPersistance is a sqlite wrapper which help you to handle with database.

I'm still writing this document, you can check test case for usage.

Async Operation in CTPersistance

DO NOT USE GCD DIRECTLY

DO NOT USE GCD DIRECTLY

DO NOT USE GCD DIRECTLY

CTPersistance provide CTPersistanceAsyncExecutor to do the async staff.

read:

[[CTPersistanceAsyncExecutor sharedInstance] read:^{
    NSInteger count = COUNT;
    while (count --> 0) {
        TestRecord *record = (TestRecord *)[self.testTable findWithPrimaryKey:@(count) error:NULL];
        NSLog(@"%@", record.primaryKey);
    }
}];

write:

[[CTPersistanceAsyncExecutor sharedInstance] write:^{
    NSInteger count = COUNT;
    while (count --> 0) {
        NSNumber *primaryKey = [self.testTable insertValue:@"casa" forKey:@"name" error:NULL];
        NSLog(@"%@", primaryKey);
    }
}];

see AsyncTestViewController for demo

run CTPersistance project in Simulator, and async test is the live demo for async operation.

Target-Action in CTPersistance

CTPersistance use CTMediator to handle how the database migrate, what secret key to encrypt, where to place the database file.

You should create a target, and just put it into your project, no more code and CTMediator will call your target.

the different database name should have different target, and the target should conform to protocol CTPersistanceConfigurationTarget. see here CTPersistance.h:43

the name of the target object is based on the name of your database file.for example:

say you have a database file which name is:

`aaa.sqlite`, and the target should be `Target_aaa`

`aaa_bbb.sqlite`, and the target should be `Target_aaa`

`aaa_bbb`, and the target should be `Target_aaa`

`aaa.abc.sqlite`, and the target should be `Target_aaa`

`aaa`, and the target should be `Target_aaa`

Available Actions:

• - (NSString *)Action_filePath:(NSDictionary *)params

return the absolute file path as you want. The database file name will be send in the params.

If CTPersistance can not call this method, CTPersistance will find database in [[NSSearchPathForDirectoriesInDomains(NSLibraryDirectory, NSUserDomainMask, YES) firstObject] stringByAppendingPathComponent:databaseName] folder, if still not found, CTPersistance will create the database file in this path with the database file name.

• - (CTPersistanceMigrator *)Action_fetchMigrator:(NSDictionary *)params

return the class name of migrator manager for database migration.

see Target_MigrationTestDatabase.m:20

• - (NSArray *)Action_secretKey:(NSDictionary *)params

return secret key to encrypt the database file.

if you have changed the secret key, keep the old key and append new key in a array and return it.

say you encrypt the database in version 1 (it's the version about your app) by the key oldkey, and you changed this key to newkey in version 2. Some days later you changed the key to newkey2 in version3, you should return an array like this:

@[
    @"oldkey",
    @"newkey",
    @"newkey2",
]

see Target_TestDatabase.m:13

Record

CTPersistance's record does not have to be a specific object. Any object who conforms to CTPersistanceRecordProtocol can be handled by CTPersistance.

That means you can handle any object like UIView、UIViewController with CTPersistance as long as they conforms to CTPersistanceRecordProtocol. For example you can insert a UIView, and fetch the same data as a dictionary or even UIViewController.

Though CTPersistance does not require your object to inherit from a specific model, CTPersistance provide you CTPersistanceRecord if you do not want to implement the protocol.

CRUD Operations

Create : see here

Read : see here

Update : see here

Delete : see here

Upsert : see here

Other Operations

Database Migration : see here

Index of Columns : see here

Transaction : see here

Change Key of Encryption : see here