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 2122 over 12 years Aaron Marcuse-Kubitza sql.py: mk_select(): Support joins
  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
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.

2115 05/09/2012 12:35 AM Aaron Marcuse-Kubitza

sql.py: Added cleanup_table()

2114 05/09/2012 12:33 AM Aaron Marcuse-Kubitza

csvs.py: Added row filters

2113 05/07/2012 11:14 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Fixed bug where relational functions were not being treated as value nodes, and thus their containing child was treated as a child with a backwards pointer instead of a field

View all revisions | View revisions

Also available in: Atom