resolveValueAsSQL method

String resolveValueAsSQL(
  1. Object? value, {
  2. required SQLDialect dialect,
})

Implementation

String resolveValueAsSQL(Object? value, {required SQLDialect dialect}) {
  if (value == null) return 'NULL';

  if (value is Uint8List) {
    var hex = SQLDialect.toHex(value);
    return "'\\x$hex'";
  }

  var valueSQL = switch (value) {
    num() => '$value',
    String() => "'$value'",
    DateTime() => "'${json_helper.formatDateTime(value)}'",
    List() => value.first.toString(),
    _ => value.toString(),
  };

  return valueSQL;
}