Function generateSql

src/drivers/sqlite/sql-parse-trigger.test.ts:3–26

({
  name,
  when,
  operation,
  columnNames,
  tableName,
  statement,
}: Record<string, string>)

import { parseCreateTriggerScript } from "./sql-parse-trigger";

function generateSql({
  name,
  when,
  operation,
  columnNames,
  tableName,
  statement,
}: Record<string, string>) {
  let whenString = "";
  if (when) {
    whenString = `${when} `;
  }
  let columnNameString = "";
  if (columnNames) {
    columnNameString = ` ${columnNames}`;
  }
  return `
    CREATE TRIGGER ${name}
    ${whenString}${operation}${columnNameString} ON ${tableName}
    BEGIN
      ${statement}
    END;
  `;
}

describe("parse trigger", () => {
  const name = "cust_addr_chng";