Opening multiple databases with SQLite

@interface database : NSObject {
        sqlite3 * db;
        sqlite3_stmt * query;
        NSString *queryString;
        NSString *dbPath;
}

- (void) opendb;
- (BOOL)attach_user_databases;

@end

@implementation database

- (void) opendb
{
        dbpath = [[NSBundle mainBundle] pathForResource:@"levels" ofType:@"db"];
        sqlite3_open([dbpath UTF8String], &db);

        [self attach_user_databases];

         sqlite3_prepare_v2(db, [queryString UTF8String], -1,  &query, NULL);
}

- (BOOL)attach_user_databases
{
    int dbcount = 0, result;
    NSFileManager *fm = [NSFileManager defaultManager];
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0];
    NSDirectoryEnumerator *docs = [fm enumeratorAtPath:documentsDirectory];
    NSString *file;
    while ((file = [docs nextObject])) {
        if ([[file pathExtension] isEqualToString:@"sqlite3"]) {
            ++dbcount;
            NSString *fullPath = [documentsDirectory stringByAppendingPathComponent:file];
            sqlite3_stmt *attach;
            sqlite3_prepare_v2(db,[[NSString stringWithFormat:@"ATTACH DATABASE '%@' AS 'DB%i'",fullPath,dbcount] UTF8String], -1, &attach, NULL);
            sqlite3_step(attach);
            sqlite3_finalize(attach);
        }
    }
    if (dbcount == 0) {
        queryString = @"SELECT * FROM levels WHERE ROWID=?";
        return NO;
    }
    else {
        sqlite3_stmt *cview;
        NSMutableString *createView = [NSMutableString stringWithString:@"CREATE TEMP VIEW LV AS SELECT * FROM levels"];
        for (int i=1;i<=dbcount;++i) {
            [createView appendFormat:@" UNION SELECT * FROM DB%i.levels",i];
        }
        sqlite3_prepare_v2(db, [createView UTF8String], -1, &cview, NULL);
        sqlite3_step(cview);
        sqlite3_finalize(cview);
        queryString = @"SELECT * FROM LV WHERE ROWID=?";
        return YES;
    }
}

@end
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值