...
Possible Starting Point: Route Model
Code for connection:
Code Block | ||
---|---|---|
| ||
import mysql.connector
cnx = mysql.connector.connect(
host="127.0.0.1",
port=3306,
user="admin",
password="password")
cur = cnx.cursor()
cur.execute("SELECT * FROM mainschema.coordinate")
row = cur.fetchone()
print(row)
cnx.close() |