How to store & retrieve NSArray object in sqlite database in objective c

Question

I want to store & retrieve NSArray object in single column of sqlite database. Does anyone knows how i can achieve that?

grade : [ { "gradeId" : 123, "gradeName" : "abc" }, { "gradeId" : 222, "gradeName" : "xyz" } ] — Savita Pal
– Savita Pal, Commented Feb 22, 2017 at 12:01

Mahesh Agrawal · Accepted Answer · 2017-02-27 05:12:41Z

7

The easiest way to achieve this is convert the array to JSON string and store the string in database and while fetching the data convert the JSON string to array again.

Array to JSON

NSData *jsonData = [NSJSONSerialization dataWithJSONObject:arrayObject options:NSJSONWritingPrettyPrinted error:nil]
NSString *jsonString = [[NSString alloc] initWithData:jsonData encoding:NSUTF8StringEncoding]);

JSON to Array

NSData *data = [jsonString dataUsingEncoding:NSUTF8StringEncoding];
NSArray *arrayObject = [NSJSONSerialization JSONObjectWithData:data options:NSJSONReadingAllowFragments error:nil];

edited Feb 27, 2017 at 5:12

answered Feb 22, 2017 at 12:03

Mahesh Agrawal

3,36823 silver badges36 bronze badges

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

2 Comments

Jacob M. Barnard Over a year ago

github.com/jmbarnardgh/labqlite and github.com/jmbarnardgh/labqlite_model_generator may be able to assist you with the SQLite part

Mahesh Agrawal Over a year ago

i am also using the library github.com/ccgus/fmdb and github.com/nerdyc/FMDBHelpers to interact with the SQLite database file and i have a class which contains functions for CRUD operation for required models. Those are also helpful.

Sergey · Accepted Answer · 2017-02-22 12:09:23Z

0

It's many way to do this. One of the simple is use componentsJoinedByString method.

NSArray* someArray = @[.....];
NSString* result = [someArray componentsJoinedByString:@"<some separator>"];

Also you can NSKeyedArchiver

NSArray* someArray = @[.....];
NSData* dataToSave = [NSKeyedArchiver archivedDataWithRootObject:someArray];

But you will provide object in array that confirm to the NSCoding protocol.

Also you can use json serialisation:

NSArray* someArray = @[.....];
NSData *jsonData = [NSJSONSerialization dataWithJSONObject:someArray options:NSJSONWritingPrettyPrinted error:nil]

answered Feb 22, 2017 at 12:09

Sergey

1,64710 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to store & retrieve NSArray object in sqlite database in objective c

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related