summaryrefslogtreecommitdiff
path: root/lib/output/pq/sql
diff options
context:
space:
mode:
authorDan Goodliffe <dan@randomdan.homeip.net>2021-06-13 20:30:24 +0100
committerDan Goodliffe <dan@randomdan.homeip.net>2021-06-13 20:30:24 +0100
commit194f7b8772e943dba98d672e738214808eb1a1a7 (patch)
treeefa8d2f4e79d14e1745fae586d72cea8df68048c /lib/output/pq/sql
parentAdd missing dep on schema file (diff)
downloadmygrate-194f7b8772e943dba98d672e738214808eb1a1a7.tar.bz2
mygrate-194f7b8772e943dba98d672e738214808eb1a1a7.tar.xz
mygrate-194f7b8772e943dba98d672e738214808eb1a1a7.zip
Code for setting up an initial source from scratch
Includes beginnings of the end-to-end test suite.
Diffstat (limited to 'lib/output/pq/sql')
-rw-r--r--lib/output/pq/sql/insertSource.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/lib/output/pq/sql/insertSource.sql b/lib/output/pq/sql/insertSource.sql
new file mode 100644
index 0000000..c262070
--- /dev/null
+++ b/lib/output/pq/sql/insertSource.sql
@@ -0,0 +1,3 @@
+INSERT INTO mygrate.source(host, username, password, port, database, filename, position, serverid, table_schema)
+VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9)
+RETURNING source_id