How to renaming a sqlite table programatically in iphone?

NSString *querystring ="ALTER TABLE GlossaryRelation_Temp RENAME TO GlossaryRelation ";
[self updateStatus:querystring];

-(void)updateStatus:(NSString *)queryString {
    NSString    *docsDir;
    NSArray     *dirPaths;
    dirPaths    = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    docsDir     = [dirPaths objectAtIndex:0];

    strDatabasePath         = [NSString stringWithString:[docsDir stringByAppendingPathComponent:database name]];
    NSFileManager *filemgr  = [NSFileManager defaultManager];

    if ([filemgr fileExistsAtPath: strDatabasePath] == YES)
    {
        const char *dbpath = [strDatabasePath UTF8String];
        if (sqlite3_open(dbpath, &amp;sqlDatabase) == SQLITE_OK)
        {
            const char* beginString = "BEGIN;";
            sqlite3_stmt *compiledstatement;
            sqlite3_prepare_v2(sqlDatabase, beginString, -1, &amp;compiledstatement, NULL);
            if (sqlite3_step(compiledstatement) == SQLITE_DONE) {}
            else NSLog(@"Failed!");
            sqlite3_finalize(compiledstatement);

            NSLog(@"QUERY : %@",queryString);

            const char *selectStatement = [queryString UTF8String];

            sqlite3_prepare_v2(sqlDatabase, selectStatement, -1, &amp;compiledstatement, NULL);

            if (sqlite3_step(compiledstatement) == SQLITE_DONE) {}
            else NSLog(@"Failed!");
            sqlite3_finalize(compiledstatement);

            const char* endString="END;";
            sqlite3_prepare_v2(sqlDatabase, endString, -1, &amp;compiledstatement, NULL);
            if (sqlite3_step(compiledstatement) == SQLITE_DONE) {}
            else NSLog(@"Failed!");
            sqlite3_finalize(compiledstatement);

            sqlite3_close(sqlDatabase);
        }
        else NSLog(@"Failed to open table");
    }
}

@end

NSString *querystring ="ALTER TABLE GlossaryRelation_Temp RENAME TO GlossaryRelation ";

[self updateStatus:querystring];

-(void)updateStatus:(NSString *)queryString {

NSString *docsDir;

NSArray *dirPaths;

dirPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);

docsDir = [dirPaths objectAtIndex:0];

strDatabasePath = [NSString stringWithString:[docsDir stringByAppendingPathComponent:database name]];

NSFileManager *filemgr = [NSFileManager defaultManager];

if ([filemgr fileExistsAtPath: strDatabasePath] == YES)

{

const char *dbpath = [strDatabasePath UTF8String];

if (sqlite3_open(dbpath, &sqlDatabase) == SQLITE_OK)

{

const char* beginString = "BEGIN;";

sqlite3_stmt *compiledstatement;

sqlite3_prepare_v2(sqlDatabase, beginString, -1, &compiledstatement, NULL);

if (sqlite3_step(compiledstatement) == SQLITE_DONE) {}

else NSLog(@"Failed!");

sqlite3_finalize(compiledstatement);

NSLog(@"QUERY : %@",queryString);

const char *selectStatement = [queryString UTF8String];

sqlite3_prepare_v2(sqlDatabase, selectStatement, -1, &compiledstatement, NULL);

if (sqlite3_step(compiledstatement) == SQLITE_DONE) {}

else NSLog(@"Failed!");

sqlite3_finalize(compiledstatement);

const char* endString="END;";

sqlite3_prepare_v2(sqlDatabase, endString, -1, &compiledstatement, NULL);

if (sqlite3_step(compiledstatement) == SQLITE_DONE) {}

else NSLog(@"Failed!");

sqlite3_finalize(compiledstatement);

sqlite3_close(sqlDatabase);

}

else NSLog(@"Failed to open table");

}

@end

Related Posts

Swift Programming Language Interview Questions And Answers-2

Swift Technical Interview Questions and Answers !

Steps to reviewing your codes in IOS !