-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathoutput.txt
322 lines (220 loc) · 14 KB
/
output.txt
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
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
addBranch returns: Successfully added Branch 11111111 to SysData
addBranch returns: Successfully added Branch 22222222 to SysData
addBranch returns: Successfully added Branch 33333333 to SysData
addBranch returns: Successfully added Branch 44444444 to SysData
addBranch returns: Successfully added Branch 55555555 to SysData
addBranch returns: Successfully added Branch 66666666 to SysData
addBranch returns: Successfully added Branch 77777777 to SysData
addBranch returns: Successfully added Branch 88888888 to SysData
addBranch returns: Successfully added Branch 99999999 to SysData
addBranch returns: Failed to add new Branch 99999999 to SysData
addBranch returns: Successfully added Branch 10101010 to SysData
addInstructor returns: Successfully added instructor 1 to SysData
addInstructor returns: Successfully added instructor 2 to SysData
addInstructor returns: Successfully added instructor 3 to SysData
addInstructor returns: Successfully added instructor 4 to SysData
addInstructor returns: Successfully added instructor 5 to SysData
addInstructor returns: Successfully added instructor 6 to SysData
addInstructor returns: Successfully added instructor 7 to SysData
addInstructor returns: Successfully added instructor 8 to SysData
addInstructor returns: Successfully added instructor 9 to SysData
addInstructor returns: Failed to add new instructor 9 to SysData
addInstructor returns: Successfully added instructor 10 to SysData
addReceptionist returns: Successfully added receptionist 11 to SysData
addReceptionist returns: Successfully added receptionist 12 to SysData
addReceptionist returns: Successfully added receptionist 13 to SysData
addReceptionist returns: Successfully added receptionist 14 to SysData
addReceptionist returns: Failed to add new receptionist 14 to SysData
addReceptionist returns: Successfully added receptionist 15 to SysData
addReceptionist returns: Successfully added receptionist 16 to SysData
addCustomer returns: Successfully added Customer with id 000099991 to SysData
addCustomer returns: Successfully added Customer with id 000099992 to SysData
addCustomer returns: Successfully added Customer with id 000099993 to SysData
addCustomer returns: Successfully added Customer with id 000099994 to SysData
addCustomer returns: Successfully added Customer with id 000099995 to SysData
addCustomer returns: Successfully added Customer with id 000099996 to SysData
addCustomer returns: Successfully added Customer with id 000099997 to SysData
addCustomer returns: Successfully added Customer with id 000099998 to SysData
addCustomer returns: Successfully added Customer with id 000099999 to SysData
addCustomer returns: Successfully added Customer with id 000099910 to SysData
addCustomer returns: Successfully added Customer with id 000099911 to SysData
addCustomer returns: Successfully added Customer with id 000099912 to SysData
addCustomer returns: Successfully added Customer with id 000099913 to SysData
addCustomer returns: Successfully added Customer with id 000099914 to SysData
addCustomer returns: Successfully added Customer with id 000099915 to SysData
addCustomer returns: Failed to add new Customer with id 000099915 to SysData
addCustomer returns: Successfully added Customer with id 000099916 to SysData
addCustomer returns: Successfully added Customer with id 000099917 to SysData
addCustomer returns: Successfully added Customer with id 000099918 to SysData
addCustomer returns: Successfully added Customer with id 000099919 to SysData
addCustomer returns: Successfully added Customer with id 000099920 to SysData
addCustomer returns: Failed to add new Customer with id 00009911 to SysData
addCustomer returns: Failed to add new Customer with id 000099916 to SysData
connectInstructorToBranch returns: Successfully connected between instructor 1 and branch 11111111
connectInstructorToBranch returns: Successfully connected between instructor 2 and branch 22222222
connectInstructorToBranch returns: Successfully connected between instructor 3 and branch 33333333
connectInstructorToBranch returns: Successfully connected between instructor 4 and branch 44444444
connectInstructorToBranch returns: Successfully connected between instructor 5 and branch 55555555
connectInstructorToBranch returns: Successfully connected between instructor 6 and branch 66666666
connectInstructorToBranch returns: Successfully connected between instructor 7 and branch 77777777
connectInstructorToBranch returns: Failed to connected between instructor 16 and branch 77777777
connectInstructorToBranch returns: Successfully connected between instructor 8 and branch 88888888
connectInstructorToBranch returns: Successfully connected between instructor 9 and branch 99999999
connectInstructorToBranch returns: Successfully connected between instructor 10 and branch 10101010
connectInstructorToBranch returns: Failed to connected between instructor 10 and branch 10101011
connectReceptionistToBranch returns: Successfully connected between receptionist 11 and branch 11111111
connectReceptionistToBranch returns: Successfully connected between receptionist 12 and branch 22222222
connectReceptionistToBranch returns: Successfully connected between receptionist 14 and branch 44444444
connectReceptionistToBranch returns: Successfully connected between receptionist 16 and branch 66666666
connectReceptionistToBranch returns: Failed to connected between receptionist 19 and branch 99999999
addSubToCustomer returns: Successfully added subscription 1 to customer 000099991
addSubToCustomer returns: Successfully added subscription 2 to customer 000099992
addSubToCustomer returns: Successfully added subscription 3 to customer 000099993
addSubToCustomer returns: Successfully added subscription 4 to customer 000099994
addSubToCustomer returns: Failed to add new subscription 6 to customer 000099994
addSubToCustomer returns: Failed to add new subscription 7 to customer 000099911
addSubToCustomer returns: Successfully added subscription 8 to customer 000099912
addSubToCustomer returns: Successfully added subscription 9 to customer 000099913
addSubToCustomer returns: Failed to add new subscription 10 to customer 000099911
addSubToCustomer returns: Failed to add new subscription 11 to customer 000099912
addSubToCustomer returns: Successfully added subscription 12 to customer 000099913
addSubToCustomer returns: Failed to add new subscription 13 to customer 000099991
addSubToCustomer returns: Failed to add new subscription 14 to customer 000099992
addSubToCustomer returns: Failed to add new subscription 15 to customer 000099993
addSubToCustomer returns: Failed to add new subscription 16 to customer 000099994
addSubToCustomer returns: Failed to add new subscription 17 to customer 000099922
addSubToCustomer returns: Failed to add new subscription 19 to customer 000099914
changeCustomerAddress returns: Successfully changed address of customer 000099991 Customer [Id=000099991, firstName=Gilad, lastName=Levi, birthdate=Fri Jan 01 00:00:00 IST 1988, Password=gilad234, level=BEGINNERS, Email=http:\\[email protected], customerAddress=Address [country=Israel, city=Arad, street=Nahum, housNumber=88, phoneNumber= {052-8090939,054-5121323} ]]
changeCustomerAddress returns: Successfully changed address of customer 000099994 Customer [Id=000099994, firstName=Shani, lastName=Iluz, birthdate=Fri May 05 00:00:00 IST 1978, Password=shani234, level=BEGINNERS, Email=http:\\[email protected], customerAddress=Address [country=Israel, city=Ofakim, street=Ezra, housNumber=2, phoneNumber= {052-8088977} ]]
changeCustomerAddress returns: Failed to change address of customer 000099981
changeCustomerAddress returns: Successfully changed address of customer 000099998 Customer [Id=000099998, firstName=Shai, lastName=Alush, birthdate=Tue Nov 09 00:00:00 IST 1976, Password=shai234, level=INTERMEDIATE, Email=http:\\[email protected], customerAddress=Address [country=Israel, city=Haifa, street=Horev, housNumber=3, phoneNumber= {052-8108880} ]]
addRoomToBranch returns: Successfully added room 1 to branch 11111111
addRoomToBranch returns: Successfully added room 2 to branch 11111111
addRoomToBranch returns: Successfully added room 3 to branch 11111111
addRoomToBranch returns: Successfully added room 1 to branch 22222222
addRoomToBranch returns: Successfully added room 2 to branch 22222222
addRoomToBranch returns: Successfully added room 1 to branch 66666666
addRoomToBranch returns: Failed to add room 1 to branch 66666666
addHintToRoom returns: Successfully added hint 1 to room 2 in branch 11111111
addHintToRoom returns: Failed to add hint 2 to room 2 in branch 11111111
addHintToRoom returns: Successfully added hint 2 to room 2 in branch 11111111
addHintToRoom returns: Successfully added hint 3 to room 2 in branch 11111111
addHintToRoom returns: Successfully added hint 1 to room 3 in branch 11111111
addHintToRoom returns: Failed to add hint 93 to room 93 in branch 11111111
addHintToRoom returns: Successfully added hint 1 to room 2 in branch 22222222
addRoomRun returns: Failed to add RoomRun 1 at Sat Sep 02 12:00:00 IDT 2017 to room 3 in branch 11111111
addRoomRun returns: Successfully added RoomRun 2 at Sun Sep 03 14:00:00 IDT 2017 to room 2 in branch 11111111
addRoomRun returns: Successfully added RoomRun 3 at Mon Sep 04 12:00:00 IDT 2017 to room 2 in branch 11111111
addRoomRun returns: Failed to add RoomRun 4 at Tue Sep 05 12:00:00 IDT 2017 to room 3 in branch 11111111
addRoomRun returns: Successfully added RoomRun 5 at Sun Sep 10 12:00:00 IDT 2017 to room 2 in branch 22222222
addRoomRun returns: Successfully added RoomRun 6 at Sat Sep 02 14:00:00 IDT 2017 to room 2 in branch 22222222
addRoomRun returns: Failed to add RoomRun 7 at Sat Sep 02 14:00:00 IDT 2017 to room 2 in branch 22222222
addRoomRun returns: Successfully added RoomRun 10 at Fri Sep 08 14:00:00 IDT 2017 to room 2 in branch 11111111
addRoomRun returns: Successfully added RoomRun 12 at Thu Sep 07 14:00:00 IDT 2017 to room 2 in branch 22222222
addRoomRun returns: Successfully added RoomRun 13 at Wed Sep 06 14:00:00 IDT 2017 to room 2 in branch 11111111
addEquipmentToRoomRun returns: Successfully added equipment Pistol to roomRun 2
addEquipmentToRoomRun returns: Failed to add equipment Pistol to roomRun 2
addEquipmentToRoomRun returns: Failed to add equipment Map to roomRun 3
addEquipmentToRoomRun returns: Failed to add equipment Compass to roomRun 4
addEquipmentToRoomRun returns: Successfully added equipment Gun to roomRun 5
addCustomerToRoomRun returns: Failed to add customer 000099991 to roomRun 5
addCustomerToRoomRun returns: Successfully added customer 000099992 to roomRun 2
addCustomerToRoomRun returns: Failed to add customer 000099992 to roomRun 1
addCustomerToRoomRun returns: Successfully added customer 000099992 to roomRun 5
addCustomerToRoomRun returns: Successfully added customer 000099993 to roomRun 3
addCustomerToRoomRun returns: Failed to add customer 000099993 to roomRun 1
addCustomerToRoomRun returns: Successfully added customer 000099993 to roomRun 2
addCustomerToRoomRun returns: Failed to add customer 000099994 to roomRun 1
addCustomerToRoomRun returns: Failed to add customer 000099991 to roomRun 4
addCustomerToRoomRun returns: Failed to add customer 000099992 to roomRun 4
addCustomerToRoomRun returns: Failed to add customer 000099993 to roomRun 4
addCustomerToRoomRun returns: Failed to add customer 000099994 to roomRun 4
addCustomerToRoomRun returns: Failed to add customer 000099995 to roomRun 2
addCustomerToRoomRun returns: Failed to add customer 000099991 to roomRun 1
addCustomerToRoomRun returns: Failed to add customer 000099992 to roomRun 9
addCustomerToRoomRun returns: Failed to add customer 000099921 to roomRun 5
giveAHint returns: Successfully added a hint 1 to roomRun 2
giveAHint returns: Failed to add a hint 1 to roomRun 2
giveAHint returns: Successfully added a hint 2 to roomRun 2
giveAHint returns: Successfully added a hint 3 to roomRun 2
giveAHint returns: Successfully added a hint 1 to roomRun 5
giveAHint returns: Failed to add a hint 1 to roomRun 15
removeSubscription returns: Failed to remove subscription 5
removeSubscription returns: Failed to remove subscription 6
removeSubscription returns: Successfully removed subscription 9
removeSubscription returns: Failed to remove subscription 20
removeEquipmentFromRoomRun returns: Successfully removed equipment Pistol to roomRun 2
removeEquipmentFromRoomRun returns: Failed to remove equipment Compass to roomRun 4
=======
Query_1
=======
getAllParticipatedRoomRunsOfMostActiveCustomer returns:
the following roomRuns:
1 - 2 on Sun Sep 03 14:00:00 IDT 2017
2 - 3 on Mon Sep 04 12:00:00 IDT 2017
=======
Query_2
=======
getTopJanuaryReceptionist returns:
the top january receptionist is: 11, Yarden Haim
=======
Query_3
=======
getTheMostPopularRoomType returns:
the most popular room type is: MYSTERY
=======
Query_4
=======
getAllSuperSeniorInstructors returns:
1 - 1, Eyal Haim
2 - 2, Yaron Levi
=======
Query_5
=======
getTheMostActiveDay returns:
the most active day is: Sat Sep 02 00:00:00 IDT 2017
=======
Query_6
=======
getAllRoomRunsWithoutHints returns:
the following roomRuns:
1 - 3 on Mon Sep 04 12:00:00 IDT 2017
2 - 6 on Sat Sep 02 14:00:00 IDT 2017
3 - 10 on Fri Sep 08 14:00:00 IDT 2017
4 - 12 on Thu Sep 07 14:00:00 IDT 2017
5 - 13 on Wed Sep 06 14:00:00 IDT 2017
=======
Query_7
=======
getTopEquipment returns:
the top equipment type is: Gun
=======
Query_8
=======
getAllCustomersAttendingMoreThan1City returns:
the following customers:
1 - Customer ID: 000099992
=======
Query_9
=======
getPopularBranches returns:
the following branches:
1 - Branch No.: 11111111 Branch Name: QuestRoom
2 - Branch No.: 22222222 Branch Name: QuestWorld
=======
Query_10
=======
getPotentialCustomersPerBranch returns:
Potential customers per branch are:
- Branch number: 66666666 London
- Branch number: 77777777 California
- Customer number: 000099910 California
- Customer number: 000099920 California
- Branch number: 33333333 Hadera
- Branch number: 88888888 Miami
- Branch number: 99999999 Madrid
- Branch number: 10101010 Yavne
- Branch number: 44444444 Kfar_Saba
- Branch number: 55555555 Sderot
- Branch number: 22222222 Beit_Shemesh
- Branch number: 11111111 Afula