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 about 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 6890 over 11 years Aaron Marcuse-Kubitza backups/Makefile: Synchronization: $(remote): F...
  bin 6897 over 11 years Aaron Marcuse-Kubitza import_all: Run all imports (not just the main ...
  config 6321 over 11 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 6898 over 11 years Aaron Marcuse-Kubitza inputs/Makefile: Input data: $(rsyncSrcs): Also...
  lib 6901 over 11 years Aaron Marcuse-Kubitza sql.py: DbConn.col_info(): Fixed bug where need...
  mappings 6893 over 11 years Aaron Marcuse-Kubitza mappings/Makefile: VegCore.csv: Filter out the ...
  schemas 6885 over 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added taxon_trait material...
  to_do 4524 almost 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 5971 over 11 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 13.3 KB 6853 over 11 years Aaron Marcuse-Kubitza root Makefile: PostgreSQL: $(editPhppgadmin): I...
README.TXT 16.5 KB 6888 over 11 years Aaron Marcuse-Kubitza README.TXT: Data import: On jupiter: Updated pa...
map 989 Bytes 5158 over 11 years Aaron Marcuse-Kubitza root map: Removed no longer needed public schem...
new_terms.csv 30.4 KB 4887 almost 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 almost 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
6901 12/18/2012 11:41 PM Aaron Marcuse-Kubitza

sql.py: DbConn.col_info(): Fixed bug where need to use .to_str(self) instead of self.esc_value() because self.esc_value() expects a value, not a sql_gen.Literal instance

6900 12/18/2012 11:34 PM Aaron Marcuse-Kubitza

sql.py: DbConn.col_info(): Fixed bug where self needs to be used everywhere that db normally is, because this is a DbConn method rather than a global function

6899 12/18/2012 11:31 PM Aaron Marcuse-Kubitza

sql.py: DbConn.col_info(): For PostgreSQL, use pg_catalog tables directly instead of their views in information_schema. This allows using ::regclass to look up the table in the search_path, and fixes a bug in imports with an explicit public schema where column types were looked up in public instead of public.<version>. Also don't wrap default using sql_gen.as_Code() when it's None (indicating no default value, aka default=NULL), because this value is interpreted specially by sql_gen.TypedCol.

6898 12/18/2012 11:06 PM Aaron Marcuse-Kubitza

inputs/Makefile: Input data: $(rsyncSrcs): Also include log files other than install.log.sql

6897 12/18/2012 09:41 PM Aaron Marcuse-Kubitza

import_all: Run all imports (not just the main datasources' import) with $import_source turned off, so that the Source tables will not be imported a second time when the datasource's main tables are imported. Note that it's not necessary to wait for asynchronous commands after the jobs for the main import are started (so that $import_source is not unset until after they are started), because with_all does not return until all jobs are started and have noted the $import_source setting in effect in the shell environment.

6896 12/18/2012 09:32 PM Aaron Marcuse-Kubitza

import_all: Source tables import: Fixed bug where need to use $all option to with_all to also include special datasources starting with "."

6895 12/18/2012 09:23 PM Aaron Marcuse-Kubitza

make_analytical_db: Also create taxon_trait materialized view

6894 12/17/2012 08:17 PM Aaron Marcuse-Kubitza

inputs/*/*/map.csv: Reverted special OMIT mappings for input columns that have the same name as a VegCore table and have not yet been mapped to a VegCore term

6893 12/17/2012 08:06 PM Aaron Marcuse-Kubitza

mappings/Makefile: VegCore.csv: Filter out the VegCore tables so they are not matched as terms. This is necessary because some terms have the same name as a table, but the term should be the match rather than the table.

6892 12/17/2012 08:04 PM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Changed line endings to \r\n to match the output of filter_out_ci

View all revisions | View revisions

Also available in: Atom