increment method
Increment a column value
Implementation
@override
Future<int> increment(String column, [int amount = 1]) async {
if (_wheres.isEmpty) {
throw Exception(
'Increment requires a WHERE clause to prevent mass updates.',
);
}
final sql = grammar.compileIncrement(_getQueryComponents(), column, amount);
final bindings = [
..._fromBindings,
..._whereBindings,
];
final result = await connection.execute(sql, bindings);
return result.affectedRows ?? 0;
}