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 6905 over 11 years Aaron Marcuse-Kubitza sql.py: DbConn.col_info(): raising sql_gen.NoUn...
  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
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

6899 12/18/2012 11:31 PM Aaron Marcuse-Kubitza

sql.py: DbConn.col_info(): For PostgreSQL, use pg_catalog tables directly instead of their views in information_schema. This allows using ::regclass to look up the table in the search_path, and fixes a bug in imports with an explicit public schema where column types were looked up in public instead of public.<version>. Also don't wrap default using sql_gen.as_Code() when it's None (indicating no default value, aka default=NULL), because this value is interpreted specially by sql_gen.TypedCol.

View all revisions | View revisions

Also available in: Atom