Advertisement
wkerswell

multidimensional dictionary

Oct 24th, 2012
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. //My Dictionary of objects.
  2.  
  3. -(NSMutableDictionary *)getAllPOI{
  4.     //select sponser details
  5.  
  6.     //create sql string
  7.     NSString *sql = [NSString stringWithFormat:@"SELECT * FROM POI;"];
  8.    
  9.     //create sql statement
  10.     sqlite3_stmt *statment;
  11.    
  12.     //create array to stire all the entires in.
  13.     NSMutableDictionary *dic =[[NSMutableDictionary alloc]init ];
  14.    
  15.     //check to make sure statement runs ok
  16.     if (sqlite3_prepare_v2(db, [sql UTF8String], -1, &statment, nil) == SQLITE_OK) {
  17.        
  18.         //foreach row
  19.         while (sqlite3_step(statment)==SQLITE_ROW) {
  20.            
  21.             POIDataObject * mydata = [[POIDataObject alloc] init];
  22.            
  23.             char *field0 = (char *) sqlite3_column_text(statment, 0);
  24.             char *field1 = (char *) sqlite3_column_text(statment, 1);
  25.             char *field2 = (char *) sqlite3_column_text(statment, 2);
  26.             char *field3 = (char *) sqlite3_column_text(statment, 3);
  27.             char *field4 = (char *) sqlite3_column_text(statment, 4);
  28.             char *field5 = (char *) sqlite3_column_text(statment, 5);
  29.             char *field6 = (char *) sqlite3_column_text(statment, 6);
  30.             char *field7 = (char *) sqlite3_column_text(statment, 7);
  31.             char *field8 = (char *) sqlite3_column_text(statment, 8);
  32.             char *field9 = (char *) sqlite3_column_text(statment, 9);
  33.             char *field10 = (char *) sqlite3_column_text(statment, 10);
  34.             char *field11 = (char *) sqlite3_column_text(statment, 11);
  35.             char *field13 = (char *) sqlite3_column_text(statment, 13);
  36.            
  37.             mydata.poiID = [[NSString alloc]initWithUTF8String:field0];
  38.             mydata.name = [[NSString alloc]initWithUTF8String:field1];
  39.             mydata.catID = [[NSString alloc]initWithUTF8String:field2];
  40.             mydata.description = [[NSString alloc]initWithUTF8String:field3];
  41.             mydata.latitude = [[NSString alloc]initWithUTF8String:field4];
  42.             mydata.longitude = [[NSString alloc]initWithUTF8String:field5];
  43.             mydata.www = [[NSString alloc]initWithUTF8String:field6];
  44.             mydata.email = [[NSString alloc]initWithUTF8String:field7];
  45.             mydata.phone = [[NSString alloc]initWithUTF8String:field8];
  46.             mydata.status = [[NSString alloc]initWithUTF8String:field9];
  47.             mydata.retailer = [[NSString alloc]initWithUTF8String:field10];
  48.             mydata.sponsor = [[NSString alloc]initWithUTF8String:field11];
  49.             mydata.baner = [[NSString alloc]initWithUTF8String:field13];
  50.            
  51.            
  52.             [dic setObject:mydata forKey:mydata.poiID];
  53.         }
  54.     }
  55.     NSLog(@"pois: %@",[dic objectForKey:@"1"]);
  56.    
  57.     return dic;
  58.    
  59. }  
  60.  
  61.  
  62.  
  63.  
  64.  
  65.  
  66.  
  67.  NSMutableDictionary *allPOIs = [[NSMutableDictionary alloc]init];
  68.     allPOIs = [dataBase getAllPOI];
  69.  
  70.      for (NSMutableDictionary *pois in allPOIs) {
  71.        
  72.          NSLog(@"The POI sub dic: %@",pois);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement