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 4751 about 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 5523 about 12 years Aaron Marcuse-Kubitza sql.select() calls: Removed order_by=None every...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 5526 about 12 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: Documented that accept...
  lib 5527 about 12 years Aaron Marcuse-Kubitza sql.py: mk_select(): Set order_by to None if li...
  mappings 5513 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: taxonconcept.pare...
  schemas 5518 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: taxonconcept: taxonconcept...
  to_do 4524 about 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 4523 about 12 years Aaron Marcuse-Kubitza Added validation/
Makefile 9.86 KB 5459 about 12 years Aaron Marcuse-Kubitza Makefile: Moved setting of $(root) before inclu...
README.TXT 12.9 KB 5519 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: On local machine: Adde...
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
5527 10/15/2012 03:11 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): Set order_by to None if limit == 0

5526 10/15/2012 03:09 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: Documented that accepted names must be processed before any names that resolve to them, because the entry for the accepted name contains all the ranks parsed out but the resolved name of another entry contains just some ranks and the taxonomic name. Column-based import will do this automatically when the total # of rows is <= the partition_size (because _taxonconcept_set_matched_concept_id()'s accepted taxonconcept is created after the main taxonconcept), but TNRS has more rows than this so sorting is needed to ensure that all the accepted names are processed in the first partitions.

5525 10/15/2012 02:52 PM Aaron Marcuse-Kubitza

sql.py: table_order_by(): Cache the order_by in table.order_by and propagate it when a LIKE table is created

5524 10/15/2012 02:51 PM Aaron Marcuse-Kubitza

sql_gen.py: Table: Added order_by attr to cache the results of table_order_by()

5523 10/15/2012 02:36 PM Aaron Marcuse-Kubitza

sql.select() calls: Removed order_by=None everywhere that a stable row order is required (i.e. consistent between selects, or consistent between table transformations). This causes several tests to return different inserted row counts, because the input table is now being accessed in pkey order instead of in table order. This fixes a bug where tables with more rows than ~100 would return different results for repeated calls of the same non-ordered select.

5522 10/15/2012 02:27 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): Use table_order_by() instead of table_pkey_col() to determine what column(s) to order by if order_by is set to order_by_pkey

5521 10/15/2012 02:26 PM Aaron Marcuse-Kubitza

sql.py: Added table_pkey_index(), index_order_by(), table_cluster_on(), table_order_by()

5520 10/15/2012 01:10 PM Aaron Marcuse-Kubitza

sql.py: Added index_exprs() and use it in index_cols()

5519 10/15/2012 01:08 PM Aaron Marcuse-Kubitza

README.TXT: Data import: On local machine: Added `make inputs/.TNRS/cleanup`, which is necessary because the PostgreSQL collation may differ between vegbiendev's and your DB

5518 10/15/2012 12:24 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonconcept: taxonconcept_update_ancestors(): Use matched_concept_id's ancestors instead if available. (Recursively applied, this will use the ancestors of the accepted concept.) This facilitates finding all children of and matches to an accepted concept, which will all have an entry for that concept in taxonconcept_ancestor. Note that the concept's own parents will not be indexed in taxonconcept_ancestor, because only accepted ancestors are now stored in taxonconcept_ancestor. Documented that taxonconcept_ancestor now stores the accepted ancestors of a taxonconcept.

View all revisions | View revisions

Also available in: Atom