Classe « CMySQLConnection »

Informations générales

Héritage

builtins.object
    ABC
        MySQLConnectionAbstract
            CMySQLConnection

Définition

class CMySQLConnection(MySQLConnectionAbstract):

help(CMySQLConnection)

Class initiating a MySQL Connection using Connector/C.

Constructeur(s)

Signature du constructeur	Description
__init__(self, **kwargs: Any) -> None	Initialization _{[extrait de __init__.__doc__]}

Liste des propriétés

Nom de la propriété	Description
autocommit	Get 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__]}
more_results	Check if there are more results _{[extrait de more_results.__doc__]}
num_rows	Returns number of rows of current result set _{[extrait de num_rows.__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
result_set_available	Check if a result set is available _{[extrait de result_set_available.__doc__]}
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	Check if there are unread results or rows _{[extrait de unread_result.__doc__]}
user	The user name used for connecting to the MySQL server. _{[extrait de user.__doc__]}
warning_count	Returns number of warnings _{[extrait de warning_count.__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: Optional[str] = None, oci_config_profile: Optional[str] = None, openid_token_file: Optional[str] = None) -> None	Change the current logged in user _{[extrait de cmd_change_user.__doc__]}
cmd_debug(self) -> NoReturn	Send the DEBUG command _{[extrait de cmd_debug.__doc__]}
cmd_init_db(self, database: str) -> None	Change the current database _{[extrait de cmd_init_db.__doc__]}
cmd_ping(self) -> NoReturn	Send the PING command _{[extrait de cmd_ping.__doc__]}
cmd_process_kill(self, mysql_pid: int) -> None	Kill a MySQL process _{[extrait de cmd_process_kill.__doc__]}
cmd_query_iter(self, statements: str, **kwargs: Any) -> NoReturn	Send one or more statements to the MySQL server _{[extrait de cmd_query_iter.__doc__]}
cmd_quit(self) -> None	Close the current connection with the server _{[extrait de cmd_quit.__doc__]}
cmd_refresh(self, options: int) -> Optional[Dict[str, int]]
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) -> Dict[str, Union[int, decimal.Decimal]]	Return statistics from the MySQL server _{[extrait de cmd_statistics.__doc__]}
cmd_stmt_close(self, statement_id: mysql.connector.abstracts.CMySQLPrepStmt, **kwargs: Any) -> None	Closes the prepared statement _{[extrait de cmd_stmt_close.__doc__]}
cmd_stmt_prepare(self, statement: bytes, **kwargs: Any) -> mysql.connector.abstracts.CMySQLPrepStmt	Prepares the SQL statement _{[extrait de cmd_stmt_prepare.__doc__]}
cmd_stmt_reset(self, statement_id: mysql.connector.abstracts.CMySQLPrepStmt, **kwargs: Any) -> None	Resets the prepared statement _{[extrait de cmd_stmt_reset.__doc__]}
cmd_stmt_send_long_data(self, statement_id: mysql.connector.abstracts.CMySQLPrepStmt, param_id: int, data: <class 'BinaryIO'>, **kwargs: Any) -> NoReturn	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 the current result _{[extrait de consume_results.__doc__]}
cursor(self, buffered: Optional[bool] = None, raw: Optional[bool] = None, prepared: Optional[bool] = None, cursor_class: Optional[Type[mysql.connector.cursor_cext.CMySQLCursor]] = None, dictionary: Optional[bool] = None, named_tuple: Optional[bool] = None, read_timeout: Optional[int] = None, write_timeout: Optional[int] = None) -> mysql.connector.cursor_cext.CMySQLCursor	Instantiates and returns a cursor using C Extension _{[extrait de cursor.__doc__]}
disconnect(self) -> None	Disconnect from the MySQL server _{[extrait de close.__doc__]}
fetch_eof_columns(self, prep_stmt: Optional[mysql.connector.abstracts.CMySQLPrepStmt] = None) -> Dict[str, Union[Dict[str, int], List[Tuple[str, int, NoneType, NoneType, NoneType, NoneType, Union[bool, int], int, int]]]]	Fetch EOF and column information _{[extrait de fetch_eof_columns.__doc__]}
fetch_eof_status(self) -> Optional[Dict[str, int]]	Fetch EOF and status information _{[extrait de fetch_eof_status.__doc__]}
free_result(self) -> None	Frees the result _{[extrait de free_result.__doc__]}
get_row(self, binary: bool = False, columns: Optional[List[Tuple[str, int, NoneType, NoneType, NoneType, NoneType, Union[bool, int], int, int]]] = None, raw: Optional[bool] = None, prep_stmt: Optional[mysql.connector.abstracts.CMySQLPrepStmt] = None, **kwargs: Any) -> Tuple[Optional[Tuple[Union[decimal.Decimal, bytes, datetime.date, datetime.datetime, float, int, Set[str], str, datetime.timedelta, NoneType, datetime.time], ...]], Optional[Dict[str, int]]]	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[Tuple[str, int, NoneType, NoneType, NoneType, NoneType, Union[bool, int], int, int]]] = None, raw: Optional[bool] = None, prep_stmt: Optional[mysql.connector.abstracts.CMySQLPrepStmt] = None, **kwargs: Any) -> Tuple[List[Tuple[Union[decimal.Decimal, bytes, datetime.date, datetime.datetime, float, int, Set[str], str, datetime.timedelta, NoneType, datetime.time], ...]], Optional[Dict[str, int]]]	Get all or a subset of rows returned by the MySQL server _{[extrait de get_rows.__doc__]}
handle_unread_result(self, prepared: bool = False) -> None	Check whether there is an unread result _{[extrait de handle_unread_result.__doc__]}
info_query(self, query: Union[str, bytes]) -> Optional[Tuple[Union[decimal.Decimal, bytes, datetime.date, datetime.datetime, float, int, Set[str], str, datetime.timedelta, NoneType, datetime.time], ...]]	Send a query which only returns 1 row _{[extrait de info_query.__doc__]}
is_closed(self) -> bool	Return True if the connection to MySQL Server is closed. _{[extrait de is_closed.__doc__]}
is_connected(self) -> bool	Reports whether the connection to MySQL Server is available _{[extrait de is_connected.__doc__]}
next_result(self) -> Optional[bool]	Reads the next result _{[extrait de next_result.__doc__]}
ping(self, reconnect: bool = False, attempts: int = 1, delay: int = 0) -> None	Check availability of the MySQL server _{[extrait de ping.__doc__]}
prepare_for_mysql(self, params: Union[Dict[str, Union[decimal.Decimal, bytes, datetime.date, datetime.datetime, float, int, str, datetime.time, datetime.timedelta, NoneType, bool, time.struct_time]], Sequence[Union[decimal.Decimal, bytes, datetime.date, datetime.datetime, float, int, str, datetime.time, datetime.timedelta, NoneType, bool, time.struct_time]]]) -> Union[Sequence[bytes], Dict[bytes, bytes]]	Prepare parameters for statements _{[extrait de prepare_for_mysql.__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 local_infile_in_path _{[extrait de set_allow_local_infile_in_path.__doc__]}
set_character_set_name(self, charset: str) -> None	Sets the default character set name for current connection. _{[extrait de set_character_set_name.__doc__]}
set_unicode(self, value: bool = True) -> None	Toggle unicode mode _{[extrait de set_unicode.__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, shutdown, start_transaction