Databases
StackOverflow2013
Postsdbo
POsqlite database resets on each compile and run
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POsqlite database resets on each compile and run
    primarykey
    data
    text
    <p>I have built up a basic database application in which user can insert records onto a table and app displays them on a TableView.</p> <p>Everything is working as it is supposed to be. For example, the new records do display even if we kill the app from app switcher and relaunch it from the springboard.</p> <p>BUT every time I build and run using Xcode, the database just goes to default records! The new records are just not there.</p> <p>Is it normal?... but what if I want to test my app for new records? Any fix?</p> <p>BTW, JFYI, below is the code I use to make editable DB.</p> <pre><code>-(NSString *)createEditableDatabase{ // Check if DB already exists BOOL success; NSFileManager *fileManager = [NSFileManager defaultManager]; NSError *error; NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES); NSString *documentsDir = [paths objectAtIndex:0]; NSString *writableDB = [documentsDir stringByAppendingPathComponent:@"Database.db"]; success = [fileManager fileExistsAtPath:writableDB]; //The editable DB already exists if (success) { return writableDB; } //The editable DB does not exist //Copy the default DB into App's Doc Dir. NSString *defaultPath = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:@"Database.db"]; success = [fileManager copyItemAtPath:defaultPath toPath:writableDB error:&amp;error]; if (!success) { NSAssert1(0, @"Failed to create writable DB file: '%@'", [error localizedDescription]); } return writableDB; </code></pre> <p>}</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USUmNyobe
    1. USBufferStack
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThe code looks like as if you always run into the "copy default db", you should use an else part for the first `if(success)...`.
      singulars
      1. POsqlite database resets on each compile and run
      1. USNick Weaver
    2. CO@Nick That didn't work :(
      singulars
      1. POsqlite database resets on each compile and run
      1. USBufferStack
    3. CO@Rajat Bansal hard to tell whats going wrong there, can you put NSLogs into your code and see for yourself when the db exists, dumping the filepath etc and see when it gets copied from the default db?
      singulars
      1. POsqlite database resets on each compile and run
      1. USNick Weaver
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload