pep-484: asyncio

in this patch the asyncio/events.py module, which
existed only to raise errors when trying to attach event
listeners, is removed, as we were already coding an asyncio-specific
workaround in upstream Pool / Session to raise this error,
just moved the error out to the target and did the same thing
for Engine.

We also add an async_sessionmaker class.  The initial rationale
here is because sessionmaker() is hardcoded to Session subclasses,
and there's not a way to get the use case of
sessionmaker(class_=AsyncSession) to type correctly without changing
the sessionmaker() symbol itself to be a function and not a class,
which gets too complicated for what this is. Additionally,
_SessionClassMethods has only three methods on it, one of which
is not usable with asyncio (close_all()), the others
not generally used from the session class.

Change-Id: I064a5fa5d91cc8d5bbe9597437536e37b4e801fe

1 files changed, 2 insertions, 1 deletions

diff --git a/lib/sqlalchemy/sql/base.py b/lib/sqlalchemy/sql/base.py
index ccd5e8c40..d58743340 100644
--- a/lib/sqlalchemy/sql/base.py
+++ b/lib/sqlalchemy/sql/base.py
@@ -73,6 +73,7 @@ if TYPE_CHECKING:
     from .selectable import _SelectIterable
     from .selectable import FromClause
     from ..engine import Connection
+    from ..engine import CursorResult
     from ..engine import Result
     from ..engine.base import _CompiledCacheType
     from ..engine.interfaces import _CoreMultiExecuteParams
@@ -983,7 +984,7 @@ class Executable(roles.StatementRole, Generative):
             distilled_params: _CoreMultiExecuteParams,
             execution_options: _ExecuteOptionsParameter,
             _force: bool = False,
-        ) -> Result:
+        ) -> CursorResult:
             ...
 
     @util.ro_non_memoized_property