Project

General

Profile

Statistics
| Revision:

# Date Author Comment
57 11/29/2011 05:33 PM Aaron Marcuse-Kubitza

map: Added more stubs for XML-XML mapping

56 11/29/2011 05:15 PM Aaron Marcuse-Kubitza

Started adding XML-XML mapping support to map

55 11/29/2011 04:43 PM Aaron Marcuse-Kubitza

Split off xpath.py XML functionality into xml_xpath.py

54 11/29/2011 04:28 PM Aaron Marcuse-Kubitza

map: Using SystemExit for usage errors to avoid stack trace

53 11/29/2011 04:22 PM Aaron Marcuse-Kubitza

Merged data2xml and xml2db into map

52 11/29/2011 03:03 PM Aaron Marcuse-Kubitza

Removed trailing whitespace from VegX-VegBank.csv map

51 11/29/2011 02:59 PM Aaron Marcuse-Kubitza

Created join_maps to join two 2-column map spreadsheets

50 11/29/2011 02:11 PM Aaron Marcuse-Kubitza

Renamed mappings to be compatible with Redmine allowed characters in attachment filenames

49 11/29/2011 01:59 PM Aaron Marcuse-Kubitza

Added refactored mappings and changed data2xml to use the new 2-column format

48 11/29/2011 01:25 PM Aaron Marcuse-Kubitza

Refactored db_xml.py's db insertion function to avoid extra nested functions

47 11/29/2011 01:06 PM Aaron Marcuse-Kubitza

Added README.TXT

46 11/29/2011 01:02 PM Aaron Marcuse-Kubitza

Renamed modules to remove _util

45 11/29/2011 12:47 PM Aaron Marcuse-Kubitza

Added svn:ignore for *.pyc

44 11/29/2011 12:42 PM Aaron Marcuse-Kubitza

Renamed xml2db_ and data2xml_ to remove _

43 11/29/2011 12:42 PM Aaron Marcuse-Kubitza

Moved scripts to main directory and associated files to util

42 11/29/2011 12:31 PM Aaron Marcuse-Kubitza

Moved Python modules to shared lib folder

41 11/28/2011 05:32 PM Aaron Marcuse-Kubitza

xml2db: Started refactoring xml2db() to support getting as well as inserting data

40 11/28/2011 05:29 PM Aaron Marcuse-Kubitza

xml2db: Started refactoring xml2db() to support getting as well as inserting data

39 11/28/2011 05:05 PM Aaron Marcuse-Kubitza

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

38 11/28/2011 03:16 PM Aaron Marcuse-Kubitza

data2xml: Added syntax for split paths, which map to multiple leaves

37 11/28/2011 01:52 PM Aaron Marcuse-Kubitza

xml2db: Improved empty_db to use TRUNCATE instead of DROP DATABASE. Added xml2vegbank to automatically set db env vars.

36 11/28/2011 01:51 PM Aaron Marcuse-Kubitza

data2xml: Improved syntax for XPath lookahead assertions. Changed XML printing to print multiple text nodes on separate lines.

35 11/28/2011 12:15 PM Aaron Marcuse-Kubitza

Moved vegbank_example_ver1.0.2.xml to xml2db, where it should have been

34 11/23/2011 05:22 PM Aaron Marcuse-Kubitza

data2xml: Small correction to NYBG mapping

33 11/23/2011 04:58 PM Aaron Marcuse-Kubitza

data2xml: Created simplify_xpath script to remove duplication from XPath expressions

32 11/23/2011 04:15 PM Aaron Marcuse-Kubitza

data2xml: Added support for * abbrs for backward (child-to-parent) pointers

31 11/23/2011 02:52 PM Aaron Marcuse-Kubitza

In data2xml, fixed determination of which nesting level to put IDs on

30 11/23/2011 02:45 PM Aaron Marcuse-Kubitza

Simplified expansion of * abbrs

29 11/23/2011 02:23 PM Aaron Marcuse-Kubitza

