update method
Update records in the database.
Implementation
Future<int> update(Map<String, dynamic> value) async {
_setStatement(Operator.update);
_setColumns(value.keys.toList());
_values = value.values.join(', ');
value.forEach((String k, dynamic v) {
if (_set == '') {
_set = '$k = $v';
if (v is String) {
_set = "$k = '$v'";
}
} else {
_set = '$_set, $k = $v';
if (v is String) {
_set = "$_set, $k = '$v'";
}
}
});
_buildSql();
var affectedRows = await db.update(_sql);
return affectedRows;
}