1 |
|
2008-04-28 Sascha L. Teichmann <[email protected]> |
2 |
|
|
3 |
|
* tools/formed/formed/plugins/export/xsd.py: Added support for |
4 |
|
repeat groups and integer fields. |
5 |
|
|
6 |
|
2008-04-28 Sascha L. Teichmann <[email protected]> |
7 |
|
|
8 |
|
* tools/formed/formed/plugins/export/xsd.py: New. plug-in for |
9 |
|
exporting as XML schema. not ready, yet. |
10 |
|
|
11 |
|
* tools/formed/formed/config.py: Use new plug-in. |
12 |
|
|
13 |
|
* tools/formed/formed/plugins/export/sql.py: Fixed wrong GUI text. |
14 |
|
|
15 |
|
2008-04-17 Torsten Irländer <[email protected]> |
16 |
|
|
17 |
|
* tools/formed/formed/plugins/export/sql.py: Changed WHERE clause in |
18 |
|
for the views because of the new group permissions. |
19 |
|
|
20 |
|
2008-04-09 Sascha L. Teichmann <[email protected]> |
21 |
|
|
22 |
|
* tools/anonym/cron.deleteOldAnonymized.sh: New. cron job to delete |
23 |
|
old anonymized cases. |
24 |
|
|
25 |
|
2008-04-01 Sascha L. Teichmann <[email protected]> |
26 |
|
|
27 |
|
* tools/anonym/xmlexport.py: Removed "WHERE einverstaendniserklaerung = 1" |
28 |
|
from clause to select datasets. |
29 |
|
Replace ']]>' in CDATA sections with correct splitted replacement. |
30 |
|
|
31 |
|
2008-03-12 Sascha L. Teichmann <[email protected]> |
32 |
|
|
33 |
|
* tools/anonym/cron.importAnonXml.sh: Added absolut path to xmlimport |
34 |
|
script. |
35 |
|
|
36 |
|
* tools/anonym/xmlimport.py: commented out database port from |
37 |
|
connectionstring. |
38 |
|
|
39 |
|
2008-03-12 Sascha L. Teichmann <[email protected]> |
40 |
|
|
41 |
|
* tools/formed/formed/plugins/export/sql.py: Fixed bug in generation |
42 |
|
of anonymization of repeat groups (wrong id was given). |
43 |
|
|
44 |
|
2008-03-11 Sascha L. Teichmann <[email protected]> |
45 |
|
|
46 |
|
* tools/formed/formed/plugins/export/sql.py: Generate no update |
47 |
|
statements for relations which have no anonym functions applied. |
48 |
|
|
49 |
|
2008-03-11 Sascha L. Teichmann <[email protected]> |
50 |
|
|
51 |
|
* tools/formed/formed/plugins/export/sql.py: Added a newline after |
52 |
|
'COMMIT;' in the last line. |
53 |
|
|
54 |
|
2008-03-11 Sascha L. Teichmann <[email protected]> |
55 |
|
|
56 |
|
* tools/formed/formed/plugins/export/sql.py: Fixed syntax of |
57 |
|
generated anonymize_case() function. |
58 |
|
|
59 |
|
2008-03-11 Sascha L. Teichmann <[email protected]> |
60 |
|
|
61 |
|
* tools/formed/formed/plugins/export/sql.py: Added code to |
62 |
|
generate a plpgsql function anonymize_case() that anonymized |
63 |
|
a given case and all of its depending repeat groups. |
64 |
|
|
65 |
|
2008-03-06 Sascha L. Teichmann <[email protected]> |
66 |
|
|
67 |
|
* tools/anonym/xmlimport.py: remove print of insert statement. |
68 |
|
|
69 |
|
* tools/formed/formed/plugins/export/sql.py: Print generation date in ISO. |
70 |
|
|
71 |
|
2008-03-03 Torsten Irländer <[email protected]> |
72 |
|
|
73 |
|
* anonym/cron.sendAnonXml.sh, |
74 |
|
anonym/getDbList.sh: Modified script to be used directly in the |
75 |
|
production environment (Copied running scripts from production |
76 |
|
server) |
77 |
|
|
78 |
|
* cron.importAnonXml.sh: Added deleting of ols cases. Modified script |
79 |
|
to be used in a production environment (Cpoied running script from |
80 |
|
production server) |
81 |
|
|
82 |
|
* tools/anonym/xmlexport.py: Added "WHERE" clause to SQL-Statement to |
83 |
|
ensure that only valid cases get exported |
84 |
|
|
85 |
|
2008-02-27 Sascha L. Teichmann <[email protected]> |
86 |
|
|
87 |
|
* tools/anonym/xmlimport.py: Fixed bug in date converter. |
88 |
|
|
89 |
|
2008-02-27 Sascha L. Teichmann <[email protected]> |
90 |
|
|
91 |
|
* tools/anonym/xmlimport.py: Simpilied version |
92 |
|
|
93 |
|
2008-02-27 Sascha L. Teichmann <[email protected]> |
94 |
|
|
95 |
|
* tools/anonym/cron.importAnonXml.sh: Add sudo call for |
96 |
|
xmlimport.py and parameters. |
97 |
|
|
98 |
|
* tools/anonym/xmlimport.py: Various bug fixes. Not working yet. :-/ |
99 |
|
|
100 |
|
* tools/anonym/xmlexport.py: Use python interpreter without env |
101 |
|
because of sudo context. |
102 |
|
|
103 |
|
2008-02-26 Sascha L. Teichmann <[email protected]> |
104 |
|
|
105 |
|
* tools/anonym/xmlimport.py: added support for getopt. add |
106 |
|
support to force in fkz in import of case. |
107 |
|
|
108 |
|
2008-02-26 Sascha L. Teichmann <[email protected]> |
109 |
|
|
110 |
|
* tools/anonym/xmlimport.py: Implemented logic to create/update cases. |
111 |
|
|
112 |
|
* tools/anonym/html.awk: produces valid HTML. |
113 |
|
|
114 |
|
2008-02-25 Sascha L. Teichmann <[email protected]> |
115 |
|
|
116 |
|
* tools/anonym/joincsv.py: Fix a logic bug. |
117 |
|
|
118 |
|
2008-02-25 Torsten Irlaender <[email protected]> |
119 |
|
|
120 |
|
* tools/anonym/cron.importAnonXml.sh: Added shellscript for importing |
121 |
|
exportted cases. It will read all files from a directory and import |
122 |
|
the files into the DB. After that the script will cleanup the |
123 |
|
directory. |
124 |
|
|
125 |
|
2008-02-25 Torsten Irländer <[email protected]> |
126 |
|
|
127 |
|
* tools/anonym/cron.sendAnonXml.sh, |
128 |
|
tools/anonym/xmlexport.py, |
129 |
|
tools/anonym/getDbList.sh: Added shell-scripts for exporting cases |
130 |
|
|
131 |
|
2008-02-25 Sascha L. Teichmann <[email protected]> |
132 |
|
|
133 |
|
* tools/anonym/joincsv.py: Fixed typo which generated wrong number of cols. |
134 |
|
|
135 |
|
2008-02-25 Sascha L. Teichmann <[email protected]> |
136 |
|
|
137 |
|
* tools/anonym/joincsv.py: New. Joins CSV files. |
138 |
|
|
139 |
|
* tools/anonym/html.awk: New. Converts CSV to HTML |
140 |
|
|
141 |
|
2008-02-25 Sascha L. Teichmann <[email protected]> |
142 |
|
|
143 |
|
* tools/anonym/xmlimport.py: New. Added generation of |
144 |
|
update statements. |
145 |
|
|
146 |
|
2008-02-25 Sascha L. Teichmann <[email protected]> |
147 |
|
|
148 |
|
* tools/anonym/xmlimport.py: New. Base for importing |
149 |
|
XML from cron. |
150 |
|
|
151 |
|
2008-02-24 Sascha L. Teichmann <[email protected]> |
152 |
|
|
153 |
|
* tools/formed/formed/plugins/export/html2.py: New. plug-in |
154 |
|
for a simplified HTML output |
155 |
|
|
156 |
|
* tools/formed/formed/plugins/export/typemap.py: New. plug-in |
157 |
|
for dump schema as python dictionary. |
158 |
|
|
159 |
|
* tools/formed/formed/config.py: Enable new plug-ins. Out comment |
160 |
|
old stored procedure and view generators. |
161 |
|
|
162 |
|
2008-02-19 Sascha L. Teichmann <[email protected]> |
163 |
|
|
164 |
|
* tools/anonym/xmlexport.py: New. Export all cases in database |
165 |
|
as XML. |
166 |
|
|
167 |
|
2008-02-18 Sascha L. Teichmann <[email protected]> |
168 |
|
|
169 |
|
* tools/anonym/anoymncsv.py: separate field with '\t' now. |
170 |
|
all '\t's are replaced by ' ' before. '\r\n' are removed too. |
171 |
|
|
172 |
|
2008-02-15 Sascha L. Teichmann <[email protected]> |
173 |
|
|
174 |
|
* tools/anonym/anoymncsv.py: simple script to fetch anonymous |
175 |
|
data from database. |
176 |
|
|
177 |
|
2008-02-14 Sascha L. Teichmann <[email protected]> |
178 |
|
|
179 |
|
* tools/formed/formed/plugins/export/sql.py: Exchanged name |
180 |
|
erase_value with suppress_value/suppress_value2. |
181 |
|
|
182 |
|
2008-02-13 Sascha L. Teichmann <[email protected]> |
183 |
|
|
184 |
|
* tools/formed/formed/plugins/export/sql.py: output id, master_id |
185 |
|
substitute 'erase_value' with NULL value. |
186 |
|
|
187 |
|
2008-02-13 Sascha L. Teichmann <[email protected]> |
188 |
|
|
189 |
|
* tools/formed/formed/plugins/export/sql.py: output id, master_id |
190 |
|
and uuid_id in anonymiziation views too. |
191 |
|
|
192 |
|
2008-02-13 Sascha L. Teichmann <[email protected]> |
193 |
|
|
194 |
|
* tools/formed/formed/plugins/export/sql.py: Added generation |
195 |
|
of anonymiziation views for master table views and repeat group |
196 |
|
views. |
197 |
|
|
198 |
|
2008-02-13 Sascha L. Teichmann <[email protected]> |
199 |
|
|
200 |
|
* tools/formed/formed/model/nodecomponents.py: Added attribute |
201 |
|
"function" |
202 |
|
|
203 |
|
* tools/formed/formed/io/document.py: Save attributes in |
204 |
|
alphabetical order. |
205 |
|
|
206 |
|
2008-02-02 Sascha L. Teichmann <[email protected]> |
207 |
|
|
208 |
|
* tools/formed/formed/plugins/export/sql.py: Added update rule |
209 |
|
for master table and repeat groups views. Granted update right |
210 |
|
to :cm_ka_group. |
211 |
|
|
212 |
|
2008-02-01 Sascha L. Teichmann <[email protected]> |
213 |
|
|
214 |
|
* tools/formed/formed/plugins/export/sql.py: Added a column 'uuid_id' |
215 |
|
for master table and repeat groups. Also added unique constraints |
216 |
|
to these columns. |
217 |
|
|
218 |
|
2007-12-10 Sascha L. Teichmann <[email protected]> |
219 |
|
|
220 |
|
* pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Added a system |
221 |
|
property 'root.element' to specify the name of the XML root. |
222 |
|
|
223 |
|
* pdf2xfa/startup/pdf2xfa.sh, pdf2xfa/README.TXT: Adjusted. |
224 |
|
|
225 |
|
2007-11-22 Sascha L. Teichmann <[email protected]> |
226 |
|
|
227 |
|
* pdf2xfa/startup, */pdf2xfa.sh, */pdf2xfa.init: boot scripts |
228 |
|
for GNU/Linux (tested Debian 'Etch' 4.0) by Sascha Wilde. |
229 |
|
|
230 |
|
* pdf2xfa/README.TXT: Add a remark to new boot scripts. |
231 |
|
|
232 |
|
2007-11-21 Sascha L. Teichmann <[email protected]> |
233 |
|
|
234 |
|
* pdf2xfa/src/de/intevation/pdfimport/Log.java: New. |
235 |
|
Sends logging to file. |
236 |
|
|
237 |
|
* pdf2xfa/src/de/intevation/pdfimport/Server.java, |
238 |
|
pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Adjusted |
239 |
|
to use new logging. |
240 |
|
|
241 |
|
* pdf2xfa/README.TXT: Added remark how to use logging. |
242 |
|
|
243 |
|
2007-11-16 Frank Koormann <[email protected]> |
244 |
|
|
245 |
|
* tools/formed/formed/plugins/export/sql.py (createSchema): |
246 |
|
Append only column "bearbeiter_id", standins are modelled by a |
247 |
|
separate table. |
248 |
|
|
249 |
|
2007-11-16 Sascha L. Teichmann <[email protected]> |
250 |
|
|
251 |
|
* tools/formed/formed/model/data.py, |
252 |
|
tools/formed/formed/plugins/web/view_renderer.py: |
253 |
|
Added an invisible flag for info fields. |
254 |
|
|
255 |
|
2007-11-07 Sascha L. Teichmann <[email protected]> |
256 |
|
|
257 |
|
* tools/formed/formed/model/nodecomponents.py: Fixed a few small bugs |
258 |
|
(calling a wrong method). |
259 |
|
|
260 |
|
2007-11-07 Sascha L. Teichmann <[email protected]> |
261 |
|
|
262 |
|
* tools/formed/formed/model/nodecomponents.py: Added a field |
263 |
|
'alternative' to all node components. This might be of help to |
264 |
|
match PDF imports where the descriptions do not match. |
265 |
|
|
266 |
|
2007-10-23 Frank Koormann <[email protected]> |
267 |
|
|
268 |
|
* tools/formed/formed/plugins/export/sql.py: New WHERE-Clause for views |
269 |
|
|
270 |
|
2007-10-23 Frank Koormann <[email protected]> |
271 |
|
|
272 |
|
* tools/formed/formed/plugins/export/sql.py: Set default |
273 |
|
value (-1) for choices and bools. |
274 |
|
|
275 |
|
2007-10-21 Frank Koormann <[email protected]> |
276 |
|
|
277 |
|
* tools/formed/formed/plugins/export/sql.py: Grant statements for |
278 |
|
descriptive tables added. |
279 |
|
(Table.getName): new |
280 |
|
|
281 |
|
2007-10-21 Frank Koormann <[email protected]> |
282 |
|
|
283 |
|
* tools/formed/formed/plugins/export/sql.py: "CREATE OR REPLACE" |
284 |
|
statements for views and roles to make updates easier. |
285 |
|
Add "admin_ka" membership as third option to VIEW_WHERE_CLAUSE. |
286 |
|
|
287 |
|
2007-10-19 Frank Koormann <[email protected]> |
288 |
|
|
289 |
|
* tools/formed/formed/plugins/export/sql.py: Added GRANT statements |
290 |
|
for views. The statements are prepared for variable substitution |
291 |
|
when executing the SQL-scripts by psql. |
292 |
|
|
293 |
|
2007-10-18 Sascha L. Teichmann <[email protected]> |
294 |
|
|
295 |
|
* pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Fixed: |
296 |
|
End of result XML was truncated because of an unflushed buffer. |
297 |
|
|
298 |
|
2007-10-17 Sascha L. Teichmann <[email protected]> |
299 |
|
|
300 |
|
* pdf2xfa/bin/build-jar.sh: New. Build production jar file. |
301 |
|
|
302 |
|
* pdf2xfa/README.TXT: Adjusted how to build production jar file |
303 |
|
and how to use it. |
304 |
|
|
305 |
|
* pdf2xfa/etc, pdf2xfa/etc/manifest.txt: New. Defines main class |
306 |
|
and iText dependency. |
307 |
|
|
308 |
|
2007-10-16 Sascha L. Teichmann <[email protected]> |
309 |
|
|
310 |
|
* tools/formed/formed/plugins/export/sql.py: Model 'Ja, Nein, Keine Angabe' |
311 |
|
are not modeled as BOOLEANs any more. That simpifies the conversion |
312 |
|
process web vs. db. |
313 |
|
|
314 |
|
2007-10-07 Sascha L. Teichmann <[email protected]> |
315 |
|
|
316 |
|
* tools/formed/formed/plugins/export/sql.py: Added the remaining |
317 |
|
UPDATE rules. |
318 |
|
|
319 |
|
2007-10-07 Sascha L. Teichmann <[email protected]> |
320 |
|
|
321 |
|
* tools/formed/formed/plugins/export/sql.py: Added UPDATE rules for some |
322 |
|
views. TODO: Test'em and implement the rest. |
323 |
|
|
324 |
2007-10-07 Sascha L. Teichmann <[email protected]> |
2007-10-07 Sascha L. Teichmann <[email protected]> |
325 |
|
|
326 |
* tools/formed/formed/plugins/export/sql.py: Bug fix. DELETE and INSERT |
* tools/formed/formed/plugins/export/sql.py: Bug fix. DELETE and INSERT |