Project

General

Profile

Statistics
| Revision:

# Date Author Comment
171 12/15/2011 11:31 AM Aaron Marcuse-Kubitza

xpath.py: Changed backward (child-to-parent) pointer ID abbr expansion to happen in get() when source node's tag name is known. This deals with XPath elements that are '.' being used as a pointer source.

170 12/14/2011 05:31 PM Aaron Marcuse-Kubitza

xpath.py: Moved abbr expansion code to separate function

169 12/14/2011 04:41 PM Aaron Marcuse-Kubitza

test/map: Process all tables for a given DB (.sh) input

168 12/14/2011 03:26 PM Aaron Marcuse-Kubitza

Removed /'s from DB input mappings

167 12/14/2011 01:46 PM Aaron Marcuse-Kubitza

map: Use row's index instead of pkey as ID in XML output

166 12/14/2011 01:45 PM Aaron Marcuse-Kubitza

test/map: Compare via-VegX output to direct output

165 12/14/2011 01:13 PM Aaron Marcuse-Kubitza

xpath.py: Changed order that main and other branches are processed in so it is consistent with the order the branches are specified in the XPath

164 12/14/2011 12:03 PM Aaron Marcuse-Kubitza

map: Handle metadata in order with regular mappings

163 12/14/2011 11:33 AM Aaron Marcuse-Kubitza

Accepted VegBank test output for new CSV mapping order

162 12/14/2011 11:26 AM Aaron Marcuse-Kubitza

map: Changed CSV input to process mappings in the order they are in the spreadsheet, rather than the order of the CSV columns

161 12/13/2011 05:18 PM Aaron Marcuse-Kubitza

map: Added support for XML input

160 12/13/2011 05:17 PM Aaron Marcuse-Kubitza

Accepted new test output for sorted SALVIAS_db-VegBank mapping

159 12/13/2011 05:07 PM Aaron Marcuse-Kubitza

mappings to VegBank: Sorted by output column to help VegX-VegBank conversion put elements in the same order as source-VegBank

158 12/13/2011 04:57 PM Aaron Marcuse-Kubitza

join_all_vegbank: Updated to sort output maps

157 12/13/2011 04:57 PM Aaron Marcuse-Kubitza

Added script to sort a spreadsheet

156 12/13/2011 03:51 PM Aaron Marcuse-Kubitza

xpath.py: Allowed empty names in XPaths

155 12/13/2011 03:48 PM Aaron Marcuse-Kubitza

xpath.py: Added automatic conversion of strings to paths where needed.

154 12/13/2011 03:00 PM Aaron Marcuse-Kubitza

xpath.py: Added caching of parsed XPaths. Added automatic conversion of strings to paths where needed.

153 12/13/2011 02:59 PM Aaron Marcuse-Kubitza

Added str() method to XML nodes

152 12/13/2011 02:58 PM Aaron Marcuse-Kubitza

Fixed VegX-VegBank mapping syntax error

151 12/13/2011 02:17 PM Aaron Marcuse-Kubitza

Added faded beginning of string in Parser syntax errors

150 12/13/2011 02:01 PM Aaron Marcuse-Kubitza

Updated mappings Makefile

149 12/13/2011 02:00 PM Aaron Marcuse-Kubitza

Added Makefiles for scripts and test

148 12/13/2011 01:54 PM Aaron Marcuse-Kubitza

Added mappings Makefile

147 12/13/2011 12:28 PM Aaron Marcuse-Kubitza

Added human-readable SALVIAS_db mappings

146 12/13/2011 12:28 PM Aaron Marcuse-Kubitza

db_xml.get(): Pass limit through to SQL query

145 12/13/2011 11:48 AM Aaron Marcuse-Kubitza

Regenerated human-readable mappings

144 12/12/2011 05:39 PM Aaron Marcuse-Kubitza

Fixed documentation for xml_funcs

143 12/12/2011 05:38 PM Aaron Marcuse-Kubitza

Refactored xml_dom.set_value() to avoid needing a doc parameter for the XML document

142 12/12/2011 05:35 PM Aaron Marcuse-Kubitza

xpath.py: Refactored xml_func.py to avoid needing a doc parameter for the XML document

141 12/12/2011 05:30 PM Aaron Marcuse-Kubitza

xpath.py: Refactored to avoid needing a doc parameter for the XML document

140 12/12/2011 04:41 PM Aaron Marcuse-Kubitza

Fixed DB input to ignore NULL values

139 12/12/2011 04:27 PM Aaron Marcuse-Kubitza

xml_dom.py: Changed all uses of name_of(node) to node.tagName

138 12/12/2011 04:23 PM Aaron Marcuse-Kubitza

