19 lines
645 B
TypeScript
19 lines
645 B
TypeScript
import { describe, expect, it } from "vitest";
|
|
import { splitSqlStatements } from "./sql-statements";
|
|
|
|
describe("splitSqlStatements", () => {
|
|
it("ignores semicolons inside line comments", () => {
|
|
const sql = [
|
|
"-- Existing installs have this; new installs need it.",
|
|
"ALTER TABLE users ADD COLUMN IF NOT EXISTS example TEXT NULL;",
|
|
"-- next statement",
|
|
"CREATE TABLE IF NOT EXISTS example_table (id INT PRIMARY KEY);",
|
|
].join("\n");
|
|
|
|
expect(splitSqlStatements(sql)).toEqual([
|
|
"ALTER TABLE users ADD COLUMN IF NOT EXISTS example TEXT NULL",
|
|
"CREATE TABLE IF NOT EXISTS example_table (id INT PRIMARY KEY)",
|
|
]);
|
|
});
|
|
});
|