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 7037 over 11 years Aaron Marcuse-Kubitza backups/Makefile: Synchronization: %/download: ...
  bin 7163 over 11 years Aaron Marcuse-Kubitza import_all: Removed no longer needed TNRS impor...
  config 6321 over 11 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 7186 over 11 years Aaron Marcuse-Kubitza inputs/*/*/test.xml.ref: Restored inserted row ...
  lib 7180 over 11 years Aaron Marcuse-Kubitza sql_io.py: put_table(): DuplicateKeyException: ...
  mappings 7170 over 11 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Removed no longer...
  schemas 7185 over 11 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: Expanded analytical_st...
  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 11.3 KB 7082 over 11 years Aaron Marcuse-Kubitza root Makefile: Removed $(subMake), which is now...
README.TXT 16.8 KB 7183 over 11 years Aaron Marcuse-Kubitza README.TXT: Debugging: Added instructions for "...
map 1001 Bytes 6949 over 11 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
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
7186 01/11/2013 07:02 AM Aaron Marcuse-Kubitza

inputs/*/*/test.xml.ref: Restored inserted row counts, which had gotten auto-accepted from a test run on a non-empty DB

7185 01/11/2013 06:55 AM Aaron Marcuse-Kubitza

schemas/vegbien.ERD.mwb: Expanded analytical_stem to fit the width of all fields

7184 01/11/2013 06:53 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxondetermination: taxondetermination_computer_min_fit CHECK constraint: Fixed bug where need to use CASE instead of OR when a branch of an OR shouldn't be evaluated, because PostgreSQL doesn't support short-circuit OR

7183 01/11/2013 06:38 AM Aaron Marcuse-Kubitza

README.TXT: Debugging: Added instructions for "binary chop" debugging, which requires syncing the DB schema to the svn working copy

7182 01/11/2013 06:08 AM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: Removed no longer used mappings for verbatimScientificName in _if conditions

7181 01/11/2013 06:08 AM Aaron Marcuse-Kubitza

inputs/.NCBI/nodes/test.xml.ref: Restored inserted row counts, which had gotten auto-accepted from a test run on a non-empty DB

7180 01/11/2013 06:06 AM Aaron Marcuse-Kubitza

sql_io.py: put_table(): DuplicateKeyException: Uniquifying input table to avoid internal duplicate keys: Also filter out duplicate rows in the out_table, so that they don't create duplicate key errors and the resulting index holes

7179 01/11/2013 06:01 AM Aaron Marcuse-Kubitza

sql.py: distinct_table(): Added support for custom joins used in creating the new table. This can then be used by sql_io.put_table() to filter out duplicate rows in the out_table, so that they don't create duplicate key errors and the resulting index holes.

7178 01/11/2013 05:53 AM Aaron Marcuse-Kubitza

README.TXT: Documentation: Redmine-formatted list of steps for column-based import: Added step to reinstall public schema first, to reset the sequences so that they don't create a diff when the new steps.by_col.log.sql is committed

7177 01/11/2013 05:48 AM Aaron Marcuse-Kubitza

Added inputs/ACAD/Specimen/logs/steps.by_col.log.sql

View all revisions | View revisions

Also available in: Atom