Made XML node names case-sensitive

137 12/12/2011 04:20 PM Aaron Marcuse-Kubitza

mappings to VegBank: Fixed incorrect mappings found after disabling heuristic search for missing fields

136 12/12/2011 03:49 PM Aaron Marcuse-Kubitza

test/map: Ignore diff exit status

135 12/12/2011 03:34 PM Aaron Marcuse-Kubitza

map: Implemented DB input support for querying a single table

134 12/09/2011 05:36 PM Aaron Marcuse-Kubitza

Added SALVIAS_db test accepted output

133 12/09/2011 05:35 PM Aaron Marcuse-Kubitza

map: Continued to add DB input support

132 12/09/2011 04:54 PM Aaron Marcuse-Kubitza

test/map: Echo command used to import db config

131 12/09/2011 04:02 PM Aaron Marcuse-Kubitza

Added support for multiple database engines. Changed SALVIAS_db input to use user-entered password.

130 12/09/2011 01:58 PM Aaron Marcuse-Kubitza

map: Allow db config vars to be optional. SALVIAS_db test: Changed to use salvias_plots and XPath mapping syntax.

129 12/09/2011 01:32 PM Aaron Marcuse-Kubitza

Renamed SALVIAS_db test input to use organisms table

128 12/09/2011 01:29 PM Aaron Marcuse-Kubitza

Re-committed accepted_outputs

127 12/09/2011 01:23 PM Aaron Marcuse-Kubitza

Renamed test/map output to remove CSV/DB indicator because that is now specified in the datasource name

126 12/09/2011 01:18 PM Aaron Marcuse-Kubitza

map: Started adding database get by XPath functionality

125 12/08/2011 06:48 PM Aaron Marcuse-Kubitza

format_for_review: Fixed bug where Comments column would be reformatted in addition to mappings columns

124 12/08/2011 05:35 PM Aaron Marcuse-Kubitza

Regenerated human-readable mappings

123 12/08/2011 05:15 PM Aaron Marcuse-Kubitza

Added human-readable versions of mappings and scripts to generate them

122 12/08/2011 05:14 PM Aaron Marcuse-Kubitza

VegX-VegBank mapping: Removed a duplicated mapping

121 12/08/2011 05:13 PM Aaron Marcuse-Kubitza

NYBG-VegX mapping: Added conference call feedback

120 12/08/2011 01:48 PM Aaron Marcuse-Kubitza

Added Comments column with Brad's and Aaron's comments to mapping spreadsheets

119 12/07/2011 05:01 PM Aaron Marcuse-Kubitza

Added stub for SALVIAS database test

118 12/07/2011 05:00 PM Aaron Marcuse-Kubitza

test/map: Added support for database input

117 12/07/2011 04:14 PM Aaron Marcuse-Kubitza

Preparing map to input from DB

116 12/07/2011 03:32 PM Aaron Marcuse-Kubitza

Started preparing map to input from DB

115 12/07/2011 01:27 PM Aaron Marcuse-Kubitza

xml_func.py: Added optimization to first check if function name starts with _ before looking it up in the table

114 12/07/2011 12:24 PM Aaron Marcuse-Kubitza

Added _alt functions for mappings to VegBank authorPlotCode

113 12/07/2011 12:17 PM Aaron Marcuse-Kubitza

xml_func.py: Added _alt function to choose between alternative values and used it for the collector plantName mapping

112 12/07/2011 11:54 AM Aaron Marcuse-Kubitza

VegX-VegBank mapping: Added mapping from taxonName/Simple (NYBG ScientificName) to collector plantName so that collector plantName will always have a value

111 12/07/2011 11:27 AM Aaron Marcuse-Kubitza

xml_func.py: Added support for decimal years (with day as the fraction)

110 12/07/2011 11:16 AM Aaron Marcuse-Kubitza

test/map: Added echoing of commands run

109 12/06/2011 04:19 PM Aaron Marcuse-Kubitza

Added psql_vegbank to easily access vegbank db from the command line

108 12/06/2011 04:07 PM Aaron Marcuse-Kubitza

Ignore OpenOffice lock files in mappings

107 12/06/2011 04:05 PM Aaron Marcuse-Kubitza

Added SALVIAS data CSVs and accepted test output

106 12/06/2011 03:52 PM Aaron Marcuse-Kubitza

test/map: Expanded to include all input CSVs in test/input

105 12/06/2011 03:31 PM Aaron Marcuse-Kubitza

Removed unneeded joins dir

104 12/06/2011 03:30 PM Aaron Marcuse-Kubitza

