sql.py

import mysql.connector

aws = False
if aws:
    mydb = mysql.connector.connect(host='codefusion-rds.czuesa2uqj17.us-east-1.rds.amazonaws.com', user='admin', password = 'CodeFusion-RDS', database = "CodeFusion_DB")
else:
    mydb = mysql.connector.connect(host= "localhost", user = "root", password = '',database = "CodeFusion_Local")

mycursor = mydb.cursor()

def create_user(username, password, usertype):
    mycursor.execute(f"INSERT INTO `userdetails` (`uid`, `username`,`password`, `usertype`) VALUES (NULL, '{username}', '{password}', '{usertype}');")
    mydb.commit()

def getpassword(username):
    mycursor.execute(f"SELECT `password` FROM `userdetails` WHERE `username` = '{username}';")
    password = mycursor.fetchone()
    return password[0]

def auth(username, password):
    return getpassword(username) == password

def create_listing(uid_of_seller,brand_model,specs,years_used,condition,price):
    mycursor.execute(f"INSERT INTO `listings` (`uid_of_seller`, `brand_model`, `specs`, `years_used`, `condition`,`uid_sell_table`, `price`) VALUES ('{uid_of_seller}', '{brand_model}', '{specs}', '{years_used}', '{condition}', NULL, '{price}');")
    mydb.commit()

def all_listings(): #returns nested tuple of format ( (uid_of_seller, brand_model, specs, c, condition), () )
    mycursor.execute("select * from `listings`")
    return mycursor.fetchall()

def getuidofseller(username):
    mycursor.execute(f"SELECT `uid` FROM `userdetails` WHERE `username` = '{username}';")
    return mycursor.fetchone()[0]