/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 12163

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

     -- Check: join to source db by all columns returns same number of rows
     -- ------------------
     CREATE OR REPLACE VIEW _05_list_of_plot_codes_by_project AS
     SELECT p.projectname, l.authorlocationcode AS plotCode
     SELECT p.projectname, l.authorlocationcode AS "plotCode"
     FROM location l JOIN locationevent le
     ON l.location_id=le.location_id
     JOIN project p
-...
     CREATE OR REPLACE VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project AS
     select p.projectname,
     l.authorlocationcode as plotcode,
     sub_locationevent.authoreventcode as subplotCode
     sub_locationevent.authoreventcode as "subplotCode"
     from project p join source s
     on p.source_id=s.source_id
     join locationevent le on p.project_id=le.project_id

     -- 1. Count records
     -- ------------------
     CREATE OR REPLACE VIEW _01_count_records AS
     SELECT COUNT(*) AS totalRecords
     SELECT COUNT(*) AS "totalRecords"
     FROM trait
     JOIN taxonoccurrence USING (taxonoccurrence_id)
     WHERE taxonoccurrence.source_id = source_by_shortname(current_schema)

Also available in: Unified diff