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

12380 02/23/2014 05:55 PM Aaron Marcuse-Kubitza

added validation/aggregating/traits/BIEN2_traits/_archive/bien3_validations_traits_complete.sql from Brad's e-mail

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

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

12069 02/06/2014 04:48 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/bien3_validations_traits_bien3.sql: include only records from the bien2_traits datasource, to ensure that the scope of all queries is limited to the datasource

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

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

12067 02/06/2014 04:12 PM Aaron Marcuse-Kubitza

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

12066 02/06/2014 04:11 PM Aaron Marcuse-Kubitza

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

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

12063 02/06/2014 02:48 PM Aaron Marcuse-Kubitza

added validation/aggregating/specimens/qualitative_validations_specimens.sql template, with query descriptions from NY/qualitative_validations_source_db_NYBG.sql

12062 02/06/2014 02:08 PM Aaron Marcuse-Kubitza

validation/**: removed old versions of by=-tagged files. these were not renamed in the last commit because there were newer versions that they collided with. note that because , sorts before . , the newer version (with more ",name@inst" tags) was correctly renamed instead of the older version.

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.

12059 02/06/2014 12:33 PM Aaron Marcuse-Kubitza

added validation/aggregating/pipeline/aggregating_validations_pipeline.odg with .png export

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.

12057 02/06/2014 10:57 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/traits/_archive/bien3_validations_traits_bien3.by=: renamed to indicate that this is actually not Brad's original file, as the filename would seem to indicate

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

12037 02/04/2014 04:21 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/traits/_archive/bien3_validations_traits_bien3.by=Brad@iPlant,Aaron@UCSB,: added missing .url extension

12036 02/03/2014 05:50 PM Aaron Marcuse-Kubitza

added validation/aggregating/traits/_archive/bien3_validations_traits_bien3.by=Brad@iPlant,Aaron@UCSB,

12035 02/03/2014 05:37 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/BIEN2_traits/_archive/bien3_validations_traits_original_mysql.by=Brad@iPlant,Aaron@UCSB,: renamed to indicate that it's just by Brad (it was the other file, the output queries, that were created by both of us)

12034 02/03/2014 05:32 PM Aaron Marcuse-Kubitza

added validation/aggregating/traits/BIEN2_traits/_archive/bien3_validations_traits_original_mysql.by=Brad@iPlant,Aaron@UCSB,

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

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

12032 02/03/2014 01:53 AM Aaron Marcuse-Kubitza

deleted validation/aggregating/traits/_archive/bien3_validations_traits_bien3.by=@, since there is already a version without the trailing @

12031 02/03/2014 01:48 AM Aaron Marcuse-Kubitza

validation/aggregating/traits/BIEN2_traits/_archive/bien3_validations_traits_original.by=: removed trailing (apparently, the escape for paths containing @ should only be used on the input path)

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

12017 02/01/2014 11:57 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/bien3_validations_traits_bien3.by=*: moved to _archive/

12016 02/01/2014 11:57 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original.by=*: moved to _archive/

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)