aonestar.public

Parameters

Name	Type	Mode
field_desc	text	IN
old_value	anyelement	IN
new_value	anyelement	IN
lookup_table	text	IN (DEFAULT NULL)
lookup_key	text	IN (DEFAULT 'id')
lookup_name	text	IN (DEFAULT 'name')
bool_true	text	IN (DEFAULT 'has checked')
bool_false	text	IN (DEFAULT 'has unchecked')
single_line	boolean	IN (DEFAULT true)

Definition

DECLARE 
    stmt TEXT = $$Select %I::text FROM %I WHERE %I = $1$$;
    old_text TEXT;
    new_text TEXT;
    names text[];
BEGIN
    IF old_value IS NOT DISTINCT FROM new_value THEN 
        RETURN '';    
    END IF;

    IF lookup_table IS NOT NULL THEN 
        stmt := format(stmt, lookup_name, lookup_table, lookup_key);
        EXECUTE stmt USING old_value INTO old_text;
        EXECUTE stmt USING new_value INTO new_text;
--    ELSIF map_keys IS NOT NULL THEN
--        old_text := map_texts[array_position(ARRAY[map_keys], old_value)];
--        new_text := map_texts[array_position(ARRAY[map_keys], new_value)];
    ELSE 
        old_text := old_value::TEXT;
        new_text := new_value::TEXT;
    END IF;
    
    IF single_line THEN 
        RETURN format(E'* Change %s from %s to %s\n', field_desc, COALESCE('"'||old_text||'"','NONE'), COALESCE('"'||new_text||'"','NONE'));
    ELSE 
        old_text := REPLACE(old_text, E'\n', E'\n        ');
        new_text := REPLACE(new_text, E'\n', E'\n        ');
        RETURN format(E'* Change %s\n  From: %s\n  To  : %s\n', field_desc, COALESCE(old_text,'NONE'), COALESCE(new_text,'NONE'));
    END IF;
END

fn_format_log

Parameters

Definition