forked from combats/ITA-java
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpopulate.sql
135 lines (110 loc) · 15.9 KB
/
populate.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
INSERT INTO interview.Roles (Id, Name) VALUES ('1', 'ADMIN');
INSERT INTO interview.Roles (Id, Name) VALUES ('2', 'USER');
INSERT INTO interview.Roles (Id, Name) VALUES ('3', 'HR');
INSERT INTO interview.Users (Id, Active, Email, Name, Password, Phone, Surname, role_Id) VALUES ('1', 1, 'lucky@strike.com', 'John', 'eed346aede1c64193b74d7264a809c3e', '0634942253', 'Doe', '1');
INSERT INTO interview.Users (Id, Active, Email, Name, Password, Phone, Surname, role_Id) VALUES ('2', 1, 'va@gmail.com', 'Victoria', 'eed346aede1c64193b74d7264a809c3e', '0634942253', 'Smith', '2');
INSERT INTO interview.Users (Id, Active, Email, Name, Password, Phone, Surname, role_Id) VALUES ('3', 1, 'bb@gmail.com', 'Bernardo', 'eed346aede1c64193b74d7264a809c3e', '0634942253', 'Batista', '3');
INSERT INTO interview.Users (Id, Active, Email, Name, Password, Phone, Surname, role_Id) VALUES ('4', 1, 'petr@crupet.com', 'Petro', 'eed346aede1c64193b74d7264a809c3e', '0634942253', 'Cruper', '1');
INSERT INTO interview.Users (Id, Active, Email, Name, Password, Phone, Surname, role_Id) VALUES ('5', 1, 'dod@dod.com', 'Francisco', 'eed346aede1c64193b74d7264a809c3e', '0634942253', 'Chang', '1');
INSERT INTO interview.Users (Id, Active, Email, Name, Password, Phone, Surname, role_Id) VALUES ('6', 1, 'paoloA@gmail.com', 'Paolo', 'eed346aede1c64193b74d7264a809c3e', '0634942253', 'Accorti', '2');
INSERT INTO interview.Users (Id, Active, Email, Name, Password, Phone, Surname, role_Id) VALUES ('7', 1, 'fran@gmail.com', 'Fran', 'eed346aede1c64193b74d7264a809c3e', '0634942253', 'Wilson', '3');
INSERT INTO interview.Questions VALUES ('1', 'What do you know about Java?', 1);
INSERT INTO interview.Questions VALUES ('2', 'What are the supported platforms by Java Programming Language?', 1);
INSERT INTO interview.Questions VALUES ('3', 'List any five features of Java?', 1);
INSERT INTO interview.Questions VALUES ('4', 'What kind of variables a class can consist of?', 1);
INSERT INTO interview.Questions VALUES ('5', 'What is a static variable?', 1);
INSERT INTO interview.Questions VALUES ('6', 'Why is String class considered immutable?', 1);
INSERT INTO interview.Questions VALUES ('7', 'Explain Set Interface.', 2);
INSERT INTO interview.Questions VALUES ('8', 'Difference between throw and throws?', 3);
INSERT INTO interview.Questions VALUES ('9', 'Describe life cycle of thread.', 4);
INSERT INTO interview.Questions VALUES ('10', 'Explain suspend() method under Thread class.', 4);
INSERT INTO interview.Users_Questions VALUES ('2', '1');
INSERT INTO interview.Users_Questions VALUES ('2', '2');
INSERT INTO interview.Users_Questions VALUES ('2', '3');
INSERT INTO interview.Users_Questions VALUES ('2', '4');
INSERT INTO interview.Users_Questions VALUES ('2', '5');
INSERT INTO interview.Users_Questions VALUES ('2', '6');
INSERT INTO interview.Users_Questions VALUES ('2', '7');
INSERT INTO interview.Users_Questions VALUES ('2', '8');
INSERT INTO interview.Users_Questions VALUES ('2', '9');
INSERT INTO interview.Users_Questions VALUES ('2', '10');
INSERT INTO interview.Questions VALUES ('11', 'Define class?', 1);
INSERT INTO interview.Questions VALUES ('12', 'What kind of variables a class can consist of?', 1);
INSERT INTO interview.Questions VALUES ('13', 'What is a Local Variable?', 1);
INSERT INTO interview.Questions VALUES ('14', 'What is a Instance Variable?', 1);
INSERT INTO interview.Questions VALUES ('15', 'What is a static variable?', 1);
INSERT INTO interview.Questions VALUES ('16', 'What is Singleton pattern?', 4);
INSERT INTO interview.Questions VALUES ('17', 'Explain Map Interface.', 2);
INSERT INTO interview.Questions VALUES ('18', 'What is Java Virtual Machine and how it is considered in context of Java platform independent feature?', 3);
INSERT INTO interview.Questions VALUES ('19', 'What is the default value of byte datatype in Java?', 3);
INSERT INTO interview.Questions VALUES ('20', 'What is finalize() method?', 4);
INSERT INTO interview.Users_Questions VALUES ('3', '11');
INSERT INTO interview.Users_Questions VALUES ('3', '12');
INSERT INTO interview.Users_Questions VALUES ('3', '13');
INSERT INTO interview.Users_Questions VALUES ('3', '14');
INSERT INTO interview.Users_Questions VALUES ('3', '15');
INSERT INTO interview.Users_Questions VALUES ('3', '16');
INSERT INTO interview.Users_Questions VALUES ('3', '17');
INSERT INTO interview.Users_Questions VALUES ('3', '18');
INSERT INTO interview.Users_Questions VALUES ('3', '19');
INSERT INTO interview.Users_Questions VALUES ('3', '20');
INSERT INTO interview.Questions VALUES ('21', 'When throws keyword is used?', 1);
INSERT INTO interview.Questions VALUES ('22', 'How finally used under Exception Handling?', 1);
INSERT INTO interview.Questions VALUES ('23', 'What things should be kept in mind while creating your own exceptions in Java?', 2);
INSERT INTO interview.Questions VALUES ('24', 'Define Inheritance?', 1);
INSERT INTO interview.Questions VALUES ('25', 'When super keyword is used?', 1);
INSERT INTO interview.Questions VALUES ('26', 'What is the primary benefit of Encapsulation?', 1);
INSERT INTO interview.Questions VALUES ('27', 'Define Packages in Java?', 2);
INSERT INTO interview.Questions VALUES ('28', 'Difference between Overloading and Overriding?', 3);
INSERT INTO interview.Questions VALUES ('29', 'Does it matter in what order catch statements for FileNotFoundException and IOException are written?', 4);
INSERT INTO interview.Questions VALUES ('30', 'What is the difference between a Window and a Frame?', 4);
INSERT INTO interview.Users_Questions VALUES ('7', '21');
INSERT INTO interview.Users_Questions VALUES ('7', '22');
INSERT INTO interview.Users_Questions VALUES ('7', '23');
INSERT INTO interview.Users_Questions VALUES ('7', '24');
INSERT INTO interview.Users_Questions VALUES ('7', '25');
INSERT INTO interview.Users_Questions VALUES ('7', '26');
INSERT INTO interview.Users_Questions VALUES ('7', '27');
INSERT INTO interview.Users_Questions VALUES ('7', '28');
INSERT INTO interview.Users_Questions VALUES ('7', '29');
INSERT INTO interview.Users_Questions VALUES ('7', '30');
INSERT INTO interview.Applicants (Id, Email, Phone, Birthday, Name, Surname) VALUES ('1', 'lefft@ya.ru', '', 0, 'Anton', 'Kravchuk');
INSERT INTO interview.Applicants (Id, Email, Phone, Birthday, Name, Surname) VALUES ('2', 'vasya@pupkin.su', '', 0, 'Vasya', 'Pupkin');
INSERT INTO interview.Applicants (Id, Email, Phone, Birthday, Name, Surname) VALUES ('3', 'rastaman@gmail.com', '', 0, 'Jozef', 'Jonson');
INSERT INTO interview.Applicants (Id, Email, Phone, Birthday, Name, Surname) VALUES ('4', 'vasiliy@gmail.com', '', 0, 'Harison', 'Ford');
INSERT INTO interview.Applicants (Id, Email, Phone, Birthday, Name, Surname) VALUES ('5', 'nikolay@gmail.com', '', 0, 'Mary', 'Bloody');
INSERT INTO interview.Applicants (Id, Email, Phone, Birthday, Name, Surname) VALUES ('6', 'denis@gmail.com', '', 0, 'Jecob', 'Tornnnntoooon');
INSERT INTO interview.Applicants (Id, Email, Phone, Birthday, Name, Surname) VALUES ('7', 'andrey@gmail.com', '', 0, 'Francis', 'Copppola');
INSERT INTO interview.Applicants (Id, Email, Phone, Birthday, Name, Surname) VALUES ('8', 'anton@gmail.com', '', 0, 'Billy', 'Jeam');
INSERT INTO interview.Course (Id, ImageReference, Name) VALUES ('297ea2cd476e53d001476e540a5e0111', 'groups/images/pen-java.png', 'Java');
INSERT INTO interview.Course (Id, ImageReference, Name) VALUES ('297ea2cd476e53d001476e540a5f0012', 'groups/images/pen-net.png', '.NET');
INSERT INTO interview.Course (Id, ImageReference, Name) VALUES ('297ea2cd476e53d001476e540a600013', 'groups/images/pen-devops.png', 'DevOps');
INSERT INTO interview.Course (Id, ImageReference, Name) VALUES ('297ea2cd476e53d001476e540f350015', 'groups/images/pen-jsui.png', 'JavaScript');
INSERT INTO interview.Groups (Id, Address, Capacity, EndTime, GroupName, StartBoardingTime, StartTime, course_Id) VALUES ('297ea2cd47737b6c0147737b8ced0001', 'Degtya', 0, 0, 'ITA-004', 0, 0, '297ea2cd476e53d001476e540a5e0111');
INSERT INTO interview.Groups (Id, Address, Capacity, EndTime, GroupName, StartBoardingTime, StartTime, course_Id) VALUES ('297ea2cd47737b6c0147737b8ced0002', 'Degtya', 0, 0, 'ITA-005', 0, 0, '297ea2cd476e53d001476e540a5f0012');
INSERT INTO interview.Groups (Id, Address, Capacity, EndTime, GroupName, StartBoardingTime, StartTime, course_Id) VALUES ('297ea2cd47737b6c0147737b8ced0003', 'Degtya', 0, 0, 'ITA-006', 0, 0, '297ea2cd476e53d001476e540a600013');
INSERT INTO interview.Groups (Id, Address, Capacity, EndTime, GroupName, StartBoardingTime, StartTime, course_Id) VALUES ('297ea2cd47737b6c0147737b8ced0004', 'Degtya', 0, 0, 'ITA-007', 0, 0, '297ea2cd476e53d001476e540f350015');
INSERT INTO interview.Groups (Id, Address, Capacity, EndTime, GroupName, StartBoardingTime, StartTime, course_Id) VALUES ('297ea2cd47737b6c0147737b8ced3332', 'Degtyarivska, 21G', 2, 1420185223000, 'Demo', 1420185223000, 1409644423000, '297ea2cd476e53d001476e540a5f0012');
INSERT INTO interview.Appointments (Id, ActualStartTime, ApplicantId, DurationTime, GroupId, StartTime) VALUES ('4028819947789da3014778a3bf850000', 0, '1', 1800000, '297ea2cd47737b6c0147737b8ced3332', 1406732400000);
INSERT INTO interview.Appointments (Id, ActualStartTime, ApplicantId, DurationTime, GroupId, StartTime) VALUES ('4028819947789da3014778a3eb8c0001', 0, '8', 1800000, '297ea2cd47737b6c0147737b8ced3332', 1406732400000);
INSERT INTO interview.Appointments (Id, ActualStartTime, ApplicantId, DurationTime, GroupId, StartTime) VALUES ('4028819947789da3014778a4019e0002', 0, '6', 1800000, '297ea2cd47737b6c0147737b8ced3332', 1406732400000);
INSERT INTO interview.Appointments (Id, ActualStartTime, ApplicantId, DurationTime, GroupId, StartTime) VALUES ('4028819947789da3014778a416b70003', 0, '3', 1800000, '297ea2cd47737b6c0147737b8ced3332', 1406732400000);
INSERT INTO interview.Appointments (Id, ActualStartTime, ApplicantId, DurationTime, GroupId, StartTime) VALUES ('4028819947789da3014778a6d52d0004', 0, '4', 1800000, '297ea2cd47737b6c0147737b8ced3332', 1406732400000);
INSERT INTO interview.Appointment_userIdList (Appointment_Id, UserIdList) VALUES ('4028819947789da3014778a3bf850000', '1');
INSERT INTO interview.Appointment_userIdList (Appointment_Id, UserIdList) VALUES ('4028819947789da3014778a3eb8c0001', '4');
INSERT INTO interview.Appointment_userIdList (Appointment_Id, UserIdList) VALUES ('4028819947789da3014778a4019e0002', '5');
INSERT INTO interview.Appointment_userIdList (Appointment_Id, UserIdList) VALUES ('4028819947789da3014778a416b70003', '7');
INSERT INTO interview.Appointment_userIdList (Appointment_Id, UserIdList) VALUES ('4028819947789da3014778a6d52d0004', '3');
INSERT INTO interview.ApplicantsWithStatus (Id, ApplicantsStatus, ApplicantId) VALUES ('297ea2cd47737b6c0147737b8ced3332', 0xACED00057372002E636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E7442656E63686D61726B17646B041C62E66002000249000472616E6B4C000673746174757374002E4C636F6D2F736F66747365727665696E632F6974612F656E746974792F4170706C6963616E74245374617475733B7870000000027E72002C636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E742453746174757300000000000000001200007872000E6A6176612E6C616E672E456E756D00000000000000001200007870740008454D504C4F594544, '1');
INSERT INTO interview.ApplicantsWithStatus (Id, ApplicantsStatus, ApplicantId) VALUES ('297ea2cd47737b6c0147737b8ced3332', 0xACED00057372002E636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E7442656E63686D61726B17646B041C62E66002000249000472616E6B4C000673746174757374002E4C636F6D2F736F66747365727665696E632F6974612F656E746974792F4170706C6963616E74245374617475733B7870000000027E72002C636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E742453746174757300000000000000001200007872000E6A6176612E6C616E672E456E756D00000000000000001200007870740008454D504C4F594544, '2');
INSERT INTO interview.ApplicantsWithStatus (Id, ApplicantsStatus, ApplicantId) VALUES ('297ea2cd47737b6c0147737b8ced3332', 0xACED00057372002E636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E7442656E63686D61726B17646B041C62E66002000249000472616E6B4C000673746174757374002E4C636F6D2F736F66747365727665696E632F6974612F656E746974792F4170706C6963616E74245374617475733B7870000000027E72002C636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E742453746174757300000000000000001200007872000E6A6176612E6C616E672E456E756D00000000000000001200007870740008454D504C4F594544, '3');
INSERT INTO interview.ApplicantsWithStatus (Id, ApplicantsStatus, ApplicantId) VALUES ('297ea2cd47737b6c0147737b8ced3332', 0xACED00057372002E636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E7442656E63686D61726B17646B041C62E66002000249000472616E6B4C000673746174757374002E4C636F6D2F736F66747365727665696E632F6974612F656E746974792F4170706C6963616E74245374617475733B7870000000027E72002C636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E742453746174757300000000000000001200007872000E6A6176612E6C616E672E456E756D00000000000000001200007870740008454D504C4F594544, '4');
INSERT INTO interview.ApplicantsWithStatus (Id, ApplicantsStatus, ApplicantId) VALUES ('297ea2cd47737b6c0147737b8ced3332', 0xACED00057372002E636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E7442656E63686D61726B17646B041C62E66002000249000472616E6B4C000673746174757374002E4C636F6D2F736F66747365727665696E632F6974612F656E746974792F4170706C6963616E74245374617475733B7870000000027E72002C636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E742453746174757300000000000000001200007872000E6A6176612E6C616E672E456E756D00000000000000001200007870740008454D504C4F594544, '5');
INSERT INTO interview.ApplicantsWithStatus (Id, ApplicantsStatus, ApplicantId) VALUES ('297ea2cd47737b6c0147737b8ced3332', 0xACED00057372002E636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E7442656E63686D61726B17646B041C62E66002000249000472616E6B4C000673746174757374002E4C636F6D2F736F66747365727665696E632F6974612F656E746974792F4170706C6963616E74245374617475733B7870000000027E72002C636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E742453746174757300000000000000001200007872000E6A6176612E6C616E672E456E756D00000000000000001200007870740008454D504C4F594544, '6');
INSERT INTO interview.ApplicantsWithStatus (Id, ApplicantsStatus, ApplicantId) VALUES ('297ea2cd47737b6c0147737b8ced3332', 0xACED00057372002E636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E7442656E63686D61726B17646B041C62E66002000249000472616E6B4C000673746174757374002E4C636F6D2F736F66747365727665696E632F6974612F656E746974792F4170706C6963616E74245374617475733B7870000000027E72002C636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E742453746174757300000000000000001200007872000E6A6176612E6C616E672E456E756D00000000000000001200007870740008454D504C4F594544, '7');
INSERT INTO interview.ApplicantsWithStatus (Id, ApplicantsStatus, ApplicantId) VALUES ('297ea2cd47737b6c0147737b8ced3332', 0xACED00057372002E636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E7442656E63686D61726B17646B041C62E66002000249000472616E6B4C000673746174757374002E4C636F6D2F736F66747365727665696E632F6974612F656E746974792F4170706C6963616E74245374617475733B7870000000027E72002C636F6D2E736F66747365727665696E632E6974612E656E746974792E4170706C6963616E742453746174757300000000000000001200007872000E6A6176612E6C616E672E456E756D00000000000000001200007870740008454D504C4F594544, '8');
INSERT INTO interview.ApplicantInterview (id, applicantId, finalComment) VALUES ('1', 'TestApplicantId', 'TestFinalComment');
INSERT INTO interview.ApplicantInterview_usersId (ApplicantInterview_id, usersId) VALUES ('1', 'TestUserIdOne');
INSERT INTO interview.ApplicantInterview_usersId (ApplicantInterview_id, usersId) VALUES ('1', 'TestUserIdTwo');
INSERT INTO interview.InterviewQuestions (question_id, comment, mark, question, weight) VALUES ('297ee46d47865fdb0147865ffb480009', 'TestComment', 1, 'TestQuestion', 4);
INSERT INTO interview.InterviewQuestions (question_id, comment, mark, question, weight) VALUES ('297ee46d47865fdb0147865ffb4a000a', 'TestComment', 1, 'TestQuestion', 4);