Get Multiple Rows on SQLite in Flutter

Question

I keep only the "productID" information of the products added to the favorites in the "favorite" table in the database. I had no problem adding this information to the table. (product table and favorite table are separate.) But when I wanted to list all favorite products in the table, I found the codes that allowed me to query one by one. What I need is a function that can give the List<int> productIDs as parameter and return favorite products as List<Map<String, dynamic>>> . I looked almost everywhere but could not find it. The function I use to fetch favorite product IDs stored in the favorite table:

Future<List<Map<String, dynamic>>> favProds() async{
    List<int> IDs = new List<int>();
    var db = await _getDatabase();
    var result = await db.query(_favTable, orderBy: '$_columnProdID DESC');
    for(Map incomingMap in result){
      IDs.add(incomingMap['prodID']);
    }
    return _getFavProdsWithIDList(IDs);
  }

This is my function that takes the ID List as a parameter and returns a list containing favorite products as maps:

Future<List<Map<String, dynamic>>> _getFavProdsWithIDList(List<int> IDs) async{
    var db = await _getDatabase();
    var result = await db.query("$_prodTable", where: '$_columnProdID = ?', whereArgs: IDs);
    return result;
  }

Here is the error I get when I use them:

Unhandled Exception: DatabaseException(Cannot bind argument at index 8 because the index is out of range.  The statement has 1 parameters.) sql 'SELECT * FROM urun WHERE urunID = ?' args [230, 180, 179, 20, 19, 18, 17, 2]}

From this error, we see that adding products to the favorite table is successful.

Oleg Plotnikov · Accepted Answer · 2020-12-06 11:31:36Z

3

If you wan select records where id in list of ids you should use query like

SELECT * FROM urun WHERE urunID IN (1, 2, 3);

You have two options.

Provide same number of placeholders as list length

final placeholders = List.generate(5,(_) => "?").join(",");
var result = await db.query("$_prodTable", where: '$_columnProdID IN ($placeholders)', whereArgs: IDs);

Since ids is integers just

var result = await db.query("$_prodTable", where: '$_columnProdID IN (${IDs.join(",")})');

answered Dec 6, 2020 at 11:31

Oleg Plotnikov

3152 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Get Multiple Rows on SQLite in Flutter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related