sqlite connection with Objective C

Question

I have a simple piece of code where I connect my sqliteDb. My sqlite3_prepare_v2 though repeatedly fails. I narrowed it down to the following piece of code:

NSString *sqLiteDb = [[NSBundle mainBundle] pathForResource:@"xyz" ofType:@"sqlite3"];

sqLiteDb returns null. I don't know why - tried everything I could and followed many threads. Really struggling here - please help.

dreamlax · Accepted Answer · 2013-01-30 04:18:01Z

1

Are you sure your xyz.sqlite3 file is included in the correct Target Membership? If it is not included, then it will not be copied to your bundle when building.

Screenshot

answered Jan 30, 2013 at 4:18

dreamlax

95.7k31 gold badges166 silver badges211 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

iAppDeveloper · Accepted Answer · 2013-01-30 04:50:04Z

Try this

in.h file

 NSString *databasePath;


in .m file


NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,               NSUserDomainMask, YES);
  NSString *documentsDir = [documentPaths objectAtIndex:0];
  databasePath = [documentsDir stringByAppendingPathComponent:@"dbname.sqlite"];    
  [self checkAndCreateDatabase];

-(void) checkAndCreateDatabase
    {
     // Check if the SQL database has already been saved to the users phone, if not then copy it over
     BOOL success;

     // Create a FileManager object, we will use this to check the status
     // of the database and to copy it over if required
     NSFileManager *fileManager = [NSFileManager defaultManager];

     // Check if the database has already been created in the users filesystem
     success = [fileManager fileExistsAtPath:databasePath];

     // If the database already exists then return without doing anything
     if(success) return;

     // If not then proceed to copy the database from the application to the users filesystem

     // Get the path to the database in the application package
     NSString *databasePathFromApp = [[[NSBundle mainBundle] resourcePath]  stringByAppendingPathComponent:databaseName];

     // Copy the database from the package to the users filesystem
     [fileManager copyItemAtPath:databasePathFromApp toPath:databasePath error:nil];

   }

Collectives™ on Stack Overflow

sqlite connection with Objective C

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related