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 2125 about 12 years Aaron Marcuse-Kubitza sql.py: put_table(): Take a dict mapping out to...
  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
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)

2120 05/09/2012 02:26 AM Aaron Marcuse-Kubitza

sql.py: mk_select(): Support ORDER BY clause. By default, order by the pkey, since PostgreSQL apparently doesn't do this automatically (and this was causing some staging table tests to fail).

2119 05/09/2012 02:04 AM Aaron Marcuse-Kubitza

bin/map: In debug mode, print the row # and input row just like in error messages

2118 05/09/2012 01:51 AM Aaron Marcuse-Kubitza

bin/map: verbose_errors also defaults to on in debug mode

2117 05/09/2012 01:39 AM Aaron Marcuse-Kubitza

sql.py: add_row_num(): Make the row number column the primary key

2116 05/09/2012 12:36 AM Aaron Marcuse-Kubitza

csv2db: Use new sql.cleanup_table() to map NULL-equivalents to NULL. Consider the empty string to be NULL.

View all revisions | View revisions

Also available in: Atom