Or do SOC ```py
async def fetch_user_data(cursor, user_id, guild_id):
await cursor.execute('SELECT 1 FROM users WHERE memberid = ? AND guildid = ?', (user_id, guild_id,))
return await cursor.fetchone()
async def fetch_user_coins(cursor, user_id, guild_id):
await cursor.execute('SELECT coins FROM users WHERE memberid = ? AND guildid = ?', (user_id, guild_id,))
return await cursor.fetchone()
async def create_new_user(cursor, user_id, guild_id, coins=100):
await cursor.execute("INSERT INTO users(memberid, guildid, coins) VALUES (?, ?, ?)", (user_id, guild_id, coins))
@client.tree.command(name='account', description='view your account')
async def setup(ctx: discord.Interaction):
async with aiosqlite.connect("main.db") as db:
async with db.cursor() as cursor:
data = await fetch_user_data(cursor, ctx.user.id, ctx.guild.id)
if data:
(coins,) = await fetch_user_coins(cursor, ctx.user.id, ctx.guild.id)
embed = discord.Embed(title=f"{ctx.user}'s Account", description=f'Coins: {coins}')
await ctx.response.send_message(embed=embed)
else:
await create_new_user(cursor, ctx.user.id, ctx.guild.id)
await ctx.response.send_message("Account made!")
await db.commit()