vRYJjfiQ

1USE kodilla_course;
2
3CREATE TABLE STATS (
4	STAT_ID INT(11) AUTO_INCREMENT PRIMARY KEY,
5	STAT_DATE DATETIME NOT NULL,
6	STAT VARCHAR(20) NOT NULL,
7	VALUE INT(11) NOT NULL
8);
9
10DROP VIEW IF EXISTS BESTSELLERS_COUNT;
11
12CREATE VIEW BESTSELLERS_COUNT AS
13	SELECT COUNT(*) AS THE_COUNT FROM books b 
14	  WHERE b.bestseller = TRUE;
15      
16DROP EVENT IF EXISTS UPDATE_BESTSELLERS_EVENT;
17      
18DELIMITER $$
19      
20CREATE EVENT UPDATE_BESTSELLERS_EVENT
21	ON SCHEDULE EVERY 10 SECOND
22    DO
23		BEGIN
24			CALL UpdateBestsellerStatus();
25            INSERT INTO STATS(STAT_DATE, STAT, VALUE)
26              VALUES (CURDATE(), "BESTSELLER", (SELECT THE_COUNT FROM BESTSELLERS_COUNT));
27		END $$
28    
29DELIMITER ;