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 2550 about 12 years Aaron Marcuse-Kubitza bin/map: by_col: Strip only XML functions that ...
  config 272 over 12 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2529 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
  lib 2553 about 12 years Aaron Marcuse-Kubitza db_xml.py: put_table(): Pass is_func to sql.put...
  mappings 2529 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
  schemas 2554 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql, functions.sql: Made cast f...
  to_do 2547 about 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 9.47 KB 2095 about 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: functions schema: Re...
README.TXT 2.7 KB 1967 about 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: Install public schem...
map 978 Bytes 1979 about 12 years Aaron Marcuse-Kubitza root map: Fill in defaults for inputs from VegB...

Latest revisions

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

2546 06/01/2012 12:54 PM Aaron Marcuse-Kubitza

sql.py: put_table(): in_table name: Remove '-pkeys' suffix from the into table name before adding '-input' so that the name is shorter and clearer

2545 06/01/2012 12:43 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Wrap repr() calls for debug messages in strings.as_tt() to add Redmine formatting

View all revisions | View revisions

Also available in: Atom