Mercurial > hg > tema
changeset 0:1d2fe61a3a62 release_0_1
Tema 0.1 (imported from CVS).
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/build.xml Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,33 @@ +<?xml version="1.0"?> +<project name="tema" default="dist" basedir="."> + + <property name="src" value="src"/> + <property name="build" value="build"/> + <property name="dist" value="dist"/> + <property name="res" value="res"/> + <property name="jar_file" value="tema.jar"/> + + <target name="init"> + <tstamp/> + <mkdir dir="${build}"/> + </target> + + <target name="compile" depends="init"> + <javac srcdir="${src}" destdir="${build}" + deprecation="on" optimize="on" debug="on"/> + </target> + + <target name="dist" depends="compile"> + <jar jarfile="${dist}/${jar_file}" manifest="${src}/Manifest.mf"> + <fileset dir="${build}" includes="**/*.class"/> + </jar> + </target> + + <target name="clean"> + <delete> + <fileset dir="${build}" includes="**/*.class"/> + </delete> + <delete file="${dist}/${jar_file}"/> + </target> + +</project>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/biotope-top.sql Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,20 @@ +SELECT t1.*, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 1) = Left(t1.rangcode, 1) AND +Right(t2.rangcode, 8) = '00000000') AS class0, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 3) = Left(t1.rangcode, 3) AND +Right(t2.rangcode, 6) = '000000') AS class1, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 5) = Left(t1.rangcode, 5) AND +Right(t2.rangcode, 4) = '0000') AS class2, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 7) = Left(t1.rangcode, 7) AND +Right(t2.rangcode, 2) = '00') AS class3 + +FROM biotopelist AS t1 +WHERE Right(t1.rangcode, 2) <> '00' AND rusname
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/biotope.sql Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,24 @@ +SELECT t1.*, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 1) = Left(t1.rangcode, 1) +AND Right(t2.rangcode, 8) = '00000000' +AND Right(t1.rangcode, 8) <> '00000000') AS class0, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 3) = Left(t1.rangcode, 3) +AND Right(t2.rangcode, 6) = '000000' +AND Right(t1.rangcode, 6) <> '000000') AS class1, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 5) = Left(t1.rangcode, 5) +AND Right(t2.rangcode, 4) = '0000' +AND Right(t1.rangcode, 4) <> '0000') AS class2, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 7) = Left(t1.rangcode, 7) +AND Right(t2.rangcode, 2) = '00' +AND Right(t1.rangcode, 2) <> '00') AS class3 + +FROM biotopelist AS t1 +WHERE rusname
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/biotope.template Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,17 @@ +<?xml version="1.0" encoding="ISO-8859-5"?> +<!DOCTYPE ÞߨáÐÝØÕ_ÒØÔÐ SYSTEM "brief.dtd"> +<!-- rangcode: <%xml_escape get\rangcode%> --> +<ÞߨáÐÝØÕ_ÒØÔÐ show="0"> + <àØáãÝÚØ display="0"> + <%optional:<ÚÐàâÐ_àÐáßàÞáâàÐÝÕÝØï ÝÞÜÕà="1" file="<%xml_escape image:maps/<%get\rangcode%>.gif maps/<%get\code%>.png png%>"/>%> +<%query:photo_sql [%\<%include\photo.template%>%] <%get\code%>%> + </àØáãÝÚØ> + <ÝÐ×ÒÐÝØÕ><%xml_escape get\rusname%></ÝÐ×ÒÐÝØÕ> + <ÚÛÐáá><%xml_escape get\class0%></ÚÛÐáá> + <ßÞÔÚÛÐáá1><%xml_escape get\class1%></ßÞÔÚÛÐáá1> + <ßÞÔÚÛÐáá2><%xml_escape get\class2%></ßÞÔÚÛÐáá2> + <ßÞÔÚÛÐáá3><%xml_escape get\class3%></ßÞÔÚÛÐáá3> + <ÚàÐâÚÐï_åÐàÐÚâÕàØáâØÚÐ rows="3"><%xml_cdata get\descript%></ÚàÐâÚÐï_åÐàÐÚâÕàØáâØÚÐ> + <ßàØÜÕà_ÞߨáÐÝØï rows="3"><%xml_cdata get\geobotdescr%></ßàØÜÕà_ÞߨáÐÝØï> + <ÐÒâÞàë_ÞߨáÐÝØï><%xml_escape get\contributors%></ÐÒâÞàë_ÞߨáÐÝØï> +</ÞߨáÐÝØÕ_ÒØÔÐ>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/brief.dtd Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,27 @@ +<?xml encoding="ISO-8859-5"?> +<!ELEMENT ÞߨáÐÝØÕ_ÒØÔÐ (àØáãÝÚØ?, ÝÐ×ÒÐÝØÕ, ÚÛÐáá, ßÞÔÚÛÐáá1, ßÞÔÚÛÐáá2, ßÞÔÚÛÐáá3, ÚàÐâÚÐï_åÐàÐÚâÕàØáâØÚÐ, ßàØÜÕà_ÞߨáÐÝØï, ÐÒâÞàë_ÞߨáÐÝØï)> +<!ELEMENT àØáãÝÚØ (äÞâÞÓàÐäØï|ÚÐàâÐ_àÐáßàÞáâàÐÝÕÝØï)*> +<!ELEMENT äÞâÞÓàÐäØï EMPTY> +<!ELEMENT ÚÐàâÐ_àÐáßàÞáâàÐÝÕÝØï EMPTY> +<!ELEMENT ÝÐ×ÒÐÝØÕ (#PCDATA)> +<!ELEMENT ÚÛÐáá (#PCDATA)> +<!ELEMENT ßÞÔÚÛÐáá1 (#PCDATA)> +<!ELEMENT ßÞÔÚÛÐáá2 (#PCDATA)> +<!ELEMENT ßÞÔÚÛÐáá3 (#PCDATA)> +<!ELEMENT ÚàÐâÚÐï_åÐàÐÚâÕàØáâØÚÐ (#PCDATA)> +<!ELEMENT ßàØÜÕà_ÞߨáÐÝØï (#PCDATA)> +<!ELEMENT ÐÒâÞàë_ÞߨáÐÝØï (#PCDATA)> +<!ATTLIST ÞߨáÐÝØÕ_ÒØÔÐ show (0|1) "1"> +<!ATTLIST àØáãÝÚØ + display CDATA #FIXED "0"> +<!ATTLIST äÞâÞÓàÐäØï + num ID #REQUIRED + file CDATA #REQUIRED + big CDATA #REQUIRED + text CDATA #IMPLIED + ÐÒâÞà CDATA #IMPLIED> +<!ATTLIST ÚÐàâÐ_àÐáßàÞáâàÐÝÕÝØï + num ID #REQUIRED + file CDATA #REQUIRED> +<!ATTLIST ÚàÐâÚÐï_åÐàÐÚâÕàØáâØÚÐ rows CDATA #FIXED "3"> +<!ATTLIST ßàØÜÕà_ÞߨáÐÝØï rows CDATA #FIXED "3">
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/class.sql Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,7 @@ +SELECT t1.* +FROM biotopelist AS t1 +WHERE rusname AND Right(t1.rangcode, 8) = '00000000' + AND EXISTS + (SELECT NULL FROM biotopelist AS t2 + WHERE Left(t2.rangcode, 1) = Left(t1.rangcode, 1) + AND Right(t2.rangcode, 8) <> '00000000')
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/classes.template Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,5 @@ +<?xml version="1.0" encoding="ISO-8859-5"?> +<ÚÛÐááØäØÚÐæØï><%query:class_sql [%\ + <!-- rangcode: <%xml_escape get\rangcode%> --> + <ÚÛÐáá id="<%get\NUMBER%>"><%xml_escape get\rusname%></ÚÛÐáá>%]%> +</ÚÛÐááØäØÚÐæØï>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/main.template Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,11 @@ +<%!: + <%prepare:biotope_sql <%read\biotope.sql%>%> + <%prepare:photo_sql <%read\photo.sql%>%> + <%prepare:class_sql <%read\class.sql%>%> + <%prepare:plant_sql <%read\plant.sql%>%> + + <%query:biotope_sql [%\<%write:<%get\code%>.xml <%include\biotope.template%>%> %]%> + + <%write:classes.xml <%include\classes.template%>%> + <%write:plants.xml <%include\plants.template%>%> +%>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/photo.sql Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,1 @@ +SELECT * from photos WHERE biotope = ?
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/photo.template Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,3 @@ + <äÞâÞÓàÐäØï num="<%xml_escape get\NUMBER%>" <%optional:ÐÒâÞà="<%xml_escape get\authphoto%>" %>text="" + file="<%xml_escape image:biotopephotos/<%get\photo%> images/<%get\SUPER.code%>_<%get\NUMBER%>.jpg jpg 300 300%>" + big="<%xml_escape copy:biotopephotos/<%get\photo%> images/big/<%get\SUPER.code%>_<%get\NUMBER%>.jpg%>"/>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/plant.sql Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,3 @@ +SELECT t1.* +FROM biotopelist AS t1 +WHERE rusname AND Right(t1.rangcode, 2) <> '00'
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/plants.template Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,5 @@ +<?xml version="1.0" encoding="ISO-8859-5"?> +<àÐáâÕÝØï><%query:plant_sql [%\ + <!-- rangcode: <%xml_escape get\rangcode%> --> + <àÐáâÕÝØÕ><%xml_escape get\rusname%></àÐáâÕÝØÕ>%]%> +</àÐáâÕÝØï>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/biotopes/tema.properties Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,22 @@ +# Data source configuration +resource : jdbc:odbc:biotopes-data +driver : sun.jdbc.odbc.JdbcOdbcDriver + +# Base directory for images and files +resource_base : C:\\biotopes\\db + +# Template to start processing with +main_template : main.template + +# File encodings +input_encoding : ISO-8859-5 +output_encoding : ISO-8859-5 + +# Cache templates +cache_read : true + +# Output main_template parsing result to stderr +#output : stderr + +# File to output error messages (redirect stderr) +#log : tema.log
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/readme.html Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,86 @@ +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" + "DTD/xhtml1-transitional.dtd"> + +<html> + +<head> + <title>DbReader</title> + <meta http-equiv="Content-Type" content="text/html; charset=koi8-r" /> +</head> + +<body> +<h1>DbReader</h1> + +<h2>õÓÔÁÎÏ×ËÁ ÐÒÏÇÒÁÍÍÙ</h2> +<ol> +<li>òÁÓÐÁËÏ×ÁÔØ ÁÒÈÉ×.</li> + +<li>õÓÔÁÎÏ×ÉÔØ ÉÓÔÏÞÎÉË ÄÁÎÎÙÈ:<br /> +× Windows 2000: ðÁÎÅÌØ ÕÐÒÁ×ÌÅÎÉÑ/áÄÍÉÎÉÓÔÒÉÒÏ×ÁÎÉÅ/éÓÔÏÞÎÉËÉ ÄÁÎÎÙÈ (ODBC), ÄÏÂÁ×ÉÔØ biotopes-data.mdb.</li> + +<li>îÁÓÔÒÏÉÔØ ÐÒÏÇÒÁÍÍÕ:<br /> +÷ ÆÁÊÌÅ dbreader.properties ÕËÁÚÁÔØ ÉÍÑ, ÐÒÉÓ×ÏÅÎÎÏÅ ÉÓÔÏÞÎÉËÕ ÄÁÎÎÙÈ:<br /> + <code>resource: jdbc:odbc:<em>ÉÍÑ</em></code><br /> +É ÐÕÔØ Ë ËÁÔÁÌÏÇÕ, ÏÔÎÏÓÉÔÅÌØÎÏ ËÏÔÏÒÏÇÏ ÐÒÏÇÒÁÍÍÁ ÂÕÄÅÔ ÉÓËÁÔØ ÉÚÏÂÒÁÖÅÎÉÑ (ÓÏÄÅÒÖÁÝÉÊ biotopephotos É maps):<br /> + <code>resource_base: C:\\biotopes</code><br /> +(ÓÉÍ×ÏÌ '\' ÎÅÏÂÈÏÄÉÍÏ ÄÕÂÌÉÒÏ×ÁÔØ)</li> + +<li>úÁÐÕÓË ÐÒÏÇÒÁÍÍÙ:<br /> +<code>dbreader.bat</code> ÉÌÉ<br /> +<code>java -jar dbreader.jar</code>.<br /> +äÌÑ ÚÁÐÕÓËÁ ÎÅÏÂÈÏÄÉÍÁ Java Runtime Environment (JRE) 5.0, ÍÏÖÎÏ ÓËÁÞÁÔØ Ó <a href="http://java.sun.com/j2se/1.5.0/download.jsp">http://java.sun.com/j2se/1.5.0/download.jsp</a>. ÷ÏÚÍÏÖÎÏ, ÂÕÄÅÔ ÒÁÂÏÔÁÔØ É ÓÏ ÓÔÁÒÙÍÉ ×ÅÒÓÉÑÍÉ JRE - ÎÅ ÐÒÏ×ÅÒÑÌ. + +÷ÓÅ ÚÎÁÞÅÎÉÑ ÆÁÊÌÁ ËÏÎÆÉÇÕÒÁÃÉÉ ÍÏÖÎÏ ÐÅÒÅÏÐÒÅÄÅÌÑÔØ ÐÒÉ ÚÁÐÕÓËÅ ÐÒÏÇÒÁÍÍÙ:<br /> +ËÏÍÁÎÄÁ <code>java -Dru.karrc.dbreader.<em>ËÌÀÞ</em>=<em>ÚÎÁÞÅÎÉÅ</em> -jar dbreader.jar</code><br /> +(ÎÁÐÒÉÍÅÒ: <code>java -Dru.karrc.dbreader.log=dbreader.log -jar dbreader.jar</code>)</li> +</ol> + +<h2>òÁÂÏÔÁ ÐÒÏÇÒÁÍÍÙ</h2> + +<p>ðÒÏÇÒÁÍÍÁ ×ÙÐÏÌÎÑÅÔ ÚÁÐÒÏÓ biotope.sql (ÉÌÉ ÄÒÕÇÏÊ, ÕËÁÚÁÎÎÙÊ × dbreader.properties), ÐÏÓÌÅ ÞÅÇÏ ÏÂÒÁÂÁÔÙ×ÁÅÔ ÆÁÊÌ biotope.template, ÚÁÍÅÎÑÑ ÎÁÊÄÅÎÎÙÅ × ÎÅÍ ÉÎÓÔÒÕËÃÉÉ ÎÁ ÒÅÚÕÌØÔÁÔÙ ÉÈ ×ÙÐÏÌÎÅÎÉÑ.</p> +<p>æÏÒÍÁÔ ÉÎÓÔÒÕËÃÉÊ: <code><%<em>ÓÐÉÓÏË_ÆÕÎËÃÉÊ</em>[:|\]<em>ÄÁÎÎÙÅ</em>%></code>, <em>ÓÐÉÓÏË ÆÕÎËÃÉÊ</em> - ÉÍÅÎÁ ÆÕÎËÃÉÊ ÒÁÚÄÅÌÅÎÎÙÅ ÐÒÏÂÅÌÏÍ, ÓÐÉÓÏË ÍÏÖÅÔ ÂÙÔØ ÐÕÓÔÙÍ. åÓÌÉ ÕËÁÚÁÎÏ ÎÅÓËÏÌØËÏ ÆÕÎËÃÉÊ, ÏÎÉ ×ÙÐÏÌÎÑÀÔÓÑ ÎÁÞÉÎÁÑ Ó ÐÏÓÌÅÄÎÅÊ.</p> + +<h3>òÁÚÄÅÌÉÔÅÌÉ ÍÅÖÄÕ ÓÐÉÓËÏÍ ÆÕÎËÃÉÊ É ÄÁÎÎÙÍÉ</h3> + +<ul> + <li><code>:</code> - ÄÁÎÎÙÅ ÂÕÄÕÔ ÏÂÒÁÂÁÔÙ×ÁÔØÓÑ ÒÅËÕÒÓÉ×ÎÏ.</li> + <li><code>\</code> - ÄÁÎÎÙÅ ÂÕÄÕÔ ÐÅÒÅÄÁÎÙ ÆÕÎËÃÉÉ ÂÅÚ ÏÂÒÁÂÏÔËÉ. íÏÖÎÏ ÉÓÐÏÌØÚÏ×ÁÔØ ÄÌÑ ÜËÒÁÎÉÒÏ×ÁÎÉÑ ËÏÍÂÉÎÁÃÉÊ ÓÉÍ×ÏÌÏ× <code><%</code> É <code>%></code> (<code><%\<%%></code> É <code><%\%%>></code>).</li> +</ul> + +<h3>æÕÎËÃÉÉ</h3> + +<ul> + <li><code><%get:<em>ÉÍÑ</em>%></code><br /> + úÁÍÅÎÑÅÔÓÑ ÎÁ ÚÎÁÞÅÎÉÅ ×ÓÔÒÏÅÎÎÏÊ ÐÅÒÅÍÅÎÎÏÊ ÉÌÉ ËÏÌÏÎËÉ ÚÁÐÒÏÓÁ.</li> + + <li><code><%optional:<em>ÔÅËÓÔ</em>%></code><br /> + úÁÍÅÎÑÅÔÓÑ ÎÁ <em>ÔÅËÓÔ</em>, ÅÓÌÉ × ÎÅÍ ÎÁÊÄÅÎÙ ÉÎÓÔÒÕËÃÉÉ, ÚÁÍÅÎÉ×ÛÉÅÓÑ ÎÁ ÎÅÐÕÓÔÙÅ ÓÔÒÏËÉ, ÉÎÁÞÅ ÚÁÍÅÎÑÅÔÓÑ ÎÁ ÐÕÓÔÕÀ ÓÔÒÏËÕ.</li> + + <li><code><%escape:<em>ÔÅËÓÔ</em>%></code><br /> + úÁÍÅÎÑÅÔ × ÔÅËÓÔÅ "ÏÐÁÓÎÙÅ" ÓÉÍ×ÏÌÙ (ÔÁÂÌÉÃÁ ÚÁÍÅÎ ÚÁÄÁÅÔÓÑ × ÆÁÊÌÅ ËÏÎÆÉÇÕÒÁÃÉÉ).</li> + + <li><code><%invoke:<em>ÉÍÑ</em>; <em>ÐÁÒÁÍ1</em> <em>ÐÁÒÁÍ2</em> ... <em>ÐÁÒÁÍN</em>%></code><br /> + ÷ÙÐÏÌÎÑÅÔ ÚÁÐÒÏÓ Ó ÐÁÒÁÍÅÔÒÁÍÉ <em>ÉÍÑ</em>.sql É ÚÁÍÅÎÑÅÔÓÑ ÎÁ ÒÅÚÕÌØÔÁÔÙ ÏÂÒÁÂÏÔËÉ ÛÁÂÌÏÎÁ <em>ÉÍÑ</em>.template. úÎÁÞÅÎÉÑ ÐÁÒÁÍÅÔÒÏ× ÐÏÄÓÔÁ×ÌÑÀÔÓÑ × ÚÁÐÒÏÓ ×ÍÅÓÔÏ ÓÉÍ×ÏÌÁ '?'.</li> + + <li><code><%image:<em>ÉÓÈ_ÆÁÊÌ</em> <em>ËÏÎ_ÆÁÊÌ</em> <em>ÆÏÒÍÁÔ</em> [<em>ÍÁËÓ_ÛÉÒÉÎÁ</em>] [<em>ÍÁËÓ_×ÙÓÏÔÁ</em>]%></code><br /> + úÁÇÒÕÖÁÅÔ ÉÚÏÂÒÁÖÅÎÉÅ ÉÚ ÆÁÊÌÁ <em>ÉÓÈ_ÆÁÊÌ</em> (ÐÕÔØ ÏÐÒÅÄÅÌÑÅÔÓÑ ÏÔÎÏÓÉÔÅÌØÎÏ ËÏÎÆÉÇÕÒÁÃÉÏÎÎÏÇÏ ÐÁÒÁÍÅÔÒÁ "resource_base") É ÐÒÅÏÂÒÁÚÕÅÔ ÅÇÏ × ÕËÁÚÁÎÎÙÊ ÆÏÒÍÁÔ, ÓÏÈÒÁÎÑÑ ÒÅÚÕÌØÔÁÔ × <em>ËÏÎ_ÆÁÊÌ</em>. åÓÌÉ ÚÁÄÁÎÙ ÍÁËÓÉÍÁÌØÎÁÑ ×ÙÓÏÔÁ É ÛÉÒÉÎÁ, ÂÏÌØÛÉÅ ÉÚÏÂÒÁÖÅÎÉÑ ÂÕÄÕÔ ÕÍÅÎØÛÅÎÙ. +ðÒÉ ÕÓÐÅÛÎÏÍ ×ÙÐÏÌÎÅÎÉÉ, ÉÎÓÔÒÕËÃÉÑ <code><%image:...%></code> ÂÕÄÅÔ ÚÁÍÅÎÅÎÁ ÎÁ ÚÎÁÞÅÎÉÅ <em>ËÏÎ_ÆÁÊÌ</em>, ÉÎÁÞÅ - ÎÁ ÐÕÓÔÕÀ ÓÔÒÏËÕ.</li> + + <li><code><%copy:<em>ÉÓÈ_ÆÁÊÌ</em> <em>ËÏÎ_ÆÁÊÌ</em>%></code><br /> + ëÏÐÉÒÕÅÔ ÆÁÊÌ <em>ÉÓÈ_ÆÁÊÌ</em> (ÐÕÔØ ÏÐÒÅÄÅÌÑÅÔÓÑ ÏÔÎÏÓÉÔÅÌØÎÏ ËÏÎÆÉÇÕÒÁÃÉÏÎÎÏÇÏ ÐÁÒÁÍÅÔÒÁ "resource_base") × <em>ËÏÎ_ÆÁÊÌ</em>. ðÒÉ ÕÓÐÅÛÎÏÍ ×ÙÐÏÌÎÅÎÉÉ, ÉÎÓÔÒÕËÃÉÑ <code><%copy:...%></code> ÂÕÄÅÔ ÚÁÍÅÎÅÎÁ ÎÁ ÚÎÁÞÅÎÉÅ <em>ËÏÎ_ÆÁÊÌ</em>, ÉÎÁÞÅ - ÎÁ ÐÕÓÔÕÀ ÓÔÒÏËÕ.</li> +</ul> + +<h3>÷ÓÔÒÏÅÎÎÙÅ ÐÅÒÅÍÅÎÎÙÅ</h3> + +<p><code>NUMBER</code> - ÐÏÒÑÄËÏ×ÙÊ ÎÏÍÅÒ ÓÔÒÏËÉ ÒÅÚÕÌØÔÁÔÁ ×ÙÐÏÌÎÅÎÉÑ ÚÁÐÒÏÓÁ. +þÔÏÂÙ ÏÂÒÁÔÉÔØÓÑ Ë ÐÅÒÅÍÅÎÎÏÊ ÚÁÐÒÏÓÁ, ÉÚ ËÏÔÏÒÏÇÏ ÏÂÒÁÂÁÔÙ×ÁÅÍÙÊ ÛÁÂÌÏÎ ÂÙÌ ×ÙÚ×ÁÎ Ó ÐÏÍÏÝØÀ ÆÕÎËÃÉÉ invoke, ÐÅÒÅÄ ÉÍÅÎÅÍ ÐÅÒÅÍÅÎÎÏÊ ÎÕÖÎÏ ÄÏÂÁ×ÉÔØ <code>SUPER.</code> (ÎÁÐÒÉÍÅÒ: <code>SUPER.NUMBER</code>).</p> + +<h3>ðÒÉÍÅÒ</h3> + +<p>óÌÅÄÕÀÝÁÑ ÉÎÓÔÒÕËÃÉÑ ÐÏÌÕÞÉÔ ÚÎÁÞÅÎÉÅ ÉÚ ÓÔÏÌÂÃÁ name É ÚÁÍÅÎÉÔ × ÎÅÍ ÓÐÅÃÉÁÌØÎÙÅ ÓÉÍ×ÏÌÙ:</p> +<p><code><%escape get:name%></code></p> + +<p align="right"><i><a href="mailto:kryshen@cs.karelia.ru">íÉÈÁÉÌ ëÒÙÛÅÎØ</a></i></p> + +</body> +</html>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/readme.txt Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,63 @@ +text/plain; charset=UTF-8 + +У�тановка программы +------------------- + +1. Ра�паковать архив. + +2. У�тановить и�точник данных: +в Windows 2000: Панель управлени�/�дмини�трирование/И�точники данных (ODBC), добавить biotopes.mdb. + +3. �а�троить программу: +В файле dbreader.properties указать им�, при�военное и�точнику данных: + "resource: jdbc:odbc:<им�>" +и путь к каталогу, отно�ительно которого программа будет и�кать изображени� (�одержащий biotopephotos и maps): + "resource_base: C:\\biotopes" +(�имвол '\' необходимо дублировать) + +4. Запу�к программы: dbreader.bat или "java -jar dbreader.jar" +Дл� запу�ка необходима Java Runtime Environment (JRE) 5.0, можно �качать � http://java.sun.com/j2se/1.5.0/download.jsp. Возможно, будет работать и �о �тарыми вер�и�ми JRE - не провер�л. + +В�е значени� файла конфигурации можно переопредел�ть при запу�ке программы: + команда "java -Dru.karrc.dbreader.<ключ>=<значение> -jar dbreader.jar" +(например: "java -Dru.karrc.dbreader.log=dbreader.log -jar dbreader.jar") + + +Работа программы +---------------- + +Программа выполн�ет запро� biotope.sql (или другой, указанный в dbreader.properties), по�ле чего обрабатывает файл biotope.template, замен�� найденные в нем ин�трукции на результаты их выполнени�. + +Формат ин�трукций: "<%�пи�ок_функций[:|\]данные%>", �пи�ок функций - имена функций разделенные пробелом, �пи�ок может быть пу�тым. Е�ли указано не�колько функций, они выполн�ют�� начина� � по�ледней. + +Разделители между �пи�ком функций и данными: +':' - данные будут обрабатывать�� рекур�ивно. +'\' - данные будут переданы функции без обработки. Можно и�пользовать дл� �кранировани� комбинаций �имволов "<%" и "%>" ("<%\<%%>" и "<%\%%>>"). + +Функции: +<%get:<им�>%> - замен�ет�� на значение в�троенной переменной или колонки запро�а. + +<%optional:<тек�т>%> +Замен�ет�� на <тек�т>, е�ли в нем найдены ин�трукции, заменившие�� на непу�тые �троки, иначе замен�ет�� на пу�тую �троку. + +<%escape:<тек�т>%> +Замен�ет в тек�те "опа�ные" �имволы (таблица замен задает�� в файле конфигурации). + +<%invoke:<им�> <парам1> <парам2> ... <парамN>%> +Выполн�ет запро� � параметрами <им�>.sql и замен�ет�� на результаты обработки шаблона <им�>.template. Значени� параметров под�тавл�ют�� в запро� вме�то �имвола '?'. + +<%image:<и�х_файл> <кон_файл> <формат> [<мак�_ширина>] [<мак�_вы�ота>]%> +Загружает изображение из файла <и�х_файл> (путь определ�ет�� отно�ительно конфигурационного параметра "resource_base") и преобразует его в указанный формат, �охран�� результат в <кон_файл>. Е�ли заданы мак�имальна� вы�ота и ширина, большие изображени� будут уменьшены. +При у�пешном выполнении, ин�трукци� "<%!image ...%>" будет заменена на значение <кон_файл>, иначе - на пу�тую �троку. + +<%copy:<и�х_файл> <кон_файл>%> +Копирует файл <и�х_файл> (путь определ�ет�� отно�ительно конфигурационного параметра "resource_base"). +При у�пешном выполнении, ин�трукци� "<%!copy ...%>" будет заменена на значение <кон_файл>, иначе - на пу�тую �троку. + +В�троенные переменные: +NUMBER - пор�дковый номер �троки результата выполнени� запро�а. +Чтобы обратить�� к переменной запро�а, из которого обрабатываемый шаблон был вызван � помощью функции invoke, перед именем переменной нужно добавить "SUPER." (например: "SUPER.NUMBER"). + +Пример: +Следующа� ин�трукци� получит значение из �толбца name и заменит в нем �пециальные �имволы: +<%escape get:name%>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/tema Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,3 @@ +#!/bin/sh + +java -jar tema.jar
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/tema.bat Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,1 @@ +java -jar tema.jar
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/dist/tema.properties Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,22 @@ +# Data source configuration +# resource : jdbc:odbc:biotopes-data +# driver : sun.jdbc.odbc.JdbcOdbcDriver + +# Base directory for images and files +# resource_base : C:\\biotopes\\db + +# Template to start processing with +main_template : main.template + +# File encodings +# input_encoding : ISO-8859-5 +# output_encoding : ISO-8859-5 + +# Cache templates +cache_read : true + +# Output main_template parsing result to stderr +#output : stderr + +# File to output error messages (redirect stderr) +#log : tema.log
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/doc/article.txt Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,391 @@ +* ðÒÅÏÂÒÁÚÏ×ÁÎÉÅ ÂÁÚÙ ÄÁÎÎÙÈ × XML-ÆÏÒÍÁÔ ÜÌÅËÔÒÏÎÎÏÊ ÂÉÂÌÉÏÔÅËÉ. + +äÌÑ ÒÅÛÅÎÉÑ ÚÁÄÁÞÉ ÐÒÅÏÂÒÁÚÏ×ÁÎÉÑ ÂÁÚÙ ÄÁÎÎÙÈ "íÅÓÔÏÏÂÉÔÁÎÉÑ ÷ÏÓÔÏÞÎÏÊ +æÅÎÎÏÓËÁÎÄÉÉ" ÉÚ ÆÏÒÍÁÔÁ Microsoft Access × XML-ÆÏÒÍÁÔ ÜÌÅËÔÒÏÎÎÏÊ +ÂÉÂÌÉÏÔÅËÉ ëÁÒîã òáî ÂÙÌÁ ÒÁÚÒÁÂÏÔÁÎÁ ÐÒÏÇÒÁÍÍÎÁÑ ÓÉÓÔÅÍÁ DbReader. + +ðÒÏÇÒÁÍÍÁ DbReader Ñ×ÌÑÅÔÓÑ ÕÎÉ×ÅÒÓÁÌØÎÙÍ ÓÒÅÄÓÔ×ÏÍ ÄÌÑ ÐÒÅÄÓÔÁ×ÌÅÎÉÑ +ÉÎÆÏÒÍÁÃÉÉ ÉÚ ÂÁÚ ÄÁÎÎÙÈ × ÔÅËÓÔÏ×ÙÈ ÆÏÒÍÁÔÁÈ. ðÒÏÇÒÁÍÍÁ ÏÂÒÁÂÁÔÙ×ÁÅÔ +ÚÁÄÁÎÎÙÅ ÛÁÂÌÏÎÙ ÔÅËÓÔÏ×ÙÈ ÆÁÊÌÏ× É ÚÁÍÅÎÑÅÔ ÎÁÊÄÅÎÎÙÅ × ÎÉÈ +ÉÎÓÔÒÕËÃÉÉ ÎÁ ÒÅÚÕÌØÔÁÔÙ ÉÈ ×ÙÐÏÌÎÅÎÉÑ. òÁÚÌÉÞÎÙÅ ÉÎÓÔÒÕËÃÉÉ ÐÏÚ×ÏÌÑÀÔ +ÆÏÒÍÉÒÏ×ÁÔØ SQL-ÚÁÐÒÏÓÙ, ×ÙÐÏÌÎÑÔØ ÉÈ É ÏÂÒÁÂÁÔÙ×ÁÔØ ÐÏÌÕÞÅÎÎÙÅ +ÄÁÎÎÙÅ. + + +* æÏÒÍÁÔ ÉÎÓÔÒÕËÃÉÊ: + + <%<ÓÐÉÓÏË_ÆÕÎËÃÉÊ>{:|\}<ÄÁÎÎÙÅ>%> + ÇÄÅ + +<ÓÐÉÓÏË_ÆÕÎËÃÉÊ> - ÓÐÉÓÏË ÉÍÅÎ ÆÕÎËÃÉÊ, ÒÁÚÄÅÌÅÎÎÙÈ ÐÒÏÂÅÌÁÍÉ. + íÏÖÅÔ ÂÙÔØ ÐÕÓÔÙÍ. +<ÄÁÎÎÙÅ> - ÄÁÎÎÙÅ, ÐÅÒÅÄÁ×ÁÅÍÙÅ ÆÕÎËÃÉÉ. + + +* æÏÒÍÁÔ ÄÁÎÎÙÈ: + + [<ÓÐÉÓÏË_ÁÒÇÕÍÅÎÔÏ×>][<ÔÅËÓÔ>] + ÇÄÅ + +<ÓÐÉÓÏË_ÁÒÇÕÍÅÎÔÏ×> - ÓÐÉÓÏË ÁÒÇÕÍÅÎÔÏ× ÆÕÎËÃÉÉ, ÒÁÚÄÅÌÅÎÎÙÈ ÐÒÏÂÅÌÁÍÉ. + íÏÖÅÔ ÂÙÔØ ÐÕÓÔÙÍ. +<ÔÅËÓÔ> - ÔÅËÓÔ, ÐÅÒÅÄÁ×ÁÅÍÙÊ ÆÕÎËÃÉÉ ÂÅÚ ÒÁÚÂÉÅÎÉÑ ÎÁ ÁÒÇÕÍÅÎÔÙ. + íÏÖÅÔ ÂÙÔØ ÐÕÓÔÙÍ. ëÏÌÉÞÅÓÔ×Ï ÁÒÇÕÍÅÎÔÏ×, ÐÏÓÌÅ ËÏÔÏÒÏÇÏ ÓÌÅÄÕÅÔ + ÔÅËÓÔ, ÚÁ×ÉÓÉÔ ÏÔ ÆÕÎËÃÉÉ. + +òÁÚÄÅÌÉÔÅÌØ ÍÅÖÄÕ ÓÐÉÓËÏÍ ÆÕÎËÃÉÊ É ÄÁÎÎÙÍÉ ÏÐÒÅÄÅÌÑÅÔ, ËÁË ÄÏÌÖÎÙ +ÏÂÒÁÂÁÔÙ×ÁÔØÓÑ ÄÁÎÎÙÅ ÆÕÎËÃÉÉ: +: - ÒÅËÕÒÓÉ×ÎÁÑ ÏÂÒÁÂÏÔËÁ, +\ - ÐÅÒÅÄÁÔØ ÂÅÚ ÏÂÒÁÂÏÔËÉ. + +åÓÌÉ × ÓÐÉÓËÅ ÆÕÎËÃÉÊ ÚÁÄÁÎÏ Ä×Å É ÂÏÌÅÅ ÆÕÎËÃÉÉ, ÏÎÉ ×ÙÐÏÌÎÑÀÔÓÑ, +ÎÁÞÉÎÁÑ Ó ÐÏÓÌÅÄÎÅÊ, ÔÁË ÞÔÏ ËÁÖÄÁÑ ÆÕÎËÃÉÑ ÐÏÌÕÞÁÅÔ × ËÁÞÅÓÔ×Å ÄÁÎÎÙÈ +ÒÅÚÕÌØÔÁÔ ×ÙÐÏÌÎÅÎÉÑ ÓÌÅÄÕÀÝÅÊ ÆÕÎËÃÉÉ. + +ëÁÖÄÁÑ ÆÕÎËÃÉÑ ÉÍÅÅÔ ËÏÄ ×ÏÚ×ÒÁÔÁ - ÃÅÌÏÅ ÞÉÓÌÏ. ëÏÄ ×ÏÚ×ÒÁÔÁ +ÉÎÓÔÒÕËÃÉÉ - ËÏÄ ×ÏÚ×ÒÁÔÁ ÐÅÒ×ÏÊ × ÓÐÉÓËÅ ÆÕÎËÃÉÉ. ëÏÄ ×ÏÚ×ÒÁÔÁ, +ÐÏÌÕÞÁÅÍÙÊ ÐÒÉ ÏÂÒÁÂÏÔËÅ ÔÅËÓÔÁ - ÓÕÍÍÁ ËÏÄÏ× ×ÏÚ×ÒÁÔÁ ÏÂÒÁÂÏÔÁÎÎÙÈ +ÉÎÓÔÒÕËÃÉÊ. + +÷ÍÅÓÔÏ ÓËÏÂÏË '<', '>' ÍÏÖÎÏ ÉÓÐÏÌØÚÏ×ÁÔØ ÓËÏÂËÉ '[', ']'. + + +* òÅÁÌÉÚÏ×ÁÎÎÙÅ ÆÕÎËÃÉÉ: + +æÕÎËÃÉÑ: set +áÒÇÕÍÅÎÔÙ: <ÉÍÑ> +ôÅËÓÔ: <ÚÎÁÞÅÎÉÅ> +äÅÊÓÔ×ÉÅ: ÕÓÔÁÎÁ×ÌÉ×ÁÅÔ ÚÎÁÞÅÎÉÅ ÐÅÒÅÍÅÎÎÏÊ <ÉÍÑ> +òÅÚÕÌØÔÁÔ: <ÉÍÑ> +ëÏÄ ×ÏÚ×ÒÁÔÁ: 1 + +æÕÎËÃÉÑ: get +áÒÇÕÍÅÎÔÙ: <ÉÍÑ> +òÅÚÕÌØÔÁÔ: ÚÎÁÞÅÎÉÅ ÐÅÒÅÍÅÎÎÏÊ <ÉÍÑ>. +ëÏÄ ×ÏÚ×ÒÁÔÁ: 1, ÅÓÌÉ ÚÎÁÞÅÎÉÅ ÐÅÒÅÍÅÎÎÏÊ ÂÙÌÏ ÕÓÔÁÎÏ×ÌÅÎÏ, 0 - ÉÎÁÞÅ. + +æÕÎËÃÉÑ: prepare +áÒÇÕÍÅÎÔÙ: <ÉÍÑ> +ôÅËÓÔ: <ÚÁÐÒÏÓ> +äÅÊÓÔ×ÉÅ: ðÏÄÇÏÔÁ×ÌÉ×ÁÅÔ SQL-ÚÁÐÒÏÓ <ÚÁÐÒÏÓ> ÄÌÑ ×ÙÐÏÌÎÅÎÉÑ, + ÚÁÐÉÓÙ×ÁÅÔ ÐÏÄÇÏÔÏ×ÌÅÎÎÙÊ ÚÁÐÒÏÓ × ÐÅÒÅÍÅÎÎÕÀ <ÉÍÑ>. +òÅÚÕÌØÔÁÔ: <ÉÍÑ> +ëÏÄ ×ÏÚ×ÒÁÔÁ: 1 + +æÕÎËÃÉÑ: query +áÒÇÕÍÅÎÔÙ: <ÉÍÑ_ÚÁÐÒÏÓÁ> <ÛÁÂÌÏÎ> <ÐÁÒÁÍ1> ... <ÐÁÒÁÍN> +äÅÊÓÔ×ÉÅ: ÷ÙÐÏÌÎÑÅÔ ÚÁÐÒÏÓ Ó ÐÁÒÁÍÅÔÒÁÍÉ, ÐÏÄÇÏÔÏ×ÌÅÎÎÙÊ Ó ÐÏÍÏÝØÀ + ÆÕÎËÃÉÉ prepare. úÎÁÞÅÎÉÑ ÐÁÒÁÍÅÔÒÏ× ÐÏÄÓÔÁ×ÌÑÀÔÓÑ × + ÚÁÐÒÏÓ ×ÍÅÓÔÏ ÓÉÍ×ÏÌÁ '?'. úÎÁÞÅÎÉÑ ÐÏÌÅÊ ÏÔ×ÅÔÁ ÂÕÄÕÔ + ÚÁÐÉÓÁÎÙ, ËÁË ÐÅÒÅÍÅÎÎÙÅ ÛÁÂÌÏÎÁ <ÛÁÂÌÏÎ>. ðÒÉ ÏÂÒÁÂÏÔËÉ + ÛÁÂÌÏÎÁ <ÛÁÂÌÏÎ> ÔÁËÖÅ ÏÐÒÅÄÅÌÑÅÔÓÑ ÐÅÒÅÍÅÎÎÁÑ NUMBER, + ÓÏÄÅÒÖÁÝÁÑ ÎÏÍÅÒ ÔÅËÕÝÅÊ ÓÔÒÏËÉ ÏÔ×ÅÔÁ. ðÅÒÅÍÅÎÎÙÅ, + ÏÐÒÅÄÅÌÅÎÎÙÅ × ×ÙÚÙ×ÁÀÝÅÍ ÛÁÂÌÏÎÅ, ÄÏÓÔÕÐÎÙ ÉÚ ÛÁÂÌÏÎÁ + <ÛÁÂÌÏÎ> ÐÏ ÉÍÅÎÉ SUPER.<ÉÍÑ_ÐÅÒÅÍÅÎÎÏÊ>. + +òÅÚÕÌØÔÁÔ: ÒÅÚÕÌØÔÁÔ ÏÂÒÁÂÏÔËÉ ÛÁÂÌÏÎÁ <ÛÁÂÌÏÎ> ÄÌÑ ËÁÖÄÏÊ ÓÔÒÏËÉ + ÏÔ×ÅÔÁ. +ëÏÄ ×ÏÚ×ÒÁÔÁ: ËÏÌÉÞÅÓÔ×Ï ÐÏÌÕÞÅÎÎÙÈ ÓÔÒÏË ÏÔ×ÅÔÁ. + +æÕÎËÃÉÑ: optional +ôÅËÓÔ: <ÄÁÎÎÙÅ> +òÅÚÕÌØÔÁÔ: <ÄÁÎÎÙÅ>, ÅÓÌÉ ÐÒÉ ÏÂÒÁÂÏÔËÅ ÄÁÎÎÙÈ ÂÙÌ ÐÏÌÕÞÅÎ + ËÏÄ ×ÏÚ×ÒÁÔÁ ÏÔÌÉÞÎÙÊ ÏÔ 0, ÉÎÁÞÅ - ÐÕÓÔÁÑ ÓÔÒÏËÁ. +ëÏÄ ×ÏÚ×ÒÁÔÁ: 1, ÅÓÌÉ ÒÅÚÕÌØÔÁÔ - ÐÕÓÔÁÑ ÓÔÒÏËÁ, 0 - ÉÎÁÞÅ. + +æÕÎËÃÉÑ: image +áÒÇÕÍÅÎÔÙ: <ÉÓÈ_ÆÁÊÌ> <ËÏÎ_ÆÁÊÌ> <ÆÏÒÍÁÔ> [<ÍÁËÓ_ÛÉÒÉÎÁ> [<ÍÁËÓ_×ÙÓÏÔÁ>]] +äÅÊÓÔ×ÉÅ: úÁÇÒÕÖÁÅÔ ÉÚÏÂÒÁÖÅÎÉÅ ÉÚ ÆÁÊÌÁ <ÉÓÈ_ÆÁÊÌ> (ÐÕÔØ ÏÐÒÅÄÅÌÑÅÔÓÑ + ÏÔÎÏÓÉÔÅÌØÎÏ ËÏÎÆÉÇÕÒÁÃÉÏÎÎÏÇÏ ÐÁÒÁÍÅÔÒÁ "resource_base") É + ÐÒÅÏÂÒÁÚÕÅÔ ÅÇÏ × ÕËÁÚÁÎÎÙÊ ÆÏÒÍÁÔ, ÓÏÈÒÁÎÑÑ ÒÅÚÕÌØÔÁÔ × + <ËÏÎ_ÆÁÊÌ>. åÓÌÉ ÚÁÄÁÎÙ ÍÁËÓÉÍÁÌØÎÁÑ ×ÙÓÏÔÁ É ÛÉÒÉÎÁ, ÂÏÌØÛÉÅ + ÉÚÏÂÒÁÖÅÎÉÑ ÂÕÄÕÔ ÕÍÅÎØÛÅÎÙ. +òÅÚÕÌØÔÁÔ: <ËÏÎ_ÆÁÊÌ> ÐÒÉ ÕÓÐÅÛÎÏÍ ×ÙÐÏÌÎÅÎÉÉ, ÐÕÓÔÁÑ ÓÔÒÏËÁ - ÉÎÁÞÅ. +ëÏÄ ×ÏÚ×ÒÁÔÁ: 1 ÐÒÉ ÕÓÐÅÛÎÏÍ ×ÙÐÏÌÎÅÎÉÉ, 0 - ÉÎÁÞÅ. + +æÕÎËÃÉÑ: copy +áÒÇÕÍÅÎÔÙ: <ÉÓÈ_ÆÁÊÌ> <ËÏÎ_ÆÁÊÌ> +äÅÊÓÔ×ÉÅ: ëÏÐÉÒÕÅÔ ÆÁÊÌ <ÉÓÈ_ÆÁÊÌ> × ÆÁÊÌ <ËÏÎ_ÆÁÊÌ> + (ÐÕÔØ <ÉÓÈ_ÆÁÊÌ> ÏÐÒÅÄÅÌÑÅÔÓÑ ÏÔÎÏÓÉÔÅÌØÎÏ + ËÏÎÆÉÇÕÒÁÃÉÏÎÎÏÇÏ ÐÁÒÁÍÅÔÒÁ "resource_base"). +òÅÚÕÌØÔÁÔ: <ËÏÎ_ÆÁÊÌ> ÐÒÉ ÕÓÐÅÛÎÏÍ ×ÙÐÏÌÎÅÎÉÉ, ÐÕÓÔÁÑ ÓÔÒÏËÁ - ÉÎÁÞÅ. +ëÏÄ ×ÏÚ×ÒÁÔÁ: 1 ÐÒÉ ÕÓÐÅÛÎÏÍ ×ÙÐÏÌÎÅÎÉÉ, 0 - ÉÎÁÞÅ. + +æÕÎËÃÉÑ: write +áÒÇÕÍÅÎÔÙ: <ÉÍÑ_ÆÁÊÌÁ> +ôÅËÓÔ: <ÄÁÎÎÙÅ> +äÅÊÓÔ×ÉÅ: úÁÐÉÓÙ×ÁÅÔ <ÄÁÎÎÙÅ> × ÆÁÊÌ <ÉÓÈ_ÆÁÊÌ>. +òÅÚÕÌØÔÁÔ: <ËÏÎ_ÆÁÊÌ> ÐÒÉ ÕÓÐÅÛÎÏÍ ×ÙÐÏÌÎÅÎÉÉ, ÐÕÓÔÁÑ ÓÔÒÏËÁ - ÉÎÁÞÅ. +ëÏÄ ×ÏÚ×ÒÁÔÁ: 1 ÐÒÉ ÕÓÐÅÛÎÏÍ ×ÙÐÏÌÎÅÎÉÉ, 0 - ÉÎÁÞÅ. + +æÕÎËÃÉÑ: read +ôÅËÓÔ: <ÉÍÑ_ÆÁÊÌÁ> +äÅÊÓÔ×ÉÅ: þÉÔÁÅÔ ÆÁÊÌ <ÉÍÑ_ÆÁÊÌÁ>. +òÅÚÕÌØÔÁÔ: ÐÒÏÞÉÔÁÎÎÙÅ ÄÁÎÎÙÅ ÐÒÉ ÕÓÐÅÛÎÏÍ ×ÙÐÏÌÎÅÎÉÉ, ÐÕÓÔÁÑ + ÓÔÒÏËÁ - ÉÎÁÞÅ. +ëÏÄ ×ÏÚ×ÒÁÔÁ: 1 ÐÒÉ ÕÓÐÅÛÎÏÍ ×ÙÐÏÌÎÅÎÉÉ, 0 - ÉÎÁÞÅ. + +æÕÎËÃÉÑ: include +ôÅËÓÔ: <ÉÍÑ_ÆÁÊÌÁ> +äÅÊÓÔ×ÉÅ: ×ËÌÀÞÁÅÔ ÛÁÂÌÏÎ ÉÚ ÆÁÊÌÁ <ÉÍÑ_ÆÁÊÌÁ>. +òÅÚÕÌØÔÁÔ: ÒÅÚÕÌØÔÁÔ ÏÂÒÁÂÏÔËÉ ÛÁÂÌÏÎÁ. +ëÏÄ ×ÏÚ×ÒÁÔÁ: ËÏÄ ×ÏÚ×ÒÁÔÁ, ÐÏÌÕÞÅÎÎÙÊ ÐÒÉ ÏÂÒÁÂÏÔËÅ ÛÁÂÌÏÎÁ. + +æÕÎËÃÉÑ: ! +ôÅËÓÔ: <ÄÁÎÎÙÅ> +äÅÊÓÔ×ÉÅ: ÎÅÔ. +òÅÚÕÌØÔÁÔ: ÎÅÔ. +ëÏÄ ×ÏÚ×ÒÁÔÁ: ËÏÄ ×ÏÚ×ÒÁÔÁ, ÐÏÌÕÞÅÎÎÙÊ ÐÒÉ ÏÂÒÁÂÏÔËÅ ÔÅËÓÔÁ ÄÁÎÎÙÈ. + +æÕÎËÃÉÑ: replace +áÒÇÕÍÅÎÔÙ: <ÓÔÒ1> <ÓÔÒ2> +ôÅËÓÔ: <ÄÁÎÎÙÅ> +òÅÚÕÌØÔÁÔ: ÄÁÎÎÙÅ, Ó ÚÁÍÅÎÅÎÎÙÍÉ ×ÈÏÖÄÅÎÉÑÍÉ ÐÏÄÓÔÒÏËÉ <ÓÔÒ1> + ÎÁ <ÓÔÒ2>. +ëÏÄ ×ÏÚ×ÒÁÔÁ: ËÏÄ ×ÏÚ×ÒÁÔÁ, ÐÏÌÕÞÅÎÎÙÊ ÐÒÉ ÏÂÒÁÂÏÔËÅ ÔÅËÓÔÁ ÄÁÎÎÙÈ. + +æÕÎËÃÉÑ: xml_escape +ôÅËÓÔ: <ÄÁÎÎÙÅ> +òÅÚÕÌØÔÁÔ: ÔÅËÓÔ <ÄÁÎÎÙÅ>, × ËÏÔÏÒÏÍ ÓÉÍ×ÏÌÙ + '&', '<', '>', '`', '\' ÚÁÍÅÎÅÎÙ ÎÁ ÓÏÏÔ×ÅÔÓÔ×ÕÀÝÉÅ + ÓÕÝÎÏÓÔÉ XML. +ëÏÄ ×ÏÚ×ÒÁÔÁ: ËÏÄ ×ÏÚ×ÒÁÔÁ, ÐÏÌÕÞÅÎÎÙÊ ÐÒÉ ÏÂÒÁÂÏÔËÅ ÔÅËÓÔÁ ÄÁÎÎÙÈ. + +æÕÎËÃÉÑ: xml_cdata +ôÅËÓÔ: <ÄÁÎÎÙÅ> +òÅÚÕÌØÔÁÔ: ÄÁÎÎÙÅ × ×ÉÄÅ ÂÌÏËÁ XML CDATA. +ëÏÄ ×ÏÚ×ÒÁÔÁ: ËÏÄ ×ÏÚ×ÒÁÔÁ, ÐÏÌÕÞÅÎÎÙÊ ÐÒÉ ÏÂÒÁÂÏÔËÅ ÔÅËÓÔÁ ÄÁÎÎÙÈ. + +óÉÓÔÅÍÁ DbReader ÒÁÓÛÉÒÑÅÍÁ: ×ÏÚÍÏÖÎÏ ÄÏÂÁ×ÌÅÎÉÅ × ÓÉÓÔÅÍÕ ÎÏ×ÙÈ +ÆÕÎËÃÉÊ, ÒÅÁÌÉÚÏ×ÁÎÎÙÈ × ×ÉÄÅ ËÌÁÓÓÏ× ÎÁ ÑÚÙËÅ Java. + + +* ðÒÉÍÅÎÅÎÉÅ ÓÉÓÔÅÍÙ DbReader ÄÌÑ ÐÒÅÏÂÒÁÚÏ×ÁÎÉÑ ÂÁÚÙ ÄÁÎÎÙÈ + "íÅÓÔÏÏÂÉÔÁÎÉÑ ÷ÏÓÔÏÞÎÏÊ æÅÎÎÏÓËÁÎÄÉÉ" ÉÚ ÆÏÒÍÁÔÁ Microsoft Access × + XML-ÆÏÒÍÁÔ ÜÌÅËÔÒÏÎÎÏÊ ÂÉÂÌÉÏÔÅËÉ ëÁÒîã òáî + +äÌÑ ÐÒÅÏÂÒÁÚÏ×ÁÎÉÑ ÉÓÐÏÌØÚÕÀÔÓÑ Ä×Å ÔÁÂÌÉÃÙ ÂÁÚÙ ÄÁÎÎÙÈ "íÅÓÔÏÏÂÉÔÁÎÉÑ +÷ÏÓÔÏÞÎÏÊ æÅÎÎÏÓËÁÎÄÉÉ" (ÐÅÒÅÞÉÓÌÅÎÙ ÔÏÌØËÏ ÉÓÐÏÌØÚÕÅÍÙÅ ÐÏÌÑ): + +biotopelist (code, rangcode, rusname, engname, descript, geobotdescr, + contributors, descrdate) + + code - ÓÞÅÔÞÉË, ËÌÀÞÅ×ÏÅ ÐÏÌÅ; + rangcode - ÐÏÌÅ × ÆÏÒÍÁÔÅ ABBCCDDEE, ÇÄÅ á, BB, CC, DD, åå - ËÏÄÙ + ËÌÁÓÓÁ, ÐÏÄËÌÁÓÓÏ× É ÒÁÓÔÅÎÉÑ; + rusname, engname, descript, geobotdescr - ÔÅËÓÔÏ×ÙÅ ÐÏÌÑ; + descrdate - ÄÁÔÁ. + +photos (biotope, photo, authphoto) + + biotope - ÞÉÓÌÏ, ÕËÁÚÙ×ÁÅÔ ÎÁ code × biotopelist; + photo - ÉÍÑ ÆÁÊÌÁ ÆÏÔÏÇÒÁÆÉÉ; + authphoto - ÔÅËÓÔ. + +ôÒÅÂÕÅÔÓÑ ÓÇÅÎÅÒÉÒÏ×ÁÔØ xml-ÆÁÊÌ ÄÌÑ ËÁÖÄÏÊ ÚÁÐÉÓÉ × biotopelist, ÆÁÊÌ +ÓÏ ÓÐÉÓËÏÍ ËÌÁÓÓÏ×, ÆÁÊÌ ÓÏ ÓÐÉÓËÏÍ ÒÁÓÔÅÎÉÊ, ÐÏÌÎÏÒÁÚÍÅÒÎÙÅ É +ÕÍÅÎØÛÅÎÎÙÅ ×ÅÒÓÉÉ ËÁÖÄÏÊ ÆÏÔÏÇÒÁÆÉÉ. + +äÌÑ ÇÅÎÅÒÁÃÉÉ xml-ÆÁÊÌÏ× Ó ÏÐÉÓÁÎÉÑÍÉ ÂÉÏÔÏÐÏ× ÉÓÐÏÌØÚÏ×ÁÌÓÑ ÓÌÅÄÕÀÝÉÊ +ÛÁÂÌÏÎ DbReader (ÆÁÊÌ biotope.template): + +---------------------------------------------------------------------- +<?xml version="1.0" encoding="ISO-8859-5"?> +<!DOCTYPE ÏÐÉÓÁÎÉÅ_×ÉÄÁ SYSTEM "brief.dtd"> +<!-- rangcode: <%xml_escape get\rangcode%> --> +<ÏÐÉÓÁÎÉÅ_×ÉÄÁ show="0"> + <ÒÉÓÕÎËÉ display="0"> + <%optional:<ËÁÒÔÁ_ÒÁÓÐÒÏÓÔÒÁÎÅÎÉÑ ÎÏÍÅÒ="1" + file="<%xml_escape image:maps/<%get\rangcode%>.gif maps/<%get\code%>.png png%>"/>%> +<%query:photo_sql [%\<%include\photo.template%>%] <%get\code%>%> + </ÒÉÓÕÎËÉ> + <ÎÁÚ×ÁÎÉÅ><%xml_escape get\rusname%></ÎÁÚ×ÁÎÉÅ> + <ËÌÁÓÓ><%xml_escape get\class0%></ËÌÁÓÓ> + <ÐÏÄËÌÁÓÓ1><%xml_escape get\class1%></ÐÏÄËÌÁÓÓ1> + <ÐÏÄËÌÁÓÓ2><%xml_escape get\class2%></ÐÏÄËÌÁÓÓ2> + <ÐÏÄËÌÁÓÓ3><%xml_escape get\class3%></ÐÏÄËÌÁÓÓ3> + <ËÒÁÔËÁÑ_ÈÁÒÁËÔÅÒÉÓÔÉËÁ rows="3"><%xml_cdata get\descript%></ËÒÁÔËÁÑ_ÈÁÒÁËÔÅÒÉÓÔÉËÁ> + <ÐÒÉÍÅÒ_ÏÐÉÓÁÎÉÑ rows="3"><%xml_cdata get\geobotdescr%></ÐÒÉÍÅÒ_ÏÐÉÓÁÎÉÑ> + <Á×ÔÏÒÙ_ÏÐÉÓÁÎÉÑ><%xml_escape get\contributors%></Á×ÔÏÒÙ_ÏÐÉÓÁÎÉÑ> +</ÏÐÉÓÁÎÉÅ_×ÉÄÁ> +---------------------------------------------------------------------- + +óÏÏÔ×ÅÔÓÔ×ÕÀÝÉÊ SQL-ÚÁÐÒÏÓ, ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ËÏÔÏÒÏÇÏ ÕÓÔÁÎÁ×ÌÉ×ÁÀÔÓÑ +ÚÎÁÞÅÎÉÑ ÐÅÒÅÍÅÎÎÙÈ ÛÁÂÌÏÎÁ rangcode, rusname, class0, class1, class2, +class3, descript, geobotdescr É contributors (ÆÁÊÌ biotope.sql): + +---------------------------------------------------------------------- +SELECT t1.*, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 1) = Left(t1.rangcode, 1) +AND Right(t2.rangcode, 8) = '00000000' +AND Right(t1.rangcode, 8) <> '00000000') AS class0, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 3) = Left(t1.rangcode, 3) +AND Right(t2.rangcode, 6) = '000000' +AND Right(t1.rangcode, 6) <> '000000') AS class1, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 5) = Left(t1.rangcode, 5) +AND Right(t2.rangcode, 4) = '0000' +AND Right(t1.rangcode, 4) <> '0000') AS class2, + +(SELECT t2.rusname FROM biotopelist AS t2 +WHERE Left(t2.rangcode, 7) = Left(t1.rangcode, 7) +AND Right(t2.rangcode, 2) = '00' +AND Right(t1.rangcode, 2) <> '00') AS class3 + +FROM biotopelist AS t1 +WHERE rusname +---------------------------------------------------------------------- + +ûÁÂÌÏÎ biotope.template ÓÏÄÅÒÖÉÔ ÉÎÓÔÒÕËÃÉÀ <%include\photo.template%>, +×ËÌÀÞÁÀÝÕÀ ÛÁÂÌÏÎ ÏÐÉÓÁÎÉÑ ÆÏÔÏÇÒÁÆÉÉ (ÆÁÊÌ photo.template): + +---------------------------------------------------------------------- + <ÆÏÔÏÇÒÁÆÉÑ num="<%xml_escape get\NUMBER%>" + <%optional:Á×ÔÏÒ="<%xml_escape get\authphoto%>" %>text="" + file="<%xml_escape image:biotopephotos/<%get\photo%> images/<%get\SUPER.code%>_<%get\NUMBER%>.jpg jpg 300 300%>" + big="<%xml_escape copy:biotopephotos/<%get\photo%> images/big/<%get\SUPER.code%>_<%get\NUMBER%>.jpg%>"/> +---------------------------------------------------------------------- + +óÏÏÔ×ÅÔÓÔ×ÕÀÝÉÊ SQL-ÚÁÐÒÏÓ ÄÌÑ ÐÏÌÕÞÅÎÉÑ ÏÐÉÓÁÎÉÑ ÆÏÔÏÇÒÁÆÉÊ +(photo.sql): + +---------------------------------------------------------------------- +SELECT * from photos WHERE biotope = ? +---------------------------------------------------------------------- + +ûÁÂÌÏÎ, ÇÅÎÅÒÉÒÕÀÝÉÊ ÓÐÉÓÏË ËÌÁÓÓÏ× (ÆÁÊÌ classes.template): + +---------------------------------------------------------------------- +<?xml version="1.0" encoding="ISO-8859-5"?> +<ËÌÁÓÓÉÆÉËÁÃÉÑ><%query:class_sql [%\ + <!-- rangcode: <%xml_escape get\rangcode%> --> + <ËÌÁÓÓ id="<%get\NUMBER%>"><%xml_escape get\rusname%></ËÌÁÓÓ>%]%> +</ËÌÁÓÓÉÆÉËÁÃÉÑ> +---------------------------------------------------------------------- + +óÏÏÔ×ÅÔÓÔ×ÕÀÝÉÊ SQL-ÚÁÐÒÏÓ (class.sql): + +---------------------------------------------------------------------- +SELECT t1.* +FROM biotopelist AS t1 +WHERE rusname AND Right(t1.rangcode, 8) = '00000000' + AND EXISTS + (SELECT NULL FROM biotopelist AS t2 + WHERE Left(t2.rangcode, 1) = Left(t1.rangcode, 1) + AND Right(t2.rangcode, 8) <> '00000000') +---------------------------------------------------------------------- + +ûÁÂÌÏÎ, ÇÅÎÅÒÉÒÕÀÝÉÊ ÓÐÉÓÏË ÒÁÓÔÅÎÉÊ (ÆÁÊÌ plants.template): + +---------------------------------------------------------------------- +<?xml version="1.0" encoding="ISO-8859-5"?> +<ÒÁÓÔÅÎÉÑ><%query:plant_sql [%\ + <!-- rangcode: <%xml_escape get\rangcode%> --> + <ÒÁÓÔÅÎÉÅ><%xml_escape get\rusname%></ÒÁÓÔÅÎÉÅ>%]%> +</ÒÁÓÔÅÎÉÑ> +---------------------------------------------------------------------- + +óÏÏÔ×ÅÔÓÔ×ÕÀÝÉÊ SQL-ÚÁÐÒÏÓ (plant.sql): + +---------------------------------------------------------------------- +SELECT t1.* +FROM biotopelist AS t1 +WHERE rusname AND Right(t1.rangcode, 2) <> '00' +---------------------------------------------------------------------- + +óÉÓÔÅÍÁ DbReader ÎÁÞÉÎÁÅÔ ÒÁÂÏÔÕ Ó ÏÂÒÁÂÏÔËÉ ÛÁÂÌÏÎÁ index.template, +ËÏÔÏÒÙÊ ÓÏÄÅÒÖÉÔ ×ÙÚÏ×Ù ÐÅÒÅÞÉÓÌÅÎÎÙÈ ×ÙÛÅ SQL-ÚÁÐÒÏÓÏ× É ×ËÌÀÞÅÎÉÑ +ÛÁÂÌÏÎÏ×: + +---------------------------------------------------------------------- +<%!: + <%prepare:biotope_sql <%read\biotope.sql%>%> + <%prepare:photo_sql <%read\photo.sql%>%> + <%prepare:class_sql <%read\class.sql%>%> + <%prepare:plant_sql <%read\plant.sql%>%> + + <%query:biotope_sql [%\<%write:<%get\code%>.xml <%include\biotope.template%>%> %]%> + + <%write:classes.xml <%include\classes.template%>%> + <%write:plants.xml <%include\plants.template%>%> +%> +---------------------------------------------------------------------- + +ðÒÉÍÅÒ ÓÇÅÎÅÒÉÒÏ×ÁÎÎÏÇÏ XML-ÆÁÊÌÁ: + +---------------------------------------------------------------------- +<?xml version="1.0" encoding="ISO-8859-5"?> +<!DOCTYPE ÏÐÉÓÁÎÉÅ_×ÉÄÁ SYSTEM "brief.dtd"> +<!-- rangcode: E04020302 --> +<ÏÐÉÓÁÎÉÅ_×ÉÄÁ show="0"> + <ÒÉÓÕÎËÉ display="0"> + <ÆÏÔÏÇÒÁÆÉÑ num="1" Á×ÔÏÒ="ëÒÙÛÅÎØ á.í." text="" + file="images/3_1.jpg" + big="images/big/3_1.jpg"/> + <ÆÏÔÏÇÒÁÆÉÑ num="2" Á×ÔÏÒ="ëÒÙÛÅÎØ á.í." text="" + file="images/3_2.jpg" + big="images/big/3_2.jpg"/> + </ÒÉÓÕÎËÉ> + <ÎÁÚ×ÁÎÉÅ>Betula sp. - Avenella flexuosa - Polytrichum commune</ÎÁÚ×ÁÎÉÅ> + <ËÌÁÓÓ>E. óÕÈÏÄÏÌØÎÙÅ ÍÅÓÔÏÏÂÉÔÁÎÉÑ</ËÌÁÓÓ> + <ÐÏÄËÌÁÓÓ1>á×ÔÏÍÏÒÆÎÙÅ ×ÌÁÖÎÙÅ</ÐÏÄËÌÁÓÓ1> + <ÐÏÄËÌÁÓÓ2></ÐÏÄËÌÁÓÓ2> + <ÐÏÄËÌÁÓÓ3></ÐÏÄËÌÁÓÓ3> + <ËÒÁÔËÁÑ_ÈÁÒÁËÔÅÒÉÓÔÉËÁ rows="3"><![CDATA[òÁÚ×É×ÁÀÔÓÑ ÎÁ ÌÕÇÏ×ÉËÏ×ÙÈ ×ÙÒÕÂËÁÈ ÌÅÓÏ× ÞÅÒÎÉÞÎÏÇÏ ÔÉÐÁ. þÅÒÅÚ 5 - 7 ÌÅÔ ÐÏÓÌÅ ÒÕÂËÉ ÐÏÒÏÓÌÅ×ÁÑ ÂÅÒÅÚÁ ×ÙÈÏÄÉÔ ÉÚ ÑÒÕÓÁ ÔÒÁ×ÑÎÉÓÔÙÈ ÒÁÓÔÅÎÉÊ, ÅÅ ×ÌÉÑÎÉÅ ÓËÁÚÙ×ÁÅÔÓÑ, × ÐÅÒ×ÕÀ ÏÞÅÒÅÄØ, ÎÁ ×ÌÁÖÎÏÓÔÉ ÐÏÞ×Ù.]]></ËÒÁÔËÁÑ_ÈÁÒÁËÔÅÒÉÓÔÉËÁ> + <ÐÒÉÍÅÒ_ÏÐÉÓÁÎÉÑ rows="3"></ÐÒÉÍÅÒ_ÏÐÉÓÁÎÉÑ> + <Á×ÔÏÒÙ_ÏÐÉÓÁÎÉÑ></Á×ÔÏÒÙ_ÏÐÉÓÁÎÉÑ> +</ÏÐÉÓÁÎÉÅ_×ÉÄÁ> +---------------------------------------------------------------------- + + +* óÔÒÕËÔÕÒÁ ÐÒÏÇÒÁÍÍÙ DbReader + +ðÒÏÇÒÁÍÍÁ DbReader ÎÁÐÉÓÁÎÁ ÎÁ ÑÚÙËÅ ÐÒÏÇÒÁÍÍÉÒÏ×ÁÎÉÑ Java É ÓÏÓÔÏÉÔ +ÉÚ ÓÌÅÄÕÀÝÉÈ ÏÓÎÏ×ÎÙÈ ËÌÁÓÓÏ×: + +ru.karrc.dbreader.DbReader: cÏÄÅÒÖÉÔ ÔÏÞËÕ ×ÈÏÄÁ ÐÒÏÇÒÁÍÍÙ. úÁÇÒÕÖÁÅÔ +ËÏÎÆÉÇÕÒÁÃÉÀ, ÕÓÔÁÎÁ×ÌÉ×ÁÅÔ ÓÏÅÄÉÎÅÎÉÅ Ó ÉÓÔÏÞÎÉËÏÍ ÄÁÎÎÙÈ Ó ÐÏÍÏÝØÀ +ÂÉÂÌÉÏÔÅËÉ JDBC, ÚÁÐÕÓËÁÅÔ ÏÂÒÁÂÏÔËÕ ÏÓÎÏ×ÎÏÇÏ ÛÁÂÌÏÎÁ. + +ru.karrc.dbreader.TemplateParser: ÏÓÕÝÅÓÔ×ÌÑÅÔ ÒÁÚÂÏÒ ÛÁÂÌÏÎÁ, +ÏÂÒÁÂÏÔËÕ ÉÎÓÔÒÕËÃÉÊ É ×ÙÚÏ× ÆÕÎËÃÉÊ. + +ru.karrc.dbreader.Function: ÁÂÓÔÒÁËÔÎÙÊ ËÌÁÓÓ. òÅÁÌÉÚÁÃÉÉ ×ÓÅÈ ÆÕÎËÃÉÊ +DbReader ÎÁÓÌÅÄÕÀÔ ÜÔÏÔ ËÌÁÓÓ. + +ru.karrc.dbreader.FunctionDataParser: ÏÂÒÁÂÏÔÞÉË ÄÁÎÎÙÈ +ÆÕÎËÃÉÉ. ðÏÓ×ÏÌÑÅÔ ÐÏÌÕÞÉÔØ ÓÐÉÓÏË ÁÒÇÕÍÅÎÔÏ× É ÔÅËÓÔ, ÐÅÒÅÄÁ×ÁÅÍÙÊ +ÆÕÎËÃÉÉ. ðÒÉ ÎÅÏÂÈÏÄÉÍÏÓÔÉ ×ÙÚÙ×ÁÅÔ ÒÅËÕÒÓÉ×ÎÕÀ ÏÂÒÁÂÏÔËÕ ÄÁÎÎÙÈ Ó +ÐÏÍÏÝØÀ TemplateParser. + +ru.karrc.dbreader.Functions: ÓÏÄÅÒÖÉÔ ÒÅÁÌÉÚÁÃÉÉ ÆÕÎËÃÉÊ × ×ÉÄÅ +ÁÎÏÎÉÍÎÙÈ ËÌÁÓÓÏ×, ÎÁÓÌÅÄÕÀÝÉÈ Function. + +ru.karrc.dbreader.TemplateParser: ÉÓËÌÀÞÅÎÉÅ, ×ÙÂÒÁÓÙ×ÁÅÍÏÅ × ÓÌÕÞÁÅ +×ÏÚÎÉËÎÏ×ÅÎÉÑ ÏÛÉÂËÉ ÐÒÉ ÏÂÒÁÂÏÔËÅ ÛÁÂÌÏÎÁ. + +ëÒÏÍÅ ÔÏÇÏ, ÒÅÁÌÉÚÏ×ÁÎÏ ÎÅÓËÏÌØËÏ ×ÐÏÍÏÇÁÔÅÌØÎÙÈ ËÌÁÓÓÏ×, ËÏÔÏÒÙÅ +ÉÓÐÏÌØÚÕÀÔÓÑ × ÒÅÁÌÉÚÁÃÉÑÈ ÆÕÎËÃÉÊ ÓÉÓÔÅÍÙ. + + +* íÅÔÒÉËÉ ÒÅÁÌÉÚÏ×ÁÎÎÏÊ ÐÒÏÇÒÁÍÍÎÏÊ ÓÉÓÔÅÍÙ. + +ëÏÌÉÞÅÓÔ×Ï ÆÁÊÌÏ× ÉÓÈÏÄÎÏÇÏ ËÏÄÁ: 8, +ëÏÌÉÞÅÓÔ×Ï Java-ËÌÁÓÓÏ× (×ËÌÀÞÁÑ ÁÎÏÎÉÍÎÙÅ): 27, +ïÂÝÅÅ ËÏÌÉÞÅÓÔ×Ï ÓÔÒÏË ÉÓÈÏÄÎÏÇÏ ÔÅËÓÔÁ: 1311, +ëÏÌÉÞÅÓÔ×Ï ÓÔÒÏË ËÏÄÁ (ÉÓËÌÀÞÁÑ ÐÕÓÔÙÅ ÓÔÒÏËÉ É ËÏÍÍÅÎÔÁÒÉÉ): 812, +ëÏÌÉÞÅÓÔ×Ï ÓÔÒÏË ËÏÍÍÅÎÔÁÒÉÅ×: 180. + + +* úÁËÌÀÞÅÎÉÅ + +á×ÔÏÒÏÍ ÂÙÌÁ ÒÁÚÒÁÂÏÔÁÎÁ ÐÒÏÇÒÁÍÍÎÁÑ ÓÉÓÔÅÍÁ DbReader, ËÏÔÏÒÁÑ +Ñ×ÌÑÅÔÓÑ ÒÁÓÛÉÒÑÅÍÙÍ É ÕÎÉ×ÅÒÓÁÌØÎÙÍ ÓÒÅÄÓÔ×ÏÍ ÄÌÑ ÐÒÅÄÓÔÁ×ÌÅÎÉÑ +ÉÎÆÏÒÍÁÃÉÉ ÉÚ ÂÁÚ ÄÁÎÎÙÈ × ÔÅËÓÔÏ×ÙÈ ÆÏÒÍÁÔÁÈ. ó ÐÏÍÏÝØÀ ÓÉÓÔÅÍÙ +DbReader ÂÁÚÁ ÄÁÎÎÙÈ "íÅÓÔÏÏÂÉÔÁÎÉÑ ÷ÏÓÔÏÞÎÏÊ æÅÎÎÏÓËÁÎÄÉÉ" ÂÙÌÁ +ÐÅÒÅ×ÅÄÅÎÁ × XML-ÆÏÒÍÁÔ ÜÌÅËÔÒÏÎÎÏÊ ÂÉÂÌÉÏÔÅËÉ ëÁÒîã òáî.
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sample/class.xml Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,9 @@ +<?xml version="1.0" encoding="ISO-8859-5"?> +<ÚÛÐááØäØÚÐæØï> + <ÚÛÐáá id="1">°ÝâàÞßÞÓÕÝÝëÕ ÜÕáâÞÞÑØâÐÝØï</ÚÛÐáá> + <ÚÛÐáá id="2">¼Þàï Ø ÜÞàáÚØÕ ßÞÑÕàÕÖìï</ÚÛÐáá> + <ÚÛÐáá id="3">¾×ÕàÐ Ø ßàØÑàÕÖÝëÕ ÜÕáâÞÞÑØâÐÝØï</ÚÛÐáá> + <ÚÛÐáá id="4">ÀÕÚØ, àãçìØ Ø ßàØÑàÕÖÝëÕ ÜÕáâÞÞÑØâÐÝØï</ÚÛÐáá> + <ÚÛÐáá id="5">±ÞÛÞâÐ Ø ×ÐÑÞÛÞçÕÝÝëÕ ×ÕÜÛØ</ÚÛÐáá> + <ÚÛÐáá id="6">ÁãåÞÔÞÛìÝëÕ ÜÕáâÞÞÑØâÐÝØï</ÚÛÐáá> +</ÚÛÐááØäØÚÐæØï>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sample/plants.xml Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,6 @@ +<?xml version="1.0" encoding="ISO-8859-5"?> +<àÐáâÕÝØï> + <àÐáâÕÝØÕ>Betula sp.</àÐáâÕÝØÕ> + <àÐáâÕÝØÕ>Calamagrostis arundinacea</àÐáâÕÝØÕ> + <àÐáâÕÝØÕ>Geranium sylvaticum</àÐáâÕÝØÕ> +</àÐáâÕÝØï>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/Manifest.mf Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,2 @@ +Manifest-Version: 1.0 +Main-Class: kryshen.tema.Tema
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/kryshen/tema/Function.java Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,22 @@ +/* + * Copyright (C) 2005, 2006 Mikhail A. Kryshen + * + * $Id: Function.java,v 1.1.1.1 2006/05/16 14:04:09 mikhail Exp $ + */ + +package kryshen.tema; + +import java.io.*; +import java.util.*; +import java.sql.ResultSet; + +public abstract class Function { + public final String name; + + protected Function(String name) { + this.name = name; + } + + public abstract int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException; +}
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/kryshen/tema/FunctionDataParser.java Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,122 @@ +/* + * Copyright (C) 2006 Mikhail A. Kryshen + * + * $Id: FunctionDataParser.java,v 1.1.1.1 2006/05/16 14:04:09 mikhail Exp $ + */ + +package kryshen.tema; + +import java.io.*; +import java.util.*; + +import static kryshen.tema.TemplateParser.Result; +import static kryshen.tema.TemplateParser.FunctionData; +import static kryshen.tema.TemplateParser.Terminator; + +/** + * Parser for a function data. + * + * @author Mikhail A. Kryshen + */ +public class FunctionDataParser { + static final char[] ARG_SEPARATORS = TemplateParser.LIST_SEPARATORS; + + private TemplateParser tp; + private FunctionData fd; + private Reader in; + + private boolean available = true; + private boolean first = true; + + FunctionDataParser(TemplateParser tp, FunctionData fd, + Reader in) { + this.tp = tp; + this.fd = fd; + this.in = in; + } + + private TemplateParser.Result parseData(Writer out, boolean argument) + throws IOException, TemplateException { + + if (!available) + throw new TemplateException + ("Unexpected end of instruction data."); + + TemplateParser.Result r; + + if (fd == FunctionData.RECURSIVE) { + r = tp.parse(in, out, true, + argument ? ARG_SEPARATORS : null, + (argument || !first) ? ARG_SEPARATORS : null); + } else if (fd == FunctionData.NONRECURSIVE) { + r = tp.parse(in, out, false, + argument ? ARG_SEPARATORS : null, + (argument || !first) ? ARG_SEPARATORS : null); + } else if (fd == FunctionData.SUBFUNCTION && argument) { + /* Subfunction can pass a list of arguments */ + StringWriter sw = new StringWriter(); + tp.parseFunction(in, sw); + sw.close(); + in = new StringReader(sw.toString()); + fd = FunctionData.NONRECURSIVE; + r = parseData(out, true); + } else if (fd == FunctionData.SUBFUNCTION) { + r = new Result(null, tp.parseFunction(in, out), false); + } else { + throw new IllegalArgumentException("Invalid FunctiodData: " + fd); + } + + if (r.terminator != TemplateParser.Terminator.SEPARATOR) + available = false; // No more function data available. + + first = false; + return r; + } + + public int parseData(Writer out) throws IOException, TemplateException { + return parseData(out, false).substitutions; + } + + public String getData() throws IOException, TemplateException { + StringWriter sw = new StringWriter(); + parseData(sw); + sw.close(); + return sw.toString(); + } + + public int parseNextArg(Writer out) throws IOException, TemplateException { + TemplateParser.Result r = parseData(out, true); + + // Ignore empty arguments. + while (r.empty && available) { + r = parseData(out, true); + } + + return r.substitutions; + } + + public String getNextArg() throws IOException, TemplateException { + StringWriter sw = new StringWriter(); + parseNextArg(sw); + sw.close(); + return sw.toString(); + } + + public List<String> getArgs() throws IOException, TemplateException { + List<String> l = new ArrayList<String>(); + + while (available) { + l.add(getNextArg()); + } + + return l; + } + + public boolean hasMoreData() { + return available; + } + + public TemplateParser getTemplateParser() { + return tp; + } +}
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/kryshen/tema/Functions.java Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,336 @@ +/* + * Copyright (C) 2005, 2006 Mikhail A. Kryshen + * + * $Id: Functions.java,v 1.1.1.1 2006/05/16 14:04:09 mikhail Exp $ + */ + +package kryshen.tema; + +import java.io.*; +import java.util.*; + +import java.sql.SQLException; +import java.sql.PreparedStatement; + +import kryshen.tema.functions.*; + +public class Functions { + public static final Function GET = + new Function("get") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + String name = fdp.getData(); + return fdp.getTemplateParser().parseVariable(name, out); + } + }; + + public static final Function SET = + new Function("set") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + String arg0 = fdp.getNextArg(); + String arg1 = fdp.getData(); + + fdp.getTemplateParser().setValue(arg0, arg1); + + out.write(arg0); + return 1; + } + }; + + /* prepare:qury_name sql_statement */ + public static final Function PREPARE = + new Function("prepare") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + String arg0 = fdp.getNextArg(); + String data = fdp.getData(); + + PreparedStatement statement; + + try { + statement = Tema.connection.prepareStatement(data); + } catch (SQLException e) { + throw new TemplateException(e.getMessage(), e); + } + + fdp.getTemplateParser().setValue(arg0, statement); + + out.write(arg0); + return 1; + } + }; + + public static final Function OPTIONAL = + new Function("optional") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + StringWriter sw = new StringWriter(); + int s = fdp.parseData(sw); + sw.close(); + String data = sw.toString(); + + if (s > 0) { + out.write(data); + return 1; + } else { + return 0; + } + } + }; + + public static final Function IMAGE = + new Function("image") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + String arg0 = fdp.getNextArg(); + String arg1 = fdp.getNextArg(); + String arg2 = fdp.getNextArg(); + int arg3 = fdp.hasMoreData() ? + Integer.parseInt(fdp.getNextArg()) : -1; + int arg4 = fdp.hasMoreData() ? + Integer.parseInt(fdp.getNextArg()) : -1; + + File source = new File + (Tema.getProperty("resource_base"), arg0); + + try { + ImageConverter.convert + (source, /* source file */ + new File(arg1), /* dest file */ + arg2, /* format */ + arg3, /* max width */ + arg4); /* max height */ + } catch (Exception e) { + System.err.println(e); + return 0; + } + + out.write(arg1); + return 1; + } + }; + + public static final Function COPY = + new Function("copy") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + String arg0 = fdp.getNextArg(); + String arg1 = fdp.getNextArg(); + + File source = new File + (Tema.getProperty("resource_base"), arg0); + File dest = new File(arg1); + + try { + copyFile(source, dest); + } catch (IOException e) { + System.err.println(e); + return 0; + } + out.write(arg1); + return 1; + } + }; + + /* query:sql_query template arg1 arg2 ... argN */ + public static final Function QUERY = + new Function("query") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + String arg0 = fdp.getNextArg(); + String arg1 = fdp.getNextArg(); + List<String> args = fdp.getArgs(); + + TemplateParser tp = fdp.getTemplateParser(); + + try { + return Tema.query + (arg1, (PreparedStatement)tp.getValue(arg0), + args, tp, out); + } catch (SQLException e) { + throw new TemplateException(e.getMessage(), e); + } + } + }; + + public static final Function WRITE = + new Function("write") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + String arg0 = fdp.getNextArg(); + + System.err.println("Writing " + arg0 + "..."); + + Writer fw; + + try { + fw = Tema.createFileWriter(arg0); + } catch (IOException e) { + System.err.println(e); + return 0; + } + + try { + fdp.parseData(fw); + } finally { + fw.close(); + } + + out.write(arg0); + + System.err.println("Saved " + arg0 + "."); + return 1; + } + }; + + public static final Function READ = + new Function("read") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + String filename = fdp.getData(); + String file; + + try { + file = Tema.readFile(new File(filename)); + } catch (IOException e) { + System.err.println(e); + return 0; + } + + out.write(file); + return 1; + } + }; + + public static final Function INCLUDE = + new Function("include") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + String filename = fdp.getData(); + + Reader fin = new BufferedReader + (Tema.createCachedFileReader(new File(filename))); + + int r = fdp.getTemplateParser().parse(fin, out); + + fin.close(); + return r; + } + }; + + public static final Function NULL_OUTPUT = + new Function("!") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + /* Write nothing. */ + return fdp.parseData(new Writer() { + public void close() {} + public void flush() {} + public void write(char[] cbuf, int off, int len) {} + }); + } + }; + + public static final Function REPLACE = + new Function("replace") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + String arg0 = fdp.getNextArg(); + String arg1 = fdp.getNextArg(); + + ReplaceWriter rw = new ReplaceWriter(out, arg0, arg1); + + int ret = fdp.parseData(rw); + rw.finish(); + return ret; + } + }; + + public static final Function XML_ESCAPE = + new Function("xml_escape") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + final String[] chars = {"&", "<", ">", "`", "\""}; + final String[] escape = {"&", "<", ">", "'", """}; + + ReplaceWriter rw = new ReplaceWriter(out, chars, escape); + + int ret = fdp.parseData(rw); + rw.finish(); + return ret; + } + }; + + public static final Function XML_CDATA = + new Function("xml_cdata") { + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + ReplaceWriter rw = new ReplaceWriter + (out, "]]>", "]]]><![CDATA[]>", "<![CDATA[", "]]>"); + + int ret = fdp.parseData(rw); + rw.finish(); + return ret; + } + }; + + public static final Function DEFINE = new Define(); + + private static void copyFile(File src, File dest) throws IOException { + System.err.print("Copying " + src + "... "); + + if (src.lastModified() < dest.lastModified()) { + System.err.println(dest + " is up to date."); + return; + } + + File parent = dest.getParentFile(); + if (parent != null) parent.mkdirs(); + + InputStream in = new FileInputStream(src); + OutputStream out = new FileOutputStream(dest); + + byte[] buffer = new byte[1024]; + int len; + while ((len = in.read(buffer)) > 0) { + out.write(buffer, 0, len); + } + in.close(); + out.close(); + + System.err.println("saved " + dest + "."); + } + + static void registerAllFunctions(TemplateParser p) { + p.registerFunction(GET); + p.registerFunction(SET); + p.registerFunction(OPTIONAL); + p.registerFunction(IMAGE); + p.registerFunction(COPY); + p.registerFunction(QUERY); + p.registerFunction(PREPARE); + p.registerFunction(WRITE); + p.registerFunction(READ); + p.registerFunction(INCLUDE); + p.registerFunction(NULL_OUTPUT); + p.registerFunction(REPLACE); + p.registerFunction(XML_ESCAPE); + p.registerFunction(XML_CDATA); + p.registerFunction(DEFINE); + } +}
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/kryshen/tema/ImageConverter.java Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,184 @@ +/* + * Copyright (C) 2005, 2006 Mikhail A. Kryshen + * + * $Id: ImageConverter.java,v 1.1.1.1 2006/05/16 14:04:09 mikhail Exp $ + */ + +package kryshen.tema; + +import java.util.*; +import java.io.*; +import java.awt.*; +import java.awt.image.*; +import java.awt.geom.AffineTransform; +import javax.imageio.*; +import javax.imageio.stream.*; + +/** + * Class defines static method to convert images to specified format. + * + * @author Mikhail A. Kryshen + */ +class ImageConverter { + + static void convert(File source, File dest, String format, + int maxWidth, int maxHeight) + throws IOException, InterruptedException { + + System.err.print("Converting image " + source + "... "); + + if (source.lastModified() < dest.lastModified()) { + System.err.println(dest + " is up to date."); + return; + } + + BufferedImage image = ImageIO.read(source); + + //int type = image.getType(); + //final int type = BufferedImage.TYPE_INT_RGB; + //ColorModel cm = image.getColorModel(); + + int w = image.getWidth(null); + int h = image.getHeight(null); + + //boolean scale = false; + + float scale = 1f; + + if (maxWidth > 0 && w > maxWidth) + scale = (float)maxWidth / w; + + if (maxHeight > 0 && h * scale > maxHeight) + scale = (float)maxHeight / h; + + if (scale != 1f) { + w *= scale; h *= scale; + +// ColorModel cm = image.getColorModel(); +// boolean alphaPremultiplied = cm.isAlphaPremultiplied(); +// WritableRaster raster = cm.createCompatibleWritableRaster(w, h); +// BufferedImage scaled = new BufferedImage +// (cm, raster, alphaPremultiplied, null); + +// BufferedImage scaled = new BufferedImage(w, h, image.getType()); + + + Image scaled = image.getScaledInstance(w, h, Image.SCALE_SMOOTH); + + ColorModel cm = image.getColorModel(); + boolean alphaPremultiplied = image.isAlphaPremultiplied(); + WritableRaster raster = cm.createCompatibleWritableRaster(w, h); + image = new BufferedImage(cm, raster, alphaPremultiplied, null); + + Graphics g = image.getGraphics(); + g.drawImage(scaled, 0, 0, null); + g.dispose(); + +// image = scale(image, scaled, scale); +// Graphics2D g = scaled.createGraphics(); +// g.setRenderingHint(RenderingHints.KEY_INTERPOLATION, +// RenderingHints.VALUE_INTERPOLATION_BILINEAR); +// System.err.print(" " + g.drawImage(image, 0, 0, w, h, null) + " "); +// g.dispose(); +// image = scaled; + } + + File parent = dest.getParentFile(); + if (parent != null) parent.mkdirs(); + + ImageIO.write(image, format, dest); + System.err.println("saved " + dest + "."); + } + +// public static ColorModel getColorModel(Image image) +// throws InterruptedException { + +// PixelGrabber grabby = new PixelGrabber(image, 0, 0, 1, 1, false); +// if (!grabby.grabPixels()) +// throw new RuntimeException("pixel grab fails"); +// return grabby.getColorModel(); +// } + +// private static BufferedImage scale(BufferedImage image, +// BufferedImage dest, +// float scale) { + +// AffineTransform tx = new AffineTransform(); +// tx.scale(scale, scale); + +// AffineTransformOp op = new AffineTransformOp +// (tx, AffineTransformOp.TYPE_BILINEAR); + +// return op.filter(image, dest); +// } + + // TEST + + public static void main(String[] args) + throws IOException, InterruptedException { + + convert(new File(args[0]), new File(args[1]), "png", 300, 300); + } + + +// public static BufferedImage toBufferedImage(Image image, ColorModel cm) { +// if (image instanceof BufferedImage) +// return (BufferedImage)image; + +// int w = image.getWidth(null); +// int h = image.getHeight(null); + +// boolean alphaPremultiplied = cm.isAlphaPremultiplied(); +// WritableRaster raster = cm.createCompatibleWritableRaster(w, h); +// BufferedImage result = new BufferedImage(cm, raster, alphaPremultiplied, null); +// Graphics2D g = result.createGraphics(); + +// g.drawImage(image, 0, 0, null); +// g.dispose(); + +// return result; +// } +} + + +// This is how I'd recommend it in JDK1.4 using javax.imageio.ImageIO to +// do the reading/writing and Java2D to do the scaling. + +// // read in the original image +// BufferedImage in = ImageIO.read(new File("in.jpg")); + +// // create a new image of the smaller size +// BufferedImage out = new BufferedImage(newWidth, newHeight); + +// // get the graphics associated with the new image +// Graphics g = out.getGraphics(); + +// // draw the original image into the new image, scaling +// // on the fly +// g.drawImage(in, newWidth, newHeight, null); + +// // dispose the graphics object +// g.dispose(); + +// // write out the new image +// ImagIO.write("out.jpg", "jpeg", new File("out.jpg")); + +// ------------------------------------------ + +// For nicer scaling, you could add a rendering hint to the graphics +// object before painting. + +// ie. + +// Graphics2D g2d = (Graphics2D)g; +// g2d.setRenderingHint(RenderingHints.KEY_INTEPOLATION, +// RenderingHints.VALUE_INTERPOLATION_BILINEAR); + +// or use VALUE_INTERPOLATION_BICUBIC for the best. + +// But as you can guess, nicer == slower. + +// Shannon Hickey +// shann...@swingteam.com +// Swing Team http://TheSwingConnection.com http://TheJavaTutorial.com +// Java Software, a division of Sun Microsystems, Inc.
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/kryshen/tema/ReplaceWriter.java Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,140 @@ +/* + * Copyright (C) 2006 Mikhail A. Kryshen + * + * $Id: ReplaceWriter.java,v 1.1.1.1 2006/05/16 14:04:09 mikhail Exp $ + */ + +package kryshen.tema; + +import java.io.Writer; +import java.io.FilterWriter; +import java.io.IOException; + +import java.util.LinkedList; +import java.util.Iterator; + +/** + * FilterWriter which replaces characters with escape strings. + * + * @author Mikhail A. Kryshen + */ +class ReplaceWriter extends FilterWriter { + private String[] patterns; + private String[] replaces; + + private String prefix; + private String postfix; + + private int maxPatternLength = 0; + + /** Had this Writer processed any data? */ + private boolean processedData = false; + + private StringBuffer buffer = new StringBuffer(); + + public ReplaceWriter(Writer w, String pattern, String replace) { + this(w, new String[]{pattern}, new String[]{replace}); + } + + public ReplaceWriter(Writer w, String pattern, String replace, + String prefix, String postfix) { + + this(w, new String[]{pattern}, new String[]{replace}, + prefix, postfix); + } + + public ReplaceWriter(Writer w, String[] patterns, String[] replaces) { + this(w, patterns, replaces, null, null); + } + + public ReplaceWriter(Writer w, String[] patterns, String[] replaces, + String prefix, String postfix) { + super(w); + + this.patterns = patterns; + this.replaces = replaces; + + this.prefix = prefix; + this.postfix = postfix; + + for (int i = 0; i < patterns.length; i++) { + int length = patterns[i].length(); + if (length > maxPatternLength) + maxPatternLength = length; + } + } + + private boolean processBuffer(int minLength) throws IOException { + if (buffer.length() == 0) return false; + + if (!processedData) { + if (prefix != null) + super.write(prefix, 0, prefix.length()); + processedData = true; + } + + int k; + for (k = 0; minLength + k < buffer.length(); k++) { + for (int i = 0; i < patterns.length; i++) { + String pattern = patterns[i]; + int length = pattern.length(); + + if (length + k > buffer.length()) + continue; + + boolean match = true; + + for (int j = 0; j < length; j++) { + if (pattern.charAt(j) != buffer.charAt(j + k)) { + match = false; + break; + } + } + + if (match) { + super.write(buffer.substring(0, k), 0, k); + buffer.delete(0, k + length); + super.write(replaces[i], 0, replaces[i].length()); + return true; + } + } + } + + super.write(buffer.substring(0, k), 0, k); + buffer.delete(0, k); + + return false; + } + + public void write(int c) throws IOException { + buffer.append((char)c); + processBuffer(maxPatternLength); + } + + public void write(char[] cbuf, int off, int len) throws IOException { + for (int i = off; i < off + len; i++) { + buffer.append(cbuf[i]); + } + processBuffer(maxPatternLength); + } + + public void write(String str, int off, int len) throws IOException { + buffer.append(str.substring(off, off + len)); + processBuffer(maxPatternLength); + } + + public void finish() throws IOException { + while (processBuffer(0)); + +// super.write(buffer.toString(), 0, buffer.length()); +// buffer.delete(0, buffer.length()); + + if (processedData && postfix != null) + super.write(postfix, 0, postfix.length()); + } + + public void close() throws IOException { + finish(); + super.close(); + } +}
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/kryshen/tema/Tema.java Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,237 @@ +/* + * Copyright (C) 2005, 2006 Mikhail A. Kryshen + * + * $Id: Tema.java,v 1.1.1.1 2006/05/16 14:04:09 mikhail Exp $ + */ + +package kryshen.tema; + +import java.sql.Driver; +import java.sql.DriverManager; +import java.sql.Connection; +import java.sql.Statement; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.sql.ResultSetMetaData; +import java.sql.SQLException; + +import java.util.Map; +import java.util.HashMap; +import java.util.Properties; +import java.util.List; +import java.util.Collections; + +import java.io.*; + +/** + * Tema main class. + * + * @author Mikhail A. Kryshen + */ +public class Tema { + private static final String CONFIG_FILE = "tema.properties"; + private static final String ENV_PREFIX = "kryshen.tema."; + + private static Properties config = new Properties(); + static Connection connection = null; + + private static String inputEncoding; + private static String outputEncoding; + + static Map<File, String> fileCache = null; + + public static void main(String[] args) + throws IOException, TemplateException, SQLException, + ClassNotFoundException, InstantiationException, + IllegalAccessException { + + InputStream configIn = new FileInputStream(CONFIG_FILE); + config.load(configIn); + configIn.close(); + + String logFile = getProperty("log"); + if (logFile != null && logFile.length() > 0) + System.setErr(new PrintStream(new FileOutputStream(logFile))); + + if (Boolean.parseBoolean(getProperty("cache_read")) == true) + fileCache = new HashMap<File, String>(); + + inputEncoding = getProperty("input_encoding", "iso-8859-1"); + outputEncoding = getProperty("output_encoding", "iso-8859-1"); + + String resourceProperty = getProperty("resource"); + + if (resourceProperty != null) { + String driverProperty = getProperty("driver"); + if (driverProperty != null) { + // Register driver. + Driver d = (Driver)Class.forName(driverProperty).newInstance(); + } + + // Open connection. + connection = DriverManager.getConnection(resourceProperty); + } + +// String maxFilesString = getProperty("max_output_files"); +// int maxFiles = -1; +// if (maxFilesString != null) +// maxFiles = Integer.parseInt(maxFilesString); + + String main = getProperty("main_template"); + String output = getProperty("output"); + + Writer out; + + if ("stderr".equals(output)) + out = new OutputStreamWriter(System.err); + else + out = new OutputStreamWriter(System.out); + + InputStream is = new FileInputStream(main); + Reader in = new BufferedReader(new InputStreamReader(is, inputEncoding)); + + TemplateParser p = new TemplateParser(); + try { + p.parse(in, out); + } finally { + in.close(); + out.flush(); + } + + System.err.println("Done"); + } + +// private static void readEscapes() { +// for (int i = 1;; i++) { +// String pattern = getProperty("escape_char_" + i); + +// if (pattern == null) break; + +// escapes.put(pattern.charAt(0), +// getProperty("escape_string_" + i)); +// } +// } + + /** + * Get configuration property. + */ + static String getProperty(String name) { + String value = System.getProperty(ENV_PREFIX + name); + if (value != null) return value; + return config.getProperty(name); + } + + /** + * Get configuration property. + */ + static String getProperty(String name, String fallback) { + String value = getProperty(name); + if (value != null) return value; + return fallback; + } + + /** + * Process subquery and template. + * + * @param template template to fill with data. + * @param ps query statement to execute. + * @param args list of query parameters. + * @param superParser invoking object. + * @param out Writer to output processed data. + * + * @return number of processed rows in query result. + */ + static int query(String template, PreparedStatement ps, + List<String> args, + TemplateParser superParser, + Writer out) + throws IOException, SQLException, TemplateException { + + StringReader templateReader = new StringReader(template); + + int i = 1; + + for (String arg : args) { + ps.setString(i++, arg); + } + + ResultSet r = ps.executeQuery(); + ResultSetMetaData rm = r.getMetaData(); + int columnCount = rm.getColumnCount(); + + String[] names = new String[columnCount]; + + for (int j = 0; j < columnCount; j++) { + names[j] = rm.getColumnName(j + 1); + } + + TemplateParser p = new TemplateParser(superParser); + + for (i = 1; r.next(); i++) { + p.clearValues(); + + for (int j = 0; j < columnCount; j++) { + Object value = r.getObject(j + 1); + if (r.wasNull()) value = null; + + p.setValue(names[j], value); + } + + p.setValue("NUMBER", i); + p.parse(templateReader, out); + templateReader.reset(); + } + + r.close(); + ps.clearParameters(); + return i - 1; + } + + static Writer createFileWriter(String filename) throws IOException { + OutputStream os = new FileOutputStream(filename); + return new OutputStreamWriter(os, Tema.outputEncoding); + } + + static Reader createFileReader(File file) throws IOException { + InputStream is = new FileInputStream(file); + return new InputStreamReader(is, Tema.inputEncoding); + } + + static Reader createCachedFileReader(File file) throws IOException { + if (fileCache != null) return new StringReader(readFile(file)); + else return createFileReader(file); + } + + /** + * Read text file. + */ + static String readFile(File file) throws IOException { + String data; + + if (fileCache != null) { + data = fileCache.get(file); + if (data != null) return data; + } + + Reader r = new BufferedReader(createFileReader(file)); + + // FIXME: possible overflow (long -> int). + StringBuffer sb = new StringBuffer((int)file.length()); + + try { + for (int c = r.read(); c >= 0; c = r.read()) { + sb.append((char)c); + } + } finally { + r.close(); + } + + data = sb.toString(); + + if (fileCache != null) { + fileCache.put(file, data); + } + + return data; + } +}
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/kryshen/tema/TemplateException.java Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,24 @@ +/* + * Copyright (C) 2006 Mikhail A. Kryshen + * + * $Id: TemplateException.java,v 1.1.1.1 2006/05/16 14:04:09 mikhail Exp $ + */ + +package kryshen.tema; + +/** + * Signals that template parsing fails. + * + * @author Mikhail A. Kryshen + */ +public class TemplateException extends Exception { + // TODO: store the number of template line with error. + + public TemplateException(String message) { + super(message); + } + + public TemplateException(String message, Throwable cause) { + super(message, cause); + } +}
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/kryshen/tema/TemplateParser.java Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,287 @@ +/* + * Copyright (C) 2005, 2006 Mikhail A. Kryshen + * + * $Id: TemplateParser.java,v 1.1.1.1 2006/05/16 14:04:09 mikhail Exp $ + */ + +package kryshen.tema; + +import java.io.*; +import java.util.*; + +/** + * Parser for DbReader templates. + * + * @author Mikhail A. Kryshen + */ +public class TemplateParser { + static final String SUPER = "SUPER."; + + /* Brackets. */ + static final char[] BR_LEFT = {'<', '['}; + static final char[] BR_RIGHT = {'>', ']'}; + + static final char BR_IN = '%'; + + /* Separators. */ + static final char[] REC_DATA_SEPARATORS = {':'}; + static final char[] NONREC_DATA_SEPARATORS = {'\\', '`'}; + static final char[] LIST_SEPARATORS = {' ', '\t', '\r', '\n'}; + + static enum FunctionData { + SUBFUNCTION, RECURSIVE, NONRECURSIVE; + }; + + static enum Terminator { + EOF, BRACKET, SEPARATOR; + }; + + static class Result { + Terminator terminator; + int substitutions; + + /** No text had been parsed. */ + boolean empty; + + Result(Terminator terminator, int substitutions, boolean empty) { + this.terminator = terminator; + this.substitutions = substitutions; + this.empty = empty; + } + + Result() { + this(null, 0, true); + } + }; + + private Map<String, Function> functions = new HashMap<String, Function>(); + + private Map<String, Object> variables = new HashMap<String, Object>(); + private TemplateParser superParser; + + private int termBracket = -1; + + public TemplateParser() { + this(null); + } + + public TemplateParser(TemplateParser superParser) { + this.superParser = superParser; + + Functions.registerAllFunctions(this); + } + + public void registerFunction(Function f) { + functions.put(f.name, f); + } + + public int parse(Reader in, Writer out) + throws IOException, TemplateException { + + return parse(in, out, true, null, null).substitutions; + } + + /** + * Parse template. + * + * @param in Reader to read template data. + * @param out Writer to write processed data. + * @param recursive enables recursive processing. + * @param separators characters which terminate parsing block. + * @param leading characters to ignore at the beginning of the block. + */ + Result parse(Reader in, Writer out, boolean recursive, + char[] separators, char[] leading) + throws IOException, TemplateException { + + Result result = new Result(); + int lc = -1; + + while (true) { + int c = in.read(); + + if (leading != null && isSeparator(c, leading)) + continue; + else + leading = null; + + boolean leftBracket = false; + int index; + + for (index = 0; index < BR_LEFT.length; index++) { + if (lc == BR_LEFT[index]) { + leftBracket = true; + break; + } + } + + if (recursive && leftBracket && c == BR_IN) { + + lc = -1; + int tb = termBracket; + termBracket = BR_RIGHT[index]; + result.substitutions += parseFunction(in, out); + termBracket = tb; + + } else if (lc == BR_IN && c == termBracket) { + + lc = -1; + result.terminator = Terminator.BRACKET; + break; + + } else { + + if (lc >= 0) + out.write(lc); + + lc = c; + } + + if (c < 0) { + result.terminator = Terminator.EOF; + break; + } else if (separators != null && isSeparator(c, separators)) { + result.terminator = Terminator.SEPARATOR; + break; + } + + result.empty = false; + } + + return result; + } + + int parseVariable(String name, Writer out) + throws IOException, TemplateException { + + Object ovalue = getValue(name); + if (ovalue == null) + return 0; + + String svalue = ovalue.toString(); + + if (svalue == null || svalue.length() == 0) + return 0; + + out.write(svalue); + return 1; + } + + boolean isSeparator(int c, char[] separators) { + for (char p : separators) { + if (c == p) return true; + } + + return false; + } + + int parseFunction(Reader in, Writer out) + throws IOException, TemplateException { + + StringBuffer sb = new StringBuffer(); + + while (true) { + int c = in.read(); + + if (isSeparator(c, LIST_SEPARATORS)) { + return invokeFunction(sb.toString(), + FunctionData.SUBFUNCTION, + in, out); + } else if (isSeparator(c, REC_DATA_SEPARATORS)) { + return invokeFunction(sb.toString(), + FunctionData.RECURSIVE, + in, out); + } else if (isSeparator(c, NONREC_DATA_SEPARATORS)) { + return invokeFunction(sb.toString(), + FunctionData.NONRECURSIVE, + in, out); + } else if (c < 0) { + System.err.println("Error: unexpected end of file."); + return 0; + } else { + sb.append((char)c); + } + } + } + + private int invokeFunction(String name, FunctionData fd, + Reader in, Writer out) + throws IOException, TemplateException { + + FunctionDataParser fdp = new FunctionDataParser(this, fd, in); + + if ("".equals(name)) { + return fdp.parseData(out); + } + + Function f = getFunction(name); + + if (f == null) { + throw new TemplateException("Unknown function: " + name); + } + + int r = f.invoke(fdp, out); + + if (fdp.hasMoreData()) { + /* Skip remaining function data. */ + fdp.parseData(new Writer() { + public void close() {} + public void flush() {} + public void write(char[] cbuf, int off, int len) {} + }); + } + + return r; + } + + Function getFunction(String name) throws TemplateException { + Function function = functions.get(name); + if (function != null) return function; + + if (superParser != null) { + if (name.startsWith(SUPER)) + return superParser.getFunction(name.substring(SUPER.length())); + else + return superParser.getFunction(name); + } + + return null; + } + + Object getValue(String name) throws TemplateException { + Object value = variables.get(name); + if (value != null) return value; + + if (superParser != null) { + if (name.startsWith(SUPER)) + return superParser.getValue(name.substring(SUPER.length())); + else + return superParser.getValue(name); + } + + return null; + } + + void setValue(String name, Object value) { + variables.put(name, value); + } + + void clearValues() { + variables.clear(); + } + + // TEST + public static void main(String[] args) + throws IOException, TemplateException { + + TemplateParser p = new TemplateParser(); + + FileReader in = new FileReader("parser.in"); + FileWriter out = new FileWriter("parser.out"); + + p.parse(in, out); + + in.close(); + out.close(); + } +}
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/kryshen/tema/functions/Define.java Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,59 @@ +/* + * Copyright (C) 2006 Mikhail A. Kryshen + * + * $Id: Define.java,v 1.1.1.1 2006/05/16 14:04:09 mikhail Exp $ + */ + +package kryshen.tema.functions; + +import java.io.*; +import java.util.*; + +import kryshen.tema.*; + +public class Define extends Function { + public Define() { + super("define"); + } + + public int invoke(FunctionDataParser fdp, Writer out) + throws IOException, TemplateException { + + final String arg0 = fdp.getNextArg(); + final String data = fdp.getData(); + + Function newFunction = new Function(arg0) { + public int invoke(final FunctionDataParser fdp, final Writer out) + throws IOException, TemplateException { + + TemplateParser functionParser = + new TemplateParser(fdp.getTemplateParser()); + + functionParser.registerFunction(new Function("nextarg") { + public int invoke(FunctionDataParser unusedFdp, + final Writer out) + throws IOException, TemplateException { + + return fdp.parseNextArg(out); + } + }); + + functionParser.registerFunction(new Function("data") { + public int invoke(FunctionDataParser unusedFdp, + final Writer out) + throws IOException, TemplateException { + + return fdp.parseData(out); + } + }); + + return functionParser.parse(new StringReader(data), out); + } + }; + + fdp.getTemplateParser().registerFunction(newFunction); + + out.write(arg0); + return 1; + } +}
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/test/inctest.template Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,1 @@ +<%test:1 2 3%>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/test/macrotest Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,3 @@ +#!/bin/sh + +java -jar ../dist/tema.jar
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/test/main.template Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,3 @@ +<%define`test [%nextarg:%]+[%nextarg:%]=[%data:]%> +<%include`inctest.template%> +<%test:<%test:ab cd x%> [%\<%test\1 2 3%>%] y%>
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/test/tema.properties Tue May 16 18:04:09 2006 +0400 @@ -0,0 +1,22 @@ +# Data source configuration +# resource : jdbc:odbc:biotopes-data +# driver : sun.jdbc.odbc.JdbcOdbcDriver + +# Base directory for images and files +# resource_base : C:\\biotopes\\db + +# Template to start processing with +main_template : main.template + +# File encodings +# input_encoding : ISO-8859-5 +# output_encoding : ISO-8859-5 + +# Cache templates +# cache_read : true + +# Output main_template parsing result to stderr +# output : stderr + +# File to output error messages (redirect stderr) +# log : dbreader.log
