Activity
From 10/30/2011 to 11/28/2011
11/28/2011
- 05:32 PM Revision 41: xml2db: Started refactoring xml2db() to support getting as well as inserting data
- 05:29 PM Revision 40: xml2db: Started refactoring xml2db() to support getting as well as inserting data
- 05:05 PM Revision 39: xml2db: Changed to return ID (pkey) of inserted record and use this returned value as parent_id instead of getting the parent_id from the parent XML node
- 03:16 PM Revision 38: data2xml: Added syntax for split paths, which map to multiple leaves
- 01:52 PM Revision 37: xml2db: Improved empty_db to use TRUNCATE instead of DROP DATABASE. Added xml2vegbank to automatically set db env vars.
- 01:51 PM Revision 36: data2xml: Improved syntax for XPath lookahead assertions. Changed XML printing to print multiple text nodes on separate lines.
- 12:15 PM Revision 35: Moved vegbank_example_ver1.0.2.xml to xml2db, where it should have been
11/23/2011
- 05:39 PM Task #286: CSV-XML-database mapping script
- I updated the data2xml script (demo at nimoy:/home/bien_shared/svn/scripts/data2xml/test) to support the pointer form...
- 05:37 PM Task #285: CSV to XML mappings for NYBG, SALVIAS
- I made a number of changes to the NYBG and SALVIAS mappings to support VegX's concept of pointers between objects.
- 05:22 PM Revision 34: data2xml: Small correction to NYBG mapping
- 04:58 PM Revision 33: data2xml: Created simplify_xpath script to remove duplication from XPath expressions
- 04:15 PM Revision 32: data2xml: Added support for * abbrs for backward (child-to-parent) pointers
- 02:52 PM Revision 31: In data2xml, fixed determination of which nesting level to put IDs on
- 02:45 PM Revision 30: Simplified expansion of * abbrs
- 02:23 PM Revision 29: Removed no longer necessary strip() from node value getter
- 02:22 PM Revision 28: Added patch for xml.dom.minidom.Element.writexml to avoid adding extra whitespace around text nodes
- 12:45 PM Revision 27: Added pointer field name abbreviations to data2xml and NYBG mappings
11/22/2011
- 04:35 PM Revision 26: In data2xml, fixed pointer handling to deal with pointer targets that are themselves pointers
- 04:01 PM Revision 25: In data2xml, added shortcut for lookahead assertion using ! symbol
- 02:32 PM Revision 24: In data2xml, fixed backward (child-to-parent) pointer handling to get and set attribute values properly
- 01:52 PM Revision 23: In data2xml, fixed xpath.get() to do last_only optimization properly for pointer targets
- 01:32 PM Revision 22: In data2xml, added support for XPath pointers
11/21/2011
- 05:48 PM Revision 21: Merged data2xml XPath functionality into xpath.py. Merged data2xml xml_dom.py and xml2db xml_util.py into identical xml_util.py for each script.
- 04:50 PM Revision 20: Added empty_db script to reset the vegbank database after running xml2db/test in commit mode
- 02:20 PM Task #287: XML to database conversion script (merged into CSV-XML-database mapping script)
- The script is on nimoy at @/home/bien_shared/svn/scripts/xml2db@. You can run the demo at @/home/bien_shared/svn/scri...
- 02:01 PM Revision 19: Changed xml2db and vegbank db to be owned by new user vegbank
11/18/2011
- 05:38 PM Revision 18: Changed xml2db and data2xml to help standardize mapping to different XML formats
- 02:48 PM Revision 17: Added DROP DATABASE and CREATE DATABASE to vegbank.sql
- 12:52 PM Revision 16: Changed xml2db to use primarily node contents to determine whether a node is a field or a child table
11/17/2011
- 04:42 PM Revision 15: Changed xml2db to use the first column in a table as its primary key
- 04:08 PM Revision 14: Changed xml2db to avoid inserting duplicate rows
- 03:31 PM Revision 13: Initial version of xml2db. Doesn't yet handle all duplicate rows correctly.
- 11:29 AM Revision 12: Removed .pyc files
- 10:29 AM Revision 11: Added BIEN 3 scripts
- 10:08 AM Task #287 (Resolved): XML to database conversion script (merged into CSV-XML-database mapping script)
- Python script to import an XML file into a PostgreSQL database
- 10:07 AM Task #286 (New): CSV-XML-database mapping script
- Python script to map CSV, XML, and database datasources to each other, using a map spreadsheet when needed
- 10:06 AM Task #285 (Resolved): CSV to XML mappings for NYBG, SALVIAS
- CSV spreadsheets mapping CSV file columns to XPath expressions for the NYBG and SALVIAS datasources
Also available in: Atom