P0UkDnkc

1-(BOOL) createTable{
2
3[instance.database open];
4
5NSString *query = @"create table if not exists inventorydata (sku text primary key not null, upc text not null, name text, price text, displaySize text, displayFlag integer, status text);";
6
7BOOL success = [instance.database executeStatements:query];
8
9if(success)
10    NSLog(@"Table inventorydata Created Successfully");
11else
12    NSLog(@"Error occured while Creating Table");
13
14[instance.database close];
15return success;}
16	
17-(void)insertData:(Model *)data
18{
19    [instance.database open];
20
21    BOOL isInserted=[instance.database executeUpdate:@"INSERT INTO inventorydata (sku,upc,name,price,displaySize,displayFlag,status) VALUES (?,?,?,?,?,?,?)",data.sku,data.upc,data.name,data.price,data.display_size,data.displayflag,data.status];
22    [instance.database close];
23
24    if(isInserted)
25    NSLog(@"");
26    else
27    NSLog(@"Error occurred while inserting");
28}