Skip to content

Error with FLASK-MIGRATE #18

@Francesco1970

Description

@Francesco1970

Versione SQLAlcademy 2.0

by running the following command:

flask db migrate -m "Initial migration."

[2024-06-28 17:03:28,019] INFO in run: DEBUG = True
[2024-06-28 17:03:28,019] INFO in run: Page Compression = FALSE
[2024-06-28 17:03:28,019] INFO in run: DBMS = sqlalchemy_sqlany://dba:sql@127.0.0.1:49152/GeinaWEB
INFO [alembic.runtime.migration] Context impl SqlanydbImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
Traceback (most recent call last):
File "", line 198, in _run_module_as_main
File "", line 88, in run_code
File "R:\Geina-WEB.venv\Scripts\flask.exe_main
.py", line 7, in
File "R:\Geina-WEB.venv\Lib\site-packages\flask\cli.py", line 1105, in main
cli.main()
File "R:\Geina-WEB.venv\Lib\site-packages\click\core.py", line 1078, in main
rv = self.invoke(ctx)
^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\click\core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\click\core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\click\core.py", line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\click\core.py", line 783, in invoke
return __callback(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\click\decorators.py", line 33, in new_func
return f(get_current_context(), *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\flask\cli.py", line 386, in decorator
return ctx.invoke(f, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\click\core.py", line 783, in invoke
return _callback(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\flask_migrate\cli.py", line 109, in migrate
migrate(directory, message, sql, head, splice, branch_label, version_path,
File "R:\Geina-WEB.venv\Lib\site-packages\flask_migrate_init
.py", line 111, in wrapped
f(*args, **kwargs)
File "R:\Geina-WEB.venv\Lib\site-packages\flask_migrate_init
.py", line 170, in migrate
command.revision(config, message, autogenerate=True, sql=sql,
File "R:\Geina-WEB.venv\Lib\site-packages\alembic\command.py", line 236, in revision
script_directory.run_env()
File "R:\Geina-WEB.venv\Lib\site-packages\alembic\script\base.py", line 582, in run_env
util.load_python_file(self.dir, "env.py")
File "R:\Geina-WEB.venv\Lib\site-packages\alembic\util\pyfiles.py", line 95, in load_python_file
module = load_module_py(module_id, path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\alembic\util\pyfiles.py", line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "", line 940, in exec_module
File "", line 241, in _call_with_frames_removed
File "R:\Geina-WEB\migrations\env.py", line 119, in
run_migrations_online()
File "R:\Geina-WEB\migrations\env.py", line 113, in run_migrations_online
context.run_migrations()
File "", line 8, in run_migrations
File "R:\Geina-WEB.venv\Lib\site-packages\alembic\runtime\environment.py", line 946, in run_migrations
self.get_context().run_migrations(**kw)
File "R:\Geina-WEB.venv\Lib\site-packages\alembic\runtime\migration.py", line 606, in run_migrations
heads = self.get_current_heads()
^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\alembic\runtime\migration.py", line 539, in get_current_heads
if not self._has_version_table():
^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\alembic\runtime\migration.py", line 556, in _has_version_table
return sqla_compat._connectable_has_table(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\alembic\util\sqla_compat.py", line 299, in _connectable_has_table
return inspect(connectable).has_table(tablename, schemaname)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "R:\Geina-WEB.venv\Lib\site-packages\sqlalchemy\engine\reflection.py", line 429, in has_table
return self.dialect.has_table(
^^^^^^^^^^^^^^^^^^^^^^^
TypeError: SQLAnyDialect.has_table() got an unexpected keyword argument 'info_cache'

I analyzed the module and understood that it depends on the fact that the module must be updated to the SQLAlcademy 2.0 version.

Perhaps you can help me solve it

ringrazio anticipatamento per l'aiuto

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions