Project

General

Profile

Statistics
| Revision:

root @ 2214

Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  bin 2195 over 12 years Aaron Marcuse-Kubitza db_xml.py: put_table(): Added limit and start o...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2184 over 12 years Aaron Marcuse-Kubitza Mapped some unmapped fields in DwC inputs
  lib 2214 over 12 years Aaron Marcuse-Kubitza sql_gen.py: ValueCond.to_str(): Added value_cod...
  mappings 2183 over 12 years Aaron Marcuse-Kubitza Added mappings/for_review/DwC2-VegBIEN.specimen...
  schemas 2159 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added _toGrowthform
  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
2214 05/17/2012 02:22 PM Aaron Marcuse-Kubitza

sql_gen.py: ValueCond.to_str(): Added value_code param
2213 05/17/2012 02:16 PM Aaron Marcuse-Kubitza

sql_gen.py: Literal, CompareCond: Implemented to_str(). ValueCond: Autoconvert literal values to Literals.
2212 05/17/2012 02:14 PM Aaron Marcuse-Kubitza

sql.py: DbConn: Added esc_value()
2211 05/17/2012 01:52 PM Aaron Marcuse-Kubitza

Moved SQL code generation classes from sql.py to new sql_gen.py. sql_gen.py: Added Code, Literal, ValueCond, and CompareCond. sql.py: Removed Query because we will use a different approach.
2210 05/17/2012 12:43 PM Aaron Marcuse-Kubitza

sql.py: Added Query, Table, Col
2209 05/17/2012 11:28 AM Aaron Marcuse-Kubitza

sql.py: get(): Fixed bug where limit=1 needs to be passed to select() as a keyword arg now that the distinct_on param comes before it
2208 05/17/2012 11:01 AM Aaron Marcuse-Kubitza

sql.py: put_table(): mk_main_select(): Pass outer var conds to mk_select()
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

View all revisions | View revisions

Also available in: Atom