JirhgimJ

1@client.event
2async def on_ready():
3    db = sqlite3.connect('console.sqlite')
4    cursor = db.cursor()
5    cursor.execute('''
6        CREATE TABLE IF NOT EXISTS main(
7        console TEXT
8        user TEXT
9        )
10        ''')
11
12@client.group(invoke_without_command=True)
13async def profile(ctx, member : discord.Member):
14  print('Ill work on this later')
15
16@profile.command()
17async def console(ctx, text):
18  db = sqlite3.connect('console.sqlite')
19  cursor = db.cursor()
20  cursor.execute(f'SELECT console FROM main WHERE user = {ctx.author.mention}')
21  result = cursor.fetchone()
22  if result is None:
23    sql = ("INSERT INTO main(user, console) VALUES(?,?)")
24    val = (ctx.author.mention, text)
25    embed=discord.Embed(description="Profile Page Console Set To **`{text}`**")
26    await ctx.send(embed=embed)
27  elif result is not None:
28    sql = ("UPDATE main SET console = ? WHERE user = ?")
29    val = (text, ctx.author.mention)
30    embed=discord.Embed(description="Profile Page Console Updated To **`{text}`**")
31    await ctx.send(embed=embed)
32  cursor.execute(sql, val)
33  db.commit()
34  cursor.close()
35  db.close()