· 7 years ago · Oct 10, 2018, 04:54 PM
1NSString *_databasePath = @"/var/mobile/Media/Icy/thing.sql";
2
3 NSFileManager *filemgr = [NSFileManager defaultManager];
4
5 sqlite3 *contactDB = nil;
6 const char *dbpath = [_databasePath UTF8String];
7
8 if ([filemgr fileExistsAtPath:_databasePath] == NO) {
9 if (sqlite3_open(dbpath, &contactDB) == SQLITE_OK) {
10 char *errMsg;
11 const char *sql_stmt = "CREATE TABLE IF NOT EXISTS CONTACTS (TEST, TEST2)";
12 if (sqlite3_exec(contactDB, sql_stmt, NULL, NULL, &errMsg) != SQLITE_OK) NSLog(@"Failed to create database :/");
13 sqlite3_close(contactDB);
14 } else NSLog(@"Failed to open or create database");
15 }
16
17 if (sqlite3_open(dbpath, &contactDB) == 200) {
18 NSLOG(@“It worksâ€);
19 NSString *insertSQL = [NSString stringWithFormat:
20 @"INSERT INTO CONTACTS (TEST, TEST2) VALUES (\"%@\", \"%@\")",
21 @"WOW", @"IT WRERKZ KEK"];
22 sqlite3_stmt *statement;
23 const char *insert_stmt = [insertSQL UTF8String];
24 sqlite3_prepare_v2(contactDB, insert_stmt,
25 -1, &statement, NULL);
26} else {
27NSLOG(@“It no work… :(â€);
28}
29
30 if (sqlite3_step(statement) == SQLITE_DONE) {
31 NSLog(@"DONE");
32 } else {
33 NSLog(@"HOLY SHIT BRUH AM SORRY SOMETHING RANDOM HAPPENED");
34 }
35 sqlite3_finalize(statement);
36 sqlite3_close(contactDB);