ConnectorTypeMYSQL

class connector_types.connector_type_mysql.ConnectorTypeMYSQL

Interact with a MySQL database. This connector type supports the execute, fetch, fetchrow, and fetchval commands. Each command expects an SQL query and returns the status, list, record or field value respectively.

Consult the MySQL SQL language documentation at https://dev.mysql.com/doc/refman/8.0/en/introduction.html for more information.

Inputs

Name	Type	Default	Description
check_hostname	bool	True	If set, the hostname of the MySQL server is checked against the server_ca certificate
database	str	``
execute	str	None
executemany	list	None
fetch	str	None
fetchrow	str	None
fetchval	str	None
host	str
params	list	None
password	str	None
port	int	3306
server_ca	str	None
transaction	list	None
user	str	root

Outputs

Name	Type	Default	Description
result	object

Constants

input_list = ['check_hostname', 'database', 'execute', 'executemany', 'fetch', 'fetchrow', 'fetchval', 'host', 'params', 'password', 'port', 'server_ca', 'transaction', 'user'] output_list = ['result'] ssl_context_inputs = ['check_hostname', 'client_cert', 'client_key', 'server_ca'] version = 1

Methods

execute

details

log

details

one_of_inputs

details

run

details