Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  pipeline 12171 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/pipeline/aggregating_val...
  plots 12224 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/*/*.sql, schemas/vegbien...
  specimens 12224 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/*/*.sql, schemas/vegbien...
  traits 12224 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/*/*.sql, schemas/vegbien...

Latest revisions

# Date Author Comment
12224 02/14/2014 03:09 PM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql, schemas/vegbien.sql, lib/runscripts/validations.pg.sql.run, inputs/bien2_traits/validations.sql: added _ to beginning of each view name so the validation views would sort at the top in the datasource's tables list. this will also make the validation result sets easily distinguishable from the data tables.

12223 02/14/2014 02:34 PM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: renamed views to match the current naming scheme in the DB. these files still need to be kept up-to-date because there are some queries that haven't been implemented yet, and therefore exist only in these files, not the DB.

12219 02/14/2014 12:03 PM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original_mysql.VegCore.sql: added util to search_path so that IFNULL would link to util.ifnull()

12188 02/13/2014 04:10 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original_mysql.VegCore.sql: added view names using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW

12187 02/13/2014 04:10 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original_mysql.VegCore.sql: removed trailing whitespace

12172 02/13/2014 10:41 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql, validation/aggregating/*/*.sql: renamed public_validation_* to plural public_validations_* since we refer to them as aggregating validation*s*

12171 02/13/2014 10:33 AM Aaron Marcuse-Kubitza

validation/aggregating/pipeline/aggregating_validations_pipeline.odg: made "diff tables" the same size as the other major labels

12170 02/13/2014 10:30 AM Aaron Marcuse-Kubitza

validation/aggregating/pipeline/aggregating_validations_pipeline.odg: added CSVs export arrows and import process arrows, as decided in conference call

12167 02/13/2014 08:26 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _12_count_of_verbatim_taxa_per_plot_in_each_project: removed typo (in the original queries, not added by the refactoring)

12166 02/13/2014 08:23 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: shortened view names to fit in the 63-char limit

View revisions

Also available in: Atom