Annotation: unit_tests.create_dummy_countries

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_countries()
RETURNS void

Information: unit_tests.create_dummy_countries

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

Implementation: unit_tests.create_dummy_countries

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_countries()
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM core.countries WHERE country_code='dummy-co01') THEN        
        INSERT INTO core.countries(country_code, country_name)
        SELECT 'dummy-co01', 'Test Mock Country';
    END IF;

    RETURN;
END
$function$