Annotation: unit_tests.create_dummy_sales_teams

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_sales_teams()
RETURNS void

Information: unit_tests.create_dummy_sales_teams

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

Implementation: unit_tests.create_dummy_sales_teams

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_sales_teams()
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM core.sales_teams WHERE sales_team_code='dummy-st01') THEN        
        INSERT INTO core.sales_teams(sales_team_code, sales_team_name)
        SELECT 'dummy-st01', 'Test Mock Sales Team';
    END IF;

    RETURN;
END
$function$