Hi all i am like 99% finshed this pain in the but script but i am now getting a error mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use near
for the life of me i cant work it out and i tihnk i am going half blind just looking at the code can you please help me out
from requests_html import HTMLSessionimport mysql.connectormydb = mysql.connector.connect( host="localhost", user="root", passwd="*****", database="flightdata")mycursor = mydb.cursor()# create an HTML Session objectsession = HTMLSession()# Use the object above to connect to needed webpageresp = session.get("https://www.adelaideairport.com.au/flight-information/flight-search/?flt_no=&carrier=All&city=&dte=Current&leg=Departures")# Run JavaScript code on webpageresp.html.render()data = []airline_spans = resp.html.find('.SearchResultFlightListRow')print (airline_spans)airline_list = [span.text.split('\n') for span in airline_spans]for flight in airline_list: if len(flight) == 7: flightno, From, to, scheduled, estimated, gate, status = flight print ("This is a " + estimated) if estimated == "": print (" currently no dely ") print ("This is a " + estimated) estimated = 'IDEL' # print (f'Flight no {flightno} from {From} to {to} is scheduled to depart at {scheduled} from gate {gate} and flight status is {status}') elif len(flight) == 6: print (flight) status = "IDEL" print (status) flightno, From, to, scheduled, estimated, gate = flight print ("This is a " + estimated) if estimated == "": print (" currently no dely ") print ("This is a " + estimated) estimated = 'IDEL' # print (f'Flight no {flightno} from {From} to {to} is scheduled to depart at {scheduled} from gate {gate} ') elif len(flight) == 5: flightno, From, to, scheduled, estimated = flight origin = str(From) flight_id = str('na') airline = str('na') destination = str (to) flightNumbers = str(flightno) scheduledTime = str(scheduled) estimatedTime = str(estimated) scheduledDate = str('na') latestTime = str(estimated) status = str(status) gate = str(gate) print (From, flight_id, flightNumbers, airline, destination, scheduledTime, scheduledDate, latestTime, status, gate) sql = "INSERT INTO flightinfo (origin, id, airline, destinations, flightNumbers, scheduledTime, estimatedTime, scheduledDate, latestTime, status, gate) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s. %s)" val = (origin, flight_id, airline, destination, flightNumbers, scheduledTime, estimatedTime, scheduledDate, latestTime, status, gate) data.append(val)# doing a batch insertmycursor.executemany(sql, data)mydb.commit()print(mycursor.rowcount, "was inserted.")
It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.
it looks like the error is comming from gate = str(gate)
mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server v
ersion for the right syntax to use near '. '22'),('Adelaide', 'na', 'na', 'Sydney', 'JQ761', '12:40 pm', '12:42 pm', 'na'' at line 1
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial