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...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 3409 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Added %.backup/test
  bin 3406 over 12 years Aaron Marcuse-Kubitza pg_dump_vegbien: If first arg is "all", dump en...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 3387 over 12 years Aaron Marcuse-Kubitza input.Makefile: Mapping: $(map): Fixed bug wher...
  lib 3418 over 12 years Aaron Marcuse-Kubitza sql_io.py: put_table(): Removed no longer used ...
  mappings 3337 over 12 years Aaron Marcuse-Kubitza mappings/VegX-VegBIEN.stems.csv: Reattached loc...
  schemas 3416 over 12 years Aaron Marcuse-Kubitza schemas/py_functions.sql: _date(): Just run str...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.4 KB 3393 over 12 years Aaron Marcuse-Kubitza Moved archived imports and make targets to main...
README.TXT 3.71 KB 3410 over 12 years Aaron Marcuse-Kubitza README.TXT: Maintenance: Full DB: Documented ho...
map 1.21 KB 3140 over 12 years Aaron Marcuse-Kubitza top-level map: Added support for custom public ...

Latest revisions

# Date Author Comment
3418 07/17/2012 06:46 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): Removed no longer used conds var (invalid rows are removed from the in_table using sql.delete() instead of being filtered out in the main select)

3417 07/17/2012 06:43 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): Removed no longer used distinct_on var (sql.distinct_table() handles filtering the join_cols)

3416 07/17/2012 06:24 PM Aaron Marcuse-Kubitza

schemas/py_functions.sql: _date(): Just run str() on the returned datetime because it will usually be converted to a PostgreSQL timestamp anyway, so excluding the time from the string isn't necessary

3415 07/17/2012 06:15 PM Aaron Marcuse-Kubitza

schemas/py_functions.sql: Added _date()

3414 07/17/2012 06:14 PM Aaron Marcuse-Kubitza

sql.py: run_query(): Exception parsing: Remove PL/Python prefix from exception message so that the regexps can match at the beginning of the message

3413 07/17/2012 05:50 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): Handle sql.InvalidValueExceptions by filtering the value out of all input columns. This will be useful for SQL functions that raise exceptions.

3412 07/17/2012 04:49 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: namedplace, plantname: *_unique UNIQUE INDEX: Reordered columns to put rank after parent_id and plantname so that these columns, which are usually input table columns, can be used in a merge join index scan, while rank, which is usually a literal value, can applied as an index filter condition after the merge join

3411 07/17/2012 04:42 PM Aaron Marcuse-Kubitza

sql.py: distinct_table(): Removed literal values from UNIQUE INDEXes because the query planner did not seem to use them to do a merge join

3410 07/17/2012 04:01 PM Aaron Marcuse-Kubitza

README.TXT: Maintenance: Full DB: Documented how to test full DB backup

3409 07/17/2012 03:47 PM Aaron Marcuse-Kubitza

backups/Makefile: Added %.backup/test

View all revisions | View revisions

Also available in: Atom