MadSqlite 0.2.3

MadSqlite 0.2.3

测试已测试
语言语言 CC
许可证 BSD
发布上次发布2017年3月

Will Kamp 维护。



MadSqlite 0.2.3

  • 作者
  • William Kamp

MadSqlite iOS Objective-C 框架

MadSqlite 可通过 CocoaPods 获得。要安装它,只需将以下行添加到 Podfile 中

pod 'MadSqlite', '~> 0.2.3'

或者最新版

pod 'MadSqlite', :git => 'https://github.com/manimaul/madsqlite-ios-objc.git', :submodules => true

示例

// Open / create database
id <MADDatabase> md = [MADSqliteFactory databaseNamed:@"mydb"];
[md exec:@"CREATE TABLE location_table(name TEXT, latitude REAL, longitude REAL, image BLOB);"];

// Insert into database
id <MADContentValues> cv = [MADSqliteFactory contentValues];
[cv putString:@"name" withValue:@"Cheshire Cat"];
[cv putReal:@"latitude" withValue:@(51.2414945)];
[cv putReal:@"longitude" withValue:@(-0.6354629)];
NSData *data = UIImagePNGRepresentation([UIImage imageNamed:@"Cheshire Cat"]);
[cv putBlob:@"image" withValue:data];
[md insert:@"location_table" withValues:cv];

// Query database
id <MADQuery> query = [md query:@"SELECT name, latitude, longitude FROM location_table WHERE name=?"
                       withArgs:@[@"Cheshire Cat"]];
if ([query moveToFirst]) {
    while (![query isAfterLast]) {
        NSString *name = [query getString:0];
        NSNumber *latitude = [query getReal:1];
        NSNumber *longitude = [query getReal:2];
        NSLog(@"name:%@ latitude:%@ longitude:%@", name, latitude, longitude);
        [query moveToNext];
    }
}