insert method

Future<QueryResult> insert(
  1. Map<String, dynamic> data
)

Executes an INSERT statement with the provided data. Returns the query result (includes affected rows).

Implementation

Future<QueryResult> insert(Map<String, dynamic> data) async {
  final params = _snapshotParams();
  final columns = data.keys.map(_quoteIdentifier).join(', ');
  final values = data.keys.map((k) {
    final paramName = 'i${++_paramIndex}';
    params[paramName] = data[k];
    return '@$paramName';
  }).join(', ');

  final sql = 'INSERT INTO ${_quoteIdentifier(_table)} ($columns) VALUES ($values)';
  return await _executor.query(sql, params);
}