I have a json map like this:
<code>[{"Ingridient_name":"Aalsuppe","Ingridient_mass":"688","Ingridient_mass_unit":"Milliliter"},{"Ingridient_name":"Auflauf","Ingridient_mass":"245","Ingridient_mass_unit":"Stück"}]
</code>
<code>[{"Ingridient_name":"Aalsuppe","Ingridient_mass":"688","Ingridient_mass_unit":"Milliliter"},{"Ingridient_name":"Auflauf","Ingridient_mass":"245","Ingridient_mass_unit":"Stück"}]
</code>
[{"Ingridient_name":"Aalsuppe","Ingridient_mass":"688","Ingridient_mass_unit":"Milliliter"},{"Ingridient_name":"Auflauf","Ingridient_mass":"245","Ingridient_mass_unit":"Stück"}]
Now I want to put this map into my SQLite database. I know SQLite is not a database to store json maps, so i guess I have to convert the map to a jsonString, however I am not shure how I can implement this in my SQlite database table.
This is my database table right now (title and discription are not relevant):
<code>static Future<void> createTables(sql.Database database) async {
await database.execute("""CREATE TABLE items(
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
title TEXT,
description TEXT,
) """);
</code>
<code>static Future<void> createTables(sql.Database database) async {
await database.execute("""CREATE TABLE items(
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
title TEXT,
description TEXT,
) """);
</code>
static Future<void> createTables(sql.Database database) async {
await database.execute("""CREATE TABLE items(
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
title TEXT,
description TEXT,
) """);
Any help is appreciated