Как исправить следующую ошибку в SQLalchemy?

Хочу создать таблицу в MySQL базе данных, использую для этого SQLAlchemy. Сама таблица выглядит следующим образом:

users_places = Table(
        'users_places', meta,
        Column('id', mysql.INTEGER(unsigned=True), nullable=False, primary_key=True, autoincrement=True),
        Column('user_id', mysql.INTEGER(unsigned=True), nullable=False),
        Column('place_name', String(512), nullable=False, default="you didn't set a name"),
        Column('latitude', DECIMAL(precision=9, scale=6, asdecimal=True), nullable=False),
        Column('longitude', DECIMAL(precision=9, scale=6, asdecimal=True), nullable=False),
        Column('image_path', String(1024), nullable=False, default="you didn't set an image")
    )

При попытке запуска программы получаю сообщение об ошибке:

Traceback (most recent call last):
  File "C:/Users/Andrew/PycharmProjects/telegrambotv1.0/main.py", line 31, in <module>
    class DatabaseSettings:
  File "C:/Users/Andrew/PycharmProjects/telegrambotv1.0/main.py", line 42, in DatabaseSettings
    Column('image_path', String(1024), nullable=False, default="you didn't set an image")
  File "<string>", line 2, in __new__
  File "C:\Users\Andrew\PycharmProjects\telegrambotv1.0\venv\lib\site-packages\sqlalchemy\util\deprecations.py", line 139, in warned
    return fn(*args, **kwargs)
  File "C:\Users\Andrew\PycharmProjects\telegrambotv1.0\venv\lib\site-packages\sqlalchemy\sql\schema.py", line 564, in __new__
    metadata._remove_table(name, schema)
  File "C:\Users\Andrew\PycharmProjects\telegrambotv1.0\venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 69, in __exit__
    exc_value, with_traceback=exc_tb,
  File "C:\Users\Andrew\PycharmProjects\telegrambotv1.0\venv\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
    raise exception
  File "C:\Users\Andrew\PycharmProjects\telegrambotv1.0\venv\lib\site-packages\sqlalchemy\sql\schema.py", line 559, in __new__
    table._init(name, metadata, *args, **kw)
  File "C:\Users\Andrew\PycharmProjects\telegrambotv1.0\venv\lib\site-packages\sqlalchemy\sql\schema.py", line 612, in _init
    )._set_parent_with_dispatch(self)
  File "C:\Users\Andrew\PycharmProjects\telegrambotv1.0\venv\lib\site-packages\sqlalchemy\sql\base.py", line 463, in _set_parent_with_dispatch
    self._set_parent(parent)
  File "C:\Users\Andrew\PycharmProjects\telegrambotv1.0\venv\lib\site-packages\sqlalchemy\sql\schema.py", line 3604, in _set_parent
    table_pks = [c for c in table.c if c.primary_key]
  File "C:\Users\Andrew\PycharmProjects\telegrambotv1.0\venv\lib\site-packages\sqlalchemy\sql\schema.py", line 497, in c
    return self._c
AttributeError: 'Table' object has no attribute '_c'

Как исправить эту ошибку?


Ответы (0 шт):