How to insert arrays into Sqlite database

Question

Please let me know how to insert arrays into the Sqlite table. I am passing 2 arrays as the parameter. Here is the code:

-(void)saveData:(NSMutableArray *)firstArray second:(NSMutableArray *)secondArray {

[self openDB];

NSString *createSQL = @"CREATE TABLE IF NOT EXISTS Table1"
“(EID INTEGER PRIMARY KEY, Array1 TEXT, Array2 TEXT);";
char *errorMsg;
if (sqlite3_exec (database, [createSQL UTF8String],
                  NULL, NULL, &errorMsg) != SQLITE_OK)
{
    sqlite3_close(database);
    NSAssert(0, @"Error creating table: %s", errorMsg);
}

    char *update = "INSERT OR REPLACE INTO Table1 (ID, Array1, Array2)"
    "VALUES (?, ?, ?);";
    errorMsg=NULL;
    sqlite3_stmt *stmt;
    if (sqlite3_prepare_v2(database, update, -1, &stmt, nil)
        == SQLITE_OK) {

        Please let me know how to insert the data.

        if (sqlite3_step(stmt) != SQLITE_DONE)
            NSAssert(0, @"Error updating table: %s", errorMsg);
        sqlite3_finalize(stmt);

}

}

What difficulty are you facing? Why don't you save your arrays in XML files inside sandboxed folder? — El Tomato
– El Tomato, Commented Jan 30, 2014 at 20:20
I have my values in firstArray and secondArray as it passed as parameters. But I dont know how can I insert these values into the tables. — user2903572
– user2903572, Commented Jan 30, 2014 at 20:24

Owen Hartnett · Accepted Answer · 2014-01-30 20:27:24Z

3

You have multiple problems with what you're doing, which seems to stem from an unfamiliarity with SQLite. First of all, sqlite doesn't understand arrays as primitive values, not to mention NSMutableArrays. Second, you're trying to pass the values in as parameters, but you're not setting the parameters anywhere. I suggest this book which should give you a better understanding of SQLite, or go through the online tutorials at sqlite.org

answered Jan 30, 2014 at 20:27

Owen Hartnett

5,9352 gold badges21 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Asmaa Shaban · Accepted Answer · 2017-02-28 16:36:38Z

0

to insert array you have to use one to many relationship so you need to create table contans for ex id and array1 and array2 as composite primary key

answered Feb 28, 2017 at 16:36

Asmaa Shaban

115 bronze badges

Comments

peak · Accepted Answer · 2019-11-21 09:01:19Z

0

The JSON1 extension provides basic support for managing (JSON) arrays. It requires SQLite version 3.9.0 (2015-10-14). For further details, see:

https://www.sqlite.org/json1.html

answered Nov 21, 2019 at 9:01

peak

119k21 gold badges185 silver badges218 bronze badges

Collectives™ on Stack Overflow

How to insert arrays into Sqlite database

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related