KeyError occurs in a simple Alembic use case

[brunolnetto]

Dear fellows,

I (try to) use alembic in a small project. I setup the required URI for database. Since I add it to docker-compose as a command, it should run specifically on app startup. Unfortunately, I get following error. Since I am not familiar with alembic, this is hard for me to solve. The target metadata is 'target_metadata = Base.metadata' in my case. The repository is [1]. Any help is appreciated.

  File "/usr/local/bin/alembic", line 8, in <module>
    sys.exit(main())
  File "/usr/local/lib/python3.9/site-packages/alembic/config.py", line 641, in main
    CommandLine(prog=prog).main(argv=argv)
  File "/usr/local/lib/python3.9/site-packages/alembic/config.py", line 631, in main
    self.run_cmd(cfg, options)
  File "/usr/local/lib/python3.9/site-packages/alembic/config.py", line 608, in run_cmd
    fn(
  File "/usr/local/lib/python3.9/site-packages/alembic/command.py", line 403, in upgrade
    script.run_env()
  File "/usr/local/lib/python3.9/site-packages/alembic/script/base.py", line 583, in run_env
    util.load_python_file(self.dir, "env.py")
  File "/usr/local/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/local/lib/python3.9/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 850, in exec_module
  File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
  File "alembic/env.py", line 93, in <module>
    run_migrations_online()
  File "alembic/env.py", line 75, in run_migrations_online
    connectable = engine_from_config(
  File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 819, in engine_from_config
    url = options.pop("url")
KeyError: 'url'

[1] https://github.com/brunolnetto/RF_CNPJ/blob/dockerizer-crawler/alembic/env.py

[CaselIT]

Hi,

That seems that in the config is missing the url keyword when calling engine_from_config here https://github.com/brunolnetto/RF_CNPJ/blob/afdd77698cbb219fca9c16f55172449629eceffa/alembic/env.py#L75

[brunolnetto]

You have a good eyesight, sir. I initialized from command run 'alembic init'. Shouldn't it leave the key as a dev-user recommendation? I think so.

@CaselIT I use script [1] to initialize my database. Can Alembic run this script for me or is this not how Alembic work?

[1] https://github.com/brunolnetto/RF_CNPJ/blob/afdd77698cbb219fca9c16f55172449629eceffa/scripts/init_db.sh

[CaselIT]

You are free to edit the env file as you please. your liked example seems to construct the uri manually. You can use create_engine instead of engine_from_config

[brunolnetto]

Great. I made a use case for a simpler version of aforementioned repository. In case you are interested in helping further, I am unable to initialize (tables) and setup (roles and privileges) to the database just by use of SQLAlchemy and Alembic. Your help will be very appreciated. Thank you in advance.

https://github.com/brunolnetto/db-cron-docker/tree/main