27 lines
1.2 KiB
SQL
27 lines
1.2 KiB
SQL
DELIMITER $$
|
|
CREATE PROCEDURE insertOptionDetails()
|
|
BEGIN
|
|
DECLARE i INT DEFAULT 0;
|
|
DECLARE var_menu_option_id INT;
|
|
DECLARE count_menu_option INT;
|
|
|
|
SET count_menu_option = (SELECT COUNT(*) FROM `menu_option`);
|
|
|
|
WHILE(i < count_menu_option) DO
|
|
SET var_menu_option_id = (SELECT menu_option_id
|
|
FROM `menu_option`
|
|
LIMIT i, 1);
|
|
|
|
INSERT IGNORE INTO `option_detail` (name, extra_price, created_at, created_by, updated_at, updated_by, menu_option_id)
|
|
VALUES ('MEDIUM', FLOOR(RAND() * 3 + 1) * 1000, now(), 'system', now(), 'system', var_menu_option_id);
|
|
INSERT IGNORE INTO `option_detail` (name, extra_price, created_at, created_by, updated_at, updated_by, menu_option_id)
|
|
VALUES ('LARGE', FLOOR(RAND() * 3 + 1) * 1000, now(), 'system', now(), 'system', var_menu_option_id);
|
|
INSERT IGNORE INTO `option_detail` (name, extra_price, created_at, created_by, updated_at, updated_by, menu_option_id)
|
|
VALUES ('VENTI', FLOOR(RAND() * 3 + 1) * 1000, now(), 'system', now(), 'system', var_menu_option_id);
|
|
|
|
SET i = i + 1;
|
|
END WHILE;
|
|
END$$
|
|
DELIMITER ;
|
|
|
|
CALL insertOptionDetails(); |