pod 'YHDB', '~> 1.0.3'

#import "NSObject+YHDB.h"

@implementation

- (NSString *)dbName {
    return @"YHDB";
}

//have primaryKey
- (NSString *)primaryKey {
    return @"a";
}

//Perform if you need ensure a row or some rows while primaryKey is AutoIncrement
//自增主键时，如果需要唯一确定一行或者几行时用
- (NSArray *)whereKeysForPrimaryKeyAutoIncrement {
    return @[@"c"];
}
@end

Model *model = [[Model alloc] init];
model.a = 1;
model.b = @"a"
model.c = 1.1;

[model save];//save data to database

Model *model0 = [[Model alloc] init];
model0.a = 1;
model0.b = @"a"
model0.c = 1.1;

Model *model1 = [[Model alloc] init];
model1.a = 2;
model1.b = @"b"
model1.c = 2.2;

[Model save:@[model0, model1]];//save data to database

[model insert];
[Model insert:@[model0, model1]];
[Model insert:@"sql"];
[Model insert:@[sql0,sql1,...];

//1.delete from Model;
[[Model deleteSelf] executeDelete];

//2.delete from Model where a = 1
[[[Model deleteSelf] where:@"a = 1"] executeDelete];
[[[Model deleteSelf] where:@{@"a" : @(1)}] executeDelete];

//3.delete from Model where a in (1,2,3)
[[[Model deleteSelf] whereIn:@"a in (1,2,3)"] executeDelete];
[[[Model deleteSelf] whereIn:@{@"a" : @[@(1), @(2), @(3)]}] executeDelete];

[model update];
[Model update:@[model0, model1]];
[Model update:@"sql"];
[Model update:@[sql0,sql1,...];

//1.select one row to model
Model *model = [[Model alloc] initWithPK:@(1)];

//2.select a lot row to model
NSArray *array = [Model selectModelsWithSql:@"select * from Model"];
NSArray *array = [[Model select:@"*"] executeQuery];
//and...
/**choose what you need:
 *where:     @{key : obj} || @"key = obj" 
 *           [... where:@{@"a" : @(1)}]; [... where:@"a = 1"];
 *whereIn:   @{key : @[obj]} || @"key in (obj)" 
 *           [... whereIn:@"a in (1,2,3)"]; [... whereIn:@{@"a" : @[@(1), @(2), @(3)]}];
 *groupBy:   @[key] || @"key" 
 *           [... groupBy:@"a"]; [... groupBy:@[a]];
 *having:    @"string" [... having:@"a > 1"];
 *orderBy:   @{@"ASC" : @[key]}, @{@"DESC" : @[key]} || @"key ASC", @"key DESC" 
 *           [... orderBy:@"a ASC"]; [... orderBy:@{@"ASC" : @[@"a"]];
 *limit:     0, size [... limit:0, 10];
 */

 //3.select count
 NSInteger count = [[Model selectCount] executeQueryCount];

[Model executeUpdateWithSql:@"sql"];

NSArray *array = [Model executeQueryWithSql:@"sql"];

[Model resetDB];

[Model createIndexOnColumn:@"a"];

[Model dropIndexOnColumn:@"a"];

@interface Model
//add a property
@property (nonatomic, strong)NSString *d;
@end

[Model alterTableAddColumn:@"d"];

[Model drop];