Project

General

Profile

Statistics
| Revision:

# Date Author Comment
12404 02/24/2014 08:37 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: renamed truncated views to match the output queries

12403 02/24/2014 12:30 AM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: can't double-JOIN like in MySQL (`JOIN a JOIN b ON a_conds AND b_conds`), so split double-JOIN into two JOINs w/ own ON clauses

12402 02/24/2014 12:28 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: removed `LIMIT 10` to match output queries

12401 02/24/2014 12:26 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: updated table names to match our renamings

12398 02/24/2014 12:21 AM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: can't double-JOIN like in MySQL (`JOIN a JOIN b ON a_conds AND b_conds`), so split double-JOIN into two JOINs w/ own ON clauses

12397 02/24/2014 12:16 AM Aaron Marcuse-Kubitza

added validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql, modified from bien3_validations_salvias_db_original.sql using the steps at http://wiki.vegpath.org/Aggregating_validations_refactoring

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.

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*

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

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

12159 02/13/2014 07:41 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: removed type-specific prefix from the view name, which is now part of the validation schema

12068 02/06/2014 04:16 PM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql (the output queries): added `SET search_path TO validation`

12065 02/06/2014 04:03 PM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: added CREATE VIEW prefixes using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW

12064 02/06/2014 03:47 PM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: added CREATE VIEW prefixes using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW

12061 02/06/2014 01:56 PM Aaron Marcuse-Kubitza

validation/**: removed by=... indicators so that we don't have to add an author name every time a file is changed. the author indicator is not needed now that both Brad's and my edits are open-source.

12058 02/06/2014 11:09 AM Aaron Marcuse-Kubitza

added validation/aggregating/plots/FIA/bien3_validations_fia_input.sql.eml.txt. note that a .url file is not needed because this information is in the .eml.txt file.

12056 02/06/2014 10:49 AM Aaron Marcuse-Kubitza

added validation/aggregating/plots/FIA/

12055 02/06/2014 03:46 AM Aaron Marcuse-Kubitza

validation/aggregating/*.by=Brad@iPlant*: placed under version control, since these are now open-source

12054 02/06/2014 03:41 AM Aaron Marcuse-Kubitza

validation/**: removed svn:ignore exclusion of iPlant-owned files, since these are now open-source

12033 02/03/2014 01:54 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/_archive/bien3_validations_salvias_vegbien.by=: removed trailing @

12021 02/02/2014 05:30 PM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.by=: moved to _archive/ so only the most recent version would be in the main plots/ directory

12009 01/24/2014 11:22 PM Aaron Marcuse-Kubitza

added validation/aggregating/, containing folders for Brad's scripts (the scripts themselves cannot be in the repository because they are not UCSB-owned)