Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  bin 2560 over 12 years Aaron Marcuse-Kubitza bin/map: by_col: Stripping XML functions not in...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2556 over 12 years Aaron Marcuse-Kubitza xpath.py: get(): Create attrs: Put keys last so...
  lib 2562 over 12 years Aaron Marcuse-Kubitza sql.py: put_table(): FunctionValueException: Fi...
  mappings 2529 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
  schemas 2554 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql, functions.sql: Made cast f...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 9.47 KB 2095 over 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: functions schema: Re...
README.TXT 2.7 KB 1967 over 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: Install public schem...
map 978 Bytes 1979 over 12 years Aaron Marcuse-Kubitza root map: Fill in defaults for inputs from VegB...

Latest revisions

# Date Author Comment
2562 06/01/2012 07:06 PM Aaron Marcuse-Kubitza

sql.py: put_table(): FunctionValueException: Fixed bug where only function calls, not plain columns, were handled, by using sql_gen.unwrap_func_call() to remove any function call only if there was one

2561 06/01/2012 07:04 PM Aaron Marcuse-Kubitza

sql_gen.py: Added unwrap_func_call()

2560 06/01/2012 06:47 PM Aaron Marcuse-Kubitza

bin/map: by_col: Stripping XML functions not in the DB: Fixed bug where preserve_funcs.add() was used when `preserve_funcs |=` should have been used to add the entire iterable that sql.tables() returns

2559 06/01/2012 06:45 PM Aaron Marcuse-Kubitza

sql.py: not_null_col: Changed value to 'not_null_col' so that column doesn't seem like a status indicator of whether some value is not null (in fact it's just a column that is always not null)

2558 06/01/2012 06:05 PM Aaron Marcuse-Kubitza

xml_func.py: Replaced xpath.get_1() with xpath.get_value() where possible, for simplicity

2557 06/01/2012 05:59 PM Aaron Marcuse-Kubitza

xml_func.py: strip(): Evaluate structural functions like _ignore and _ref by process() instead of removing them. Store structural functions' names in structural_funcs module var. This ensures that _ref targets are still expanded in column-based import.

2556 06/01/2012 05:56 PM Aaron Marcuse-Kubitza

xpath.py: get(): Create attrs: Put keys last so that any lookahead assertion's path will be created last as it would have without the assertion. This ensures that any value argument of an XML function will always go last even if a lookahead assertion would otherwise have caused it to be created with the element's keys, which previously were created before the attributes.

2555 06/01/2012 04:55 PM Aaron Marcuse-Kubitza

sql.py: put_table(): If is_func, default into table name ends in () instead of '-pkeys'

2554 06/01/2012 04:54 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql, functions.sql: Made cast functions STRICT to enable the RETURNS NULL ON NULL INPUT optimization

2553 06/01/2012 04:33 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Pass is_func to sql.put_table()

View all revisions | View revisions

Also available in: Atom