Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  branches 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 12228 almost 11 years Aaron Marcuse-Kubitza schemas/util.sql: added materialize_query()
  • svn:ignore: extern

Latest revisions

# Date Author Comment
12228 02/15/2014 02:46 PM Aaron Marcuse-Kubitza

schemas/util.sql: added materialize_query()

12227 02/15/2014 04:08 AM Aaron Marcuse-Kubitza

/README.TXT: Schema changes: clarified that the staging tables should only be reinstalled if needed

12226 02/15/2014 04:08 AM Aaron Marcuse-Kubitza

/README.TXT: put ... around all uppercased text, for consistency

12225 02/14/2014 04:36 PM Aaron Marcuse-Kubitza

_license/non-open-source/applies_to.txt: clarified that this is an exclusions list, not an inclusions list, in terms of what's open-source

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.

12222 02/14/2014 12:39 PM Aaron Marcuse-Kubitza

schemas/util.sql: ifnull(): use COALESCE instead, because it turns out that MySQL's IFNULL is just a special case of this

12221 02/14/2014 12:20 PM Aaron Marcuse-Kubitza

added inputs/bien2_traits/validations.sql, from validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original_mysql.VegCore.sql

12220 02/14/2014 12:20 PM Aaron Marcuse-Kubitza

inputs/input.Makefile: $(svnFilesGlob): added validations.sql

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()

View all revisions | View revisions

Also available in: Atom