Z9z3xCbs

1
2USE kodilla_project;
3DROP TABLE IF EXISTS STATS;
4CREATE TABLE STATS (
5	STAT_ID INT(11) AUTO_INCREMENT,
6	STAT_DATE DATETIME NOT NULL,
7	STAT VARCHAR(20) NOT NULL,
8	VALUE INT(11) NOT NULL,
9	PRIMARY KEY (`STAT_ID`) 
10  );
11  
12
13DROP VIEW IF EXISTS BESTSELLERS_COUNT;
14CREATE VIEW BESTSELLERS_COUNT(bestseller_quantity)
15AS SELECT COUNT(*) FROM BOOKS
16WHERE BESTSELLER = 1; 
17
18
19DROP EVENT IF EXISTS UPDATE_BESTSELLERS;    
20CREATE EVENT UPDATE_BESTSELLERS
21	ON SCHEDULE EVERY 1 MINUTE
22    DO CALL UpdateBestsellers();
23
24USE kodilla_project;
25DROP EVENT IF EXISTS UPDATE_STAT;    
26CREATE EVENT UPDATE_STAT
27	ON SCHEDULE EVERY 1 MINUTE
28    DO INSERT INTO STATS(
29			STAT_DATE,
30            STAT,
31            VALUE
32            )
33		SELECT 
34        CURDATE(),
35        "BESTSELLERS",
36        bestseller_quantity
37        FROM BESTSELLERS_COUNT;