Annotation: unit_tests.create_dummy_units

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_units()
RETURNS void

Information: unit_tests.create_dummy_units

Schema	unit_tests
Function Name	create_dummy_units
Arguments
Owner	postgres
Result Type	void
Description

Implementation: unit_tests.create_dummy_units

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_units()
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM core.units WHERE unit_code='dummy-uni01') THEN        
        INSERT INTO core.units(unit_code, unit_name)
        SELECT 'dummy-uni01', 'Test Mock Unit';
    END IF;

    RETURN;
END
$function$