-
Notifications
You must be signed in to change notification settings - Fork 0
/
course_event.py
281 lines (242 loc) · 11 KB
/
course_event.py
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
import urllib2
import json
import pymysql.cursors
API_BASE="http://bartjsonapi.elasticbeanstalk.com/api"
def lambda_handler(event, context):
if (event["session"]["application"]["applicationId"] !=
"amzn1.ask.skill.3ff5db33-4e40-4071-925c-b0d66b4a553e"):
raise ValueError("Invalid Application ID")
if event["session"]["new"]:
on_session_started({"requestId": event["request"]["requestId"]}, event["session"])
if event["request"]["type"] == "LaunchRequest":
return on_launch(event["request"], event["session"])
elif event["request"]["type"] == "IntentRequest":
return on_intent(event["request"], event["session"])
elif event["request"]["type"] == "SessionEndedRequest":
return on_session_ended(event["request"], event["session"])
def on_session_started(session_started_request, session):
print "Starting new session."
def on_launch(launch_request, session):
return get_welcome_response()
def on_intent(intent_request, session):
intent = intent_request["intent"]
intent_name = intent_request["intent"]["name"]
if intent_name == "GetStatus":
return get_system_status()
elif intent_name == "GetElevators":
return get_elevator_status()
elif intent_name == "GetCourseNum":
return get_course_num(intent)
elif intent_name == "GetWhen":
return get_when(intent)
elif intent_name == "GetInstr":
return get_instr(intent)
elif intent_name == "GetSeats":
return get_seats(intent)
elif intent_name == "AMAZON.HelpIntent":
return get_welcome_response()
elif intent_name == "AMAZON.CancelIntent" or intent_name == "AMAZON.StopIntent":
return handle_session_end_request()
else:
raise ValueError("Invalid intent")
def on_session_ended(session_ended_request, session):
print "Ending session."
# Cleanup goes here...
def handle_session_end_request():
card_title = "BART - Thanks"
speech_output = "Thank you for using the BART skill. See you next time!"
should_end_session = True
return build_response({}, build_speechlet_response(card_title, speech_output, None, should_end_session))
def get_welcome_response():
session_attributes = {}
card_title = "BART"
speech_output = "Welcome to the course for Department of Computer Science skill. " \
"You can ask me a course number from any class, or " \
"ask me for system status or elevator status reports."
reprompt_text = "Please ask me a course number, " \
"for example what is 16950."
should_end_session = False
return build_response(session_attributes, build_speechlet_response(
card_title, speech_output, reprompt_text, should_end_session))
def get_system_status():
session_attributes = {}
card_title = "BART System Status"
reprompt_text = ""
should_end_session = False
response = urllib2.urlopen(API_BASE + "/status")
bart_system_status = json.load(response)
speech_output = "There are currently " + bart_system_status["traincount"] + " trains operating. "
if len(bart_system_status["message"]) > 0:
speech_output += bart_system_status["message"]
else:
speech_output += "The trains are running normally."
return build_response(session_attributes, build_speechlet_response(
card_title, speech_output, reprompt_text, should_end_session))
def get_elevator_status():
session_attributes = {}
card_title = "BART Elevator Status"
reprompt_text = ""
should_end_session = False
response = urllib2.urlopen(API_BASE + "/elevatorstatus")
bart_elevator_status = json.load(response)
speech_output = "BART elevator status. " + bart_elevator_status["bsa"]["description"]
return build_response(session_attributes, build_speechlet_response(
card_title, speech_output, reprompt_text, should_end_session))
def get_course_num(intent):
session_attributes = {}
card_title = "CourseNum"
speech_output = "I'm not sure which course you wanted for. " \
"Please try again."
reprompt_text = "I'm not sure which course you wanted for. " \
"Try asking about 1110 or 2110 for example."
should_end_session = False
if "CourseNum" in intent["slots"]:
course_num = intent["slots"]["CourseNum"]["value"]
card_title = "CourseNum is " + course_num.title()
if(course_num != None):
# Connect to the database
connection = pymysql.connect(
host="uvaclasses.martyhumphrey.info",
user='UVAClasses',
password='WR6V2vxjBbqNqbts',
db='uvaclasses',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
try:
with connection.cursor() as cursor:
# Read a single record
sql = "SELECT `Title` FROM `CompSci1178Data` WHERE `Number`=%s"
cursor.execute(sql,(str(course_num)))
result = cursor.fetchone()
speech_output = "It is " + str(result['Title'])
reprompt_text = ""
finally:
connection.close()
return build_response(session_attributes, build_speechlet_response(
card_title, speech_output, reprompt_text, should_end_session))
def get_when(intent):
session_attributes = {}
card_title = "CourseNum"
speech_output = "I'm not sure which course you wanted for. " \
"Please try again."
reprompt_text = "I'm not sure which course you wanted for. " \
"Try asking about 1110 or 2110 for example."
should_end_session = False
if "CourseNum" in intent["slots"]:
course_num = intent["slots"]["CourseNum"]["value"]
card_title = "CourseNum is " + course_num.title()
if(course_num != None):
# Connect to the database
connection = pymysql.connect(
host="uvaclasses.martyhumphrey.info",
user='UVAClasses',
password='WR6V2vxjBbqNqbts',
db='uvaclasses',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
try:
with connection.cursor() as cursor:
# Read a single record
sql = "SELECT `Days` FROM `CompSci1178Data` WHERE `Number`=%s"
cursor.execute(sql,(str(course_num)))
result = cursor.fetchone()
speech_output = "It is " + str(result['Days'])
reprompt_text = ""
finally:
connection.close()
return build_response(session_attributes, build_speechlet_response(
card_title, speech_output, reprompt_text, should_end_session))
def get_instr(intent):
session_attributes = {}
card_title = "CourseNum"
speech_output = "I'm not sure which course you wanted for. " \
"Please try again."
reprompt_text = "I'm not sure which course you wanted for. " \
"Try asking about 1110 or 2110 for example."
should_end_session = False
if "CourseNum" in intent["slots"]:
course_num = intent["slots"]["CourseNum"]["value"]
card_title = "CourseNum is " + course_num.title()
if(course_num != None):
# Connect to the database
connection = pymysql.connect(
host="uvaclasses.martyhumphrey.info",
user='UVAClasses',
password='WR6V2vxjBbqNqbts',
db='uvaclasses',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
try:
with connection.cursor() as cursor:
# Read a single record
sql = "SELECT `Instructor` FROM `CompSci1178Data` WHERE `Number`=%s"
cursor.execute(sql,(str(course_num)))
result = cursor.fetchone()
speech_output = "It is " + str(result['Instructor'])
reprompt_text = ""
finally:
connection.close()
return build_response(session_attributes, build_speechlet_response(
card_title, speech_output, reprompt_text, should_end_session))
def get_seats(intent):
session_attributes = {}
card_title = "CourseNum"
speech_output = "I'm not sure which course you wanted for. " \
"Please try again."
reprompt_text = "I'm not sure which course you wanted for. " \
"Try asking about 1110 or 2110 for example."
should_end_session = False
if "CourseNum" in intent["slots"]:
course_num = intent["slots"]["CourseNum"]["value"]
card_title = "CourseNum is " + course_num.title()
if(course_num != None):
# Connect to the database
connection = pymysql.connect(
host="uvaclasses.martyhumphrey.info",
user='UVAClasses',
password='WR6V2vxjBbqNqbts',
db='uvaclasses',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
try:
with connection.cursor() as cursor:
# Read a single record
sql = "SELECT `EnrollmentLimit` - `Enrollment` AS `seats` FROM `CompSci1178Data` WHERE `Number`=%s"
cursor.execute(sql,(str(course_num)))
result = cursor.fetchone()
if(int(result['seats']) == 1):
speech_output = "There is only " + str(result['seats'])
elif(int(result['seats']) < 1):
speech_output = "There is no seat at all"
else:
speech_output = "There are " + str(result['seats'])
reprompt_text = ""
finally:
connection.close()
return build_response(session_attributes, build_speechlet_response(
card_title, speech_output, reprompt_text, should_end_session))
def build_speechlet_response(title, output, reprompt_text, should_end_session):
return {
"outputSpeech": {
"type": "PlainText",
"text": output
},
"card": {
"type": "Simple",
"title": title,
"content": output
},
"reprompt": {
"outputSpeech": {
"type": "PlainText",
"text": reprompt_text
}
},
"shouldEndSession": should_end_session
}
def build_response(session_attributes, speechlet_response):
return {
"version": "1.0",
"sessionAttributes": session_attributes,
"response": speechlet_response
}