Annotation: unit_tests.create_dummy_users

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_users()
RETURNS void

Information: unit_tests.create_dummy_users

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

Implementation: unit_tests.create_dummy_users

CREATE OR REPLACE FUNCTION unit_tests.create_dummy_users()
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM office.users WHERE user_name='plpgunit-test-user-000001') THEN
        INSERT INTO office.users(role_id, user_name, full_name, password, office_id)
        SELECT office.get_role_id_by_role_code('USER'), 'plpgunit-test-user-000001', 'PLPGUnit Test User', 'thoushaltnotlogin', office.get_office_id_by_office_code('dummy-off01');
    END IF;
END
$function$