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
  bin 3339 over 12 years Aaron Marcuse-Kubitza bin/map: Fixed bug where errors table indexes c...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 3341 over 12 years Aaron Marcuse-Kubitza inputs/import.stats.xls: Updated with stats fro...
  lib 3348 over 12 years Aaron Marcuse-Kubitza sql.py: Added constraint_cond()
  mappings 3337 over 12 years Aaron Marcuse-Kubitza mappings/VegX-VegBIEN.stems.csv: Reattached loc...
  schemas 3344 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: specimenreplicate: specime...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.5 KB 3249 over 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: Schemas: Added schem...
README.TXT 2.96 KB 3205 over 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Import data into VegBI...
map 1.21 KB 3140 over 12 years Aaron Marcuse-Kubitza top-level map: Added support for custom public ...

Latest revisions

# Date Author Comment
3348 07/12/2012 10:05 AM Aaron Marcuse-Kubitza

sql.py: Added constraint_cond()

3347 07/12/2012 09:26 AM Aaron Marcuse-Kubitza

sql.py: run_query(): ConstraintException: Include table in the constraint name because constraints are scoped by table

3346 07/12/2012 09:18 AM Aaron Marcuse-Kubitza

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

3345 07/12/2012 09:12 AM Aaron Marcuse-Kubitza

sql.py: ConstraintException: Also store the constraint's condition, if any

3344 07/12/2012 08:24 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: specimenreplicate: specimenreplicate_unique_catalognumber UNIQUE INDEX: Limited to rows where sourceaccessioncode IS NULL, so that it will only be used as an alternate if the datasource does not specify a sourceaccessioncode. This should fix the SpeciesLink bug where input rows with catalognumber_dwc IS NULL match multiple output rows when compared on the specimenreplicate_unique_catalognumber UNIQUE INDEX because they were excluded from the uniquifying by the index filter.

3343 07/12/2012 08:10 AM Aaron Marcuse-Kubitza

schemas/vegbien.ERD.mwb: Synced with schema

3342 07/12/2012 08:06 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: specimenreplicate: Added UNIQUE INDEX on plantobservation_id for direct vouchers in plots data

3341 07/12/2012 07:16 AM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated with stats from latest import

3340 07/11/2012 10:36 PM Aaron Marcuse-Kubitza

sql.py: Removed no longer used constraint_cols(). index_cols() can always be used for a UNIQUE constraint because a UNIQUE index is automatically created for it.

3339 07/11/2012 10:34 PM Aaron Marcuse-Kubitza

bin/map: Fixed bug where errors table indexes could not be looked up using index_cols() because their schema was not in the search_path, by explicitly adding the in_schema at the end of the search_path. This is the only reason the in_schema needs to be in the search_path, but it's unavoidable because the "duplicate key value violates unique constraint" error does not included the constraint's schema.

View all revisions | View revisions

Also available in: Atom