summaryrefslogtreecommitdiff
path: root/oracle-conversion/grab.sh
diff options
context:
space:
mode:
Diffstat (limited to 'oracle-conversion/grab.sh')
-rw-r--r--oracle-conversion/grab.sh7
1 files changed, 7 insertions, 0 deletions
diff --git a/oracle-conversion/grab.sh b/oracle-conversion/grab.sh
new file mode 100644
index 0000000..e54ba24
--- /dev/null
+++ b/oracle-conversion/grab.sh
@@ -0,0 +1,7 @@
+#!/bin/sh
+
+sqlplus nils/secret < export-lessons.sql
+sqlplus kapv/secret < export-kapv.sql
+
+./fixml.sh /tmp/export-lesson.xml > lesson.xml
+./fixml.sh /tmp/export-kapv.xml | xsltproc rowset-to-sql.xsl - > kapv.sql