Annotation: unit_tests.create_dummy_brands

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_brands()
RETURNS void

Information: unit_tests.create_dummy_brands

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

Implementation: unit_tests.create_dummy_brands

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_brands()
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM core.brands WHERE brand_code='dummy-br01') THEN        
        INSERT INTO core.brands(brand_code, brand_name)
        SELECT 'dummy-br01', 'Test Mock Brand';
    END IF;

    RETURN;
END
$function$