diff options
| author | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-26 18:49:51 +0100 |
|---|---|---|
| committer | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-26 22:03:06 +0100 |
| commit | df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51 (patch) | |
| tree | af18982b5354d95900749b513f5387a2e8397fa9 /oracle-conversion/fixml.sh | |
| parent | 4eba780ed25ea4fbae8e032dc3510e1c083d0310 (diff) | |
| download | sqltutor-plugin-df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51.tar.gz sqltutor-plugin-df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51.tar.bz2 sqltutor-plugin-df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51.zip | |
begin oracle conversion toolset
Diffstat (limited to 'oracle-conversion/fixml.sh')
| -rwxr-xr-x | oracle-conversion/fixml.sh | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/oracle-conversion/fixml.sh b/oracle-conversion/fixml.sh new file mode 100755 index 0000000..75bbcf8 --- /dev/null +++ b/oracle-conversion/fixml.sh @@ -0,0 +1,7 @@ +sed -e "s/ *$//" -e "s/^ *//" -e "/^$/d" $1 | \ + sed 's/^SQL.*from \([^ ]*\)'"'"'.*/<ROWSET NAME="\1">/' | \ + sed -e "/<ROWSET>/d" -e "/^SQL/d" -e '/^<?xml/d' | \ + sed -e '1i <DATABASE>' -e '$a </DATABASE>' | \ + sed -e :a -e 'N;s/\n//g' -e ba | \ + sed 's: *</:</:g' | \ + xmllint --format - |