How to enable DELETE MODE in iOS coredata sqlite using swift

Question

I am learning iOS database creation using CoreData. I created sample application to understand the CoreData.I extracted the Sqlite file from default database creation directory to check the data using SQLite browser.But DBBrowser showing nothing.But success message showing and data retrieving from the database. Then i found this about CoreData database mode.I found the solution to change the WAL mode.After that i run, again WAL mode database is creating in database directory. I am not understanding what wrong happening with my code. Anyone give the solution.

Xcode version:6.3

iOS sdk:8.3

CODE

  lazy var persistentStoreCoordinator: NSPersistentStoreCoordinator? = {
  var options = Dictionary<NSObject, AnyObject>()
  options[NSMigratePersistentStoresAutomaticallyOption] = true
   options[NSInferMappingModelAutomaticallyOption] = true
   options["journal_mode"] = "DELETE" 

    var coordinator: NSPersistentStoreCoordinator? = NSPersistentStoreCoordinator(managedObjectModel: self.managedObjectModel)
    let url = self.applicationDocumentsDirectory.URLByAppendingPathComponent("CoreDartaDemo.sqlite")
    var error: NSError? = nil
    var failureReason = "There was an error creating or loading the application's saved data."
    if coordinator!.addPersistentStoreWithType(NSSQLiteStoreType, configuration: nil, URL: url, options: options, error: &error) == nil 
     {
      error report
     }
     return coordinator
    }()

Matteo Piombo · Accepted Answer · 2015-05-08 07:05:31Z

0

Not sure I fully understand your question, anyway have you tried turning off journaling?

options["journal_mode"] = "OFF"

Hope this helps

answered May 8, 2015 at 7:05

Matteo Piombo

6,7362 gold badges27 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How to enable DELETE MODE in iOS coredata sqlite using swift

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related