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 2516 about 12 years Aaron Marcuse-Kubitza Added debug2redmine and helper file debug2redmi...
  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 2534 about 12 years Aaron Marcuse-Kubitza sql.py: put_table(): MissingCastException: Fixe...
  mappings 2529 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
  schemas 2530 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql, functions.sql: Removed _to...
  to_do 811 over 12 years Aaron Marcuse-Kubitza Added to_do/milestones.doc
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
2534 05/31/2012 01:38 PM Aaron Marcuse-Kubitza

sql.py: put_table(): MissingCastException: Fixed bug where renaming of cast literal value was not properly propagated to the returned value of the function call, causing the query to assume that a DISTINCT ON column referred to column in one of the joined tables instead of a named column in the SELECT columns list. This logic error would have been very difficult to catch without inspecting the code!

2533 05/31/2012 01:33 PM Aaron Marcuse-Kubitza

sql_gen.py: Added wrap_in_func()

2532 05/31/2012 01:25 PM Aaron Marcuse-Kubitza

sql_gen.py: FunctionCall: Filter args through remove_col_rename() to remove any renamings from the function args

2531 05/31/2012 01:20 PM Aaron Marcuse-Kubitza

sql.py: put_table(): No handler for exception: Print full exception instead of just first line to assist in debugging

2530 05/31/2012 01:06 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql, functions.sql: Removed _to* relational functions because type casting for those types is now automatic

2529 05/31/2012 01:02 PM Aaron Marcuse-Kubitza

mappings/DwC2-VegBIEN.specimens.csv: Removed _to* relational functions because type casting for those types is now automatic

2528 05/31/2012 12:59 PM Aaron Marcuse-Kubitza

schemas/functions.sql: Added cast functions for _to* relational functions

2527 05/31/2012 12:58 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Changed cast functions' input types to text because type must match exactly, not just be implicitly castable

2526 05/31/2012 12:47 PM Aaron Marcuse-Kubitza

sql.py: run_query(): MissingCastException parsing: Support multiple-word types

2525 05/31/2012 12:38 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Handle MissingCastExceptions by attempting to call a function with the name of the type on the column

View all revisions | View revisions

Also available in: Atom