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 2110 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: *Latitude/...
  lib 2134 about 12 years Aaron Marcuse-Kubitza sql.py: put_table(): Added support for putting ...
  mappings 2110 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: *Latitude/...
  schemas 2107 about 12 years Aaron Marcuse-Kubitza schemas/functions.sql: Added _toDouble
  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
2134 05/13/2012 03:51 AM Aaron Marcuse-Kubitza

sql.py: put_table(): Added support for putting just a window subset of the rows in the table. Removed "SELECT statement missing a WHERE, LIMIT, or OFFSET clause" warnings.

2133 05/13/2012 03:30 AM Aaron Marcuse-Kubitza

sql.py: put_table(): Return the column where the pkeys are made available (the out_pkey) instead of taking it as an argument

2132 05/13/2012 03:20 AM Aaron Marcuse-Kubitza

sql.py: put_table(): Get input pkeys corresponding to rows in insert and join together out_pkeys and in_pkeys into final pkeys table

2131 05/13/2012 01:04 AM Aaron Marcuse-Kubitza

sql.py: put_table(): Fully support multiple in_tables, joined together using the main input table's pkey

2130 05/13/2012 01:02 AM Aaron Marcuse-Kubitza

sql.py: mk_select(): joins: Fixed bug where USING-based joins did not have closing ")"

2129 05/13/2012 12:28 AM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Fixed bug where in_table was last in in_tables instead of first, causing it to be ignored by the current put_table() implementation, which only considers the first table name

2128 05/13/2012 12:17 AM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Fixed bug where pkeys_table returned by recursive call to put_table() needed to be prefixed with $ to be treated as an input column name rather than a literal value

2127 05/09/2012 05:29 AM Aaron Marcuse-Kubitza

sql.py: mk_select(): Support joins with USING, which can be used to merge multiple input cols into the same output col

2126 05/09/2012 04:42 AM Aaron Marcuse-Kubitza

sql.py: mk_insert_select(): embeddable: Fixed bug where query that uses function was being sorted by its first column (the default mk_select() setting), when it should be left in its original order

2125 05/09/2012 04:36 AM Aaron Marcuse-Kubitza

sql.py: put_table(): Take a dict mapping out to in cols instead of separate in and out cols lists

View all revisions | View revisions

Also available in: Atom