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.

Input Schema

• host

  Type: string

• port

  Type: anyOf

  Options:

• user

  Type: string

  Default: root

• password

  Type: string

• database

  Type: string

• server_ca

  Type: anyOf

  Options:

• check_hostname

  If set, the hostname of the MySQL server is checked against the server_ca certificate.

  Type: boolean

  Default: True

• execute

  Type: anyOf

  Options:

• executemany

  Type: anyOf

  Options:

• fetch

  Type: anyOf

  Options:

• fetchrow

  Type: anyOf

  Options:

• fetchval

  Type: anyOf

  Options:

• transaction

  Type: anyOf

  Options:

• params

  Type: array

  Items:

Output Schema

• result

  Data

Constants

ssl_context_inputs = ['check_hostname', 'client_cert', 'client_key', 'server_ca']