Insert multiple records in Sqflite

sqlite flutter sqflite
AlexPad picture AlexPad · May 30, 2019 · Viewed 9.8k times · Source

How to insert quickly multiple records in sqflite? The standard quickly method is:

await database.insert(table, object.toMap())

But I don't think that insert record one to one with a cycle is a good idea. Or I can insert all list with a transaction?

Answer

CopsOnRoad picture CopsOnRoad · May 30, 2019

As I mentioned in the comment, you can use Batch. Here is the sample. 

Batch batch = db.batch();
batch.insert('Test', {'name': 'item'});
batch.update('Test', {'name': 'new_item'}, where: 'name = ?', whereArgs: ['item']);
batch.delete('Test', where: 'name = ?', whereArgs: ['item']);

Now if you are looking for result (it will cost you some memory), you use

results = await batch.commit();

And if you are looking for fast performance, just ignore the result and use

await batch.commit(noResult: true);

Source

Related questions

How to do a database query with SQFlite in Flutter

How do you query data from SQLite database in Flutter using the SQFlite plugin? I have been working on learning this recently, so I am adding my answer below as a means to help me learn and also as a …

Read More
How to create multiple tables in a database in sqflite?

Im building and app with flutter that uses SQLite database. I have created first table using this piece of code: void _createDb(Database db, int newVersion) async { await db.execute('''CREATE TABLE cards (id_card INTEGER PRIMARY KEY, color TEXT, …

Read More
Sqlite in flutter, how database assets work

I am looking at this (https://github.com/tekartik/sqflite/blob/master/doc/opening_asset_db.md) for populating data that is already formatted and need for the app, for read functionality only. So my understanding of creating an SQLite …

Read More