Python SQL

Question 1

Creating Connection

Answer 1

conn = Main_Menu.create_connection(“Candles Database”)
cur = conn.cursor()

def create_connection(connstr):
conn = None
try:
conn = sqlite3.connect(connstr)
except Exception as e:
print(e)
return conn

Question 2

SELECT (with LIKE)

Answer 2

sql = (“SELECT OldCustomerOrders.CustomerOrderID FROM OldCustomerOrders WHERE OldCustomerOrders.CustomerOrderID LIKE ‘%” + word + “%’”)
cur.execute(sql)
self.x = cur.fetchall()

OR

cur.execute(“SELECT Forename, Surname, Orders, OldCustomerOrders.CustomerOrderID FROM Customers, OldCustomerOrders WHERE Customers.CustomerID = OldCustomerOrders.CustomerID”)
_fetched = cur.fetchall()