Swift 3 : db.execute not run with get path use Bundle.main.path

Question

I use path obtained from Bundle.main.path can not insert update sqlite database with db.execute function No display error, I do not understand why, please help me below is my code

var config = Configuration()
config.readonly = false
config.foreignKeysEnabled = false
enter code here
let path1:String = Bundle.main.path(forResource: "data", ofType: "sqlite",inDirectory: "Data")!
db = try DatabaseQueue(path: path1,configuration:  config)
--------------
try db.execute("update detail set favorite = \(newDetail.favorite!) where id = \(newDetail.id!)")

Kalle · Accepted Answer · 2017-09-28 13:52:01Z

1

You can not write into a file within the app bundle, you have to copy the sqlite file to e.g. the documents directory and use that copy to save your data.

answered Sep 28, 2017 at 13:52

Kalle

3023 silver badges11 bronze badges

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

1 Comment

Ngoc Vu Over a year ago

thank you for supporting me, i'm a newbie, can you create an example for me?

Collectives™ on Stack Overflow

Swift 3 : db.execute not run with get path use Bundle.main.path

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related