updateSpecificColumn method

Future<bool> updateSpecificColumn({
  1. required String tableName,
  2. required String columnName,
  3. required dynamic data,
  4. required Map<String, dynamic> whereArgsList,
})

Implementation

Future<bool> updateSpecificColumn({
  required String tableName,
  required String columnName,
  required dynamic data,
  required Map<String, dynamic> whereArgsList,
}) async {
  final db = await instance.database;

  data = ErrorHandling.encodeDataTypeForDb(value: data);

  try {
    final whereList = getWhereandArgs(map: whereArgsList);

    final rowsAffected = await db.rawUpdate(
      'UPDATE $tableName SET $columnName = ? WHERE ${whereList[0]}',
      [data, ...whereList[1]],
    );
    // return rowsAffected > 0;
    return true;
  } catch (e) {
    print('<updateSpecificColumn> tablename: $tableName: Error: $e');
    return false;
  } finally {
    await closeDatabase();
  }
}