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 2458 over 12 years Aaron Marcuse-Kubitza bin/map: Fixed bug where verbosity needed to be...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2438 over 12 years Aaron Marcuse-Kubitza input.Makefile: Configuration: Removed debug va...
  lib 2469 over 12 years Aaron Marcuse-Kubitza db_xml.py: put_table(): Subset in_table: Docume...
  mappings 2364 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: plantname....
  schemas 2412 over 12 years Aaron Marcuse-Kubitza schemas/functions.sql, vegbien.sql: Changed CAS...
  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
2469 05/29/2012 07:43 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Subset in_table: Document that in_table will be shadowed (hidden) by the created temp table, rather than versioned, now that the table is (almost) always created as a temp table

2468 05/29/2012 07:40 PM Aaron Marcuse-Kubitza

sql.py: Create temp items as permanent in autocommit mode rather than in debug mode so that temp items are only permanent if actually committing result. This ensures that the generated SQL in test mode matches what would actually get run in regular commit mode, and the SQL is only altered to make the temp items visible if actually debugging (autocommit mode).

2467 05/29/2012 07:30 PM Aaron Marcuse-Kubitza

sql.py, sql_gen.py: Reformatted generated SQL for presentability by adding newlines

2466 05/29/2012 07:14 PM Aaron Marcuse-Kubitza

sql.py: DbConn.run_query(): Put a newline before the query in the debug message so that multiline queries have all rows at the left edge rather than the first row prefixed by other text

2465 05/29/2012 07:09 PM Aaron Marcuse-Kubitza

sql.py: DbConn.run_query(): Don't put generated query debug message all on one line, so that embedded newlines are preserved

2464 05/29/2012 06:59 PM Aaron Marcuse-Kubitza

sql.py: Fixed bug where queries with versioned identifiers which threw an exception (not related to name collisions) were being output with a too-high log_level, because all exceptions were output with the higher exc_log_level, by making the following changes: DbConn.run_query(): Changed exc_log_level param to log_ignore_excs param so that only certain exceptions would cause the query to be output with a higher log_level. Moved the code that actual emits the query debug message from DbConn.run_query() to module-level run_query() so it would apply the log_ignore_excs filter after the exception had already been parsed into specific types.

2463 05/29/2012 03:16 PM Aaron Marcuse-Kubitza

Moved "Putting columns" debug message from db_xml.py put_table() to sql.py put_table() to put it in the same place as the other debug messages

2462 05/29/2012 03:12 PM Aaron Marcuse-Kubitza

sql_gen.py: Added remove_col_rename() and use it where `if isinstance(value, NamedCol): value = value.code` was used

2461 05/29/2012 03:10 PM Aaron Marcuse-Kubitza

sql_gen.py: CompareCond.to_str(): If left_value has been renamed as a NamedCol, unwrap it

2460 05/29/2012 02:53 PM Aaron Marcuse-Kubitza

sql_gen.py: Join.to_str(): Fixed bug where USING should be used if all columns are join_same_not_null, rather than join_same, because USING uses plain = for comparison. sql.py: put_table(): input_joins now can use sql_gen.join_same_not_null in order to use USING syntax.

View all revisions | View revisions

Also available in: Atom