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 6908 over 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Merged provider_view, prov...
  config 6321 over 11 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 6906 over 11 years Aaron Marcuse-Kubitza mappings/Makefile: VegCore.csv: Filter out the ...
  lib 6909 over 11 years Aaron Marcuse-Kubitza lib/common.Makefile: Revisions: Allow $(version...
  mappings 6893 over 11 years Aaron Marcuse-Kubitza mappings/Makefile: VegCore.csv: Filter out the ...
  schemas 6908 over 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Merged provider_view, prov...
  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
6909 12/19/2012 05:02 AM Aaron Marcuse-Kubitza

lib/common.Makefile: Revisions: Allow $(version) to be overridden in the environment, so that the public schema and all log files share the same, pregenerated version

6908 12/19/2012 04:16 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Merged provider_view, provider_count, and owner_count into provider_count, using the combining query for Brad's data providers page at <http://bien.nceas.ucsb.edu/bien/people/data-providers/>

6907 12/19/2012 01:23 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: sync_taxon_trait_to_view(): Changed pkey to index because there can be multiple values of the same taxon's trait from different observations

6906 12/19/2012 01:16 AM 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.

6905 12/19/2012 12:29 AM Aaron Marcuse-Kubitza

sql.py: DbConn.col_info(): raising sql_gen.NoUnderlyingTableException: Fixed bug where also need to catch DoesNotExistException, which is thrown by ::regclass

6904 12/19/2012 12:26 AM Aaron Marcuse-Kubitza

sql.py: DbConn.col_info(): Fixed bug where need to run run_query() recoverably, because this query throws an exception if the column's table does not exist (the information_schema query just returned no rows)

6903 12/19/2012 12:22 AM Aaron Marcuse-Kubitza

sql.py: DbConn.col_info(): Fixed bug where need to use pg_get_expr() on pg_attrdef.adbin instead of shortcut field adsrc, because adsrc does not include schema qualifiers on table names (including strings passed to `nextval('..._seq'::regclass)`)

6902 12/18/2012 11:42 PM Aaron Marcuse-Kubitza

sql.py: DbConn.col_info(): Fixed bug where need to pass through cacheable param to run_query()

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

View all revisions | View revisions

Also available in: Atom