diff options
| author | Gord Thompson <gord@gordthompson.com> | 2020-09-17 10:32:31 -0600 |
|---|---|---|
| committer | Gord Thompson <gord@gordthompson.com> | 2020-09-17 11:42:06 -0600 |
| commit | dcd2be16b9c9a6a52b6bb7e144e31998b7cee631 (patch) | |
| tree | e95ec8fb6fda83ead83997e34b5467aec02ed28d /lib/sqlalchemy | |
| parent | d5c89a541f5233baf6b6a7498746820caa7b407f (diff) | |
| download | sqlalchemy-dcd2be16b9c9a6a52b6bb7e144e31998b7cee631.tar.gz | |
Add support for Azure authentication options
Fixes: #5592
Change-Id: I0688e5ea0fc6b01a0b72f397daea8f57a2ec0766
Diffstat (limited to 'lib/sqlalchemy')
| -rw-r--r-- | lib/sqlalchemy/connectors/pyodbc.py | 10 | ||||
| -rw-r--r-- | lib/sqlalchemy/dialects/mssql/pyodbc.py | 3 |
2 files changed, 10 insertions, 3 deletions
diff --git a/lib/sqlalchemy/connectors/pyodbc.py b/lib/sqlalchemy/connectors/pyodbc.py index 96ac0c1f1..e1a7c99f4 100644 --- a/lib/sqlalchemy/connectors/pyodbc.py +++ b/lib/sqlalchemy/connectors/pyodbc.py @@ -95,9 +95,15 @@ class PyODBCConnector(Connector): user = keys.pop("user", None) if user: connectors.append("UID=%s" % user) - connectors.append("PWD=%s" % keys.pop("password", "")) + pwd = keys.pop("password", "") + if pwd: + connectors.append("PWD=%s" % pwd) else: - connectors.append("Trusted_Connection=Yes") + authentication = keys.pop("authentication", None) + if authentication: + connectors.append("Authentication=%s" % authentication) + else: + connectors.append("Trusted_Connection=Yes") # if set to 'Yes', the ODBC layer will try to automagically # convert textual data from your database encoding to your diff --git a/lib/sqlalchemy/dialects/mssql/pyodbc.py b/lib/sqlalchemy/dialects/mssql/pyodbc.py index df340bbca..8bc318ea0 100644 --- a/lib/sqlalchemy/dialects/mssql/pyodbc.py +++ b/lib/sqlalchemy/dialects/mssql/pyodbc.py @@ -52,7 +52,8 @@ name must be URL encoded which means using plus signs for spaces:: Other keywords interpreted by the Pyodbc dialect to be passed to ``pyodbc.connect()`` in both the DSN and hostname cases include: -``odbc_autotranslate``, ``ansi``, ``unicode_results``, ``autocommit``. +``odbc_autotranslate``, ``ansi``, ``unicode_results``, ``autocommit``, +``authentication`` (e.g., ``authentication=ActiveDirectoryIntegrated``). Note that in order for the dialect to recognize these keywords (including the ``driver`` keyword above) they must be all lowercase. |