Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 12779 almost 11 years Aaron Marcuse-Kubitza *{.sh,run}: use new begin_target instead of `ec...
  _archive 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  _license 14301 over 10 years Aaron Marcuse-Kubitza added derived/TNRS/Morphospecies and scope.eml*...
  backups 14334 over 10 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 14099 over 10 years Aaron Marcuse-Kubitza bin/import_all: hidden_srcs(): removed `by_col=...
  config 14064 over 10 years Aaron Marcuse-Kubitza fix: config/VirtualBox_VMs/vegbiendev/README.TX...
  derived 14298 over 10 years Aaron Marcuse-Kubitza added derived/TNRS/Morphospecies and scope.eml*...
  downloads 13537 over 10 years Aaron Marcuse-Kubitza added downloads/
  exports 13929 over 10 years Aaron Marcuse-Kubitza exports/2014-6-4.Iara_Lacher.reserve_prioritiza...
  inputs 14332 over 10 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: taxon_match: COMMENT: ...
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 14074 over 10 years Aaron Marcuse-Kubitza bugfix: lib/sql_io.py: put_table(): handle_Miss...
  mappings 13947 over 10 years Aaron Marcuse-Kubitza fix: mappings/VegCore-VegBIEN.csv: mapped DwC y...
  planning 13880 over 10 years Aaron Marcuse-Kubitza planning/meetings/BIEN conference call availabi...
  schemas 14344 over 10 years Aaron Marcuse-Kubitza bugfix: schemas/util.sql: rematerialize_view():...
  validation 13963 over 10 years Aaron Marcuse-Kubitza validation/completeness/BIENDatesPopulated.xlsx...
  web 14336 over 10 years Aaron Marcuse-Kubitza web/username_prefix.php: substitutions: also su...
  wiki 13787 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: use lowercase when there is a s...
.htaccess 326 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_filter.upload 33 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_ignore 12 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
LICENSE.TXT 6.17 KB 13787 over 10 years Aaron Marcuse-Kubitza **/LICENSE.TXT: use lowercase when there is a s...
Makefile 12.9 KB 14068 over 10 years Aaron Marcuse-Kubitza bugfix: /Makefile: postgres_restart-*: argument...
README.TXT 34.4 KB 14197 over 10 years Aaron Marcuse-Kubitza bugfix: /README.TXT: Full database import: adde...
fix_perms 97 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
map 1001 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
new_terms.csv 80.2 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
run 518 Bytes 12968 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
unmapped_terms.csv 33 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
14344 07/26/2014 04:53 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: rematerialize_view(): don't populate unless recreate() can successfully recreate the dependent views, to avoid populating the entire table (which for some views can take hours) only to have the changes rolled back by a failing dependent view

14343 07/26/2014 04:42 AM Aaron Marcuse-Kubitza

schemas/util.sql: removed no longer used materialize_view(). use util.copy() instead.

14342 07/26/2014 04:41 AM Aaron Marcuse-Kubitza

schemas/util.sql: rematerialize_view(): call util.copy() directly instead of via util.materialize_view()

14341 07/26/2014 04:35 AM Aaron Marcuse-Kubitza

schemas/util.sql: removed no longer used copy_types_and_data(). use util.materialize_view() instead.

14340 07/26/2014 04:20 AM Aaron Marcuse-Kubitza

schemas/util.sql: to_freq(): use util.copy() instead of util.copy_types_and_data() to avoid a dependency on util.copy_types_and_data()

14339 07/25/2014 09:57 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: copy_data(): also need to ANALYZE table after loading data into it

14338 07/25/2014 09:13 PM Aaron Marcuse-Kubitza

schemas/public_.sql: analytical_stem_view: use viewFullOccurrence_individual_view to avoid duplicated code between the views. this moves the stem-related columns to the end of the view.

14337 07/25/2014 06:26 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added viewFullOccurrence_individual_view

14336 07/25/2014 06:20 PM Aaron Marcuse-Kubitza

web/username_prefix.php: substitutions: also support "" because Postgres doubles " to escape them

14335 07/25/2014 06:17 PM Aaron Marcuse-Kubitza

web/username_prefix.php: added support for substitutions ( x."_y@url -> x.x_y@url ), which can be used when a table name is repeated in a column name

View revisions

Also available in: Atom