Classe « connection »

Méthode mariadb.connection.connect

Signature de la méthode connect

def connect(*args, **kwargs) 

Description

connect.__doc__

Establishes a connection to a database server and returns a connection
object.

Connection parameters are provided as a set of keyword arguments:
----------------------
host: string
    The host name or IP address of the database server

user: string
username: string
    The username used to authenticate with the database server

password: string
passwd: string
    The password of the given user

database: string
db: string
    database (schema) name to use when connecting with the database
    server

unix_socket: string
    The location of the unix socket file to use instead of using an IP port
    to connect. If socket authentication is enabled, this can also be used
    in place of a password.

port: integer
    port number of the database server. If not specified the default
    value of 3306 will be used.

connect_timeout: integer
    connect timeout in seconds

read_timeout: integer
    read timeout in seconds

write_timeout: integer
    write timeout in seconds

local_infile: boolean
    Eenables or disables the use of LOAD DATA LOCAL INFILE statements.

compress: boolean
    Uses the compressed protocol for client server communication. If the
    server doesn't support compressed protocol, the default protocol will
    be used

init_command: string
    Command(s) which will be executed when connecting and reconnecting to
    the database server

default_file: string
    Read options from the specified option file. If the file is an empty
    string, default configuration file(s) will be used

default_group: string
    Read options from the specified group

ssl_key: string
    Defines a path to a private key file to use for TLS. This option
    requires that you use the absolute path, not a relative path. The
    specified key must be in PEM format

ssl_cert: string
    Defines a path to the X509 certificate file to use for TLS.
    This option requires that you use the absolute path, not a relative
    path. The X609 certificate must be in PEM format.

ssl_ca: string
    Defines a path to a PEM file that should contain one or more X509
    certificates for trusted Certificate Authorities (CAs) to use for TLS.
    This option requires that you use the absolute path, not a relative
    path.

ssl_capath: string
    Defines a path to a directory that contains one or more PEM files that
    contains one X509 certificate for a trusted Certificate Authority (CA)

ssl_cipher: string
    Defines a list of permitted cipher suites to use for TLS

ssl_crlpath: string
    Defines a path to a PEM file that should contain one or more revoked
    X509 certificates to use for TLS. This option requires that you use
    the absolute path, not a relative path.

ssl_verify_cert: boolean
    Enables server certificate verification.

ssl: Boolean
    The connection must use TLS security or it will fail.

autocommit: Boolean or None
    Specifies the autocommit settings: None will use the server default,    True will enable autocommit, False will disable it (default).