author | František Kučera <franta-hg@frantovo.cz> |
Tue, 26 Feb 2019 15:47:43 +0100 | |
branch | v_0 |
changeset 231 | 71439ecbe71f |
parent 198 | 03d8492e2ca8 |
child 249 | 7655df0622ee |
permissions | -rw-r--r-- |
franta-hg@119 | 1 |
<?xml version="1.0" encoding="UTF-8"?> |
franta-hg@119 | 2 |
<!-- |
franta-hg@119 | 3 |
SQL-DK |
franta-hg@119 | 4 |
Copyright © 2013 František Kučera (frantovo.cz) |
franta-hg@119 | 5 |
|
franta-hg@119 | 6 |
This program is free software: you can redistribute it and/or modify |
franta-hg@119 | 7 |
it under the terms of the GNU General Public License as published by |
franta-hg@119 | 8 |
the Free Software Foundation, either version 3 of the License, or |
franta-hg@119 | 9 |
(at your option) any later version. |
franta-hg@119 | 10 |
|
franta-hg@119 | 11 |
This program is distributed in the hope that it will be useful, |
franta-hg@119 | 12 |
but WITHOUT ANY WARRANTY; without even the implied warranty of |
franta-hg@119 | 13 |
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
franta-hg@119 | 14 |
GNU General Public License for more details. |
franta-hg@119 | 15 |
|
franta-hg@119 | 16 |
You should have received a copy of the GNU General Public License |
franta-hg@119 | 17 |
along with this program. If not, see <http://www.gnu.org/licenses/>. |
franta-hg@119 | 18 |
--> |
franta-hg@119 | 19 |
|
franta-hg@119 | 20 |
<!-- |
franta-hg@119 | 21 |
This XSLT can be used for viewing config files in a web browser (Firefox, rekonq etc.) |
franta-hg@119 | 22 |
--> |
franta-hg@119 | 23 |
|
franta-hg@119 | 24 |
<xsl:stylesheet version="1.0" |
franta-hg@119 | 25 |
xmlns="http://www.w3.org/1999/xhtml" |
franta-hg@119 | 26 |
xmlns:h="http://www.w3.org/1999/xhtml" |
franta-hg@119 | 27 |
xmlns:c="https://sql-dk.globalcode.info/xmlns/configuration" |
franta-hg@119 | 28 |
xmlns:xsl="http://www.w3.org/1999/XSL/Transform" |
franta-hg@119 | 29 |
xmlns:fn="http://www.w3.org/2005/xpath-functions" |
franta-hg@119 | 30 |
xmlns:svg="http://www.w3.org/2000/svg" |
franta-hg@119 | 31 |
xmlns:xs="http://www.w3.org/2001/XMLSchema" |
franta-hg@119 | 32 |
exclude-result-prefixes="fn h p xs"> |
franta-hg@119 | 33 |
<xsl:output |
franta-hg@119 | 34 |
method="xml" |
franta-hg@119 | 35 |
indent="yes" |
franta-hg@119 | 36 |
encoding="UTF-8" |
franta-hg@119 | 37 |
doctype-public="-//W3C//DTD XHTML 1.1 plus MathML 2.0 plus SVG 1.1//EN" |
franta-hg@119 | 38 |
doctype-system="http://www.w3.org/2002/04/xhtml-math-svg/xhtml-math-svg.dtd"/> |
franta-hg@119 | 39 |
|
franta-hg@119 | 40 |
<xsl:param name="header" select="'SQL-DK configuration'"/> |
franta-hg@119 | 41 |
|
franta-hg@119 | 42 |
<xsl:template match="/"> |
franta-hg@119 | 43 |
<html> |
franta-hg@119 | 44 |
<head> |
franta-hg@119 | 45 |
<title><xsl:value-of select="$header"/></title> |
franta-hg@119 | 46 |
<style type="text/css"> |
franta-hg@119 | 47 |
body { |
franta-hg@119 | 48 |
font-family: sans; |
franta-hg@119 | 49 |
background-color: #eee; |
franta-hg@119 | 50 |
color: black; |
franta-hg@119 | 51 |
padding-left: 20px; |
franta-hg@119 | 52 |
} |
franta-hg@119 | 53 |
|
franta-hg@119 | 54 |
p { |
franta-hg@119 | 55 |
max-width: 800px; |
franta-hg@119 | 56 |
} |
franta-hg@119 | 57 |
|
franta-hg@119 | 58 |
h1,h2 { |
franta-hg@119 | 59 |
max-width: 800px; |
franta-hg@119 | 60 |
border-radius: 8px; |
franta-hg@119 | 61 |
border: 1px solid #ddd; |
franta-hg@119 | 62 |
background-color: #e8e8e8; |
franta-hg@119 | 63 |
padding: 6px; |
franta-hg@119 | 64 |
text-shadow: 2px 2px 2px #aaa; |
franta-hg@119 | 65 |
} |
franta-hg@119 | 66 |
|
franta-hg@119 | 67 |
h1 { |
franta-hg@119 | 68 |
font-size: 150% |
franta-hg@119 | 69 |
} |
franta-hg@119 | 70 |
|
franta-hg@119 | 71 |
h2 { |
franta-hg@119 | 72 |
font-size: 100%; |
franta-hg@119 | 73 |
font-weight: bold; |
franta-hg@119 | 74 |
} |
franta-hg@119 | 75 |
|
franta-hg@119 | 76 |
table { |
franta-hg@119 | 77 |
border-collapse:collapse; |
franta-hg@119 | 78 |
margin-top: 10px; |
franta-hg@119 | 79 |
margin-bottom: 10px; |
franta-hg@119 | 80 |
} |
franta-hg@119 | 81 |
td, th { |
franta-hg@119 | 82 |
border: 1px solid #ddd; |
franta-hg@119 | 83 |
padding-top: 4px; |
franta-hg@119 | 84 |
padding-bottom: 4px; |
franta-hg@119 | 85 |
padding-left: 6px; |
franta-hg@119 | 86 |
padding-right: 6px; |
franta-hg@119 | 87 |
font-weight: normal; |
franta-hg@119 | 88 |
vertical-align: top; |
franta-hg@119 | 89 |
} |
franta-hg@119 | 90 |
thead tr { |
franta-hg@119 | 91 |
background: #e8e8e8; |
franta-hg@119 | 92 |
color:black; |
franta-hg@119 | 93 |
} |
franta-hg@119 | 94 |
tbody tr:hover { |
franta-hg@119 | 95 |
background-color: #e9e9e9; |
franta-hg@119 | 96 |
color:black; |
franta-hg@119 | 97 |
} |
franta-hg@119 | 98 |
|
franta-hg@119 | 99 |
ul { |
franta-hg@119 | 100 |
margin: 0px; |
franta-hg@119 | 101 |
} |
franta-hg@119 | 102 |
|
franta-hg@119 | 103 |
li { |
franta-hg@119 | 104 |
padding: 0px; |
franta-hg@119 | 105 |
} |
franta-hg@198 | 106 |
|
franta-hg@198 | 107 |
.notes { |
franta-hg@198 | 108 |
font-size: 66%; |
franta-hg@198 | 109 |
} |
franta-hg@198 | 110 |
.notes p { |
franta-hg@198 | 111 |
margin-bottom: 0px; |
franta-hg@198 | 112 |
} |
franta-hg@119 | 113 |
</style> |
franta-hg@119 | 114 |
</head> |
franta-hg@119 | 115 |
<body> |
franta-hg@119 | 116 |
<h1><xsl:value-of select="$header"/></h1> |
franta-hg@119 | 117 |
|
franta-hg@119 | 118 |
<p> |
franta-hg@119 | 119 |
This file defines per-user configuration of <a href="https://sql-dk.globalcode.info/">SQL-DK</a> |
franta-hg@119 | 120 |
– an SQL batch client. |
franta-hg@119 | 121 |
</p> |
franta-hg@119 | 122 |
|
franta-hg@119 | 123 |
|
franta-hg@119 | 124 |
<h2>Database connections</h2> |
franta-hg@119 | 125 |
|
franta-hg@119 | 126 |
<p>This databases are configured:</p> |
franta-hg@119 | 127 |
|
franta-hg@119 | 128 |
<xsl:choose> |
franta-hg@119 | 129 |
<xsl:when test="c:configuration/c:database"> |
franta-hg@119 | 130 |
<table> |
franta-hg@119 | 131 |
<thead> |
franta-hg@119 | 132 |
<tr> |
franta-hg@119 | 133 |
<td>name</td> |
franta-hg@119 | 134 |
<td>username</td> |
franta-hg@119 | 135 |
<td>url</td> |
franta-hg@198 | 136 |
<td>JDBC driver</td> |
franta-hg@119 | 137 |
<td>properties</td> |
franta-hg@119 | 138 |
</tr> |
franta-hg@119 | 139 |
</thead> |
franta-hg@119 | 140 |
<tbody> |
franta-hg@119 | 141 |
<xsl:for-each select="c:configuration/c:database"> |
franta-hg@119 | 142 |
<tr> |
franta-hg@119 | 143 |
<td><xsl:value-of select="c:name"/></td> |
franta-hg@119 | 144 |
<td><xsl:value-of select="c:userName"/></td> |
franta-hg@119 | 145 |
<td><xsl:value-of select="c:url"/></td> |
franta-hg@198 | 146 |
<td><xsl:value-of select="c:driver"/></td> |
franta-hg@119 | 147 |
<td><ul><xsl:apply-templates select="c:property"/></ul></td> |
franta-hg@119 | 148 |
</tr> |
franta-hg@119 | 149 |
</xsl:for-each> |
franta-hg@119 | 150 |
</tbody> |
franta-hg@119 | 151 |
</table> |
franta-hg@119 | 152 |
</xsl:when> |
franta-hg@119 | 153 |
<xsl:otherwise><p>no databases are configured</p></xsl:otherwise> |
franta-hg@119 | 154 |
</xsl:choose> |
franta-hg@119 | 155 |
|
franta-hg@198 | 156 |
<div class="notes"> |
franta-hg@198 | 157 |
<p>Notes:</p> |
franta-hg@198 | 158 |
<ul> |
franta-hg@198 | 159 |
<li>passwords are hidden in this output</li> |
franta-hg@198 | 160 |
<li>JDBC drivers are not mandatory – not needed in SQL-DK, but sometimes useful when <code>jdbc-dk-driver</code> is used in other applications to load SQL-DK's database connections</li> |
franta-hg@198 | 161 |
</ul> |
franta-hg@198 | 162 |
</div> |
franta-hg@119 | 163 |
|
franta-hg@119 | 164 |
|
franta-hg@119 | 165 |
<h2>Output formatters</h2> |
franta-hg@119 | 166 |
|
franta-hg@119 | 167 |
<p> |
franta-hg@119 | 168 |
Default formatter: |
franta-hg@119 | 169 |
<xsl:choose> |
franta-hg@119 | 170 |
<xsl:when test="c:configuration/c:defaultFormatter"><xsl:value-of select="c:configuration/c:defaultFormatter"/></xsl:when> |
franta-hg@119 | 171 |
<xsl:otherwise>none (built-in default will be used)</xsl:otherwise> |
franta-hg@119 | 172 |
</xsl:choose> |
franta-hg@119 | 173 |
</p> |
franta-hg@119 | 174 |
|
franta-hg@119 | 175 |
<xsl:choose> |
franta-hg@119 | 176 |
<xsl:when test="c:configuration/c:formatter"> |
franta-hg@119 | 177 |
<table> |
franta-hg@119 | 178 |
<thead> |
franta-hg@119 | 179 |
<tr> |
franta-hg@119 | 180 |
<td>name</td> |
franta-hg@119 | 181 |
<td>class name</td> |
franta-hg@119 | 182 |
<td>properties</td> |
franta-hg@119 | 183 |
</tr> |
franta-hg@119 | 184 |
</thead> |
franta-hg@119 | 185 |
<tbody> |
franta-hg@119 | 186 |
<xsl:for-each select="c:configuration/c:formatter"> |
franta-hg@119 | 187 |
<tr> |
franta-hg@119 | 188 |
<td><xsl:value-of select="c:name"/></td> |
franta-hg@119 | 189 |
<td><xsl:value-of select="c:class"/></td> |
franta-hg@119 | 190 |
<td><ul><xsl:apply-templates select="c:property"/></ul></td> |
franta-hg@119 | 191 |
</tr> |
franta-hg@119 | 192 |
</xsl:for-each> |
franta-hg@119 | 193 |
</tbody> |
franta-hg@119 | 194 |
</table> |
franta-hg@119 | 195 |
</xsl:when> |
franta-hg@119 | 196 |
<xsl:otherwise><p>no additional formatters are defined (built-in defaults will be used)</p></xsl:otherwise> |
franta-hg@119 | 197 |
</xsl:choose> |
franta-hg@119 | 198 |
|
franta-hg@119 | 199 |
</body> |
franta-hg@119 | 200 |
</html> |
franta-hg@119 | 201 |
</xsl:template> |
franta-hg@119 | 202 |
|
franta-hg@119 | 203 |
<xsl:template match="c:property"> |
franta-hg@119 | 204 |
<li> |
franta-hg@119 | 205 |
<xsl:value-of select="@name"/> = <xsl:value-of select="."/> |
franta-hg@119 | 206 |
</li> |
franta-hg@119 | 207 |
</xsl:template> |
franta-hg@119 | 208 |
|
franta-hg@119 | 209 |
</xsl:stylesheet> |