def insert(*args):
cur = conn.cursor()
cur.execute(
f"INSERT INTO users (discord_user, handle) VALUES {args} ON CONFLICT (discord_user) DO UPDATE SET handle='{args[1]}'"
)
conn.commit()
def select():
cur = conn.cursor()
cur.execute(f"SELECT * FROM users")
return cur.fetchall()
def clear():
cur = conn.cursor()
cur.execute(f"DELETE FROM users")
conn.commit()
def select(discord_user):
cur = conn.cursor()
cur.execute(
f"SELECT handle FROM users WHERE discord_user='******'")
return cur.fetchall()[0][0]