Как исправить следующую ошибку в 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'
Как исправить эту ошибку?