Function generateInsertStatementFromRows

frontend/src/utils/v1/sql.ts:324–347

(params: {
  engine: Engine;
  schema: string | undefined;
  table: string;
  columns: string[];
  rows: RowValue[][];
})

// the given rows. Each `rows[i]` is the cell array of one result row, aligned
// with `columns`.
export const generateInsertStatementFromRows = (params: {
  engine: Engine;
  schema: string | undefined;
  table: string;
  columns: string[];
  rows: RowValue[][];
}): string => {
  const { engine, schema, table, columns, rows } = params;
  const schemaAndTable = generateSchemaAndTableNameInSQL(
    engine,
    schema ?? "",
    table
  );
  const columnNames = columns
    .map((column) => wrapSQLIdentifier(column, engine))
    .join(", ");
  const valueLines = rows
    .map(
      (row) =>
        `  (${row.map((cell) => rowValueToSQLLiteral(cell, engine)).join(", ")})`
    )
    .join(",\n");
  return `INSERT INTO ${schemaAndTable} (${columnNames}) VALUES\n${valueLines};`;
};

export const generateSimpleUpdateStatement = (
  engine: Engine,