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 over 12 years Aaron Marcuse-Kubitza bin/map: In debug mode, print the row # and inp...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2110 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: *Latitude/...
  lib 2130 over 12 years Aaron Marcuse-Kubitza sql.py: mk_select(): joins: Fixed bug where USI...
  mappings 2110 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: *Latitude/...
  schemas 2107 over 12 years Aaron Marcuse-Kubitza schemas/functions.sql: Added _toDouble
  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
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

2124 05/09/2012 04:08 AM Aaron Marcuse-Kubitza

sql.py: mk_select(): Joins: Reversed order of left_col and right_col in the joins dict as well, so the joined table's columns are the keys

2123 05/09/2012 04:05 AM Aaron Marcuse-Kubitza

sql.py: mk_select(): Joins: Reversed order of left_col and right_col so the column of the table being joined is first, to match the form of a WHERE clause

2122 05/09/2012 03:56 AM Aaron Marcuse-Kubitza

sql.py: mk_select(): Support joins

2121 05/09/2012 03:27 AM Aaron Marcuse-Kubitza

sql.py: mk_select(): Accept a list of tables to join together (initial implementation just uses the first table)

View all revisions | View revisions

Also available in: Atom