How to update a table in SQLite database in objective C?

Question

I created a table named "dept" in sqlite manually that has username (as Varchar) and Password (as Integer).

I used the following code to update a table

NSString *database2=[[NSBundle mainBundle]pathForResource:@"deptDatabase" ofType:@"sqlite"];
NSString *databasePath2=[NSString stringWithFormat:@"%@",database2];

const char *dbPath=[databasePath2 UTF8String];
if (sqlite3_open(dbPath, &dbHandler)==SQLITE_OK) {
    NSLog(@"database Opened");
    const char* updateQuery="update dept set password=1234 where username='suren'";
    sqlite3_stmt *stmt;
    if (sqlite3_prepare_v2(dbHandler, updateQuery, -1, &stmt, NULL)==SQLITE_OK) {
        NSLog(@"Query Executed");
    }
}

sqlite3_close(dbHandler);

but the table seems to be not updating. Can anyone pls tell me how to update the table by altering the above code. Thanks in advance

rckoenes · Accepted Answer · 2012-05-22 09:18:40Z

3

You can't not update fils in the mainBundle, these files are readonly.

To make changes to the database, you will have to copy it to the document directory. And use the database in the document directory and not the one in the main bundle. Only use the one in the main bundle as a payload file to be copied to the document directory if there is not file there.

Why do you create a new string here:

NSString *database2=[[NSBundle mainBundle]pathForResource:@"deptDatabase" ofType:@"sqlite"];
NSString *databasePath2=[NSString stringWithFormat:@"%@",database2];

The database2 is same as databasePath2. You are only using up memory here.

answered May 22, 2012 at 9:18

rckoenes

69.5k9 gold badges136 silver badges168 bronze badges

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

2 Comments

surendher Over a year ago

Thanks...As you told files in the mainBundle are read only, what is the alternative way to solve my issue.

rckoenes Over a year ago

I've edited my answer to suggest a way. Copy the file to the document directory and don't use the one the main bundle. Just use the the file in main bundle as a payload.

Anshuk Garg · Accepted Answer · 2012-05-22 10:17:02Z

copy file from bundle to documents directory

NSString *databaseName = @"YOUR DB NAME WITH EXTENSION";
// Get the path to the documents directory and append the databaseName
NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString *documentsDir = [documentPaths objectAtIndex:0];
NSString *databasePath = [documentsDir stringByAppendingPathComponent:databaseName];

NSFileManager *fileManager = [NSFileManager defaultManager];
BOOL success=[fileManager fileExistsAtPath:databasePath];

if (!success) {

    NSString *databasePathFromApp = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:databaseName];

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

then u can work in the path databasePath (documents directory)

const char *dbPath=[databasePath UTF8String];
if (sqlite3_open(dbPath, &dbHandler)==SQLITE_OK) {
    NSLog(@"database Opened");
    const char* updateQuery="update dept set password=1234 where username='suren'";
    sqlite3_stmt *stmt;
    if (sqlite3_prepare_v2(dbHandler, updateQuery, -1, &stmt, NULL)==SQLITE_OK) {
        NSLog(@"Query Executed");
    }
}

sqlite3_close(dbHandler);

hope it helps.. happy coding :)

Collectives™ on Stack Overflow

How to update a table in SQLite database in objective C?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related