Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 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 4751 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 6404 about 12 years Aaron Marcuse-Kubitza bin/map: update_in_label(): Removed hardcoded s...
  config 6321 about 12 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 6413 about 12 years Aaron Marcuse-Kubitza db_xml.py: put(): _setDefault(): Delay the eval...
  lib 6418 about 12 years Aaron Marcuse-Kubitza lib/PostgreSQL-MySQL.csv: Remove indexes with W...
  mappings 6409 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: source table mapp...
  schemas 6417 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_aggregate: Adde...
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 12 KB 6337 about 12 years Aaron Marcuse-Kubitza root Makefile: PostgreSQL: $(postgresReload-Lin...
README.TXT 14.6 KB 6373 about 12 years Aaron Marcuse-Kubitza README.TXT: Datasource setup: Add input data fo...
map 989 Bytes 5158 about 12 years Aaron Marcuse-Kubitza root map: Removed no longer needed public schem...
new_terms.csv 30.4 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
6418 11/24/2012 11:05 AM Aaron Marcuse-Kubitza

lib/PostgreSQL-MySQL.csv: Remove indexes with WHERE clauses

6417 11/24/2012 10:34 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_aggregate: Added primary key on institutionCode, plotName, scientificNameWithMorphospecies, recordNumber. Note that this makes these fields NOT NULL, which should not be a problem because there are inner joins instead of LEFT JOINs on most of the tables which provide them, and LEFT JOINed tables have their identifying fields combined to create a NOT NULL value.

6416 11/24/2012 10:27 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: recordNumber: Combine identifying fields in taxonoccurrence, plantobservation, and stemobservation to ensure that this field is unique within the plot and not NULL

6415 11/24/2012 10:23 AM Aaron Marcuse-Kubitza

lib/PostgreSQL-MySQL.csv: Only match a statement-terminating ; when it's at the end of a line

6414 11/24/2012 10:02 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_aggregate: Added primary key on institutionCode, plotName, scientificNameWithMorphospecies. Note that this makes these fields NOT NULL, which should not be a problem because there are inner joins instead of LEFT JOINs on the tables which provide them.

6413 11/24/2012 09:21 AM Aaron Marcuse-Kubitza

db_xml.py: put(): _setDefault(): Delay the evaluation of each col_default's value until the col_default is actually retrieved. This fixes a bug in the source table mappings where the explicit source entry was being created after the col_default source entry, causing the initial entry, which did not have the additional fields populated, to be used instead.

6412 11/24/2012 09:14 AM Aaron Marcuse-Kubitza

dicts.py: Added WrapDict, a dict that runs a function on each value retrieved

6411 11/24/2012 08:59 AM Aaron Marcuse-Kubitza

db_xml.py: put(): _setDefault(): Fixed bug where need to copy col_defaults before calling update() on it, to avoid modifying the input value (which may be reused by the caller, expecting it to be unmodified)

6410 11/24/2012 08:54 AM Aaron Marcuse-Kubitza

db_xml.py: put(): col_defaults param: Fixed bug where need to use None as default value, because col_defaults will be modified by put() and the {} default value is a global instance

6409 11/24/2012 08:29 AM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: source table mappings: Set shortname to env var $source when it's not explicitly specified, because shortname is a required field of source

View all revisions | View revisions

Also available in: Atom