-- 创建自定义函数，用于将阿拉伯数字转换为罗马数字
DELIMITER $$

CREATE FUNCTION arabic_to_roman(n INT) RETURNS VARCHAR(5)
    DETERMINISTIC
BEGIN
    DECLARE result VARCHAR(5);
    SET result = '';

    -- 使用简单的条件语句转换数字
    CASE n
        WHEN '1' THEN SET result = 'I';
        WHEN '2' THEN SET result = 'II';
        WHEN '3' THEN SET result = 'III';
        WHEN '4' THEN SET result = 'IV';
        WHEN '5' THEN SET result = 'V';
        WHEN '6' THEN SET result = 'VI';
        WHEN '7' THEN SET result = 'VII';
        WHEN '8' THEN SET result = 'VIII';
        ELSE SET result = 'Invalid';
    END CASE;

    RETURN result;
END$$

DELIMITER ;


-- 创建自定义函数，用于将阿拉伯数字转换为罗马数字
DELIMITER $$

CREATE FUNCTION arabic_to_roman2(n INT) RETURNS VARCHAR(5)
    DETERMINISTIC
BEGIN
    DECLARE result VARCHAR(5);
    SET result = '';

    -- 使用简单的条件语句转换数字
    CASE n
        WHEN '1' THEN SET result = '01';
        WHEN '2' THEN SET result = '02';
        WHEN '3' THEN SET result = '03';
        WHEN '4' THEN SET result = '04';
        WHEN '5' THEN SET result = '05';
        WHEN '6' THEN SET result = '06';
        WHEN '7' THEN SET result = '07';
        WHEN '8' THEN SET result = '08';
        WHEN '9' THEN SET result = '09';
        ELSE SET result = 'Invalid';
    END CASE;

    RETURN result;
END$$

DELIMITER ;

-- ALTER TABLE your_table_name MODIFY COLUMN session_idx VARCHAR(10);
-- DROP FUNCTION IF EXISTS arabic_to_roman;
-- DROP FUNCTION IF EXISTS arabic_to_roman2;

UPDATE visualization_playerepisode SET session_idx = arabic_to_roman(1) where session_idx = '1';