Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2_traits 12224 over 10 years Aaron Marcuse-Kubitza validation/aggregating/*/*.sql, schemas/vegbien...
  _archive 12062 over 10 years Aaron Marcuse-Kubitza validation/**: removed old versions of by=-tagg...
bien3_validations_traits_bien3.sql 3.32 KB 12224 over 10 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*

12163 02/13/2014 08:02 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: use "" to preserve case in column aliases, so that they match the input queries

12162 02/13/2014 07:58 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: use current_schema instead of a hardcoded datasource name or psql variable

12161 02/13/2014 07:49 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: search_path: added public

12160 02/13/2014 07:45 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: use the new type-specific validation schema names

View revisions

Also available in: Atom