Как исправить ошибку с исправление данных?

Question

[mandico]

Выдает такую ошибку, когда пытаюсь обновить данные в SQl
код могу предоставить

Traceback (most recent call last):
  File "C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\dispatcher.py", line 388, in _process_polling_updates
    for responses in itertools.chain.from_iterable(await self.process_updates(updates, fast)):
  File "C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\dispatcher.py", line 225, in process_updates
    return await asyncio.gather(*tasks)
  File "C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\handler.py", line 117, in notify
    response = await handler_obj.handler(*args, **partial_data)
  File "C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\dispatcher.py", line 246, in process_update
    return await self.message_handlers.notify(update.message)
  File "C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\handler.py", line 117, in notify
    response = await handler_obj.handler(*args, **partial_data)
  File "d:\Programming\Python\C8\bot.py", line 46, in enter_update_treshka
    user = db.select_user(id=message.from_user.id)
  File "d:\Programming\Python\C8\sqlite.py", line 65, in select_user
    return self.execute(sql, parameters, fetchone=True)
  File "d:\Programming\Python\C8\sqlite.py", line 21, in execute
    cursor.execute(sql, parameters)
sqlite3.OperationalError: near "=": syntax error

Comments

[ayazer]

sqlite3.OperationalError: near "=": syntax error

все написано-же. проверяйте свой запрос

[mandico]

ayazer, Не могу найти ошибку(

[mandico]

import sqlite3


class Database:
    def __init__(self, path_to_db="Sqlite/database.db"):
        self.path_to_db = path_to_db
        self.connection

    @property
    def connection(self):
        return sqlite3.connect(self.path_to_db)

    def execute(self, sql: str, parameters: tuple = None, fetchone = False,
                fetchall = False, commit = False):
        if not parameters:
            parameters = tuple()
        connection = self.connection
        connection.set_trace_callback(logger)
        cursor = connection.cursor()
        data = None
        cursor.execute(sql, parameters)
        if commit:
            connection.commit()
        if fetchone:
            data = cursor.fetchone()
        if fetchall:
            data = cursor.fetchall()
        connection.close()
        return data
    
    def create_table_users(self):
        sql = """
        CREATE TABLE Users ( 
        id int NOT NULL, 
        name varchar(255) NOT NULL,
        treshka int,
        kasan int,
        presents int,
        vstrecha int,
        podklich int
        PRIMARY KEY (id)
        );
        """
        self.execute(sql, commit=True)

    def add_user(self, id:int, name:str, treshka:int =  None, kasan:int = None, presents:int = None, vstrecha:int = None, podklich:int = None):
        sql = "INSERT INTO Users(id, name, treshka, kasan, presents, vstrecha, podklich) VALUES(?, ?, ?, ?, ?, ?, ?)"
        parameters = (id, name, treshka, kasan, presents, vstrecha, podklich)
        self.execute(sql, parameters=parameters, commit=True)
    
    def select_all_users(self):
        sql = "SELECT * FROM Users"
        return self.execute(sql, fetchall=True)
    
    @staticmethod
    def format_args(sql, parameters=dict):
        sql += " AND ".join([
            f"{item} = ?" for item in parameters
        ])
        return sql, tuple(parameters.values())

    def select_user(self, **kwargs):
        sql = "SELECT * FROM Users WHERE"
        sql, parameters = self.format_args(sql, kwargs)
        return self.execute(sql, parameters, fetchone=True)

    def count_users(self):
        return self.execute("SELECT COUNT(*) from Users", fetchone=True)

    #def update_email(self, email, id):
    #    sql = "UPDATE Users SET email =? WHERE id=?"
    #    return self.execute(sql, parameters=(email, id), commit=True)

    def update_treshka(self, treshka, id):
        sql = "UPDATE Users SET treshka =? WHERE id=?"
        return self.execute(sql, parameters=(treshka, id), commit=True)

    def delete_user(self):
        self.execute("DELETE FROM Users WHERE True")

def logger(statement):
        print(f"""
_________________________________________
Executing:
{statement}
_________________________________________
        """)

Answer 1

[Wispik]

в format_args добавь print(sql) и посмотри, какой запрос формируется во время ошибки

Answer 2

[mandico]

Вот что выдает

D:\Programming>C:/Users/Bekzod/AppData/Local/Programs/Python/Python39/python.exe d:/Programming/Python/C8/bot.py
INFO:aiogram:Bot: dadabaevbot [@dadabaevbot]
WARNING:aiogram:Updates were skipped successfully.
INFO:aiogram.dispatcher.dispatcher:Start polling.
ERROR:asyncio:Task exception was never retrieved
future: <Task finished name='Task-18' coro=<Dispatcher._process_polling_updates() done, defined at C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\dispatcher.py:380> exception=OperationalError('no such table: Users')>
Traceback (most recent call last):
  File "C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\dispatcher.py", line 388, in _process_polling_updates     
    for responses in itertools.chain.from_iterable(await self.process_updates(updates, fast)):
  File "C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\dispatcher.py", line 225, in process_updates
    return await asyncio.gather(*tasks)
  File "C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\handler.py", line 117, in notify
    response = await handler_obj.handler(*args, **partial_data)
  File "C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\dispatcher.py", line 246, in process_update
    return await self.message_handlers.notify(update.message)
  File "C:\Users\Bekzod\AppData\Local\Programs\Python\Python39\lib\site-packages\aiogram\dispatcher\handler.py", line 117, in notify
    response = await handler_obj.handler(*args, **partial_data)
  File "d:\Programming\Python\C8\bot.py", line 45, in enter_update_treshka
    db.update_treshka(treshka=treshka, id=message.from_user.id)
  File "d:\Programming\Python\C8\sqlite.py", line 77, in update_treshka
    return self.execute(sql, parameters=(treshka, id), commit=True)
  File "d:\Programming\Python\C8\sqlite.py", line 21, in execute
    cursor.execute(sql, parameters)
sqlite3.OperationalError: no such table: Users

Comments

[Wispik]

нет таблицы Users

[mandico]

Wispik, Но в бд есть

[Wispik]

mandico, тут я уже незнаю. Проверь название таблицы, подключение к бд и т.д.