Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to save and fetch data from Sqlite database

    @jyoti.rana
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 520
    Comment on it

    First include the sqlite file in your project. Then copy that file from bundle to documents directory as below and create Database method.

    1. -(void)createDatabase{
    2.     NSString *pathForDocumentDirectory =[self databasePath]; //define new path and put old path in new one
    3.     
    4.     if ([[NSFileManager defaultManager]fileExistsAtPath:pathForDocumentDirectory]) {
    5.         return;
    6.         
    7.     }
    8.     
    9.     NSString *path = [[NSBundle mainBundle] pathForResource:@"myDatabase" ofType:@"sqlite"];
    10.     NSLog(@"bundle path %@",path);
    11.     
    12.     NSLog(@"doc dir path %@",pathForDocumentDirectory);
    13.     NSError *error;
    14.     [[NSFileManager defaultManager] copyItemAtPath:path toPath:pathForDocumentDirectory error:&error];
    15.     
    16.     if (error) {
    17.         NSLog(@"error while transferring file=> %@",error.localizedDescription);
    18.     } else {
    19.         NSLog(@"db file saved in documents");
    20.     }
    21.     
    22. }

     

    For Database path we can use below method.

    1. -(NSString *)databasePath{
    2.  
    3.  
    4.     //define the property of databasepath ,path start from zero.
    5.  
    6.  
    7.     NSString *pathForDocumentDirectory=[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask, YES)objectAtIndex:0];
    8.     
    9.     pathForDocumentDirectory=[pathForDocumentDirectory stringByAppendingPathComponent:@"myDatabase.sqlite"];  //add myDatabase in this, myDatabase is the database which we created
    10.     
    11.     return pathForDocumentDirectory; //got database path in pathForDocumentDirectory
    12.     
    13. }

    By using below code we can save data in database.

    1. -(BOOL)saveRecordsInDb {
    2.     
    3.     const char *databasePath = [self.databasePath UTF8String];  //convert db path in char formate
    4.     
    5.     if (sqlite3_open(databasePath, &database) == SQLITE_OK)  //open database
    6.     {
    7.         
    8.         NSString *insertData = [NSString stringWithFormat:@"insert into myTable (firstName,lastName) values (\"%@\",\"%@\")",@"jaya",@"arti"]; //myTable is the table name having two columns first name and last name.
    9.         
    10.         const char *insert_stmt = [insertData UTF8String]; // converting insertData into char
    11.         
    12.         sqlite3_prepare_v2(database, insert_stmt,-1, &statement, NULL);//prepare statement
    13.         
    14.         BOOL success;
    15.         
    16.         if (sqlite3_step(statement) == SQLITE_DONE)//step is used for execution
    17.         {
    18.             success = YES;
    19.         }
    20.         else {
    21.             success = NO;
    22.         }
    23.         
    24.         sqlite3_reset(statement); //reset to value 0
    25.         
    26.         return success;
    27.     }
    28.     return NO;
    29. }
    30.  
    31.  

    If we want to fetch records then we can use following code. In below code we are printing fetched data.
     

    1. -(NSArray *)getAllDetailsFromDb{
    2.     
    3.     const char *databasePath = [self.databasePath UTF8String]; //converting databasePath path into char
    4.     
    5.     NSMutableArray *resultArray = [NSMutableArray new];
    6.     
    7.     if (sqlite3_open(databasePath, &database) == SQLITE_OK)
    8.     {
    9.         
    10.         NSString *getDetails = [NSString stringWithFormat:@"select * from myTable];
    11.         
    12.         const char * get_stmt = [getDetails UTF8String];//convert getDetails into char formate
    13.         
    14.         if (sqlite3_prepare_v2(database,
    15.                                get_stmt, -1, &statement, NULL) == SQLITE_OK)//for connection
    16.         {
    17.             
    18.             while (sqlite3_step(statement) == SQLITE_ROW)
    19.             {
    20.    //it will run values column by column so we have to write column 0 ,column1 and all.
    21.  
    22.                NSString *firstDetail = [[NSString alloc] initWithUTF8String:
    23.                                    (const char *) sqlite3_column_text(statement, 0)];
    24.                 NSString *secondDetail = [[NSString alloc] initWithUTF8String:
    25.                                    (const char *) sqlite3_column_text(statement, 1)];
    26.                 
    27.  
    28.                 NSLog(@"checks are %@ %@ ",firstDetail,secondDetail);
    29.                            
    30.             }
    31.             
    32.             sqlite3_reset(statement);
    33.         }
    34.         
    35.         else{
    36.             NSLog(@"Not found");
    37.             return nil;
    38.         }
    39.     }
    40.     NSLog(@"%@",resultArray);
    41.     return resultArray;
    42. }
    43.  
    44.  
    45.  
    46.  
    47.  

     

    saving data in database sqlite Database Fetch data from database ios create database database path
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: