Hi,

I am interested in getting this exact same stack up and running, but after I clone, install all the dependencies and setup the DATABASE in the .env file and run python app/main.py and I get the following error:

$ python app/main.py 
INFO: Uvicorn running on http://localhost:8888 (Press CTRL+C to quit)
INFO: Started reloader process [49720]
INFO: Started server process [49722]
INFO: Waiting for application startup.
INFO: ASGI 'lifespan' protocol appears unsupported.
INFO: ('127.0.0.1', 59591) - "GET / HTTP/1.1" 500
ERROR: Exception in ASGI application
Traceback (most recent call last):
  File "/Users/arnaudsj/.local/share/virtualenvs/h7IURhCI/lib/python3.7/site-packages/uvicorn/protocols/http/httptools_impl.py", line 370, in run_asgi
    result = await app(self.scope, self.receive, self.send)
  File "/Users/arnaudsj/.local/share/virtualenvs/h7IURhCI/lib/python3.7/site-packages/uvicorn/middleware/debug.py", line 81, in __call__
    raise exc from None
  File "/Users/arnaudsj/.local/share/virtualenvs/h7IURhCI/lib/python3.7/site-packages/uvicorn/middleware/debug.py", line 78, in __call__
    await self.app(scope, receive, inner_send)
  File "/Users/arnaudsj/.local/share/virtualenvs/h7IURhCI/lib/python3.7/site-packages/starlette/applications.py", line 133, in __call__
    await self.error_middleware(scope, receive, send)
  File "/Users/arnaudsj/.local/share/virtualenvs/h7IURhCI/lib/python3.7/site-packages/starlette/middleware/errors.py", line 122, in __call__
    raise exc from None
  File "/Users/arnaudsj/.local/share/virtualenvs/h7IURhCI/lib/python3.7/site-packages/starlette/middleware/errors.py", line 100, in __call__
    await self.app(scope, receive, _send)
  File "/Users/arnaudsj/.local/share/virtualenvs/h7IURhCI/lib/python3.7/site-packages/gino/ext/starlette.py", line 73, in __call__
    scope['connection'] = await self.db.acquire(lazy=True)
  File "/Users/arnaudsj/.local/share/virtualenvs/h7IURhCI/lib/python3.7/site-packages/gino/api.py", line 481, in acquire
    return self.bind.acquire(*args, **kwargs)
  File "/Users/arnaudsj/.local/share/virtualenvs/h7IURhCI/lib/python3.7/site-packages/gino/api.py", line 501, in __getattribute__
    raise self._exception
gino.exceptions.UninitializedError: Gino engine is not initialized.

With both of these on the same path alembic causes a deadlock condition trying to create the alembic_version table for the first time.

When I inspected the call path (by pdbing _ensure_version_table), I saw the second call to create the table that happened during the same (first) transaction, originated from the get_revisions call path. Not sure how this could ever work for someone else.

(Pdb) w
  venv/bin/alembic(8)<module>()
-> sys.exit(main())
  venv/lib/python3.8/site-packages/alembic/config.py(577)main()
-> CommandLine(prog=prog).main(argv=argv)
  venv/lib/python3.8/site-packages/alembic/config.py(571)main()
-> self.run_cmd(cfg, options)
  venv/lib/python3.8/site-packages/alembic/config.py(548)run_cmd()
