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 2639 over 12 years Aaron Marcuse-Kubitza schemas/functions.sql: _nullIf: Fixed bug where...
  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 2663 over 12 years Aaron Marcuse-Kubitza sql.py: DbConn: Added mogrify() and use it in e...
  mappings 2529 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
  schemas 2662 over 12 years Aaron Marcuse-Kubitza schemas/functions.sql: _nullIf(): Fixed bug whe...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.1 KB 2633 over 12 years Aaron Marcuse-Kubitza main Makefile: schemas/%/uninstall: Removed del...
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
2663 06/06/2012 08:43 PM Aaron Marcuse-Kubitza

sql.py: DbConn: Added mogrify() and use it in esc_value()

2662 06/06/2012 07:58 PM Aaron Marcuse-Kubitza

schemas/functions.sql: _nullIf(): Fixed bug where wrong var name was used to retrieve type param. Reenabled _nullIf now that it's working.

2661 06/06/2012 07:25 PM Aaron Marcuse-Kubitza

sql_gen.py: ColDict.__setitem__(): Translate NULL values to the appropriate default value of the key column (which is often NULL, but not always) so that select query filtering/joins work correctly

2660 06/06/2012 07:21 PM Aaron Marcuse-Kubitza

sql.py: DbConn.col_default(): Fixed bug where returned string needed to be wrapped in sql_gen.as_Code() because it's sometimes a SQL expression and sometimes NULL

2659 06/06/2012 07:20 PM Aaron Marcuse-Kubitza

sql_gen.py: Added as_Code(). Split SQL code objects into separate sections so unparameterized classes would be separate from general classes.

2658 06/06/2012 07:08 PM Aaron Marcuse-Kubitza

sql_gen.py: Code.to_str(): Fixed bug where needed to raise NotImplementedError, not NotImplemented

2657 06/06/2012 06:58 PM Aaron Marcuse-Kubitza

dicts.py: is_dict(): Fixed bug where lists also have getitem() methods, so keys() was checked for instead

2656 06/06/2012 06:44 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Fixed bug where mapping was still a plain dict because that's what dicts.join() returns, by moving the wrapping of it in a sql_gen.ColDict after dicts.join()

2655 06/06/2012 06:28 PM Aaron Marcuse-Kubitza

sql_gen.py: ColDict: Fixed bug where copy() needed to be implemented

2654 06/06/2012 06:14 PM Aaron Marcuse-Kubitza

sql.py: into_table_name(): Fixed bug where key needed to be passed through str() now that ColDict uses Col objects for everything

View all revisions | View revisions

Also available in: Atom