whereColumnHasValue method

Future<ISQLiteItem?> whereColumnHasValue(
  1. ISQLiteItem item,
  2. String columnName,
  3. dynamic columnValueOf
)

Implementation

Future<ISQLiteItem?> whereColumnHasValue(
  ISQLiteItem item,
  String columnName,
  dynamic columnValueOf,
) async {
  var table = item.getTableName();
  String condition = '$columnName = ?';
  var db = await getOpenDatabase();

  var maps = await db.query(
    table,
    where: condition,
    whereArgs: [columnValueOf], // Pass the value as an array
    limit: 1, // Set limit to 1 to return only a single item
  );

  if (maps.isNotEmpty) {
    return item.fromMap(maps.first); // Return the first matching item
  } else {
    return null; // Return null if no match found
  }
}