It is not showing updated database manually in objective c

Question

I am using SQLite database (firefox addon) to my iOS development. I insert data manually to my database. but first time run the program , show that data. but after insert again data to database in manually that data is not showing. I'm beginner for ios development. Bellow has my database connection. please help.

- (void)viewDidLoad
{
    NSString *defaultDBPath;
    NSFileManager *fileManager = [NSFileManager defaultManager];
    NSError *error;
    NSString *ddPath = [self getDBPath];
    BOOL success = [fileManager fileExistsAtPath:ddPath];

    if(!success) {

        defaultDBPath = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:@"AddressBook.sqlite"];
        success = [fileManager copyItemAtPath:defaultDBPath toPath:ddPath error:&error];

        if (!success)
            NSAssert1(0, @"Failed to create writable database file with message '%@'.", [error localizedDescription]);
    }

   // const char *dbpath=[ddPath UTF8String];
    const char *dbpath1=[ddPath UTF8String];
    sqlite3_stmt *statement;
     NSMutableArray  *company =[[NSMutableArray alloc]init];

    if (sqlite3_open(dbpath1, &contactDB)==SQLITE_OK)
    {
        NSString *querySQL=[NSString stringWithFormat:@"SELECT CompanyName FROM tblCompany order by CompanyName"];

        const char *query_stmt=[querySQL UTF8String];

        if (sqlite3_prepare_v2(contactDB, query_stmt, -1, &statement, NULL)==SQLITE_OK)
        {
            int i=0;
            while(sqlite3_step(statement)==SQLITE_ROW)
            {
                NSString *my=[[NSString alloc]initWithUTF8String:(const char*)sqlite3_column_text(statement, 0)];
                NSLog(@"name %@",my);


               [company insertObject:my atIndex:i];
               i=i+1;
                companyDetails=[NSDictionary dictionaryWithContentsOfFile:my];

               // [[cell textlabel] setText:my];
            }
            companies =company;
            companyKey=[companyDetails allKeys];
            sqlite3_finalize(statement);
        }
        else
            NSLog(@"Not connected");
        sqlite3_close(contactDB);
    }

Getdatabase path method ::

- (NSString *) getDBPath {
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory , NSUserDomainMask, YES);
    NSString *documentsDir = [paths objectAtIndex:0];
    return [documentsDir stringByAppendingPathComponent:@"Address.sqlite"];
}

I tried these but ti is not showing updated database data in my iOS application. Please give me a solution.

You are only copying the database once. After that it exists in your doc directory and will not be copied again. — borrrden
– borrrden, Commented Jan 8, 2013 at 3:54
This is because each time you are running your application a new sqlite file is created. — Anusha Kottiyal
– Anusha Kottiyal, Commented Jan 8, 2013 at 4:29
If you are adding manually to the .sqlite file in your project then you need to reset the simulator. Else if you are opening the file from finder and then open .sqlite and making changes it wont reflect in your database — Dhara
– Dhara, Commented Jan 8, 2013 at 4:47

NANNAV · Accepted Answer · 2013-01-08 04:20:57Z

0

you not check .sqlite file in project folder,to check file path like this

/Users/username/Library/Application Support/iPhone Simulator/5.0/Applications/4F4574E2-AD8A-493E-9B16-2D456AFAEB6C/Documents/your file.sqlite 

//username - your user name
//4F4574E2-AD8A-493E-9B16-2D456AFAEB6C  -it changed for projects

answered Jan 8, 2013 at 4:20

NANNAV

4,9014 gold badges34 silver badges50 bronze badges

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

1 Comment

Himesh Over a year ago

I found the reason for this. This path was the problem. Thank You !

Collectives™ on Stack Overflow

It is not showing updated database manually in objective c

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related