From d74a7b7aec40d83b940dbfe10850734075aa6c5c Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Sun, 27 Jun 2021 18:59:21 +0100 Subject: Add an existing table to the config --- lib/output/pq/sql/insertColumn.sql | 2 ++ lib/output/pq/sql/insertTable.sql | 3 +++ lib/output/pq/sql/selectSourceSchema.sql | 3 +++ 3 files changed, 8 insertions(+) create mode 100644 lib/output/pq/sql/insertColumn.sql create mode 100644 lib/output/pq/sql/insertTable.sql create mode 100644 lib/output/pq/sql/selectSourceSchema.sql (limited to 'lib/output/pq/sql') diff --git a/lib/output/pq/sql/insertColumn.sql b/lib/output/pq/sql/insertColumn.sql new file mode 100644 index 0000000..b8efde9 --- /dev/null +++ b/lib/output/pq/sql/insertColumn.sql @@ -0,0 +1,2 @@ +INSERT INTO mygrate.table_columns(column_name, mysql_ordinal, table_id) +VALUES($1, $2, $3) diff --git a/lib/output/pq/sql/insertTable.sql b/lib/output/pq/sql/insertTable.sql new file mode 100644 index 0000000..4b559d0 --- /dev/null +++ b/lib/output/pq/sql/insertTable.sql @@ -0,0 +1,3 @@ +INSERT INTO mygrate.tables(table_name, source_id) +VALUES($1, $2) +RETURNING table_id diff --git a/lib/output/pq/sql/selectSourceSchema.sql b/lib/output/pq/sql/selectSourceSchema.sql new file mode 100644 index 0000000..a583c4f --- /dev/null +++ b/lib/output/pq/sql/selectSourceSchema.sql @@ -0,0 +1,3 @@ +SELECT table_schema +FROM mygrate.source s +WHERE s.source_id = $1 -- cgit v1.2.3