Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  bin 2550 over 12 years Aaron Marcuse-Kubitza bin/map: by_col: Strip only XML functions that ...
  config 272 about 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 2556 over 12 years Aaron Marcuse-Kubitza xpath.py: get(): Create attrs: Put keys last so...
  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 almost 13 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: Install public schem...
map 978 Bytes 1979 almost 13 years Aaron Marcuse-Kubitza root map: Fill in defaults for inputs from VegB...

Latest revisions

# Date Author Comment
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()

2552 06/01/2012 04:32 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Added is_func param for whether out_table is the name of a SQL function, not a table

2551 06/01/2012 04:09 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Treat every node name that starts with "_" as a function, not just members of put_table_special_funcs. This ensures that DB function args are always treated as values, not children with fkeys to parent.

2550 06/01/2012 03:40 PM Aaron Marcuse-Kubitza

bin/map: by_col: Strip only XML functions that are not in the DB

2549 06/01/2012 03:39 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Make special_funcs externally available as module constant put_table_special_funcs

2548 06/01/2012 03:38 PM Aaron Marcuse-Kubitza

sql.py: tables(): Changed schema param to schema_like and filter the schema using LIKE so that all schemas can be selected

2547 06/01/2012 01:56 PM Aaron Marcuse-Kubitza

to_do/timeline.doc: Updated to reflect the month we spent on optimization and column-based import

View all revisions | View revisions

Also available in: Atom