SEC [ lisadubreuil.com ]

Linux server182.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64

LiteSpeed

198.54.114.128 | Your IP: 216.73.216.141

Cant read [ /etc/named.conf ]

[ drwxr-xr-x ]

/ opt / hc_python / lib64 / python3.12 / site-packages / sqlalchemy / dialects / mysql /

Home Upload Mass Deface Mass Delete Back Connect Info Server

Server Info

Operating System	:	Linux server182.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64
User / Group	:	1096[lisavlym] / 1092[lisavlym]
PHP Version	:	7.4.33
IP Server	:	198.54.114.128
Your IP	:	216.73.216.141
Storage	:	Total = 69.29 GB, Free = 41.67 GB [60%]
Domains	:	Cant read [ /etc/named.conf ]
Software	:	LiteSpeed
Disable Functions	:	All function is accessible
Useful Functions	:	gcc, lcc, cc, ld, make, php, perl, python, ruby, tar, gzip, bzip, bzialfa2, nc, locate, suidperl, git, docker, ssh
Downloader	:	wget, fetch, lynx, links, curl, get, lwp-mirror
CURL : ON \| SSH2 : OFF \| Magic Quotes : ON \| MySQL : ON \| MSSQL : OFF \| PostgreSQL : ON \| Oracle : OFF
Safe Mode : OFF \| Open Basedir : NONE \| Safe Mode Exec Dir : NONE \| Safe Mode Include Dir : NONE

pyodbc.py

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

r"""

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

.. note::

The PyODBC for MySQL dialect is **not tested as part of
    SQLAlchemy's continuous integration**.
    The recommended MySQL dialects are mysqlclient and PyMySQL.
    However, if you want to use the mysql+pyodbc dialect and require
    full support for ``utf8mb4`` characters (including supplementary
    characters like emoji) be sure to use a current release of
    MySQL Connector/ODBC and specify the "ANSI" (**not** "Unicode")
    version of the driver in your DSN or connection string.

Pass through exact pyodbc connection string::

import urllib

connection_string = (
        "DRIVER=MySQL ODBC 8.0 ANSI Driver;"
        "SERVER=localhost;"
        "PORT=3307;"
        "DATABASE=mydb;"
        "UID=root;"
        "PWD=(whatever);"
        "charset=utf8mb4;"
    )
    params = urllib.parse.quote_plus(connection_string)
    connection_uri = "mysql+pyodbc:///?odbc_connect=%s" % params

"""  # noqa

import re

from .base import MySQLDialect
from .base import MySQLExecutionContext
from .types import TIME
from ... import exc
from ... import util
from ...connectors.pyodbc import PyODBCConnector
from ...sql.sqltypes import Time

class _pyodbcTIME(TIME):
    def result_processor(self, dialect, coltype):
        def process(value):
            # pyodbc returns a datetime.time object; no need to convert
            return value

return process

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_statement_cache = True
    colspecs = util.update_copy(MySQLDialect.colspecs, {Time: _pyodbcTIME})
    supports_unicode_statements = True
    execution_ctx_cls = MySQLExecutionContext_pyodbc

pyodbc_driver_name = "MySQL"

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.

# set this to None as _fetch_setting attempts to use it (None is OK)
        self._connection_charset = None
        try:
            value = self._fetch_setting(connection, "character_set_client")
            if value:
                return value
        except exc.DBAPIError:
            pass

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

def _get_server_version_info(self, connection):
        return MySQLDialect._get_server_version_info(self, connection)

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

def on_connect(self):
        super_ = super().on_connect()

def on_connect(conn):
            if super_ is not None:
                super_(conn)

# declare Unicode encoding for pyodbc as per
            #   https://github.com/mkleehammer/pyodbc/wiki/Unicode
            pyodbc_SQL_CHAR = 1  # pyodbc.SQL_CHAR
            pyodbc_SQL_WCHAR = -8  # pyodbc.SQL_WCHAR
            conn.setdecoding(pyodbc_SQL_CHAR, encoding="utf-8")
            conn.setdecoding(pyodbc_SQL_WCHAR, encoding="utf-8")
            conn.setencoding(encoding="utf-8")

return on_connect

dialect = MySQLDialect_pyodbc

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	drwxr-xr-x	2025-04-04 07:56:46
..	dir	-	root/root	drwxr-xr-x	2025-04-04 07:56:46
__pycache__	dir	-	root/root	drwxr-xr-x	2025-04-04 07:56:46
__init__.py	text/x-python	2.15 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
aiomysql.py	text/x-python	9.78 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
asyncmy.py	text/x-python	9.84 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
base.py	text/plain	121.57 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
cymysql.py	text/x-python	2.25 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
dml.py	text/x-python	7.59 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
enumerated.py	text/x-python	8.25 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
expression.py	text/x-python	4.02 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
json.py	text/x-python	2.22 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
mariadb.py	text/x-python	1.42 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
mariadbconnector.py	text/x-python	8.42 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
mysqlconnector.py	text/x-python	5.59 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
mysqldb.py	text/x-python	9.3 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
provision.py	text/x-python	3.49 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
pymysql.py	text/x-python	3.99 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
pyodbc.py	text/x-python	4.2 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
reflection.py	text/x-python	22.3 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
reserved_words.py	text/plain	9.04 KB	root/root	-rw-r--r--	2025-04-04 07:56:46
types.py	text/x-python	23.77 KB	root/root	-rw-r--r--	2025-04-04 07:56:46