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 2184 about 12 years Aaron Marcuse-Kubitza Mapped some unmapped fields in DwC inputs
  lib 2207 about 12 years Aaron Marcuse-Kubitza sql.py: put_table(): mk_select_(): Fixed bug wh...
  mappings 2183 about 12 years Aaron Marcuse-Kubitza Added mappings/for_review/DwC2-VegBIEN.specimen...
  schemas 2159 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added _toGrowthform
  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
2207 05/17/2012 10:57 AM Aaron Marcuse-Kubitza

sql.py: put_table(): mk_select_(): Fixed bug where it was sometimes being called without distinct_on, causing it to return a different # of rows. Renamed mk_select_() to mk_main_select() for clarity.

2206 05/17/2012 10:48 AM Aaron Marcuse-Kubitza

sql.py: put_table(): Do inserts and selects in a loop so that it will keep retrying the operation with additional constraints until it succeeds

2205 05/15/2012 03:56 PM Aaron Marcuse-Kubitza

sql.py: put_table(): mk_select_(): Fixed bug where order_by needed to be None because otherwise it wouldn't match the distinct_on cols if they were specified

2204 05/15/2012 03:55 PM Aaron Marcuse-Kubitza

sql.py: put_table(): insert_(): Fixed bug where distinct_on was not passed to mk_select_()

2203 05/15/2012 03:30 PM Aaron Marcuse-Kubitza

sql.py: put_table(): mk_select_(): Fixed bug where distinct_on needed to be passed as a keyword param

2202 05/15/2012 03:21 PM Aaron Marcuse-Kubitza

sql.py: put_table(): insert_() and mk_select_() take distinct_on param

2201 05/15/2012 03:10 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Factored out code that inserts into pkeys table into run_query_into_pkeys() helper function

2200 05/15/2012 02:55 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): Implemented DISTINCT ON according to the distinct_on param

2199 05/15/2012 02:48 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): Added distinct_on param to set the columns to SELECT DISTINCT ON

2198 05/15/2012 02:31 PM Aaron Marcuse-Kubitza

sql.py: clean_name(): Convert names to lowercase so that PostgreSQL will behave the same whether the name is escaped with "" or not. This will help avoid bugs in code that uses temp tables created by the sql module.

View all revisions | View revisions

Also available in: Atom