compileIncrement method
Compile an increment statement into SQL.
Implementation
@override
String compileIncrement(
Map<String, dynamic> query,
String column,
int amount,
) {
final table = wrapTable(query['table']);
final wheres =
query['wheres'] != null ? compileWheres(query['wheres']) : '';
final wrappedColumn = wrap(column);
final operator = amount >= 0 ? '+' : '-';
final absAmount = amount.abs();
return 'UPDATE $table SET $wrappedColumn = $wrappedColumn $operator $absAmount $wheres'
.trim();
}