From df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51 Mon Sep 17 00:00:00 2001
From: Benjamin Franzke <benjaminfranzke@googlemail.com>
Date: Sat, 26 Jan 2013 18:49:51 +0100
Subject: begin oracle conversion toolset

---
 oracle-conversion/rowset-to-sql.xsl | 33 +++++++++++++++++++++++++++++++++
 1 file changed, 33 insertions(+)
 create mode 100644 oracle-conversion/rowset-to-sql.xsl

(limited to 'oracle-conversion/rowset-to-sql.xsl')

diff --git a/oracle-conversion/rowset-to-sql.xsl b/oracle-conversion/rowset-to-sql.xsl
new file mode 100644
index 0000000..7b2a90a
--- /dev/null
+++ b/oracle-conversion/rowset-to-sql.xsl
@@ -0,0 +1,33 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
+
+<xsl:output method="text"/>
+
+
+<xsl:template match="ROWSET">
+	<xsl:text>insert into </xsl:text>
+	<xsl:value-of select="@NAME"/>
+	<xsl:text> values</xsl:text>
+	<xsl:for-each select="ROW">
+		<xsl:text>&#10;&#9;(</xsl:text>
+		<xsl:for-each select="*">
+			<xsl:text>'</xsl:text>
+			<xsl:value-of select="."/>
+			<xsl:text>'</xsl:text>
+			<xsl:if test="position() != last()">
+				<xsl:text>,</xsl:text>
+			</xsl:if>
+		</xsl:for-each>
+		<xsl:text>)</xsl:text>
+		<xsl:if test="position() != last()">
+			<xsl:text>,</xsl:text>
+		</xsl:if>
+	</xsl:for-each>
+	<xsl:text>;&#10;</xsl:text>
+</xsl:template>
+
+<xsl:template match="/">
+	<xsl:apply-templates select="DATABASE/ROWSET" />
+</xsl:template>
+</xsl:stylesheet>
+
-- 
cgit