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...
  backups 10752 almost 11 years Aaron Marcuse-Kubitza updated backups/TNRS.backup.md5
  bin 10742 almost 11 years Aaron Marcuse-Kubitza bin/tnrs_db: add entry to new batch table
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  derived 10707 almost 11 years Aaron Marcuse-Kubitza added derived/biengeo/ from https://projects.nc...
  exports 9928 about 11 years Aaron Marcuse-Kubitza added exports/_archive/
  inputs 10839 almost 11 years Aaron Marcuse-Kubitza bugfix: inputs/input.Makefile: %/test: in by_co...
  lib 10843 almost 11 years Aaron Marcuse-Kubitza bugfix: lib/sql_io.py: put_table(): DuplicateKe...
  mappings 10722 almost 11 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped datasetURL
  planning 10806 almost 11 years Aaron Marcuse-Kubitza planning/timeline/timeline.2013.xls: updated fo...
  schemas 10833 almost 11 years Aaron Marcuse-Kubitza added schemas/postgresql*.conf.run, which insta...
  web 10837 almost 11 years Aaron Marcuse-Kubitza fix: web/links/index.htm: PostgreSQL: vacuuming...
.htaccess 326 Bytes 8771 about 11 years Aaron Marcuse-Kubitza /.htaccess: use canonical URL without symlinks
.rsync_filter.upload 33 Bytes 10042 about 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
.rsync_ignore 12 Bytes 10042 about 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
Makefile 12.6 KB 10539 almost 11 years Aaron Marcuse-Kubitza bugfix: /Makefile: postgres-Linux: phppgadmin.c...
README.TXT 23.8 KB 10820 almost 11 years Aaron Marcuse-Kubitza bugfix: /README.TXT: on a live machine, you sho...
fix_perms 97 Bytes 7560 over 11 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 over 11 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 over 11 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
run 660 Bytes 10828 almost 11 years Aaron Marcuse-Kubitza /run: taxon_trait/make(): order by scientificNa...
unmapped_terms.csv 13.1 KB 7201 over 11 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
10843 08/31/2013 05:52 PM Aaron Marcuse-Kubitza

bugfix: lib/sql_io.py: put_table(): DuplicateKeyException: need to include any index cond in the join condition, so that an index scan can be used instead of a much slower full-table sort (otherwise the query planner will not know that it can restrict results to rows satisfying the index cond)

10842 08/31/2013 05:48 PM Aaron Marcuse-Kubitza

lib/sql_gen.py: Join: added custom_cond param that can be used to add to the JOIN condition

10841 08/31/2013 01:02 AM Aaron Marcuse-Kubitza

lib/sql.py: distinct_table(): support custom filters on the distincting query

10840 08/31/2013 01:01 AM Aaron Marcuse-Kubitza

lib/sql_gen.py: ColValueCond: support conds that are just plain SQL (without separate left and right sides) using special custom_cond flag value

10839 08/30/2013 11:18 PM Aaron Marcuse-Kubitza

bugfix: inputs/input.Makefile: %/test: in by_col mode, also need to run %/test.by_col.xml

10838 08/30/2013 10:38 PM Aaron Marcuse-Kubitza

lib/sql_io.py: ensure_cond(): documented meaning of passed, failed params (at least one row passed/failed the constraint)

10837 08/30/2013 06:28 PM Aaron Marcuse-Kubitza

fix: web/links/index.htm: PostgreSQL: vacuuming: moved info about autovacuum process being aborted to correct bookmark

10836 08/30/2013 06:25 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. PostgreSQL: added info on vacuuming and analyzing.

10835 08/30/2013 06:06 PM Aaron Marcuse-Kubitza

lib/runscripts/util.run: usage: documented that this usage also applies to all files that include this file

10834 08/30/2013 06:06 PM Aaron Marcuse-Kubitza

lib/runscripts/util.run: usage: clarified that the cmd to run is a function

View all revisions | View revisions

Also available in: Atom