Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 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 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2137 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: establishm...
  lib 2139 over 12 years Aaron Marcuse-Kubitza sql.py: DbConn: Added with_savepoint(). with_sa...
  mappings 2137 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: establishm...
  schemas 2138 over 12 years Aaron Marcuse-Kubitza schemas/functions.sql: Added _toBool
  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
2139 05/13/2012 05:20 AM Aaron Marcuse-Kubitza

sql.py: DbConn: Added with_savepoint(). with_savepoint(): Use new DbConn.with_savepoint().

2138 05/13/2012 04:13 AM Aaron Marcuse-Kubitza

schemas/functions.sql: Added _toBool

2137 05/13/2012 04:12 AM Aaron Marcuse-Kubitza

mappings/DwC2-VegBIEN.specimens.csv: establishmentMeans: Use _toBool on iscultivated, isnative

2136 05/13/2012 04:11 AM Aaron Marcuse-Kubitza

schemas/functions.sql: Added _toBool

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

schemas/functions.sql: Made trigger functions IMMUTABLE since they do not modify other tables

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 ")"

View all revisions | View revisions

Also available in: Atom