REDROOM

Edit File Size: 2.63 KB

/proc/thread-self/root/opt/alt/python37/lib64/python3.7/site-packages/sqlalchemy/dialects/mysql/pyodbc.py

Text Base64

# mysql/pyodbc.py
# Copyright (C) 2005-2019 the SQLAlchemy authors and contributors
# <see AUTHORS file>
#
# This module is part of SQLAlchemy and is released under
# the MIT License: http://www.opensource.org/licenses/mit-license.php

"""

.. dialect:: mysql+pyodbc
    :name: PyODBC
    :dbapi: pyodbc
    :connectstring: mysql+pyodbc://<username>:<password>@<dsnname>
    :url: http://pypi.python.org/pypi/pyodbc/

.. note:: The PyODBC for MySQL dialect is not well supported, and
       is subject to unresolved character encoding issues
       which exist within the current ODBC drivers available.
       (see http://code.google.com/p/pyodbc/issues/detail?id=25).
       Other dialects for MySQL are recommended.

"""

import re

from .base import MySQLDialect
from .base import MySQLExecutionContext
from ... import util
from ...connectors.pyodbc import PyODBCConnector

class MySQLExecutionContext_pyodbc(MySQLExecutionContext):
    def get_lastrowid(self):
        cursor = self.create_cursor()
        cursor.execute("SELECT LAST_INSERT_ID()")
        lastrowid = cursor.fetchone()[0]
        cursor.close()
        return lastrowid

class MySQLDialect_pyodbc(PyODBCConnector, MySQLDialect):
    supports_unicode_statements = False
    execution_ctx_cls = MySQLExecutionContext_pyodbc

pyodbc_driver_name = "MySQL"

def __init__(self, **kw):
        # deal with http://code.google.com/p/pyodbc/issues/detail?id=25
        kw.setdefault("convert_unicode", True)
        super(MySQLDialect_pyodbc, self).__init__(**kw)

def _detect_charset(self, connection):
        """Sniff out the character set in use for connection results."""

# Prefer 'character_set_results' for the current connection over the
        # value in the driver.  SET NAMES or individual variable SETs will
        # change the charset without updating the driver's view of the world.
        #
        # If it's decided that issuing that sort of SQL leaves you SOL, then
        # this can prefer the driver value.
        rs = connection.execute("SHOW VARIABLES LIKE 'character_set%%'")
        opts = {row[0]: row[1] for row in self._compat_fetchall(rs)}
        for key in ("character_set_connection", "character_set"):
            if opts.get(key, None):
                return opts[key]

util.warn(
            "Could not detect the connection character set.  "
            "Assuming latin1."
        )
        return "latin1"

def _extract_error_code(self, exception):
        m = re.compile(r"\((\d+)\)").search(str(exception.args))
        c = m.group(1)
        if c:
            return int(c)
        else:
            return None

dialect = MySQLDialect_pyodbc

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Name	Size	Perms	Modified	Actions
__pycache__ DIR	-	drwxr-xr-x	2023-12-06 03:19:26	Edit Download recursive recursive
base.py	94.70 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
cymysql.py	2.19 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
dml.py	4.45 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
enumerated.py	11.04 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
gaerdbms.py	3.29 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
json.py	2.00 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
mysqlconnector.py	7.70 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
mysqldb.py	7.76 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
oursql.py	7.90 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
pymysql.py	2.28 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
pyodbc.py	2.63 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
reflection.py	17.42 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
types.py	24.02 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
zxjdbc.py	3.88 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive
__init__.py	2.01 KB	lrw-r--r--	2019-07-21 20:36:19	Edit Download recursive recursive

Directory Contents