-
Notifications
You must be signed in to change notification settings - Fork 0
/
All the SQL for Stored Procedures.sql
150 lines (111 loc) · 4.5 KB
/
All the SQL for Stored Procedures.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
/*DELIMITER $$
USE `testingframeworkdb`$$
CREATE PROCEDURE `newTest` (test_name varchar(300), des varchar(1000))
BEGIN
insert into test (test_name, description) values (test_name, des);
END$$
DELIMITER ;*/
/*call newTest('mySelenium.Driver.searchYoutube', 'bhghjgdfshghgksfdygsdfkhygdskfgsdgkygrkdydfs fyds dfgdsiygfdkgdkgkbfdskgdkhbgkdf gbkdfhbgdshbgkhdfgdf');
*/
/*select * From test;*/
/*
CREATE TABLE IF NOT EXISTS `TestingFrameworkDB`.`test_case` (
`test_auto_id` BIGINT NOT NULL,
`test_case_number` SMALLINT NOT NULL,
`date_time` DATETIME NOT NULL,
`os_version` VARCHAR(200) NULL,
`platform` VARCHAR(100) NULL,
`machine_name` VARCHAR(100) NOT NULL,
`machine_user` VARCHAR(100) NOT NULL,
`asserts` SMALLINT NULL,
`executed` TINYINT(1) NULL,
`result` VARCHAR(100) NULL,
`success` TINYINT(1) NOT NULL,
`message` VARCHAR(1000) NULL,
`stack_trace` VARCHAR(5000) NULL,
`running_time` DOUBLE NOT NULL,
`code_coverage_type` VARCHAR(80) NULL,
`code_coverage_percentage` FLOAT NULL,*/
/*DELIMITER $$
USE `testingframeworkdb` $$
CREATE PROCEDURE `newTestCase` (test_auto_id bigint, test_case_number smallint, date_time datetime, os_version varchar(200), platform varchar(100),
machine_name varchar(100), machine_user varchar(100), asserts smallint, executed bool, result varchar(100),
success bool, message varchar(1000), stack_trace varchar(5000), running_time double, code_coverage_type varchar(50),
code_coverage_percentage float)
BEGIN
insert into test_case (test_auto_id, test_case_number, date_time, os_version, platform, machine_name, machine_user, asserts, executed,
result, success, message, stack_trace, running_time, code_coverage_type, code_coverage_percentage) values
(test_auto_id, test_case_number, date_time, os_version, platform, machine_name, machine_user, asserts, executed,
result, success, message, stack_trace, running_time, code_coverage_type, code_coverage_percentage);
END$$
DELIMITER ;*/
/*DELIMITER $$
CREATE FUNCTION `testExist` (testName varchar(300))
RETURNS bool
BEGIN
DECLARE temp bool;
IF ((SELECT COUNT(*) FROM test WHERE test_name = testName) = 1)
THEN
SET temp = true;
ELSE
SET temp = false;
END IF;
RETURN temp;
END$$
DELIMITER $$*/
/*test testExist*/
/*SELECT testExist("mySelenium.Driver.searchYou");*/
/*
DELIMITER $$
CREATE FUNCTION `nextTestCaseNumber` (testName varchar(300))
RETURNS INTEGER
BEGIN
DECLARE testID bigint;
SET testID = (SELECT auto_id FROM test WHERE test_name = testName LIMIT 1);
RETURN (SELECT COUNT(*) FROM test_case WHERE test_auto_id = testID) + 1;
END$$
DELIMITER $$
*/
/*DELIMITER $$
CREATE FUNCTION `newTestRun` (test_name varchar(300), description varchar(1000), date_time datetime, os_version varchar(200), platform varchar(100),
machine_name varchar(100), machine_user varchar(100), asserts smallint, executed bool, result varchar(100),
success bool, message varchar(1000), stack_trace varchar(5000), running_time double, code_coverage_type varchar(50),
code_coverage_percentage float)
RETURNS INTEGER
BEGIN
DECLARE testExistBit BIGINT;
DECLARE returnValue INTEGER;
SET testExistBit = testExist(test_name);
IF testExistBit = 0
THEN
CALL newTest(test_name, description);
CALL newTestCase(testExist(test_name), nextTestCaseNumber(test_name), date_time, os_version, platform, machine_name, machine_user, asserts, executed,
result, success, message, stack_trace, running_time, code_coverage_type, code_coverage_percentage);
SET returnValue = 2;
ELSE
CALL newTestCase(testExistBit, nextTestCaseNumber(test_name), date_time, os_version, platform, machine_name, machine_user, asserts, executed,
result, success, message, stack_trace, running_time, code_covergae_type, code_coverage_percentage);
SET returnValue = 1;
END IF;
RETURN returnValue;
END$$
DELIMITER $$
*/
/*insert into test (test_name, description) values ("testtesttest", "dvgdfsgfdsggdfsg");*/
/*DELIMITER $$
USE `testingframeworkdb`$$
CREATE FUNCTION `testExist` (testName varchar(300))
RETURNS BIGINT
BEGIN
DECLARE temp BIGINT;
IF ((SELECT COUNT(*) FROM test WHERE test_name = testName) = 1)
THEN
SET temp = (SELECT auto_id FROM test WHERE test_name = testName LIMIT 1);
ELSE
SET temp = 0;
END IF;
RETURN temp;
END$$
DELIMITER $$*/
/*SELECT newTestRun("testtesttest3", "dfgdfsgds", CURRENT_TIMESTAMP(), "MS Vista", "x32", "JAMIE-PC", "JAMIE", 2, true, "failed", false, "jhdsahd",
"suhfiodshfiugsfyrsy stack", 10.225, "line", 20.5);*/