I've tried to setup this template and play a little bit with the commands. It seems that app database upgrade
command does not work because the signature of one of the method is invalid.
I'm going to create a pull request for this.
>> app database upgrade
Using Litestar app from env: 'app.asgi:app'
Cannot read Vite manifest file at /home/tevak/dev/litestar-fullstack/src/app/domain/web/public/manifest.json. Did you forget to build your assets?
Starting database upgrade process ───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Are you sure you you want migrate the database to the `head` revision? [y/n]: y
DEBUG - 2024-03-23 12:59:39,864 - asyncio - selector_events - Using selector: EpollSelector
......
sqlite3.Connection object at 0x6fff0ee863e0>) completed
Traceback (most recent call last):
File "/home/tevak/dev/litestar-fullstack/.venv/bin/app", line 8, in <module>
sys.exit(run_cli())
^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/src/app/__main__.py", line 26, in run_cli
run_litestar_cli()
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/litestar/__main__.py", line 6, in run_cli
litestar_group()
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/click/core.py", line 1157, in __call__
return self.main(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/rich_click/rich_command.py", line 126, in main
rv = self.invoke(ctx)
^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/click/core.py", line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/click/core.py", line 783, in invoke
return __callback(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/click/decorators.py", line 33, in new_func
return f(get_current_context(), *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/litestar/cli/_utils.py", line 273, in wrapped
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/click/decorators.py", line 33, in new_func
return f(get_current_context(), *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/litestar/cli/_utils.py", line 273, in wrapped
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/advanced_alchemy/extensions/litestar/cli.py", line 109, in upgrade_database
alembic_commands.upgrade(revision=revision, sql=sql, tag=tag)
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/advanced_alchemy/alembic/commands.py", line 92, in upgrade
return migration_command.upgrade(config=self.config, revision=revision, tag=tag, sql=sql)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/alembic/command.py", line 403, in upgrade
script.run_env()
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/alembic/script/base.py", line 583, in run_env
util.load_python_file(self.dir, "env.py")
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
module = load_module_py(module_id, path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<frozen importlib._bootstrap_external>", line 940, in exec_module
File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
File "/home/tevak/dev/litestar-fullstack/src/app/db/migrations/env.py", line 143, in <module>
asyncio.run(run_migrations_online())
File "/home/tevak/.pyenv/versions/3.11.4/lib/python3.11/asyncio/runners.py", line 190, in run
return runner.run(main)
^^^^^^^^^^^^^^^^
File "/home/tevak/.pyenv/versions/3.11.4/lib/python3.11/asyncio/runners.py", line 118, in run
return self._loop.run_until_complete(task)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/.pyenv/versions/3.11.4/lib/python3.11/asyncio/base_events.py", line 653, in run_until_complete
return future.result()
^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/src/app/db/migrations/env.py", line 135, in run_migrations_online
await connection.run_sync(do_run_migrations)
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/ext/asyncio/engine.py", line 880, in run_sync
return await greenlet_spawn(fn, self._proxied, *arg, **kw)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 186, in greenlet_spawn
result = context.switch(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/src/app/db/migrations/env.py", line 106, in do_run_migrations
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
self.get_context().run_migrations(**kw)
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/alembic/runtime/migration.py", line 605, in run_migrations
heads = self.get_current_heads()
^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/alembic/runtime/migration.py", line 538, in get_current_heads
if not self._has_version_table():
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/alembic/runtime/migration.py", line 555, in _has_version_table
return sqla_compat._connectable_has_table(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/alembic/util/sqla_compat.py", line 301, in _connectable_has_table
return inspect(connectable).has_table(tablename, schemaname)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/engine/reflection.py", line 429, in has_table
return self.dialect.has_table(
^^^^^^^^^^^^^^^^^^^^^^^
File "<string>", line 2, in has_table
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/engine/reflection.py", line 97, in cache
ret = fn(self, con, *args, **kw)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/dialects/sqlite/base.py", line 2150, in has_table
info = self._get_table_pragma(
^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/dialects/sqlite/base.py", line 2771, in _get_table_pragma
cursor = connection.exec_driver_sql(statement)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1782, in exec_driver_sql
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1842, in _execute_context
self._autobegin()
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 796, in _autobegin
self.begin()
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 864, in begin
self._transaction = RootTransaction(self)
^^^^^^^^^^^^^^^^^^^^^
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2684, in __init__
self._connection_begin_impl()
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2702, in _connection_begin_impl
self.connection._begin_impl(self)
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1107, in _begin_impl
self.dispatch.begin(self)
File "/home/tevak/dev/litestar-fullstack/.venv/lib/python3.11/site-packages/sqlalchemy/event/attr.py", line 497, in __call__
fn(*args, **kw)
TypeError: DatabaseSettings.get_engine.<locals>._sqla_on_begin() missing 1 required positional argument: '_'
### Package Version
2..7.0
### Platform
- [X] Linux
- [ ] Mac
- [ ] Windows
- [ ] Other (Please specify in the description above)