Moved VegBank mapping joins to main mappings dir so they would have similar paths for the upcoming all-sources tester

103 12/06/2011 03:11 PM Aaron Marcuse-Kubitza

Moved test scripts and files from util to test

102 12/06/2011 02:50 PM Aaron Marcuse-Kubitza

xml_func.py: Added _namepart function for extracting parts of names

101 12/06/2011 02:11 PM Aaron Marcuse-Kubitza

Finished NYBG mapping to VegBank\!

100 12/06/2011 02:04 PM Aaron Marcuse-Kubitza

test_map: Added debug option to print VegBank XML instead of importing it into the database

99 12/06/2011 01:34 PM Aaron Marcuse-Kubitza

xpath.py: Created is_positive() function

98 12/06/2011 01:28 PM Aaron Marcuse-Kubitza

Further refinements to mappings to support database constraints

97 12/06/2011 01:27 PM Aaron Marcuse-Kubitza

xpath.py: Added support for negative attribute assertions with !

96 12/06/2011 10:54 AM Aaron Marcuse-Kubitza

Changed mappings to use keys vs. attrs

95 12/06/2011 10:53 AM Aaron Marcuse-Kubitza

xpath.py: Fixed creation of attrs so it happens even when node already exists

94 12/06/2011 09:59 AM Aaron Marcuse-Kubitza

xpath.py: Added concept of keys vs attrs in XPath elem

93 12/05/2011 05:25 PM Aaron Marcuse-Kubitza

Started filling in required values for VegBank fields in mappings. Will need to refactor to move these to metadata for the datasources.

92 12/05/2011 05:24 PM Aaron Marcuse-Kubitza

Now allow empty rows. Added support for select statement limit.

91 12/05/2011 04:17 PM Aaron Marcuse-Kubitza

Added support for quoted values in XPaths

90 12/05/2011 04:02 PM Aaron Marcuse-Kubitza

Fixed name XML function. Fixed accept_test_output.

89 12/05/2011 03:59 PM Aaron Marcuse-Kubitza

Added support for name XML function. Added error handling for empty rows.

88 12/05/2011 03:28 PM Aaron Marcuse-Kubitza

Made it easier to accept test output

87 12/05/2011 03:18 PM Aaron Marcuse-Kubitza

Added NYBG stemCount metadata

86 12/05/2011 03:11 PM Aaron Marcuse-Kubitza

Added xml_func.py to process mappings whose output needs postprocessing

85 12/05/2011 01:53 PM Aaron Marcuse-Kubitza

Changed VegBank mappings to use XML functions (not implemented yet) to calculate averages and ranges

84 12/05/2011 01:25 PM Aaron Marcuse-Kubitza

Added support for mapping datasource metadata

83 12/05/2011 12:53 PM Aaron Marcuse-Kubitza

Changed for loops to use enumerate() where the index is also needed

82 12/05/2011 12:50 PM Aaron Marcuse-Kubitza

Moved XPath prep code (setting ID, value) to xpath.py

81 12/02/2011 05:27 PM Aaron Marcuse-Kubitza

xpath.py: Added deepcopy() before setting value of other branches to traverse

80 12/02/2011 05:12 PM Aaron Marcuse-Kubitza

NYSpecimenDataAmericas.test.xml: Updated for new NYBG-VegX.organisms.csv

79 12/02/2011 05:11 PM Aaron Marcuse-Kubitza

NYBG-VegX.organisms.csv: Changed voucher (primary key) column to be UniqueNYInternalRecordNumber because CatalogNumber contained an empty value

78 12/02/2011 05:10 PM Aaron Marcuse-Kubitza

xpath.py: Added basic support for split paths

77 12/02/2011 04:30 PM Aaron Marcuse-Kubitza

Merged xml_xpath.py into xpath.py in preparation for changing the XPath parse tree to be the XML DOM tree itself

76 12/02/2011 03:58 PM Aaron Marcuse-Kubitza

Refactored xpath.parse() to use a nested function instead of a class extending Parser

75 12/02/2011 03:04 PM Aaron Marcuse-Kubitza

map: Fixed mislocated import for Parser.SyntaxException

74 12/02/2011 02:21 PM Aaron Marcuse-Kubitza

Removed SALVIAS voucher_string mapping per conference call discussion

73 12/02/2011 02:16 PM Aaron Marcuse-Kubitza

map: Fixed bugs to enable mapping straight from CSV to a database. Still need a way to set plot.authorPlotCode for specimens data.

72 12/02/2011 12:05 PM Aaron Marcuse-Kubitza

Fixed ch_map_root to support subpaths which follow the root by -> rather than /. Changed spreadsheet syntax to have : between label and root.