deleteByDict method

Future deleteByDict({
  1. required String table,
  2. required Map<String, Object?> keyValues,
})

删除一个数据, 通过KeyValues, 指定列名和数据的合集

table 表名 keyValues 列名和数据的映射

返回删除的行数

Implementation

Future deleteByDict(
    {required String table, required Map<String, Object?> keyValues}) async {
  String action =
      keyValues.entries.where((element) => element.value != null).map((e) {
    if (e.value is num) {
      return "${e.key}=${e.value}";
    } else {
      return '${e.key}="${e.value}"';
    }
  }).join(" and ");
  return deleteLine('delete from $table where $action');
}