Removed no longer necessary strip() from node value getter

28 11/23/2011 02:22 PM Aaron Marcuse-Kubitza

Added patch for xml.dom.minidom.Element.writexml to avoid adding extra whitespace around text nodes

27 11/23/2011 12:45 PM Aaron Marcuse-Kubitza

Added pointer field name abbreviations to data2xml and NYBG mappings

26 11/22/2011 04:35 PM Aaron Marcuse-Kubitza

In data2xml, fixed pointer handling to deal with pointer targets that are themselves pointers

25 11/22/2011 04:01 PM Aaron Marcuse-Kubitza

In data2xml, added shortcut for lookahead assertion using ! symbol

24 11/22/2011 02:32 PM Aaron Marcuse-Kubitza

In data2xml, fixed backward (child-to-parent) pointer handling to get and set attribute values properly

23 11/22/2011 01:52 PM Aaron Marcuse-Kubitza

In data2xml, fixed xpath.get() to do last_only optimization properly for pointer targets

22 11/22/2011 01:32 PM Aaron Marcuse-Kubitza

In data2xml, added support for XPath pointers

21 11/21/2011 05:48 PM Aaron Marcuse-Kubitza

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.

20 11/21/2011 04:50 PM Aaron Marcuse-Kubitza

Added empty_db script to reset the vegbank database after running xml2db/test in commit mode

19 11/21/2011 02:01 PM Aaron Marcuse-Kubitza

Changed xml2db and vegbank db to be owned by new user vegbank

18 11/18/2011 05:38 PM Aaron Marcuse-Kubitza

Changed xml2db and data2xml to help standardize mapping to different XML formats

17 11/18/2011 02:48 PM Aaron Marcuse-Kubitza

Added DROP DATABASE and CREATE DATABASE to vegbank.sql

16 11/18/2011 12:52 PM Aaron Marcuse-Kubitza

Changed xml2db to use primarily node contents to determine whether a node is a field or a child table

15 11/17/2011 04:42 PM Aaron Marcuse-Kubitza

Changed xml2db to use the first column in a table as its primary key

14 11/17/2011 04:08 PM Aaron Marcuse-Kubitza

Changed xml2db to avoid inserting duplicate rows

13 11/17/2011 03:31 PM Aaron Marcuse-Kubitza

Initial version of xml2db. Doesn't yet handle all duplicate rows correctly.

12 11/17/2011 11:29 AM Aaron Marcuse-Kubitza

Removed .pyc files

11 11/17/2011 10:29 AM Aaron Marcuse-Kubitza

Added BIEN 3 scripts

10 12/09/2010 01:35 PM Matt Wheeler

Added ability to change the vegx node names to be different from the postgres table names.
This was the easiest way to change the postgres table names when the vegx names are
not useable for some reason. This requires that the node names be altered in the xsd...

9 12/09/2010 01:21 PM Matt Wheeler

Adding scripts to transfer data between BIEN2 to VegX schema.
Bug fixes to models.py

8 10/14/2010 12:16 PM Matt Wheeler

Some bug fixes.
Slight hack in eml-coverage and veg.xsd to get around Django case-insensitivity & VegX entities that only differ by case.
Changed default db relationship to one2many from many2many

7 10/14/2010 11:21 AM Matt Wheeler

Committing first working copy of models.py. Other py/pyc files are added/modified just to get in repos.

6 10/07/2010 01:44 PM Matt Wheeler

Adding vegx definition. Current models.py building script.

5 07/28/2010 10:48 AM Matt Wheeler

Initial import of Django version of BIEN

4 07/28/2010 10:38 AM Matt Wheeler

Removing needless files.

3 07/28/2010 10:33 AM Matt Wheeler

Inital import for script that converts vegx files into django objects.

2 06/10/2010 01:51 PM Matt Wheeler

No longer need concept hash since values are now pulled directly from tapir service

1 06/10/2010 01:47 PM Matt Wheeler

First Import