Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  branches 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 12157 almost 11 years Aaron Marcuse-Kubitza inputs/import.stats.xls: updated import times
  • svn:ignore: extern

Latest revisions

# Date Author Comment
12157 02/13/2014 06:53 AM Aaron Marcuse-Kubitza

inputs/import.stats.xls: updated import times

12156 02/13/2014 05:58 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem.datasource: removed fkey to source.shortname because this prevents individually-reloaded datasources from being published

12155 02/13/2014 05:56 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: publish(), rm(): documented runtime (1 min)

12154 02/13/2014 05:49 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added datasource_unpublish()

12153 02/13/2014 03:48 AM Aaron Marcuse-Kubitza

lib/sql_io.py: automatic handling of input/output column type mismatches: also do this for identifying columns, which first cause an error in a join in sql.distinct_table() rather than in the main insert (and thus were not handled by the existing error handling). previously, the user would have had to manually cast the input column in postprocess.sql. this involves getting handle_MissingCastException() to update join_cols as well as mapping.

12152 02/13/2014 03:37 AM Aaron Marcuse-Kubitza

lib/sql.py: distinct_table(): don't cache the table creation, because this prevents different distinct_tables from being created for the same input table

12151 02/13/2014 03:36 AM Aaron Marcuse-Kubitza

lib/sql.py: create_table(), copy_table_struct(): support custom query options, such as cacheable

12150 02/13/2014 12:29 AM Aaron Marcuse-Kubitza

lib/sql_io.py: put_table(): main loop MissingCastException handler: factored out into nested function so that it can also be used elsewhere

12149 02/13/2014 12:01 AM Aaron Marcuse-Kubitza

lib/sql.py: parse_exception(): parse "operator does not exist" errors as MissingCastExceptions (these appear when a staging table column is of the wrong type)

12148 02/08/2014 11:17 PM Aaron Marcuse-Kubitza

bugfix: /README.TXT: Full database import: Check that source contains [# datasources] rows up through XAL: added alternative verification method when this is not the case (some datasources may be near the end depending on import order)

View all revisions | View revisions

Also available in: Atom