Classe « Connection »

Informations générales

Héritage

builtins.object
    connection
        Connection

Définition

class Connection(connection):

help(Connection)

MariaDB Connector/Python Connection Object

Handles the connection to a MariaDB or MySQL database server.
It encapsulates a database session.

Connections are created using the method mariadb.connect()

Constructeur(s)

Signature du constructeur	Description
__init__(self, args, *kwargs)

Liste des attributs statiques

Attributs statiques hérités de la classe connection

auto_reconnect, connection_id, DatabaseError, DataError, dsn, Error, IntegrityError, InterfaceError, InternalError, NotSupportedError, OperationalError, PoolError, ProgrammingError, Warning, warnings

Liste des propriétés

Nom de la propriété	Description
autocommit
character_set
character_set_name
client_capabilities	Client capability flags. _{[extrait de client_capabilities.__doc__]}
collation	Client character set collation _{[extrait de collation.__doc__]}
database	Get default database for connection. _{[extrait de database.__doc__]}
extended_server_capabilities
open
server_capabilities	Server capability flags. _{[extrait de server_capabilities.__doc__]}
server_info	Server version in alphanumerical format (str) _{[extrait de server_info.__doc__]}
server_name	Name or IP address of database server. _{[extrait de server_name.__doc__]}
server_port
server_status
server_version
server_version_info
socket	Returns the socket used for database connection _{[extrait de socket.__doc__]}
thread_id
tls_cipher	TLS cipher suite if a secure connection is used. _{[extrait de tls_cipher.__doc__]}
tls_peer_cert_info	Get peer certificate information. _{[extrait de tls_peer_cert_info.__doc__]}
tls_version	TLS protocol version if a secure connection is used. _{[extrait de tls_version.__doc__]}
unix_socket	Unix socket name. _{[extrait de unix_socket.__doc__]}
user

Liste des opérateurs

Opérateurs hérités de la classe object

__eq__, __ge__, __gt__, __le__, __lt__, __ne__

Liste des méthodes

Toutes les méthodes Méthodes d'instance Méthodes statiques

Signature de la méthode	Description
__enter__(self)
__exit__(self, exc_type, exc_val, exc_tb)
begin(self)
close(self)
commit(self)
cursor(self, cursorclass=<class 'mariadb.cursors.Cursor'>, **kwargs)
get_server_version(self)
kill(self, id: int)
rollback(self)
select_db(self, new_db: str)
show_warnings(self)
tpc_begin(self, xid)
tpc_commit(self, xid=None)
tpc_prepare(self)
tpc_recover(self)
tpc_rollback(self, xid=None)
xid(format_id, transaction_id, branch_qualifier)