buildings_functions.pg

------------------------------------------------------------------------------
-- Provide unit testing for buildings functions using pgTAP
------------------------------------------------------------------------------

-- Turn off echo.
\set QUIET 1

-- Format the output nicely.
\pset format unaligned
\pset tuples_only true
\pset pager

-- Revert all changes on failure.
\set ON_ERROR_ROLLBACK 1
\set ON_ERROR_STOP true

BEGIN;
SELECT plan(3);

-- Tests
--Buildings-------------------------
SELECT set_has(
    'SELECT building_id FROM buildings.buildings',
    $$VALUES (1000029)$$,
    'Check contents of buildings table after buildings_insert function has run'
);

--Building Outlines-------------------------
SELECT set_has(
    'SELECT building_outline_id FROM buildings.building_outlines',
    $$VALUES (1000033)$$,
    'Check contents of building outlines table after building_outlines_insert function has run'
);

--Existing Subset Extracts-------------------------
SELECT set_has(
    'SELECT building_outline_id FROM buildings_bulk_load.existing_subset_extracts',
    $$VALUES (1000000)$$,
    'Check contents of existing subset extracts table after existing_subset_extracts_insert function has run'
);


-- Finish pgTAP testing
SELECT * FROM finish();

ROLLBACK;