Classe « MySQLConnection »

Informations générales

Héritage

builtins.object
    ABC
        MySQLConnectionAbstract
            MySQLConnection

Définition

class MySQLConnection(MySQLConnectionAbstract):

help(MySQLConnection)

Connection to a MySQL Server

Constructeur(s)

Signature du constructeur	Description
__init__(self, **kwargs: 'Any') -> 'None'

Liste des propriétés

Nom de la propriété	Description
autocommit	Gets whether autocommit is on or off. _{[extrait de autocommit.__doc__]}
can_consume_results	Returns whether to consume results. _{[extrait de can_consume_results.__doc__]}
charset	Returns the character set for current connection. _{[extrait de charset.__doc__]}
charset_id	The charset ID utilized during the connection phase. _{[extrait de charset_id.__doc__]}
collation	Returns the collation for current connection. _{[extrait de collation.__doc__]}
connection_id	MySQL connection ID _{[extrait de connection_id.__doc__]}
database	Get the current database _{[extrait de database.__doc__]}
get_warnings	Gets whether this connection retrieves warnings automatically. _{[extrait de get_warnings.__doc__]}
have_next_result	Returns If have next result. _{[extrait de have_next_result.__doc__]}
in_transaction	MySQL session has started a transaction _{[extrait de in_transaction.__doc__]}
is_secure	Returns `True` if is a secure connection. _{[extrait de is_secure.__doc__]}
pool_config_version	Returns the pool configuration version. _{[extrait de pool_config_version.__doc__]}
python_charset	Returns the Python character set for current connection. _{[extrait de python_charset.__doc__]}
query_attrs	Returns query attributes list. _{[extrait de query_attrs.__doc__]}
raise_on_warnings	Gets whether this connection raises an error on warnings. _{[extrait de raise_on_warnings.__doc__]}
read_timeout
server_host	MySQL server IP address or name. _{[extrait de server_host.__doc__]}
server_port	MySQL server TCP/IP port. _{[extrait de server_port.__doc__]}
sql_mode	Gets the SQL mode. _{[extrait de sql_mode.__doc__]}
time_zone	Gets the current time zone. _{[extrait de time_zone.__doc__]}
unix_socket	The Unix socket file for connecting to the MySQL server. _{[extrait de unix_socket.__doc__]}
unread_result	Gets whether there is an unread result. _{[extrait de unread_result.__doc__]}
user	The user name used for connecting to the MySQL server. _{[extrait de user.__doc__]}
write_timeout

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
close(self) -> 'None'	Disconnect from the MySQL server _{[extrait de close.__doc__]}
cmd_change_user(self, username: 'str' = '', password: 'str' = '', database: 'str' = '', charset: 'Optional[int]' = None, password1: 'str' = '', password2: 'str' = '', password3: 'str' = '', oci_config_file: 'str' = '', oci_config_profile: 'str' = '', openid_token_file: 'str' = '') -> 'Optional[OkPacketType]'	Change the current logged in user _{[extrait de cmd_change_user.__doc__]}
cmd_debug(self) -> 'EofPacketType'	Send the DEBUG command _{[extrait de cmd_debug.__doc__]}
cmd_init_db(self, database: 'str') -> 'OkPacketType'	Change the current database _{[extrait de cmd_init_db.__doc__]}
cmd_ping(self) -> 'OkPacketType'	Send the PING command _{[extrait de cmd_ping.__doc__]}
cmd_process_kill(self, mysql_pid: 'int') -> 'OkPacketType'	Kill a MySQL process _{[extrait de cmd_process_kill.__doc__]}
cmd_query_iter(self, statements: 'StrOrBytes', **kwargs: 'Any') -> 'Generator[ResultType, None, None]'	Send one or more statements to the MySQL server _{[extrait de cmd_query_iter.__doc__]}
cmd_quit(self) -> 'bytes'	Close the current connection with the server _{[extrait de cmd_quit.__doc__]}
cmd_refresh(self, options: 'int') -> 'OkPacketType'
cmd_reset_connection(self) -> 'bool'	Resets the session state without re-authenticating _{[extrait de cmd_reset_connection.__doc__]}
cmd_shutdown(self, shutdown_type: 'Optional[int]' = None) -> 'None'	Shut down the MySQL Server _{[extrait de cmd_shutdown.__doc__]}
cmd_statistics(self) -> 'StatsPacketType'	Send the statistics command to the MySQL Server _{[extrait de cmd_statistics.__doc__]}
cmd_stmt_close(self, statement_id: 'int', **kwargs: 'Any') -> 'None'	Deallocate a prepared MySQL statement _{[extrait de cmd_stmt_close.__doc__]}
cmd_stmt_fetch(self, statement_id: 'int', rows: 'int' = 1, **kwargs: 'Any') -> 'None'	Fetch a MySQL statement Result Set _{[extrait de cmd_stmt_fetch.__doc__]}
cmd_stmt_prepare(self, statement: 'bytes', **kwargs: 'Any') -> 'Mapping[str, Union[int, List[DescriptionType]]]'	Prepare a MySQL statement _{[extrait de cmd_stmt_prepare.__doc__]}
cmd_stmt_reset(self, statement_id: 'int', **kwargs: 'Any') -> 'None'	Reset data for prepared statement sent as long data _{[extrait de cmd_stmt_reset.__doc__]}
cmd_stmt_send_long_data(self, statement_id: 'int', param_id: 'int', data: 'BinaryIO', **kwargs: 'Any') -> 'int'	Send data for a column _{[extrait de cmd_stmt_send_long_data.__doc__]}
commit(self) -> 'None'	Commit current transaction _{[extrait de commit.__doc__]}
consume_results(self) -> 'None'	Consume results _{[extrait de consume_results.__doc__]}
cursor(self, buffered: 'Optional[bool]' = None, raw: 'Optional[bool]' = None, prepared: 'Optional[bool]' = None, cursor_class: 'Optional[Type[MySQLCursor]]' = None, dictionary: 'Optional[bool]' = None, named_tuple: 'Optional[bool]' = None, read_timeout: 'Optional[int]' = None, write_timeout: 'Optional[int]' = None) -> 'MySQLCursor'	Instantiates and returns a cursor _{[extrait de cursor.__doc__]}
disconnect(self) -> 'None'	Disconnect from the MySQL server _{[extrait de close.__doc__]}
get_row(self, binary: 'bool' = False, columns: 'Optional[List[DescriptionType]]' = None, raw: 'Optional[bool]' = None, prep_stmt: 'Optional[CMySQLPrepStmt]' = None, **kwargs: 'Any') -> 'Tuple[Optional[RowType], Optional[EofPacketType]]'	Get the next rows returned by the MySQL server _{[extrait de get_row.__doc__]}
get_rows(self, count: 'Optional[int]' = None, binary: 'bool' = False, columns: 'Optional[List[DescriptionType]]' = None, raw: 'Optional[bool]' = None, prep_stmt: 'Optional[CMySQLPrepStmt]' = None, **kwargs: 'Any') -> 'Tuple[List[RowType], Optional[EofPacketType]]'	Get all rows returned by the MySQL server _{[extrait de get_rows.__doc__]}
handle_unread_result(self) -> 'None'	Check whether there is an unread result _{[extrait de handle_unread_result.__doc__]}
info_query(self, query: 'str') -> 'Optional[RowType]'	Send a query which only returns 1 row _{[extrait de info_query.__doc__]}
is_connected(self) -> 'bool'	Reports whether the connection to MySQL Server is available _{[extrait de is_connected.__doc__]}
ping(self, reconnect: 'bool' = False, attempts: 'int' = 1, delay: 'int' = 0) -> 'None'	Check availability of the MySQL server _{[extrait de ping.__doc__]}
reset_session(self, user_variables: 'Optional[Dict[str, Any]]' = None, session_variables: 'Optional[Dict[str, Any]]' = None) -> 'None'	Clears the current active session _{[extrait de reset_session.__doc__]}
rollback(self) -> 'None'	Rollback current transaction _{[extrait de rollback.__doc__]}
set_allow_local_infile_in_path(self, path: 'str') -> 'None'	Set the path that user can upload files. _{[extrait de set_allow_local_infile_in_path.__doc__]}
shutdown(self) -> 'None'	Shut down connection to MySQL Server. _{[extrait de shutdown.__doc__]}

Méthodes héritées de la classe MySQLConnectionAbstract

__enter__, __exit__, __init_subclass__, __subclasshook__, cmd_process_info, cmd_query, cmd_stmt_execute, config, connect, get_self, get_server_info, get_server_version, isset_client_flag, query_attrs_append, query_attrs_clear, query_attrs_remove, reconnect, set_charset_collation, set_client_flags, set_converter_class, set_login, set_unicode, start_transaction