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 over 12 years Aaron Marcuse-Kubitza Added debug2redmine and helper file debug2redmi...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2529 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
  lib 2546 over 12 years Aaron Marcuse-Kubitza sql.py: put_table(): in_table name: Remove '-pk...
  mappings 2529 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
  schemas 2543 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql, functions.sql: Cast functi...
  to_do 811 almost 13 years Aaron Marcuse-Kubitza Added to_do/milestones.doc
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
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

2544 06/01/2012 12:39 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Output "Adding index" debug message with level=2.5 so it's not part of the Redmine steps

2543 05/31/2012 03:39 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql, functions.sql: Cast functions: Fixed bug where invalid value exceptions were not being caught, because implicit conversions to the return type apparently only happen outside the block containing the RETURN statement (i.e. at the end of the function). Fixed by adding explicit type conversion to return type, so that type conversion would happen inside try block.

2542 05/31/2012 03:31 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Re-enabled FunctionValueException handling, by just filtering out the value on all input columns that use the named function (since the error message does not specify which column it was that had the invalid value). This is in some ways better, anyway, because that way the invalid value is filtered out right away in all columns that could contain it, instead of potentially once for each column (if the value appears in more than one input column).

2541 05/31/2012 03:18 PM Aaron Marcuse-Kubitza

sql.py: add_index(): Fixed bug where expressions could not be converted to a string until their table name had been removed

2540 05/31/2012 03:17 PM Aaron Marcuse-Kubitza

sql_gen.py: Added Expr

2539 05/31/2012 03:13 PM Aaron Marcuse-Kubitza

sql.py: add_index(): Fixed bug where expressions needed to be enclosed in () to distinguish them from plain columns

2538 05/31/2012 03:06 PM Aaron Marcuse-Kubitza

sql.py: add_index(): Support simple expressions as well as columns

2537 05/31/2012 02:37 PM Aaron Marcuse-Kubitza

sql.py: Renamed index_col() to add_index() so its name isn't similar to index_cols()

View all revisions | View revisions

Also available in: Atom