Annotation: unit_tests.get_base_quantity_by_unit_id_test

Information: unit_tests.get_base_quantity_by_unit_id_test

Implementation: unit_tests.get_base_quantity_by_unit_id_test

CREATE OR REPLACE FUNCTION unit_tests.get_base_quantity_by_unit_id_test()
 RETURNS test_result
 LANGUAGE plpgsql
AS $function$
    DECLARE message test_result;
    DECLARE result boolean;
    DECLARE actual decimal;
    DECLARE expected decimal=345;
BEGIN

        INSERT INTO core.units(unit_code, unit_name)
        SELECT 'TUC-0000001', 'Test Unit 1' UNION ALL 
        SELECT 'TUC-0000002', 'Test Unit 2';


        INSERT INTO core.compound_units(base_unit_id, compare_unit_id, value)
        SELECT core.get_unit_id_by_unit_code('TUC-0000001'), core.get_unit_id_by_unit_code('TUC-0000002'), 345;

        SELECT core.get_base_quantity_by_unit_id(core.get_unit_id_by_unit_code('TUC-0000002'), 1) INTO actual;

        DELETE FROM core.compound_units WHERE base_unit_id = core.get_unit_id_by_unit_code('TUC-0000001');
        DELETE FROM core.units WHERE unit_code IN('TUC-0000001', 'TUC-0000002');

        RAISE NOTICE '%', actual;

        SELECT * FROM assert.is_equal(actual, expected) INTO message, result;        

        IF(result = false) THEN
                RETURN message;
        END IF;

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