Discord bot命令库不工作（sqlite3，Discord.py）

Question

我试图在我的Discord服务器上实现一个存储，但是命令没有执行，控制台中也没有错误，这段代码被翻译成带有JSON的sqlite 3， 我是sqlite 3和Discord.py的新手

@client.command( pass_context = True )
async def buy(ctx, arg = None):
    role = arg
    if role == None:
        await ctx.send("**Укажите роль, которую хотите купить.**")

    Aqua=50000
    Red=100000
    Green=150000
    Blue=200000
    Pink=250000
    Gold=500000

    Aqua_role = discord.utils.get( ctx.message.guild.roles, id = 718214683454210088)
    Red_role = discord.utils.get( ctx.message.guild.roles, id = 718215132286550046)
    Green_role = discord.utils.get( ctx.message.guild.roles, id = 718215275618631681)
    Blue_role = discord.utils.get( ctx.message.guild.roles, id = 718216550959677712)
    Pink_role = discord.utils.get( ctx.message.guild.roles, id = 718215775504171049)
    Gold_role = discord.utils.get( ctx.message.guild.roles, id = 718215931406581801)

    async def shop_buy(ctx):
        for row in cursor.execute(f"SELECT money FROM users where id={ctx.author.id}"):

            if role == "Gold":
                if gold_role in ctx.author.roles:
                    await ctx.send(f"{ctx.author.mention}, у вас уже имеется роль {Gold_role}")


                elif row[0] >= Gold:
                    balance = row[0] - summ

                    await ctx.send(embed=discord.Embed(                           
                        description=f" {ctx.author.mention}, покупка прошла успешно ",
                        colour=0x00ff00
                    ))

                    cursor.execute(f'UPDATE users SET money={balance} where id={ctx.author.id}')
                    conn.commit()
                    await ctx.author.add_roles(Gold_role) 

                else:
                    await ctx.send(embed=discord.Embed(                     
                        description=f"**{ctx.message.author.mention}, такой суммы нет у вас на баллансе!**",
                        colour=0xff0000
                        ))

Answer 1

实际上，您并没有在任何地方运行shop_buy()协同程序，您只是定义了它。函数/协同程序不会运行，除非您调用它们

如果您只打算在一个地方使用代码，那么协同程序甚至不是必需的

如果您想在其他地方使用shop_buy()协程，也可以在命令之外定义它：

@client.command() # context is automatically passed in rewrite
async def buy(ctx, arg = None):
    role = arg
    if role == None:
        await ctx.send("**Укажите роль, которую хотите купить.**")

    Aqua=50000
    Red=100000
    Green=150000
    Blue=200000
    Pink=250000
    Gold=500000

    Aqua_role = discord.utils.get( ctx.message.guild.roles, id = 718214683454210088)
    Red_role = discord.utils.get( ctx.message.guild.roles, id = 718215132286550046)
    Green_role = discord.utils.get( ctx.message.guild.roles, id = 718215275618631681)
    Blue_role = discord.utils.get( ctx.message.guild.roles, id = 718216550959677712)
    Pink_role = discord.utils.get( ctx.message.guild.roles, id = 718215775504171049)
    Gold_role = discord.utils.get( ctx.message.guild.roles, id = 718215931406581801)

    async def shop_buy(ctx):
        # shop_buy() code here

    await shop_buy(ctx) # you need to call the coroutine