buildings_bulk_load_functions.pg

------------------------------------------------------------------------------
-- Provide unit testing for buildings_bulk_load 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(2);

-- Tests
--Bulk Load Outlines-------------------------
SELECT results_eq(
    'SELECT bulk_load_outline_id FROM buildings_bulk_load.bulk_load_outlines WHERE supplied_dataset_id = 3',
    $$VALUES (1000000)$$,
   'Check contents of bulk load outlines table after bulk_load_outlines_insert function has run'
);

--Supplied Datasets-------------------------
SELECT set_has(
    'SELECT description, supplier_id FROM buildings_bulk_load.supplied_datasets',
    $$VALUES('Test Dataset', 1)$$,
    'Check contents of supplied datasets table after supplied_datasets_insert function has run'
);


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

ROLLBACK;