summaryrefslogtreecommitdiff
path: root/oracle-conversion/sort-lesson.xsl
diff options
context:
space:
mode:
authorBenjamin Franzke <benjaminfranzke@googlemail.com>2013-01-27 00:07:18 +0100
committerBenjamin Franzke <benjaminfranzke@googlemail.com>2013-01-27 00:08:45 +0100
commitc4b79fb817c7cc4018f1a90c733e13b8e694ea48 (patch)
treefd7cd5812256e0a46997399e3f48938d7d60384f /oracle-conversion/sort-lesson.xsl
parent4f25dfc69e3e582328702c9f1afb83c1ff9f70c4 (diff)
downloadsqltutor-plugin-c4b79fb817c7cc4018f1a90c733e13b8e694ea48.tar.gz
sqltutor-plugin-c4b79fb817c7cc4018f1a90c733e13b8e694ea48.tar.bz2
sqltutor-plugin-c4b79fb817c7cc4018f1a90c733e13b8e694ea48.zip
Add xsl-powered script to create KAPV in moodle
Diffstat (limited to 'oracle-conversion/sort-lesson.xsl')
-rw-r--r--oracle-conversion/sort-lesson.xsl22
1 files changed, 22 insertions, 0 deletions
diff --git a/oracle-conversion/sort-lesson.xsl b/oracle-conversion/sort-lesson.xsl
new file mode 100644
index 0000000..54c4601
--- /dev/null
+++ b/oracle-conversion/sort-lesson.xsl
@@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
+
+<xsl:param name="modul">1</xsl:param>
+
+<xsl:template match="ROW">
+ <ROW>
+ <xsl:copy-of select="*"/>
+ </ROW>
+</xsl:template>
+<xsl:template match="ROW" mode="order">
+ <xsl:apply-templates select="//ROWSET[@NAME='lessons']/ROW[LESSON_ID=current()/LESSON_ID and MODUL=$modul and TYP='SELECT']"/>
+</xsl:template>
+
+<xsl:template match="/">
+ <ROWSET>
+ <xsl:apply-templates select="DATABASE/ROWSET[@NAME='lesson_order']/ROW[MODUL=$modul]" mode="order">
+ <xsl:sort select="NR"/>
+ </xsl:apply-templates>
+ </ROWSET>
+</xsl:template>
+</xsl:stylesheet>