File: Create.sql

package info (click to toggle)
sqlheavy 0.1.1-1
  • links: PTS
  • area: main
  • in suites: wheezy
  • size: 3,400 kB
  • sloc: ansic: 30,371; sh: 11,012; makefile: 367; sql: 20
file content (21 lines) | stat: -rw-r--r-- 643 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
CREATE TABLE IF NOT EXISTS `queries` (
  `sql` TEXT UNIQUE NOT NULL,
  `executions` INTEGER UNSIGNED DEFAULT 1,
  `clock` FLOAT UNSIGNED NOT NULL,
  `fullscan_step` INTEGER UNSIGNED,
  `sort` INTEGER UNSIGNED
);

CREATE TRIGGER IF NOT EXISTS `queries_insert`
  BEFORE INSERT ON `queries`
  WHEN (SELECT COUNT(*) FROM `queries` WHERE `sql` = NEW.`sql`) > 0
  BEGIN
    UPDATE `queries`
      SET
        `executions` = `executions` + 1,
        `clock` = `clock` + NEW.`clock`,
        `fullscan_step` = `fullscan_step` + NEW.`fullscan_step`,
        `sort` = `sort` + NEW.`sort`
      WHERE `sql` = NEW.`sql`;
    SELECT RAISE(IGNORE);
  END;