как да добавите NSDictionary в ред на таблица в sqlite DataBase

можете да направите това, като създадете таблица с три колони (използване на заявка за създаване на таблица). И след това вмъкнете тези обекти от вашия речник в тези колони (използвайки заявка за вмъкване).

Редактиране: За вмъкване на данни използвайте заявка:

            NSString *query = [NSString stringWithFormat:@"insert into tablename (column1, column2,column3) values('%@','%@','%@')",[dic objectForKey:@"id"],[dic objectForKey:@"name"],[dic objectForKey:@"size"]];
            NSLog(@"query : %@",query);
            [self executeQuery:query];

В .h клас направете екземпляр на sqlite:

sqlite3 *database; and import:  #import<sqlite3.h>

В .m клас направете добавяне на тези методи:

-(NSString *) dataFilePath
{
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0];
    NSLog(@"PATH %@",[documentsDirectory stringByAppendingPathComponent:DatabaseName]);
    return [documentsDirectory stringByAppendingPathComponent:DatabaseName];
}

/*==================================================================
              METHOD FOR INSERTING DATA IN DATABASE
 ==================================================================*/
-(void)executeQuery:(NSString *)query
{
    //NSLog(@"QUERY : %@",query);

    sqlite3_stmt *statement;
    if(sqlite3_open([[self dataFilePath] UTF8String], &database) == SQLITE_OK)
    {
        if (sqlite3_prepare_v2(database, [query UTF8String], -1, &statement, NULL) == SQLITE_OK)
        {
            if (sqlite3_step(statement) != SQLITE_DONE)
            {
                sqlite3_finalize(statement);
            }
        }
        else
        {
            NSLog(@"query Statement Not Compiled");
        }

        sqlite3_finalize(statement);
        sqlite3_close(database);
    }
    else
    {
        NSLog(@"Data not Opened");
    }
}

За четене на данни:

/*==================================================================
 METHOD FOR Fetching Data FROM DATABASE
 ==================================================================*/
 NSString *query = [NSString stringWithFormat:@"select * from table_name"];
NSMutableArray *tableData = [self fetchingDataFromTable:query];

// Тук масивът от данни на таблицата съдържа всички записи

-(NSMutableArray *)fetchingDataFromTable:(NSString *)query;
{
    NSLog(@"QUERY : %@",query);

    NSString *idToReturn=@"";
    NSMutableArray *returnArray = [NSMutableArray new];
    if(sqlite3_open([[self dataFilePath] UTF8String], &database) == SQLITE_OK)
    {
        sqlite3_stmt *statement;
        if (sqlite3_prepare_v2(database, [query UTF8String], -1, &statement, nil)==SQLITE_OK)
        {
            while(sqlite3_step(statement)==SQLITE_ROW)
            {
                NSMutableDictionary *temp= [NSMutableDictionary new];
                const char *s;


                s=(char *)sqlite3_column_text(statement, 0);
                if(s==NULL)
                {
                    idToReturn=@"";
                }
                else
                {
                    idToReturn =[NSString stringWithUTF8String:s];
                }
                [temp setObject:idToReturn forKey:@"id"];

                s=(char *)sqlite3_column_text(statement, 1);
                if(s==NULL)
                {
                    idToReturn=@"";
                }
                else
                {
                    idToReturn =[NSString stringWithUTF8String:s];
                }
                [temp setObject:idToReturn forKey:@"name"];

                s=(char *)sqlite3_column_text(statement, 2);
                if(s==NULL)
                {
                    idToReturn=@"";
                }
                else
                {
                    idToReturn =[NSString stringWithUTF8String:s];
                }
                [temp setObject:idToReturn forKey:@"size"];

                if (temp != nil)
                {
                    [returnArray addObject:temp];

                    temp = nil;
                }

            }
            sqlite3_finalize(statement);
            sqlite3_close(database);
        }
    }
    return returnArray;

}

Дано ти помогне.

// ------- Base User -------------- //

public interface IBaseUser
{
    int Id { get; set; }
}
public class BaseUser : IBaseUser
{
    public int Id { get; set; }
}

// -------- Individual User --------//

public interface IIndividualUser : IBaseUser
{
    string Gender { get; set; }
}
public class IndividualUser: BaseUser, IIndividualUser
{
    public string Gender { get; set; }
}

// -------- Legal User --------//

public interface ILegalUser : IBaseUser
{
    string VatNumber { get; set; }
}
public class LegalUser : BaseUser, ILegalUser
{
    public string VatNumber { get; set; }
}

// -------- Base User Repo --------//

public interface IBaseUserRepo<T> where T: BaseUser
{
    T GetById(int id);
}
public class BaseUserRepo<T> where T : BaseUser, IBaseUserRepo<T>
{
    public T GetById(int id)
    {
        // logic...
    }
}

// -------- Individual User Repo --------//

public interface IIndividualUserRepo : IBaseUserRepo<IndividualUser>
{
    IndividualUser GetByGender(string gender);
}
public class IndividualUserRepo : BaseUserRepo<IndividualUser>, IIndividualUserRepo
{
    public IndividualUser GetByGender(string gender)
    {
        // logic...
    }
}

