Annotation: unit_tests.if_functions_compile

Information: unit_tests.if_functions_compile

Implementation: unit_tests.if_functions_compile

CREATE OR REPLACE FUNCTION unit_tests.if_functions_compile()
 RETURNS test_result
 LANGUAGE plpgsql
AS $function$
    DECLARE schemas text[];
    DECLARE message test_result;
    DECLARE result  boolean;
BEGIN

    schemas := ARRAY(
                SELECT nspname::text
                FROM pg_namespace
                WHERE nspname NOT LIKE 'pg%'
                AND nspname NOT IN('assert', 'unit_tests', 'information_schema')
                ORDER BY nspname
                );


    SELECT * FROM assert.if_functions_compile(VARIADIC schemas) INTO message, result;
    
    IF(result=false) THEN
        RETURN message;
    END IF;

    SELECT assert.ok('End of test.') INTO message;  
    RETURN message; 
END
$function$