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 2119 about 12 years Aaron Marcuse-Kubitza bin/map: In debug mode, print the row # and inp...
  config 272 over 12 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2137 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: establishm...
  lib 2154 about 12 years Aaron Marcuse-Kubitza sql.py: put_table(): Pass pkeys to run_query_in...
  mappings 2137 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: establishm...
  schemas 2138 about 12 years Aaron Marcuse-Kubitza schemas/functions.sql: Added _toBool
  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
2154 05/13/2012 10:28 AM Aaron Marcuse-Kubitza

sql.py: put_table(): Pass pkeys to run_query_into() by ref so it will be updated if the table name is changed

2153 05/13/2012 10:15 AM Aaron Marcuse-Kubitza

sql.py: run_query_into(): If CREATE TABLE AS generates a DuplicateTableException, rename the table with a version # prepended

2152 05/13/2012 10:08 AM Aaron Marcuse-Kubitza

sql.py: run_query_into(): Made into param a reference so that the function can change it, and renamed it to into_ref

2151 05/13/2012 09:36 AM Aaron Marcuse-Kubitza

sql.py: run_query_into(): Made into param a reference so that the function can change it, and renamed it to into_ref

2150 05/13/2012 09:11 AM Aaron Marcuse-Kubitza

sql.py: put_table(): If DuplicateKeyException: run_query_into() recoverably, so that DB errors such as DuplicateTableException will be parsed

2149 05/13/2012 09:07 AM Aaron Marcuse-Kubitza

sql.py: Removed no-longer-needed try_insert()

2148 05/13/2012 09:05 AM Aaron Marcuse-Kubitza

sql.py: Merged with_parsed_errors() into run_query() so all recoverable queries would automatically benefit from DB error message parsing. DbConn: Moved _add_cursor_info() to DbCursor.execute().

2147 05/13/2012 07:45 AM Aaron Marcuse-Kubitza

sql.py: with_parsed_errors(): Raise DuplicateTableException for "relation already exists" errors instead of "table name specified more than once" errors

2146 05/13/2012 07:43 AM Aaron Marcuse-Kubitza

sql.py: run_query_into(): Removed "DROP TABLE IF EXISTS" because sometimes when there are collisions in the temp table names, the code actually uses both "copies" of the temp table. Eventually, this situation will be resolved by adding a counter to the temp table name.

2145 05/13/2012 07:26 AM Aaron Marcuse-Kubitza

sql.py: Cleaned up DbException's and subclasses' messages

View all revisions | View revisions

Also available in: Atom