--- trunk/ChangeLog 2007/09/17 14:52:49 184 +++ trunk/ChangeLog 2008/04/29 14:22:25 268 @@ -1,3 +1,504 @@ +2008-04-29 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Use substitution group + to allow arbitrary order of repeat groups. + +2008-04-29 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Removed a needless + character. + +2008-04-29 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Added annotations + to fields. + +2008-04-29 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Added for + choice fields. + +2008-04-29 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Added support for + boolean fields based on enumerations. + +2008-04-28 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Added support for + date, text and textarea fields. + +2008-04-28 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: Added support for + repeat groups and integer fields. + +2008-04-28 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/xsd.py: New. plug-in for + exporting as XML schema. not ready, yet. + + * tools/formed/formed/config.py: Use new plug-in. + + * tools/formed/formed/plugins/export/sql.py: Fixed wrong GUI text. + +2008-04-17 Torsten Irländer + + * tools/formed/formed/plugins/export/sql.py: Changed WHERE clause in + for the views because of the new group permissions. + +2008-04-09 Sascha L. Teichmann + + * tools/anonym/cron.deleteOldAnonymized.sh: New. cron job to delete + old anonymized cases. + +2008-04-01 Sascha L. Teichmann + + * tools/anonym/xmlexport.py: Removed "WHERE einverstaendniserklaerung = 1" + from clause to select datasets. + Replace ']]>' in CDATA sections with correct splitted replacement. + +2008-03-12 Sascha L. Teichmann + + * tools/anonym/cron.importAnonXml.sh: Added absolut path to xmlimport + script. + + * tools/anonym/xmlimport.py: commented out database port from + connectionstring. + +2008-03-12 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Fixed bug in generation + of anonymization of repeat groups (wrong id was given). + +2008-03-11 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Generate no update + statements for relations which have no anonym functions applied. + +2008-03-11 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added a newline after + 'COMMIT;' in the last line. + +2008-03-11 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Fixed syntax of + generated anonymize_case() function. + +2008-03-11 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added code to + generate a plpgsql function anonymize_case() that anonymized + a given case and all of its depending repeat groups. + +2008-03-06 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: remove print of insert statement. + + * tools/formed/formed/plugins/export/sql.py: Print generation date in ISO. + +2008-03-03 Torsten Irländer + + * anonym/cron.sendAnonXml.sh, + anonym/getDbList.sh: Modified script to be used directly in the + production environment (Copied running scripts from production + server) + + * cron.importAnonXml.sh: Added deleting of ols cases. Modified script + to be used in a production environment (Cpoied running script from + production server) + + * tools/anonym/xmlexport.py: Added "WHERE" clause to SQL-Statement to + ensure that only valid cases get exported + +2008-02-27 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: Fixed bug in date converter. + +2008-02-27 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: Simpilied version + +2008-02-27 Sascha L. Teichmann + + * tools/anonym/cron.importAnonXml.sh: Add sudo call for + xmlimport.py and parameters. + + * tools/anonym/xmlimport.py: Various bug fixes. Not working yet. :-/ + + * tools/anonym/xmlexport.py: Use python interpreter without env + because of sudo context. + +2008-02-26 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: added support for getopt. add + support to force in fkz in import of case. + +2008-02-26 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: Implemented logic to create/update cases. + + * tools/anonym/html.awk: produces valid HTML. + +2008-02-25 Sascha L. Teichmann + + * tools/anonym/joincsv.py: Fix a logic bug. + +2008-02-25 Torsten Irlaender + + * tools/anonym/cron.importAnonXml.sh: Added shellscript for importing + exportted cases. It will read all files from a directory and import + the files into the DB. After that the script will cleanup the + directory. + +2008-02-25 Torsten Irländer + + * tools/anonym/cron.sendAnonXml.sh, + tools/anonym/xmlexport.py, + tools/anonym/getDbList.sh: Added shell-scripts for exporting cases + +2008-02-25 Sascha L. Teichmann + + * tools/anonym/joincsv.py: Fixed typo which generated wrong number of cols. + +2008-02-25 Sascha L. Teichmann + + * tools/anonym/joincsv.py: New. Joins CSV files. + + * tools/anonym/html.awk: New. Converts CSV to HTML + +2008-02-25 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: New. Added generation of + update statements. + +2008-02-25 Sascha L. Teichmann + + * tools/anonym/xmlimport.py: New. Base for importing + XML from cron. + +2008-02-24 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/html2.py: New. plug-in + for a simplified HTML output + + * tools/formed/formed/plugins/export/typemap.py: New. plug-in + for dump schema as python dictionary. + + * tools/formed/formed/config.py: Enable new plug-ins. Out comment + old stored procedure and view generators. + +2008-02-19 Sascha L. Teichmann + + * tools/anonym/xmlexport.py: New. Export all cases in database + as XML. + +2008-02-18 Sascha L. Teichmann + + * tools/anonym/anoymncsv.py: separate field with '\t' now. + all '\t's are replaced by ' ' before. '\r\n' are removed too. + +2008-02-15 Sascha L. Teichmann + + * tools/anonym/anoymncsv.py: simple script to fetch anonymous + data from database. + +2008-02-14 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Exchanged name + erase_value with suppress_value/suppress_value2. + +2008-02-13 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: output id, master_id + substitute 'erase_value' with NULL value. + +2008-02-13 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: output id, master_id + and uuid_id in anonymiziation views too. + +2008-02-13 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added generation + of anonymiziation views for master table views and repeat group + views. + +2008-02-13 Sascha L. Teichmann + + * tools/formed/formed/model/nodecomponents.py: Added attribute + "function" + + * tools/formed/formed/io/document.py: Save attributes in + alphabetical order. + +2008-02-02 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added update rule + for master table and repeat groups views. Granted update right + to :cm_ka_group. + +2008-02-01 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added a column 'uuid_id' + for master table and repeat groups. Also added unique constraints + to these columns. + +2007-12-10 Sascha L. Teichmann + + * pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Added a system + property 'root.element' to specify the name of the XML root. + + * pdf2xfa/startup/pdf2xfa.sh, pdf2xfa/README.TXT: Adjusted. + +2007-11-22 Sascha L. Teichmann + + * pdf2xfa/startup, */pdf2xfa.sh, */pdf2xfa.init: boot scripts + for GNU/Linux (tested Debian 'Etch' 4.0) by Sascha Wilde. + + * pdf2xfa/README.TXT: Add a remark to new boot scripts. + +2007-11-21 Sascha L. Teichmann + + * pdf2xfa/src/de/intevation/pdfimport/Log.java: New. + Sends logging to file. + + * pdf2xfa/src/de/intevation/pdfimport/Server.java, + pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Adjusted + to use new logging. + + * pdf2xfa/README.TXT: Added remark how to use logging. + +2007-11-16 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py (createSchema): + Append only column "bearbeiter_id", standins are modelled by a + separate table. + +2007-11-16 Sascha L. Teichmann + + * tools/formed/formed/model/data.py, + tools/formed/formed/plugins/web/view_renderer.py: + Added an invisible flag for info fields. + +2007-11-07 Sascha L. Teichmann + + * tools/formed/formed/model/nodecomponents.py: Fixed a few small bugs + (calling a wrong method). + +2007-11-07 Sascha L. Teichmann + + * tools/formed/formed/model/nodecomponents.py: Added a field + 'alternative' to all node components. This might be of help to + match PDF imports where the descriptions do not match. + +2007-10-23 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py: New WHERE-Clause for views + +2007-10-23 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py: Set default + value (-1) for choices and bools. + +2007-10-21 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py: Grant statements for + descriptive tables added. + (Table.getName): new + +2007-10-21 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py: "CREATE OR REPLACE" + statements for views and roles to make updates easier. + Add "admin_ka" membership as third option to VIEW_WHERE_CLAUSE. + +2007-10-19 Frank Koormann + + * tools/formed/formed/plugins/export/sql.py: Added GRANT statements + for views. The statements are prepared for variable substitution + when executing the SQL-scripts by psql. + +2007-10-18 Sascha L. Teichmann + + * pdf2xfa/src/de/intevation/pdfimport/ClientHandler.java: Fixed: + End of result XML was truncated because of an unflushed buffer. + +2007-10-17 Sascha L. Teichmann + + * pdf2xfa/bin/build-jar.sh: New. Build production jar file. + + * pdf2xfa/README.TXT: Adjusted how to build production jar file + and how to use it. + + * pdf2xfa/etc, pdf2xfa/etc/manifest.txt: New. Defines main class + and iText dependency. + +2007-10-16 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Model 'Ja, Nein, Keine Angabe' + are not modeled as BOOLEANs any more. That simpifies the conversion + process web vs. db. + +2007-10-07 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added the remaining + UPDATE rules. + +2007-10-07 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added UPDATE rules for some + views. TODO: Test'em and implement the rest. + +2007-10-07 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Bug fix. DELETE and INSERT + rules referenced none existing views. + +2007-10-07 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added DELETE and INSERT + rules for views. TODO: add UPDATE rules. + +2007-10-07 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/old_sql.py: New. Contains + the legacy SQL export filters. + + * tools/formed/formed/plugins/export/sql.py: Factored out the + legacy SQL export filters to old_sql. + + * tools/formed/formed/config.py: Adjusted to fetch legacy + filters from old_sql. + +2007-10-06 Sascha L. Teichmann + + * pdf2xfa/**: Initial import of the PDF to XFA server. + +2007-10-06 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Fixed bug + that made choices of three elements to booleans if + they have other meanings than 'Ja', 'Nein', 'keine Angabe'. + +2007-10-05 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Select ids of + underlaying tables in views too. + +2007-10-04 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Create schema inside transaction. + Various bug fixes. + +2007-10-04 Sascha L. Teichmann + + * tools/formed/formed/model/data.py: Added GroupNode.allWidgets() + to extract fields from embedded repeat groups. + + * tools/formed/formed/plugins/export/sql.py: The SQL exporter exports + views per page too. Result not tested yet. + +2007-10-01 Sascha L. Teichmann + + * tools/formed/formed/plugins/web/view_renderer.py: Ignore + in-page repeat groups while rendering pages. + +2007-10-01 Sascha L. Teichmann + + * tools/formed/formed/model/nodecomponents.py: Added visitor + traversals for document trees. + + * tools/formed/formed/model/data.py: Rewrote the + Page.allWidgets() method to use new visitor for + tree traversal. + +2007-09-27 Torsten Irlaender + + * tools/formed/formed/plugins/names/filter.py: Pages are now included + in the rename by formular name algorithm + +2007-09-26 Sascha L. Teichmann + + * tools/formed/formed/model/data.py: Removed old {next|prev}Page() + TODO: rewrite Page.allWidgets(). + + * tools/formed/formed/model/nodecomponents.py: Added a method + Node.firstLevel(criterion) to walk a defined line in the tree. + + * tools/formed/formed/plugins/export/sql.py: Extract data suitable to + build views and respective joins. + +2007-09-26 Sascha L. Teichmann + + * tools/formed/formed/plugins/web/plugin.py: add 'web.tidy:' flag to + FORMED environment variable. If set to true tidylib is used to + filter HTML content to be W3C valid. To use this feature install + uTidylib. + + * tools/formed/formed/plugins/web/server.py: Check if MIME type is + text/html and filters content through tidy if requested. + +2007-09-25 Torsten Irlaender + + * tools/formed/formed/plugins/web/view_renderer.py: Small fix and + cleanup of the form generation code. + +2007-09-21 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: Added generation time + and DROP TABLE statements to schema export. + +2007-09-20 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/sql.py: The tables are generated + in correct topolocial order now. + +2007-09-20 Sascha L. Teichmann + + * tools/formed/formed/plugins/export/mode.py: New. Filter to export + a document with items that are in given mode. + + * tools/formed/formed/model/nodecomponents.py: Added methods to clone + trees depending on selected modes. + + * tools/formed/formed/model/data.py, tools/formed/formed/model/expr.py: + Fixed clone issue with RuleNodes. + + * tools/formed/formed/config.py: Use new plug-in. + +2007-09-17 Sascha L. Teichmann + + * tools/formed/formed/plugins/web/view_renderer.py: Make the + view renderer a real view renderer. It takes a list of + items now and not only a single page. + + * tools/formed/formed/plugins/web/renderer.py: Feed a list + of items to the view renderer. + +2007-09-17 Torsten Irlaender + + * tools/formed/formed/plugins/web/view_renderer.py: + Small tweaks in rendering bools. + RadioNodes (with all its children) can now be placed in a container. + The radiobools will not get a surrounding
anymore. + I am not sure if the new way results in the wanted behaivor, but the + rendering results are much better now :) + Maybe we need a similar approach for checkboxes? + Rendering groups is still broken in some way. + +2007-09-17 Sascha L. Teichmann + + * tools/formed/formed/plugins/web/view_renderer.py: Fixed + a few bugs: Do not render empty containers, do not + generate misplaced
in choices. + Add a nameless container to catch the items that are + nor explicitly assigned to a target. Removed FormData. + + * tools/formed/formed/plugins/web/renderer.py: Removed + a needless import + 2007-09-17 Sascha L. Teichmann * tools/formed/formed/plugins/web/view_renderer.py: Implemented