Importing existing sqlite db into Swift project

Question

I have not developed anything for IOS in a long time so please bear with me. Using the Swift language for the first time in XCode 6.3. I have a pre-existing sqlite database, myDB.sqlite, that I want to import into my project.

I have added the sqlite Framework, added FMDB and the bridging header file and then added the myDB.sqlite file to my project. It is also included in "Copy Bundle Resources".

I am just trying to access myDB.sqlite in my bundle directory to copy it to my Documents directory when the app is run for the first time in the Simulator. However it keeps saying it cannot find the file.

In my AppDelegate.swift:

let dbPath = NSBundle.mainBundle().pathForResource("myDB", ofType:"sqlite")

It keeps telling me that dbPath is nil.

"added the myDB.sqlite file to my project. It is also included in Copy Bundle Resources" But clearly this was not done correctly, since if it were, dbPath would not be nil. Select myDB.sqlite in the Project navigator and use the File inspector to examine its Target membership; is it part of your app target? — matt
– matt, Commented Jun 12, 2015 at 22:14
You are right. Thank you. It has been a VERY long day. I'd accidentally deleted the myDB.sqlite file (as I hadn't physically copied it into my Project folder) while doing some cleaning up and for some reason, Xcode did not mark the file as red (to warn me that it was missing). I copied everything back and it works now. Duh! Thanks for pointing out my stupidity, now I need some zzzz. — Pompey Casmilus
– Pompey Casmilus, Commented Jun 12, 2015 at 22:39

techraf · Accepted Answer · 2016-03-19 08:54:10Z

4

Check the target membership of your SQLite database and it's done:

check

edited Mar 19, 2016 at 8:54

techraf

69.2k30 gold badges211 silver badges215 bronze badges

answered Mar 19, 2016 at 7:52

Peter Andrew

1031 silver badge7 bronze badges

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

1 Comment

jaredrada Over a year ago

This should be the accepted answer. Its one of a few things you need to do to access a file (along with potentially copying the resource into the Documents directory as in: stackoverflow.com/questions/53073791/…)

Collectives™ on Stack Overflow

Importing existing sqlite db into Swift project

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related