Question: PYTHON flightCursor = reservationConnection.cursor ( ) flightQuery = ( Select FlightNumber, DepartureTime FROM Flight WHERE AirportCode = % s AND AirlineName = % s )

PYTHON
flightCursor = reservationConnection.cursor()
flightQuery =(Select FlightNumber, DepartureTime FROM Flight
WHERE AirportCode =%s AND AirlineName =%s)
flightData =(PEK,China Airlines)
flightCursor.execute(flightQuery, flightData)
for row in flightCursor.fetchall():
print(Flight, row[0],departs at, row[1])
flightCursor.close()
flightQuery =('SELECT AirlineName, DepartureTime, AirportCode FROM Flight ' WHERE FlightNumber =%s')
flightData =(140,) # Comma required for single value tuple
flightCursor.execute (flightQuery, flightData)
row = flightCursor.A()
if row is B :
print ("Flight not found")
else:
print ("Flight', row[0], 'departs from', C)
flightCursor.close()
Questions:
1. What is identifier A?
2. What is identifier B?
3. What is identifier C?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!