// -------- Legal User Repo --------//

public interface ILegalUserRepo : IBaseUserRepo<LegalUser>
{
    LegalUser GetByVatNumber(string vatNumber);
}
public class LegalUserRepo : BaseUserRepo<LegalUser>, ILegalUserRepo
{
    public LegalUser GetByVatNumber(string vatNumber)
    {
        // logic...
    }
}

public class IndividualUserRepo : BaseUserRepo<IndividualUser>, IIndividualUserRepo

public class LegalUserRepo : BaseUserRepo<LegalUser>, ILegalUserRepo

public class BaseUserRepo<T> where T : BaseUser, IBaseUserRepo<T>

Създадох динамичен код, който ще върне списък с всички колони с всички редове

 -(NSMutableDictionary*)getRowsFromTableName:(NSString*)tableName
 {
 NSString *databasePath =[[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex:0]
//                         stringByAppendingPathComponent: @"sqlcipher.db"];
 sqlite3 *db;
 bool sqlcipher_valid = NO;
 NSMutableDictionary *dbData = [[NSMutableDictionary alloc]init];
 NSMutableArray *columnList = [[NSMutableArray alloc]init];

 if (sqlite3_open([databasePath UTF8String], &db) == SQLITE_OK) {
    const char* key = [keyString UTF8String];
    sqlite3_key(db, key, strlen(key));
    if (sqlite3_exec(db, (const char*) "SELECT count(*) FROM sqlite_master;", NULL, NULL, NULL) == SQLITE_OK) {
        if(sqlite3_prepare_v2(db, "PRAGMA cipher_version;", -1, &stmt, NULL) == SQLITE_OK) {
            if(sqlite3_step(stmt)== SQLITE_ROW) {
                const unsigned char *ver = sqlite3_column_text(stmt, 0);
                if(ver != NULL) {
                    sqlcipher_valid = YES;

                    // password is correct (or database initialize), and verified to be using sqlcipher
                    char *errMsg;
                    const char *query = [[NSString stringWithFormat:@"select * from %@",tableName] UTF8String]; //where name = 'abc'";
                    if (sqlite3_exec(db, query, NULL, NULL, &errMsg)
                        != SQLITE_OK)
                    {
                        // isSuccess = NO;
                        NSLog(@"Failed to open data into table");
                        [dbData setValue:@"Failed to open data into table" forKey:@"Message"];
                        [dbData setValue:@"Failed" forKey:@"status"];
                        return dbData;
                    }
                    else
                    {
                        NSLog(@"Data open Successfully");
                        int num_cols;
                        if(sqlite3_prepare_v2(db, query, -1, &stmt, NULL) == SQLITE_OK) {

                            while (sqlite3_step(stmt) == SQLITE_ROW)
                            {
                                num_cols = sqlite3_data_count(stmt);
                                NSMutableDictionary *columnDic = [[NSMutableDictionary alloc]init];
                                for (int i = 1; i < num_cols; i++) {
                                    NSString *colValue = [NSString stringWithUTF8String:(char*)sqlite3_column_text(stmt, i)];
                                    NSString *colName = [NSString stringWithUTF8String:(char*)sqlite3_column_name(stmt, i)];
                                    [columnDic setValue:colValue forKey:colName];
                                    NSLog(@"%@",columnDic);
                                }
                                [columnList addObject:columnDic];
                                columnDic = nil;
                            }
                            NSLog(@"%@",columnList);
                            [dbData setValue:columnList forKey:@"data"];

                        }
                    }
                }
            }
            else
            {
                NSLog(@"Error while binding variable. '%s'", sqlite3_errmsg(db));
                [dbData setValue:[NSString stringWithFormat:@"Error while binding variable. '%s'", sqlite3_errmsg(db)] forKey:@"Message"];
                [dbData setValue:@"Failed" forKey:@"status"];
                return dbData;
            }
            sqlite3_finalize(stmt);
        }
        else
        {
            NSLog(@"Error while creating update statement. '%s'", sqlite3_errmsg(db));
            [dbData setValue:[NSString stringWithFormat:@"Error while creating update statement. '%s'", sqlite3_errmsg(db)] forKey:@"Message"];
            [dbData setValue:@"Failed" forKey:@"status"];
            return dbData;
        }
    }
    else
    {
        NSLog(@"Error while creating update statement. '%s'", sqlite3_errmsg(db));
        [dbData setValue:[NSString stringWithFormat:@"Error while creating update statement. '%s'", sqlite3_errmsg(db)] forKey:@"Message"];
        [dbData setValue:@"Failed" forKey:@"status"];
        return dbData;
    }
    sqlite3_close(db);
}
NSLog(@"%@",dbData);

return dbData;

}

И вземете данни в речника от таблицата в iOS:

-(void)getData:(NSString *) tablename
{
    NSMutableDictionary * tabledata= [[NSMutableDictionary alloc] init];
    NSString *str = @"select * from ";
    NSString *strQuery = [str stringByAppendingString:tablename];
    tabledata = [db executeQuery:strQuery];

    NSDictionary *dic = [tabledata valueForKey:@"0"];
    NSLog(@"dic is:%@",dic);
}