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
execution_id	int		The ID of the connection execution
message	str		The ended message for the connection. If the connection ended with an error, the message will contain information about what went wrong
result	object
status	str		The ended status for the connection. Either "success" or "error".

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 ()

log (message)

one_of_inputs (options)

run ()