Annotation: unit_tests.create_dummy_offices

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_offices()
RETURNS void

Information: unit_tests.create_dummy_offices

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

Implementation: unit_tests.create_dummy_offices

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_offices()
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM office.offices WHERE office_code='dummy-off01') THEN
        INSERT INTO office.offices(office_code, office_name, nick_name, registration_date, currency_code, allow_transaction_posting)
        SELECT 'dummy-off01', 'PLPGUnit Test Office', 'PTO-DUMMY-0001', NOW()::date, 'NPR', true;
    END IF;

    RETURN;
END
$function$