Database Sample v2 | Spring Template Projesi

---

Sample SQL v2:

http://www.notes.selmankaya.com/wp-content/uploads/2022/12/spring_template_sample_db_v2.sql

---

DROP FUNCTION IF EXISTS dmGetTranslation;

DELIMITER //
CREATE FUNCTION dmGetTranslation(keyCode VARCHAR(256), langCode VARCHAR(16)) 
RETURNS VARCHAR(4000)
DETERMINISTIC
BEGIN
    DECLARE translationValue VARCHAR(4000);
    
    SELECT T.trans_value INTO translationValue FROM dm_tbl_translation T WHERE T.trans_key = keyCode AND T.trans_lang_code = langCode;

	IF translationValue IS NULL THEN 
        SELECT T.trans_value INTO translationValue FROM dm_tbl_translation T INNER JOIN dm_tbl_language L ON L.lang_code = T.trans_lang_code WHERE T.trans_key = keyCode AND L.lang_is_primary = TRUE;
     END IF;


	RETURN (translationValue);
END//
DELIMITER ;

SELECT dmGetTranslation('TUR', 'TR') FROM DUAL;