Detect non async driver on engine creation

An error is raised when creating an async engine with an
incompatible dbapi. Before the error was raised only when
first using the engine.

Change-Id: I977952b4c03ae51f568749ad744c545197bcd887
Reference: #5920

1 files changed, 5 insertions, 0 deletions

diff --git a/lib/sqlalchemy/ext/asyncio/engine.py b/lib/sqlalchemy/ext/asyncio/engine.py
index aa7e60dfb..db95ab371 100644
--- a/lib/sqlalchemy/ext/asyncio/engine.py
+++ b/lib/sqlalchemy/ext/asyncio/engine.py
@@ -527,6 +527,11 @@ class AsyncEngine(ProxyComparable, AsyncConnectable):
             await self.conn.close()
 
     def __init__(self, sync_engine: Engine):
+        if not sync_engine.dialect.is_async:
+            raise exc.InvalidRequestError(
+                "The asyncio extension requires an async driver to be used. "
+                f"The loaded {sync_engine.dialect.driver!r} is not async."
+            )
         self.sync_engine = self._proxied = sync_engine
 
     def begin(self):