-> fn(
  venv/lib/python3.8/site-packages/alembic/command.py(214)revision()
-> script_directory.run_env()
  venv/lib/python3.8/site-packages/alembic/script/base.py(489)run_env()
-> util.load_python_file(self.dir, "env.py")
  venv/lib/python3.8/site-packages/alembic/util/pyfiles.py(98)load_python_file()
-> module = load_module_py(module_id, path)
  venv/lib/python3.8/site-packages/alembic/util/compat.py(184)load_module_py()
-> spec.loader.exec_module(module)
  <frozen importlib._bootstrap_external>(783)exec_module()
  <frozen importlib._bootstrap>(219)_call_with_frames_removed()
  london-looker/app/models/orm/migrations/env.py(78)<module>()
-> run_migrations_online()
  london-looker/app/models/orm/migrations/env.py(72)run_migrations_online()
-> context.run_migrations()
  <string>(8)run_migrations()
  venv/lib/python3.8/site-packages/alembic/runtime/environment.py(846)run_migrations()
-> self.get_context().run_migrations(**kw)
  venv/lib/python3.8/site-packages/alembic/runtime/migration.py(510)run_migrations()
-> for step in self._migrations_fn(heads, self):
  venv/lib/python3.8/site-packages/alembic/command.py(190)retrieve_migrations()
-> revision_context.run_autogenerate(rev, context)
  venv/lib/python3.8/site-packages/alembic/autogenerate/api.py(442)run_autogenerate()
-> self._run_environment(rev, migration_context, True)
  venv/lib/python3.8/site-packages/alembic/autogenerate/api.py(454)_run_environment()
-> self.script_directory.get_revisions("heads")
  venv/lib/python3.8/site-packages/alembic/script/base.py(227)get_revisions()
-> return self.revision_map.get_revisions(id_)
  venv/lib/python3.8/site-packages/alembic/script/revision.py(321)get_revisions()
-> resolved_id, branch_label = self._resolve_revision_number(id_)
  venv/lib/python3.8/site-packages/alembic/script/revision.py(501)_resolve_revision_number()
-> self._revision_map
  venv/lib/python3.8/site-packages/alembic/util/langhelpers.py(230)__get__()
-> obj.__dict__[self.__name__] = result = self.fget(obj)
  venv/lib/python3.8/site-packages/alembic/script/revision.py(123)_revision_map()
-> for revision in self._generator():
  venv/lib/python3.8/site-packages/alembic/script/base.py(112)_load_revisions()
-> script = Script._from_filename(self, vers, file_)
  venv/lib/python3.8/site-packages/alembic/script/base.py(906)_from_filename()
-> module = util.load_python_file(dir_, filename)
  venv/lib/python3.8/site-packages/alembic/util/pyfiles.py(98)load_python_file()
-> module = load_module_py(module_id, path)
  venv/lib/python3.8/site-packages/alembic/util/compat.py(184)load_module_py()
-> spec.loader.exec_module(module)
  <frozen importlib._bootstrap_external>(783)exec_module()
  <frozen importlib._bootstrap>(219)_call_with_frames_removed()
  london-looker/app/models/orm/migrations/env.py(78)<module>()
-> run_migrations_online()
  london-looker/app/models/orm/migrations/env.py(72)run_migrations_online()
-> context.run_migrations()
  <string>(8)run_migrations()
  venv/lib/python3.8/site-packages/alembic/runtime/environment.py(846)run_migrations()
-> self.get_context().run_migrations(**kw)
  venv/lib/python3.8/site-packages/alembic/runtime/migration.py(502)run_migrations()
-> self._ensure_version_table()
> venv/lib/python3.8/site-packages/alembic/runtime/migration.py(443)_ensure_version_table()
-> self._version.create(self.connection, checkfirst=True)

(rationale: apk update / apk add should happen before pipfile, saves build time)

As referenced in https://github.com/leosussan/fastapi-gino-arq-uvicorn/pull/6#discussion_r340017046

Implements @samuelcolvin's Arq task queue for robust job / RPC handling.

PR includes:

• Distinct Dockerfile.worker, docker-compose.worker.yml
• Updated docker-compose.local.yml spins up Redis and worker
• ARQ_BACKGROUND_FUNCTIONS global: a string-separated list of function references. All listed functions made available to worker at instantiation
• New tasks folder for complicated application logic: app/tasks
• Example background function in app/tasks/messaging/send_message
• Example use of above background function in app/routes/users/create_user

Documentation: https://github.com/samuelcolvin/arq

updates to Pipfile.lock dept: added black to dev dependencies dept: added bandit to dev dependencies dept: added flake8 to dev dependencies dept: added rope to dev dependencies dept: email-validator to 1.0.5 dept: fastapi to 0.42.0 dept: psycopg2-binary to 2.8.4 dept: sqlalchemy-utils to 0.34.2 dept: uvicorn to 0.9.1

formatting: docker-compose.local.yml

I already migrate the models, but when try to manage te basic user CRUD using the endpoints, returns a 500 the create_user returns AttributeError: 'UserCreateIn' object has no attribute 'first'

Bumps certifi from 2020.4.5.1 to 2022.12.7.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Bumps urllib3 from 1.25.9 to 1.26.5.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Bumps mako from 1.1.2 to 1.2.2.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

While playing around with the gino ORM on the shell, I kept encountering the NoInspectionAvailable error. Eventually, I traced this back to @generic_repr decorator and removing it fixed the problem. Here is the full stack trace:

In [1]: from app.settings.globals import ARQ_BACKGROUND_FUNCTIONS, DATABASE_CONFIG
   ...: from app.models.orm.user import User
   ...: from app.application import app, db
   ...: await db.set_bind(DATABASE_CONFIG.url)
   ...: await User.get(1)
Out[1]: -------------------------------------------------
NoInspectionAvailable                     Traceback (most recent call last)
  /my_env/lib/python3.8/site-packages/IPython/core/formatters.py(702)__call__()
    700                 type_pprinters=self.type_printers,
    701                 deferred_pprinters=self.deferred_printers)
--> 702             printer.pretty(obj)
    703             printer.flush()
    704             return stream.getvalue()

  /my_env/lib/python3.8/site-packages/IPython/lib/pretty.py(394)pretty()
    392                         if cls is not object \
    393                                 and callable(cls.__dict__.get('__repr__')):
--> 394                             return _repr_pprint(obj, self, cycle)
    395
    396             return _default_pprint(obj, self, cycle)

  /my_env/lib/python3.8/site-packages/IPython/lib/pretty.py(700)_repr_pprint()
    698     """A pprint that just redirects to the normal repr function."""
    699     # Find newlines and replace them with p.break_()
--> 700     output = repr(obj)
    701     lines = output.splitlines()
    702     with p.group():

  /my_env/lib/python3.8/site-packages/sqlalchemy_utils/models.py(89)<lambda>()
     87     if len(fields) == 1 and callable(fields[0]):
     88         target = fields[0]
---> 89         target.__repr__ = lambda self: _generic_repr_method(self, fields=None)
     90         return target
     91     else:

  /my_env/lib/python3.8/site-packages/sqlalchemy_utils/models.py(42)_generic_repr_method()
     40
     41 def _generic_repr_method(self, fields):
---> 42     state = sa.inspect(self)
     43     field_reprs = []
     44     if not fields:

> /my_env/lib/python3.8/site-packages/sqlalchemy/inspection.py(71)inspect()
     69
     70     if raiseerr and (reg is None or ret is None):
---> 71         raise exc.NoInspectionAvailable(
     72             "No inspection system is "
     73             "available for object of type %s" % type_

NoInspectionAvailable: No inspection system is available for object of type <class 'app.models.orm.user.User'>```