Annotation: unit_tests.create_dummy_late_fees

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_late_fees()
RETURNS void

Information: unit_tests.create_dummy_late_fees

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

Implementation: unit_tests.create_dummy_late_fees

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_late_fees()
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM core.late_fee WHERE late_fee_code='dummy-lf01') THEN        
        INSERT INTO core.late_fee(late_fee_code, late_fee_name, is_flat_amount, rate)
        SELECT 'dummy-lf01', 'Test Mock Late Fee', false, 22;
    END IF;

    RETURN;
END
$function$