CPPm4Qv0

1NSString *searchTable = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@ (%@ INTEGER PRIMARY KEY, %@ TEXT, %@ TEXT, %@ TEXT)", gPsalmVersesTableName, gIDKey , gNameKey, gVerseKey, gTextKey];
2if (sqlite3_exec(mInfoDB, [searchTable UTF8String], NULL, NULL, &errMsg) != SQLITE_OK)
3    NSLog(@"Failed to create table %@", gPsalmVersesTableName);
4
5NSString *virtualTable = [NSString stringWithFormat:@"CREATE VIRTUAL TABLE IF NOT EXISTS %@ USING fts4 (content='%@', %@)",gFTSPsalmVersesTableName, gPsalmVersesTableName, gTextKey];
6if (sqlite3_exec(mInfoDB, [virtualTable UTF8String], NULL, NULL, &errMsg) != SQLITE_OK)
7    NSLog(@"Failed to create table %@", gFTSPsalmVersesTableName);
8	
9if (sqlite3_open([mDataBaseName UTF8String], &mInfoDB) == SQLITE_OK)
10    {
11        sqlite3_stmt *statement;
12        @try
13        {
14            NSString *rebuildSQL = [NSString stringWithFormat:@"INSERT INTO %@(%@) VALUES('rebuild')", gFTSPsalmVersesTableName, gFTSPsalmVersesTableName];
15
16            int result = sqlite3_prepare_v2(mInfoDB, [rebuildSQL UTF8String], -1, &statement, NULL);
17            NSLog(@"%s", sqlite3_errstr(result));
18        }
19        @finally
20        {
21            sqlite3_finalize(statement);
22            sqlite3_close(mInfoDB);
23        }
24    }