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 2648 over 12 years Aaron Marcuse-Kubitza sql.py: DbConn.DbCursor.execute(): When setting...
  mappings 2529 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
  schemas 2639 over 12 years Aaron Marcuse-Kubitza schemas/functions.sql: _nullIf: Fixed bug where...
  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
2648 06/06/2012 05:06 PM Aaron Marcuse-Kubitza

sql.py: DbConn.DbCursor.execute(): When setting self.query, provide default values for query, params because some debug printing statements use self.query directly instead of _add_cursor_info()

2647 06/06/2012 05:01 PM Aaron Marcuse-Kubitza

sql.py: insert(): Fixed bug where column remaing needed to be removed and sql_gen.Literal value unwrapped

2646 06/06/2012 03:40 PM Aaron Marcuse-Kubitza

sql.py: mk_insert_select(): cols: Fixed bug where table name needed to be removed from columns with a table

2645 06/06/2012 03:40 PM Aaron Marcuse-Kubitza

sql_gen.py: ColDict: Only allow dict inputs to constructor so update() can later be used. Ensure keys_table is a Table object.

2644 06/06/2012 02:55 PM Aaron Marcuse-Kubitza

sql_gen.py: ColDict: Translate NULL values to the key column's actual default value. This avoids incorrectly comparing against NULL in join/filter conditions when the column's actual default value must be used.

2643 06/06/2012 02:52 PM Aaron Marcuse-Kubitza

sql.py: DbConn: Added col_default()

2642 06/06/2012 02:52 PM Aaron Marcuse-Kubitza

sql_gen.py: ColDict: Take a db param for later use in getting default column values

2641 06/06/2012 02:16 PM Aaron Marcuse-Kubitza

sql_gen.py: ColDict: Take a keys_table param for operations that require the output table. Use this to convert all string keys to sql_gen.Col objects.

2640 06/06/2012 01:55 PM Aaron Marcuse-Kubitza

sql.py: put(): Use a sql_gen.ColDict for row, just like in put_table(), so that put() will benefit from planned enhancements to sql_gen.ColDict, such as translating NULL to the default value of a NOT NULL column

2639 06/06/2012 01:38 PM Aaron Marcuse-Kubitza

schemas/functions.sql: _nullIf: Fixed bug where NOT NULL parameters were not supported, because an input NULL value would not match an existing DEFAULT value in a select query, by temporarily disabling _nullIf until this can be supported. Removed previous workarounds.

View all revisions | View revisions

Also available in: Atom