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 3430 over 12 years Aaron Marcuse-Kubitza pg_dump_vegbien: Don't use SET SESSION AUTHORIZ...
  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 3432 over 12 years Aaron Marcuse-Kubitza sql_io.py: put_table(): Optimization for only l...
  mappings 3337 over 12 years Aaron Marcuse-Kubitza mappings/VegX-VegBIEN.stems.csv: Reattached loc...
  schemas 3430 over 12 years Aaron Marcuse-Kubitza pg_dump_vegbien: Don't use SET SESSION AUTHORIZ...
  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
3432 07/17/2012 10:36 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): Optimization for only literal values: Also support an empty in_tables list, for use by put()

3431 07/17/2012 10:20 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): Added optimization for only literal values, which does the same operations as put() but with the additional error handling of put_table()

3430 07/17/2012 10:17 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Don't use SET SESSION AUTHORIZATION because it doesn't work with the py_functions schema (it requires PL/Python functions to be created as user postgres and then the owner changed to bien, which SET SESSION AUTHORIZATION won't do)

3429 07/17/2012 08:53 PM Aaron Marcuse-Kubitza

sql_gen.py: Added is_literal() and use it where isinstance(..., Literal) is used

3428 07/17/2012 08:44 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Divide fields into input columns and literal values: Translate values: Allow literal values other than strings or None (from the XML parsing), because sql_io.put_table() is getting an optimization for iterations containing only literal values, which just returns the pkey of the single row for these values (which is usually an integer) instead of a temp table with the same value in each row

3427 07/17/2012 08:28 PM Aaron Marcuse-Kubitza

bin/map: by_col: Stripping XML functions not in the DB: Remove DB functions based on whether a plain SQL function of that name exists, rather than whether a relational function (i.e. a table) of that name exists. This will allow column-based import to use plain SQL functions that don't have a corresponding relational function.

3426 07/17/2012 08:23 PM Aaron Marcuse-Kubitza

db_xml.py: Don't remove any explicit pkey because the output table may be a SQL function, which does not have a pkey. This feature only existed to support importing VegBank XML exports, which we don't use (and which would be incompatible with the schema anyway).

3425 07/17/2012 08:19 PM Aaron Marcuse-Kubitza

sql.py: function_exists(): Fixed bug where select() needed to be run with auto-rollback in case it raised an exception

3424 07/17/2012 08:08 PM Aaron Marcuse-Kubitza

xml_func.py: process(): Changed rel_funcs param to a callback is_rel_func, so that caller can specify any dynamic function to determine if a name is a relational function rather than having to list out all known relational functions

3423 07/17/2012 07:54 PM Aaron Marcuse-Kubitza

sql.py: function_exists(): Use simpler cast to regproc instead of query of information_schema.routines to determine if function exists. When the schema is not specified, this also limits the schemas checked to the search_path instead of the whole DB.

View all revisions | View revisions

Also available in: Atom