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 2195 about 12 years Aaron Marcuse-Kubitza db_xml.py: put_table(): Added limit and start o...
  config 272 over 12 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2250 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Filter dat...
  lib 2258 about 12 years Aaron Marcuse-Kubitza sql.py: put_table(): DuplicateKeyException: Ass...
  mappings 2250 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Filter dat...
  schemas 2249 about 12 years Aaron Marcuse-Kubitza schemas/functions.sql: Added _toTimestamp
  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
2258 05/21/2012 07:08 PM Aaron Marcuse-Kubitza

sql.py: put_table(): DuplicateKeyException: Assert that join_cols has changed to avoid infinite loops

2257 05/21/2012 06:59 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Moved getting pkeys of already existing rows from DuplicateKeyException to try clause, so that it always runs if there are join_cols. DuplicateKeyException: Add new duplicate key cols to join_cols instead of replacing join_cols so that multiple unique constraints being violated causes the union of their columns to be used for join_cols.

2256 05/21/2012 06:23 PM Aaron Marcuse-Kubitza

sql_gen.py: Added CustomCode

2255 05/21/2012 06:05 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): joins: Fixed bug where joins dict was being modified without first being copied, causing the input value to be modified

2254 05/21/2012 05:52 PM Aaron Marcuse-Kubitza

Compare object()-based sentinel values using is. Where sentinel values must be compared using ==, use rand.rand_int() instead.

2253 05/21/2012 05:13 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Added debug messages for every action performed

2252 05/21/2012 04:45 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Moved assignment of in_pkeys_ref outside loop so it wouldn't need to be re-versioned every iteration

2251 05/21/2012 04:42 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Changed temp_suffix to temp_prefix so all temp tables for a given out_table would have the same prefix. (Existing name collisions due to truncated names are not a problem because version prefixes are automatically added.)

2250 05/21/2012 04:23 PM Aaron Marcuse-Kubitza

mappings/DwC2-VegBIEN.specimens.csv: Filter dates through _toTimestamp

2249 05/21/2012 04:20 PM Aaron Marcuse-Kubitza

schemas/functions.sql: Added _toTimestamp

View all revisions | View revisions

Also available in: Atom