Annotation: localization.add_localized_resource

Information: localization.add_localized_resource

Implementation: localization.add_localized_resource

CREATE OR REPLACE FUNCTION localization.add_localized_resource(text, text, text)
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
    IF EXISTS
    (
        SELECT 1 FROM localization.localized_resources 
        WHERE localization.localized_resources.culture_code=$1 
        AND localization.localized_resources.key=$2
    ) THEN
        UPDATE localization.localized_resources
        SET value=$3
        WHERE localization.localized_resources.culture_code=$1 AND key=$2;

        RETURN;
    END IF;

    INSERT INTO localization.localized_resources(culture_code, key, value)
    SELECT $1, $2, $3;
END
$function$