diff options
Diffstat (limited to 'lib/output/pq/sql')
| -rw-r--r-- | lib/output/pq/sql/insertColumn.sql | 2 | ||||
| -rw-r--r-- | lib/output/pq/sql/insertTable.sql | 3 | ||||
| -rw-r--r-- | lib/output/pq/sql/selectSourceSchema.sql | 3 |
3 files changed, 8 insertions, 0 deletions
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 |