主页 / 问题 / 1440454
Accepted
MrKey8840
Asked:2022-08-18 18:53:16 +0800 CST2022-08-18 18:53:16 +0800 CST

SQLite 不能在 aiogram 中工作

  • 772

写作：

@dp.message_handler(text = 'Проверка')
async def privet(message: types.Message):
   cur.execute("SELECT id FROM podpiska WHERE dt == datetime.date.today().day AND oplata == 0")
   result = cur.fetchall()
   await bot.send_message(result)

分发：

  File "C:\Users\Anna\Desktop\python\рр\bot.py", line 33, in privet
    cur.execute("SELECT id FROM podpiska WHERE dt == datetime.date.today().day A
ND oplata == 0")
sqlite3.OperationalError: near "(": syntax error
python sqlite

1 个回答

  1. Best Answer
    @dp.message_handler(text='Проверка')
async def privet(message: types.Message):
    cur.execute("SELECT id FROM podpiska WHERE dt == ? AND oplata == 0", datetime.date.today().day)
    result = cur.fetchall()
    await bot.send_message(result)
    • 0

相关问题