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
  backups 6725 almost 12 years Aaron Marcuse-Kubitza Added backups/fix_perms
  bin 6785 almost 12 years Aaron Marcuse-Kubitza my2pg: Translate blob to bytea
  config 6321 about 12 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 6798 almost 12 years Aaron Marcuse-Kubitza inputs/import.stats.xls: Updated import times
  lib 6801 almost 12 years Aaron Marcuse-Kubitza sql_io.py: put_table(): is_function: Fixed bug ...
  mappings 6795 almost 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: institutionCode: ...
  schemas 6794 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: sourcename: Added sourcena...
  to_do 4524 about 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.9 KB 6544 almost 12 years Aaron Marcuse-Kubitza root Makefile: apt-get: Use --yes to allow unat...
README.TXT 15.5 KB 6799 almost 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Checking for errors: S...
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 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
6801 12/12/2012 04:41 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): is_function: Fixed bug where need to add the pkeys table's test pkey constraint after the data is added rather than when the empty table is created, to avoid adding a pkey constraint that will later be violated by data which returns multiple output rows for an input row (such as calls to _split())

6800 12/12/2012 04:36 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): insert_into_pkeys(): Allow callers to override run_query_into()'s add_pkey_ param in case the initial version of the pkeys table should not yet have the test pkey constraint (e.g. because data is added after the table is created)

6799 12/12/2012 04:24 PM Aaron Marcuse-Kubitza

README.TXT: Data import: Checking for errors: Search for "Command exited with non-zero status" to find errors, which is faster than checking that each input's log ends in "Encountered 0 error(s)"

6798 12/12/2012 04:13 PM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated import times

6797 12/12/2012 03:50 PM Aaron Marcuse-Kubitza

README.TXT: Data import: import_all: Corrected text of note about time until control is returned to the shell

6796 12/12/2012 03:42 PM Aaron Marcuse-Kubitza

README.TXT: Data import: Moved download of logs to right after the import is done, because this is a quick step that doesn't depend on the backup- and export-creation steps

6795 12/11/2012 11:41 AM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: institutionCode: Removed mapping to sourcename.matched_source_id, which is now autopopulated. Split any list of institutionCodes apart using new _split().

6794 12/11/2012 11:28 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: sourcename: Added sourcename_set_matched_source_id() trigger

6793 12/11/2012 11:22 AM Aaron Marcuse-Kubitza

schemas/functions.sql: Added _split()

6792 12/11/2012 11:13 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: sourcelist_unique: Removed COALESCE around name because it's NOT NULL

View all revisions | View revisions

Also available in: Atom