nbfg2pBn

1CREATE TABLE STATS (
2STAT_ID INT(11) AUTO_INCREMENT PRIMARY KEY,
3STAT_DATE DATETIME NOT NULL,
4STAT VARCHAR(20) NOT NULL,
5VALUE INT(11) NOT NULL
6);
7CREATE VIEW BESTSELLER_COUNT AS
8SELECT BESTSELLER FROM books
9WHERE BESTSELLER = 1;
10
11DROP EVENT IF EXISTS BESTSELLER;
12
13DELIMITER $$
14CREATE EVENT BESTSELLER
15ON SCHEDULE EVERY 1 MINUTE
16DO 
17BEGIN 
18DECLARE BS_COUNT INT(11);
19CALL UpdateBestsellers();
20SELECT COUNT(*) FROM BESTSELLER_COUNT
21WHERE BESTSELLER = 1
22INTO BS_COUNT;
23INSERT INTO STATS(STAT_DATE, STAT, VALUE) VALUES (CURENTDATE(), "BESTSELLERS", BS_COUNT);
24END $$
25DELIMITER ;