Project

General

Profile

Statistics
| Revision:
  • svn:ignore: *.csv *.out *.tsv *.txt *.xls *.xlsx

# Date Author Comment
12040 02/04/2014 10:42 AM Aaron Marcuse-Kubitza

bugfix: inputs/SALVIAS/verify/plots.out.sql: fixed ' quoting syntax to use '' instead of \' to escape '

12039 02/04/2014 10:32 AM Aaron Marcuse-Kubitza

inputs/input.Makefile: verify/%.out: use a *.sql file in the verify/ directory itself to generate *.out, so that each datasource can have its own set of output queries. for datasources that should share the same set of queries, they can instead be symlinked to the same file.

12018 02/02/2014 12:49 AM Aaron Marcuse-Kubitza

inputs/input.Makefile: add!: verify/: also svn:ignore *.tsv, *.txt

11970 01/20/2014 11:33 AM Aaron Marcuse-Kubitza

moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).

6805 12/12/2012 06:07 PM Aaron Marcuse-Kubitza

input.Makefile: SVN: add: verify: Also ignore *.xlsx

6649 12/06/2012 05:23 PM Aaron Marcuse-Kubitza

inputs/input.Makefile: SVN: add: verify/: Added *.xls to svn:ignore

6580 12/04/2012 07:57 PM Aaron Marcuse-Kubitza

inputs/*/verify/: Updated svn:ignore

6001 11/05/2012 08:34 PM Aaron Marcuse-Kubitza

mappings/verify.plots.sql: Added # locations, # location events, which also include subplots

6000 11/05/2012 08:17 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref.sql: Standardized line wrapping to put ; on its own line in multi-line queries and at the end of the line in one-line queries

5999 11/05/2012 08:13 PM Aaron Marcuse-Kubitza

mappings/verify.plots.sql: Added "top-level" to # locations, # location events names because these queries do not include all locations

5998 11/05/2012 07:52 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref.sql: # locations: Fixed count to include all plotMetadata entries instead of just unique coordinates, because each plotMetadata entry now gets its own location

5994 11/05/2012 05:04 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref: Regenerated on vegbiendev using the PostgreSQL 9.1 pg_catalog.default collation

5982 11/02/2012 06:04 PM Aaron Marcuse-Kubitza

mappings/verify.plots.sql, inputs/SALVIAS/verify/plots.ref.sql: Renamed project column to projectname to avoid confusion with the project table

5980 11/02/2012 05:57 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref.sql: Use project_name instead of project_id everywhere, not just as the ID to list for each project, to match the corresponding VegBIEN queries

5978 11/02/2012 05:34 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref.sql: Use project_name instead of project_id as the ID to list for each project, since the SALVIAS projects table is now mapped to the DB and the project_name is used as project.projectname

4471 09/05/2012 08:34 AM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref: Regenerated on PostgreSQL staging tables. The orders have changed slightly because this is derived from a PostgreSQL translation of the queries, with corresponding changes in collations and NULL sort orders. The counts have also changed slightly, possibly due to the changes Brad made to the salvias_plots database on nimoy after the initial version was downloaded. (The current counts are correct according to the current salvias_plots database.)

4470 09/05/2012 08:31 AM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref.sql: # locations: Fixed bug where a NULL value in LatDec or LongDec would propagate to the concatenated value, reducing its uniqueness

4469 09/05/2012 08:14 AM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref.sql: Retrofitted to work with PostgreSQL staging tables

1199 02/28/2012 05:45 PM Aaron Marcuse-Kubitza

input.Makefile: Moved verify files into separate subdir