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...
  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 3427 over 12 years Aaron Marcuse-Kubitza bin/map: by_col: Stripping XML functions not in...
  config 272 almost 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 3426 over 12 years Aaron Marcuse-Kubitza db_xml.py: Don't remove any explicit pkey becau...
  mappings 3337 over 12 years Aaron Marcuse-Kubitza mappings/VegX-VegBIEN.stems.csv: Reattached loc...
  schemas 3422 over 12 years Aaron Marcuse-Kubitza schemas/functions.sql, py_functions.sql: Rename...
  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
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.

3422 07/17/2012 07:51 PM Aaron Marcuse-Kubitza

schemas/functions.sql, py_functions.sql: Renamed trigger functions to avoid collisions with plain SQL functions of the same name but different signatures, so that the plain SQL functions can be uniquely identified by their name without also requiring their signature

3421 07/17/2012 07:39 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): In queries without a FROM clause, don't order by pkey

3420 07/17/2012 07:15 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): Support queries without a FROM clause

3419 07/17/2012 07:03 PM Aaron Marcuse-Kubitza

sql.py: Added DoesNotExistException and parse it in run_query()

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)

View all revisions | View revisions

Also available in: Atom