Geek Answers Handbook

Ios - open sqlite database

I am trying to read data from sqlite database and display it as a table in ios application. But for some reason I can’t open the sqlite database, and the application crashes with the message - Could not open the database.

I created the database using sqlite manager in Firefox and copied the file to the Xcode project.

Here is my code -

-(NSString *)dataFilePath{ NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory , NSUserDomainMask, YES); NSString *documentsDir = [paths objectAtIndex:0]; return [documentsDir stringByAppendingPathComponent:kFilename]; }

I am trying to open a database using sqlite3_open_v2 command inside viewDidLoad

 sqlite3 *database; if (sqlite3_open_v2([[self dataFilePath] UTF8String], &database, SQLITE_OPEN_READWRITE, NULL) != SQLITE_OK) { sqlite3_close(database); // not sure you need to close if the open failed NSAssert(0, @"Failed to open database"); }
+4
source share
2 answers

This is how I open my database. I haven’t been doing SQLite for a long time, and I can’t give you much help other than providing this code, which I use in my application. This is from the class that I use in my application.

 static sqlite3 *database; static sqlite3_stmt *enableForeignKey; @implementation DBAdapter + (sqlite3 *)sharedInstance { if (database == NULL) { sqlite3 *newDBconnection; NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES); NSString *documentsDirectory = [paths objectAtIndex:0]; NSString *path = [documentsDirectory stringByAppendingPathComponent:@"klb_db.sqlite"]; if (sqlite3_open([path UTF8String], &newDBconnection) == SQLITE_OK) { //NSLog(@"Database Successfully Opened :)"); database = newDBconnection; if (sqlite3_prepare_v2(database, "PRAGMA foreign_keys = ON", -1, &enableForeignKey, NULL) != SQLITE_OK) { NSLog(@"ERROR IN PRAGMA!"); } sqlite3_finalize(enableForeignKey); } else { NSLog(@"Error in opening database :("); database = NULL; } } return database; }
+12
source

Am I right in thinking that your question was answered during our discussion in the ios - sqlite statement statement comments? Namely, we want to make sure that the database is included in the package (confirming the setting “Bundle Copy Resources” in Xcode for your target “Build Phase”) and that you want your application to check if the database is in the folder with your documents, and if it is not specified, you will copy it from your package ( [[[NSBundle mainBundle] bundlePath] stringByAppendingPathComponent:kFilename] ) into the document folder.

This may go beyond your original question, but since you are considering the possible deployment of your application and, more importantly, subsequent updates / releases of your application, you might want to add some table to your database with some internal database version number, which you can use to determine which version of the database the user has in the folder of his documents, and make any changes to this database that may be required to support the latter versions of your application. Just a thought.

In any case, if you still have open-ended questions, let us know. Otherwise, I assume that we have resolved your question.

+3
source

More articles:


All Articles