mercredi 7 janvier 2015

retrieving data from sqlite DB IOS

-(void)loadProjectWithId:(int)rowID { //This is where you build up your model and create instances of the objects NSString *query = [NSString stringWithFormat:@"SELECT * FROM project WHERE rowId=%d", rowID]; NSArray* resultsArray = [self.dbManager loadDataFromDB:query];



if (resultsArray.count == 1) {
int nameIndex = [[self.dbManager arrColumnNames] indexOfObject:@"name"];
NSString* databaseName = resultsArray[0][nameIndex];
NSLog(@"databaseName %@",databaseName);

}

NSString *query2 = [NSString stringWithFormat:@"SELECT * FROM screen WHERE projectId=%d", rowID];
resultsArray = [self.dbManager loadDataFromDB:query2];
for (NSArray* row in resultsArray) {
int imageIndex = [[self.dbManager arrColumnNames] indexOfObject:@"image"];
NSString* imageData = row[imageIndex];
NSLog(@"imagedata retrieved");
UIImage* image = [UIImage toImage:imageData];
}

Project *project = [[Project alloc]init];
project.name = @"Your Project";
NSMutableArray * screens = [NSMutableArray array];

Screen *screen1 = [[Screen alloc]init ];
screen1.title=@"just some title I added";
screen1.imageData=@"SELECT * FROM screen,image WHERE projectId=%d", rowID;
screen1.task =@"some task I added";

[screens addObject:screen1];


Screen *screen2 = [[Screen alloc]init ];
screen2.title=@"just some title I added";
screen2.imageData = @"SELECT * FROM screen WHERE projectId=%d", rowID;
screen2.task=@"some task I added";

[screens addObject:screen2];

project.screens = [screens copy];

NSLog(@"%@", screen1.imageData);

Aucun commentaire:

Enregistrer un commentaire