| 1 |
|
2008-04-28 Sascha L. Teichmann <[email protected]> |
| 2 |
|
|
| 3 |
|
* tools/formed/formed/plugins/export/xsd.py: New. plug-in for |
| 4 |
|
exporting as XML schema. not ready, yet. |
| 5 |
|
|
| 6 |
|
* tools/formed/formed/config.py: Use new plug-in. |
| 7 |
|
|
| 8 |
|
* tools/formed/formed/plugins/export/sql.py: Fixed wrong GUI text. |
| 9 |
|
|
| 10 |
|
2008-04-17 Torsten Irländer <[email protected]> |
| 11 |
|
|
| 12 |
|
* tools/formed/formed/plugins/export/sql.py: Changed WHERE clause in |
| 13 |
|
for the views because of the new group permissions. |
| 14 |
|
|
| 15 |
|
2008-04-09 Sascha L. Teichmann <[email protected]> |
| 16 |
|
|
| 17 |
|
* tools/anonym/cron.deleteOldAnonymized.sh: New. cron job to delete |
| 18 |
|
old anonymized cases. |
| 19 |
|
|
| 20 |
|
2008-04-01 Sascha L. Teichmann <[email protected]> |
| 21 |
|
|
| 22 |
|
* tools/anonym/xmlexport.py: Removed "WHERE einverstaendniserklaerung = 1" |
| 23 |
|
from clause to select datasets. |
| 24 |
|
Replace ']]>' in CDATA sections with correct splitted replacement. |
| 25 |
|
|
| 26 |
|
2008-03-12 Sascha L. Teichmann <[email protected]> |
| 27 |
|
|
| 28 |
|
* tools/anonym/cron.importAnonXml.sh: Added absolut path to xmlimport |
| 29 |
|
script. |
| 30 |
|
|
| 31 |
|
* tools/anonym/xmlimport.py: commented out database port from |
| 32 |
|
connectionstring. |
| 33 |
|
|
| 34 |
|
2008-03-12 Sascha L. Teichmann <[email protected]> |
| 35 |
|
|
| 36 |
|
* tools/formed/formed/plugins/export/sql.py: Fixed bug in generation |
| 37 |
|
of anonymization of repeat groups (wrong id was given). |
| 38 |
|
|
| 39 |
|
2008-03-11 Sascha L. Teichmann <[email protected]> |
| 40 |
|
|
| 41 |
|
* tools/formed/formed/plugins/export/sql.py: Generate no update |
| 42 |
|
statements for relations which have no anonym functions applied. |
| 43 |
|
|
| 44 |
|
2008-03-11 Sascha L. Teichmann <[email protected]> |
| 45 |
|
|
| 46 |
|
* tools/formed/formed/plugins/export/sql.py: Added a newline after |
| 47 |
|
'COMMIT;' in the last line. |
| 48 |
|
|
| 49 |
|
2008-03-11 Sascha L. Teichmann <[email protected]> |
| 50 |
|
|
| 51 |
|
* tools/formed/formed/plugins/export/sql.py: Fixed syntax of |
| 52 |
|
generated anonymize_case() function. |
| 53 |
|
|
| 54 |
|
2008-03-11 Sascha L. Teichmann <[email protected]> |
| 55 |
|
|
| 56 |
|
* tools/formed/formed/plugins/export/sql.py: Added code to |
| 57 |
|
generate a plpgsql function anonymize_case() that anonymized |
| 58 |
|
a given case and all of its depending repeat groups. |
| 59 |
|
|
| 60 |
|
2008-03-06 Sascha L. Teichmann <[email protected]> |
| 61 |
|
|
| 62 |
|
* tools/anonym/xmlimport.py: remove print of insert statement. |
| 63 |
|
|
| 64 |
|
* tools/formed/formed/plugins/export/sql.py: Print generation date in ISO. |
| 65 |
|
|
| 66 |
|
2008-03-03 Torsten Irländer <[email protected]> |
| 67 |
|
|
| 68 |
|
* anonym/cron.sendAnonXml.sh, |
| 69 |
|
anonym/getDbList.sh: Modified script to be used directly in the |
| 70 |
|
production environment (Copied running scripts from production |
| 71 |
|
server) |
| 72 |
|
|
| 73 |
|
* cron.importAnonXml.sh: Added deleting of ols cases. Modified script |
| 74 |
|
to be used in a production environment (Cpoied running script from |
| 75 |
|
production server) |
| 76 |
|
|
| 77 |
|
* tools/anonym/xmlexport.py: Added "WHERE" clause to SQL-Statement to |
| 78 |
|
ensure that only valid cases get exported |
| 79 |
|
|
| 80 |
|
2008-02-27 Sascha L. Teichmann <[email protected]> |
| 81 |
|
|
| 82 |
|
* tools/anonym/xmlimport.py: Fixed bug in date converter. |
| 83 |
|
|
| 84 |
|
2008-02-27 Sascha L. Teichmann <[email protected]> |
| 85 |
|
|
| 86 |
|
* tools/anonym/xmlimport.py: Simpilied version |
| 87 |
|
|
| 88 |
|
2008-02-27 Sascha L. Teichmann <[email protected]> |
| 89 |
|
|
| 90 |
|
* tools/anonym/cron.importAnonXml.sh: Add sudo call for |
| 91 |
|
xmlimport.py and parameters. |
| 92 |
|
|
| 93 |
|
* tools/anonym/xmlimport.py: Various bug fixes. Not working yet. :-/ |
| 94 |
|
|
| 95 |
|
* tools/anonym/xmlexport.py: Use python interpreter without env |
| 96 |
|
because of sudo context. |
| 97 |
|
|
| 98 |
|
2008-02-26 Sascha L. Teichmann <[email protected]> |
| 99 |
|
|
| 100 |
|
* tools/anonym/xmlimport.py: added support for getopt. add |
| 101 |
|
support to force in fkz in import of case. |
| 102 |
|
|
| 103 |
|
2008-02-26 Sascha L. Teichmann <[email protected]> |
| 104 |
|
|
| 105 |
|
* tools/anonym/xmlimport.py: Implemented logic to create/update cases. |
| 106 |
|
|
| 107 |
|
* tools/anonym/html.awk: produces valid HTML. |
| 108 |
|
|
| 109 |
|
2008-02-25 Sascha L. Teichmann <[email protected]> |
| 110 |
|
|
| 111 |
|
* tools/anonym/joincsv.py: Fix a logic bug. |
| 112 |
|
|
| 113 |
|
2008-02-25 Torsten Irlaender <[email protected]> |
| 114 |
|
|
| 115 |
|
* tools/anonym/cron.importAnonXml.sh: Added shellscript for importing |
| 116 |
|
exportted cases. It will read all files from a directory and import |
| 117 |
|
the files into the DB. After that the script will cleanup the |
| 118 |
|
directory. |
| 119 |
|
|
| 120 |
|
2008-02-25 Torsten Irländer <[email protected]> |
| 121 |
|
|
| 122 |
|
* tools/anonym/cron.sendAnonXml.sh, |
| 123 |
|
tools/anonym/xmlexport.py, |
| 124 |
|
tools/anonym/getDbList.sh: Added shell-scripts for exporting cases |
| 125 |
|
|
| 126 |
|
2008-02-25 Sascha L. Teichmann <[email protected]> |
| 127 |
|
|
| 128 |
|
* tools/anonym/joincsv.py: Fixed typo which generated wrong number of cols. |
| 129 |
|
|
| 130 |
|
2008-02-25 Sascha L. Teichmann <[email protected]> |
| 131 |
|
|
| 132 |
|
* tools/anonym/joincsv.py: New. Joins CSV files. |
| 133 |
|
|
| 134 |
|
* tools/anonym/html.awk: New. Converts CSV to HTML |
| 135 |
|
|
| 136 |
|
2008-02-25 Sascha L. Teichmann <[email protected]> |
| 137 |
|
|
| 138 |
|
* tools/anonym/xmlimport.py: New. Added generation of |
| 139 |
|
update statements. |
| 140 |
|
|
| 141 |
|
2008-02-25 Sascha L. Teichmann <[email protected]> |
| 142 |
|
|
| 143 |
|
* tools/anonym/xmlimport.py: New. Base for importing |
| 144 |
|
XML from cron. |
| 145 |
|
|
| 146 |
|
2008-02-24 Sascha L. Teichmann <[email protected]> |
| 147 |
|
|
| 148 |
|
* tools/formed/formed/plugins/export/html2.py: New. plug-in |
| 149 |
|
for a simplified HTML output |
| 150 |
|
|
| 151 |
|
* tools/formed/formed/plugins/export/typemap.py: New. plug-in |
| 152 |
|
for dump schema as python dictionary. |
| 153 |
|
|
| 154 |
|
* tools/formed/formed/config.py: Enable new plug-ins. Out comment |
| 155 |
|
old stored procedure and view generators. |
| 156 |
|
|
| 157 |
|
2008-02-19 Sascha L. Teichmann <[email protected]> |
| 158 |
|
|
| 159 |
|
* tools/anonym/xmlexport.py: New. Export all cases in database |
| 160 |
|
as XML. |
| 161 |
|
|
| 162 |
|
2008-02-18 Sascha L. Teichmann <[email protected]> |
| 163 |
|
|
| 164 |
|
* tools/anonym/anoymncsv.py: separate field with '\t' now. |
| 165 |
|
all '\t's are replaced by ' ' before. '\r\n' are removed too. |
| 166 |
|
|
| 167 |
|
2008-02-15 Sascha L. Teichmann <[email protected]> |
| 168 |
|
|
| 169 |
|
* tools/anonym/anoymncsv.py: simple script to fetch anonymous |
| 170 |
|
data from database. |
| 171 |
|
|
| 172 |
|
2008-02-14 Sascha L. Teichmann <[email protected]> |
| 173 |
|
|
| 174 |
|
* tools/formed/formed/plugins/export/sql.py: Exchanged name |
| 175 |
|
erase_value with suppress_value/suppress_value2. |
| 176 |
|
|
| 177 |
|
2008-02-13 Sascha L. Teichmann <[email protected]> |
| 178 |
|
|
| 179 |
|
* tools/formed/formed/plugins/export/sql.py: output id, master_id |
| 180 |
|
substitute 'erase_value' with NULL value. |
| 181 |
|
|
| 182 |
|
2008-02-13 Sascha L. Teichmann <[email protected]> |
| 183 |
|
|
| 184 |
|
* tools/formed/formed/plugins/export/sql.py: output id, master_id |
| 185 |
|
and uuid_id in anonymiziation views too. |
| 186 |
|
|
| 187 |
|
2008-02-13 Sascha L. Teichmann <[email protected]> |
| 188 |
|
|
| 189 |
|
* tools/formed/formed/plugins/export/sql.py: Added generation |
| 190 |
|
of anonymiziation views for master table views and repeat group |
| 191 |
|
views. |
| 192 |
|
|
| 193 |
|
2008-02-13 Sascha L. Teichmann <[email protected]> |
| 194 |
|
|
| 195 |
|
* tools/formed/formed/model/nodecomponents.py: Added attribute |
| 196 |
|
"function" |
| 197 |
|
|
| 198 |
|
* tools/formed/formed/io/document.py: Save attributes in |
| 199 |
|
alphabetical order. |
| 200 |
|
|
| 201 |
|
2008-02-02 Sascha L. Teichmann <[email protected]> |
| 202 |
|
|
| 203 |
|
* tools/formed/formed/plugins/export/sql.py: Added update rule |
| 204 |
|
for master table and repeat groups views. Granted update right |
| 205 |
|
to :cm_ka_group. |
| 206 |
|
|
| 207 |
|
2008-02-01 Sascha L. Teichmann <[email protected]> |
| 208 |
|
|
| 209 |
|
* tools/formed/formed/plugins/export/sql.py: Added a column 'uuid_id' |
| 210 |
|
for master table and repeat groups. Also added unique constraints |
| 211 |
|
to these columns. |
| 212 |
|
|
| 213 |
|
2007-12-10 Sascha L. Teichmann <[email protected]> |
| 214 |
|
|
| 215 |
|
* pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Added a system |
| 216 |
|
property 'root.element' to specify the name of the XML root. |
| 217 |
|
|
| 218 |
|
* pdf2xfa/startup/pdf2xfa.sh, pdf2xfa/README.TXT: Adjusted. |
| 219 |
|
|
| 220 |
|
2007-11-22 Sascha L. Teichmann <[email protected]> |
| 221 |
|
|
| 222 |
|
* pdf2xfa/startup, */pdf2xfa.sh, */pdf2xfa.init: boot scripts |
| 223 |
|
for GNU/Linux (tested Debian 'Etch' 4.0) by Sascha Wilde. |
| 224 |
|
|
| 225 |
|
* pdf2xfa/README.TXT: Add a remark to new boot scripts. |
| 226 |
|
|
| 227 |
|
2007-11-21 Sascha L. Teichmann <[email protected]> |
| 228 |
|
|
| 229 |
|
* pdf2xfa/src/de/intevation/pdfimport/Log.java: New. |
| 230 |
|
Sends logging to file. |
| 231 |
|
|
| 232 |
|
* pdf2xfa/src/de/intevation/pdfimport/Server.java, |
| 233 |
|
pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Adjusted |
| 234 |
|
to use new logging. |
| 235 |
|
|
| 236 |
|
* pdf2xfa/README.TXT: Added remark how to use logging. |
| 237 |
|
|
| 238 |
|
2007-11-16 Frank Koormann <[email protected]> |
| 239 |
|
|
| 240 |
|
* tools/formed/formed/plugins/export/sql.py (createSchema): |
| 241 |
|
Append only column "bearbeiter_id", standins are modelled by a |
| 242 |
|
separate table. |
| 243 |
|
|
| 244 |
|
2007-11-16 Sascha L. Teichmann <[email protected]> |
| 245 |
|
|
| 246 |
|
* tools/formed/formed/model/data.py, |
| 247 |
|
tools/formed/formed/plugins/web/view_renderer.py: |
| 248 |
|
Added an invisible flag for info fields. |
| 249 |
|
|
| 250 |
|
2007-11-07 Sascha L. Teichmann <[email protected]> |
| 251 |
|
|
| 252 |
|
* tools/formed/formed/model/nodecomponents.py: Fixed a few small bugs |
| 253 |
|
(calling a wrong method). |
| 254 |
|
|
| 255 |
|
2007-11-07 Sascha L. Teichmann <[email protected]> |
| 256 |
|
|
| 257 |
|
* tools/formed/formed/model/nodecomponents.py: Added a field |
| 258 |
|
'alternative' to all node components. This might be of help to |
| 259 |
|
match PDF imports where the descriptions do not match. |
| 260 |
|
|
| 261 |
|
2007-10-23 Frank Koormann <[email protected]> |
| 262 |
|
|
| 263 |
|
* tools/formed/formed/plugins/export/sql.py: New WHERE-Clause for views |
| 264 |
|
|
| 265 |
|
2007-10-23 Frank Koormann <[email protected]> |
| 266 |
|
|
| 267 |
|
* tools/formed/formed/plugins/export/sql.py: Set default |
| 268 |
|
value (-1) for choices and bools. |
| 269 |
|
|
| 270 |
|
2007-10-21 Frank Koormann <[email protected]> |
| 271 |
|
|
| 272 |
|
* tools/formed/formed/plugins/export/sql.py: Grant statements for |
| 273 |
|
descriptive tables added. |
| 274 |
|
(Table.getName): new |
| 275 |
|
|
| 276 |
|
2007-10-21 Frank Koormann <[email protected]> |
| 277 |
|
|
| 278 |
|
* tools/formed/formed/plugins/export/sql.py: "CREATE OR REPLACE" |
| 279 |
|
statements for views and roles to make updates easier. |
| 280 |
|
Add "admin_ka" membership as third option to VIEW_WHERE_CLAUSE. |
| 281 |
|
|
| 282 |
|
2007-10-19 Frank Koormann <[email protected]> |
| 283 |
|
|
| 284 |
|
* tools/formed/formed/plugins/export/sql.py: Added GRANT statements |
| 285 |
|
for views. The statements are prepared for variable substitution |
| 286 |
|
when executing the SQL-scripts by psql. |
| 287 |
|
|
| 288 |
|
2007-10-18 Sascha L. Teichmann <[email protected]> |
| 289 |
|
|
| 290 |
|
* pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Fixed: |
| 291 |
|
End of result XML was truncated because of an unflushed buffer. |
| 292 |
|
|
| 293 |
|
2007-10-17 Sascha L. Teichmann <[email protected]> |
| 294 |
|
|
| 295 |
|
* pdf2xfa/bin/build-jar.sh: New. Build production jar file. |
| 296 |
|
|
| 297 |
|
* pdf2xfa/README.TXT: Adjusted how to build production jar file |
| 298 |
|
and how to use it. |
| 299 |
|
|
| 300 |
|
* pdf2xfa/etc, pdf2xfa/etc/manifest.txt: New. Defines main class |
| 301 |
|
and iText dependency. |
| 302 |
|
|
| 303 |
|
2007-10-16 Sascha L. Teichmann <[email protected]> |
| 304 |
|
|
| 305 |
|
* tools/formed/formed/plugins/export/sql.py: Model 'Ja, Nein, Keine Angabe' |
| 306 |
|
are not modeled as BOOLEANs any more. That simpifies the conversion |
| 307 |
|
process web vs. db. |
| 308 |
|
|
| 309 |
|
2007-10-07 Sascha L. Teichmann <[email protected]> |
| 310 |
|
|
| 311 |
|
* tools/formed/formed/plugins/export/sql.py: Added the remaining |
| 312 |
|
UPDATE rules. |
| 313 |
|
|
| 314 |
|
2007-10-07 Sascha L. Teichmann <[email protected]> |
| 315 |
|
|
| 316 |
|
* tools/formed/formed/plugins/export/sql.py: Added UPDATE rules for some |
| 317 |
|
views. TODO: Test'em and implement the rest. |
| 318 |
|
|
| 319 |
|
2007-10-07 Sascha L. Teichmann <[email protected]> |
| 320 |
|
|
| 321 |
|
* tools/formed/formed/plugins/export/sql.py: Bug fix. DELETE and INSERT |
| 322 |
|
rules referenced none existing views. |
| 323 |
|
|
| 324 |
|
2007-10-07 Sascha L. Teichmann <[email protected]> |
| 325 |
|
|
| 326 |
|
* tools/formed/formed/plugins/export/sql.py: Added DELETE and INSERT |
| 327 |
|
rules for views. TODO: add UPDATE rules. |
| 328 |
|
|
| 329 |
|
2007-10-07 Sascha L. Teichmann <[email protected]> |
| 330 |
|
|
| 331 |
|
* tools/formed/formed/plugins/export/old_sql.py: New. Contains |
| 332 |
|
the legacy SQL export filters. |
| 333 |
|
|
| 334 |
|
* tools/formed/formed/plugins/export/sql.py: Factored out the |
| 335 |
|
legacy SQL export filters to old_sql. |
| 336 |
|
|
| 337 |
|
* tools/formed/formed/config.py: Adjusted to fetch legacy |
| 338 |
|
filters from old_sql. |
| 339 |
|
|
| 340 |
|
2007-10-06 Sascha L. Teichmann <[email protected]> |
| 341 |
|
|
| 342 |
|
* pdf2xfa/**: Initial import of the PDF to XFA server. |
| 343 |
|
|
| 344 |
|
2007-10-06 Sascha L. Teichmann <[email protected]> |
| 345 |
|
|
| 346 |
|
* tools/formed/formed/plugins/export/sql.py: Fixed bug |
| 347 |
|
that made choices of three elements to booleans if |
| 348 |
|
they have other meanings than 'Ja', 'Nein', 'keine Angabe'. |
| 349 |
|
|
| 350 |
|
2007-10-05 Sascha L. Teichmann <[email protected]> |
| 351 |
|
|
| 352 |
|
* tools/formed/formed/plugins/export/sql.py: Select ids of |
| 353 |
|
underlaying tables in views too. |
| 354 |
|
|
| 355 |
|
2007-10-04 Sascha L. Teichmann <[email protected]> |
| 356 |
|
|
| 357 |
|
* tools/formed/formed/plugins/export/sql.py: Create schema inside transaction. |
| 358 |
|
Various bug fixes. |
| 359 |
|
|
| 360 |
|
2007-10-04 Sascha L. Teichmann <[email protected]> |
| 361 |
|
|
| 362 |
|
* tools/formed/formed/model/data.py: Added GroupNode.allWidgets() |
| 363 |
|
to extract fields from embedded repeat groups. |
| 364 |
|
|
| 365 |
|
* tools/formed/formed/plugins/export/sql.py: The SQL exporter exports |
| 366 |
|
views per page too. Result not tested yet. |
| 367 |
|
|
| 368 |
|
2007-10-01 Sascha L. Teichmann <[email protected]> |
| 369 |
|
|
| 370 |
|
* tools/formed/formed/plugins/web/view_renderer.py: Ignore |
| 371 |
|
in-page repeat groups while rendering pages. |
| 372 |
|
|
| 373 |
|
2007-10-01 Sascha L. Teichmann <[email protected]> |
| 374 |
|
|
| 375 |
|
* tools/formed/formed/model/nodecomponents.py: Added visitor |
| 376 |
|
traversals for document trees. |
| 377 |
|
|
| 378 |
|
* tools/formed/formed/model/data.py: Rewrote the |
| 379 |
|
Page.allWidgets() method to use new visitor for |
| 380 |
|
tree traversal. |
| 381 |
|
|
| 382 |
|
2007-09-27 Torsten Irlaender <[email protected]> |
| 383 |
|
|
| 384 |
|
* tools/formed/formed/plugins/names/filter.py: Pages are now included |
| 385 |
|
in the rename by formular name algorithm |
| 386 |
|
|
| 387 |
|
2007-09-26 Sascha L. Teichmann <[email protected]> |
| 388 |
|
|
| 389 |
|
* tools/formed/formed/model/data.py: Removed old {next|prev}Page() |
| 390 |
|
TODO: rewrite Page.allWidgets(). |
| 391 |
|
|
| 392 |
|
* tools/formed/formed/model/nodecomponents.py: Added a method |
| 393 |
|
Node.firstLevel(criterion) to walk a defined line in the tree. |
| 394 |
|
|
| 395 |
|
* tools/formed/formed/plugins/export/sql.py: Extract data suitable to |
| 396 |
|
build views and respective joins. |
| 397 |
|
|
| 398 |
|
2007-09-26 Sascha L. Teichmann <[email protected]> |
| 399 |
|
|
| 400 |
|
* tools/formed/formed/plugins/web/plugin.py: add 'web.tidy:' flag to |
| 401 |
|
FORMED environment variable. If set to true tidylib is used to |
| 402 |
|
filter HTML content to be W3C valid. To use this feature install |
| 403 |
|
uTidylib. |
| 404 |
|
|
| 405 |
|
* tools/formed/formed/plugins/web/server.py: Check if MIME type is |
| 406 |
|
text/html and filters content through tidy if requested. |
| 407 |
|
|
| 408 |
|
2007-09-25 Torsten Irlaender <[email protected]> |
| 409 |
|
|
| 410 |
|
* tools/formed/formed/plugins/web/view_renderer.py: Small fix and |
| 411 |
|
cleanup of the form generation code. |
| 412 |
|
|
| 413 |
|
2007-09-21 Sascha L. Teichmann <[email protected]> |
| 414 |
|
|
| 415 |
|
* tools/formed/formed/plugins/export/sql.py: Added generation time |
| 416 |
|
and DROP TABLE statements to schema export. |
| 417 |
|
|
| 418 |
|
2007-09-20 Sascha L. Teichmann <[email protected]> |
| 419 |
|
|
| 420 |
|
* tools/formed/formed/plugins/export/sql.py: The tables are generated |
| 421 |
|
in correct topolocial order now. |
| 422 |
|
|
| 423 |
2007-09-20 Sascha L. Teichmann <[email protected]> |
2007-09-20 Sascha L. Teichmann <[email protected]> |
| 424 |
|
|
| 425 |
* tools/formed/formed/plugins/export/mode.py: New. Filter to export |
* tools/formed/formed/plugins/export/mode.py: New. Filter to export |
Parent Directory
| 
Revision Log
| 
Patch