生成时间维度表 mysql

CREATE TABLE time_dimension (
    time_id INT AUTO_INCREMENT PRIMARY KEY,
    date DATE NOT NULL,
    year INT NOT NULL,
    quarter INT NOT NULL,
    month INT NOT NULL,
    day INT NOT NULL,
    weekday VARCHAR(10) NOT NULL,
    is_weekend BOOLEAN NOT NULL,
    is_holiday BOOLEAN NOT NULL
);

DELIMITER $$
CREATE PROCEDURE generate_time_dimension(IN start_date DATE, IN end_date DATE)
BEGIN
    DECLARE current_date DATE;
    SET current_date = start_date;
    WHILE current_date <= end_date DO
        INSERT INTO time_dimension (
            date,
            year,
            quarter,
            month,
            day,
            weekday,
            is_weekend,
            is_holiday
        ) VALUES (
            current_date,
            YEAR(current_date),
            QUARTER(current_date),
            MONTH(current_date),
            DAY(current_date),
            DAYNAME(current_date),
            DAYOFWEEK(current_date) IN (1, 7),
            CASE WHEN current_date IN ('2023-01-01', '2023-12-25') THEN TRUE ELSE FALSE END
        );
        SET current_date = DATE_ADD(current_date, INTERVAL 1 DAY);
    END WHILE;
END$$
DELIMITER ;

CALL generate_time_dimension('2023-01-01', '2023-12-31');