samedi 28 novembre 2015

How to close database in sqlite in ios?

I am using SqliteDatabase in my project.I am calling a function for data manuplation.

-(void)updateInspectionMapData2:(NSString *)clientid : (NSString *)inspectionid : (NSString *)status
{
    NSLog(@"EIGHT");
    NSLog(@"inside update data");

    const char *dbpath = [databasePath UTF8String];
    if (sqlite3_open(dbpath, &database) == SQLITE_OK)
    {
        NSArray *checkVal = [self getSubClientDataByInspectionId:inspectionid :clientid];
        NSLog(@"check is %@",checkVal);
        if(checkVal == nil || [checkVal count] == 0)
        {
            NSString *querySql=[NSString stringWithFormat:
                                @"UPDATE inspectioninspectormap SET status=\"%@\" where inspectionid = \"%@\" and clientid =\"%@\" and (status = \"1\" or status = \"2\")",status,inspectionid,clientid];
            NSLog(@"sql is %@",querySql);
            const char *sql=[querySql UTF8String];
            if(sqlite3_prepare_v2(database,sql, -1, &statement, NULL) == SQLITE_OK)
            {
                if(SQLITE_DONE != sqlite3_step(statement))
                {
                    NSLog(@"Error while updating. '%s'", sqlite3_errmsg(database));
                }
                else
                {
                    sqlite3_reset(statement);
                    NSLog(@"Update done successfully!");
                }
            }
            sqlite3_finalize(statement);
        }

    }
    sqlite3_close(database);

}

Please tell me is this the right way to close sqlite database.I am not sure i am right because later i get error unable to open database.?

Aucun commentaire:

Enregistrer un commentaire