Script Development / MySQL

The MySQL Connector provides methods to operate MySQL databases. This Connector supports the following databases:

DFF.CONN(...) parameters are as follows:

Parameter	Type	Required / Default	Description
`connector_id`	str	Required	Connector ID
`database`	str	`None`	Specified database

`.query(...)`

Executes SQL statements, parameters are as follows:

Parameter	Type	Required / Default	Description
`sql`	str	Required	SQL statement, which can include parameter placeholders. `?` represents escaped parameters; `??` represents non-escaped parameters
`sql_params`	list	`None`	SQL parameters

Example
sql = 'SELECT * FROM ?? WHERE seq > ?'
sql_params = ['demo', 1]
result = db.query(sql, sql_params=sql_params)

Executes SQL statements for insert, delete, update, etc., and returns the number of affected rows. Parameters are as follows:

Parameter	Type	Required / Default	Description
`sql`	str	Required	SQL statement, which can include parameter placeholders. `?` represents escaped parameters; `??` represents non-escaped parameters
`sql_params`	list	`None`	SQL parameters

Example
sql = 'DELETE FROM ?? WHERE id = ?'
sql_params = ['demo', 1]
effected_rows = db.non_query(sql, sql_params=sql_params)

query(...) and non_query(...) internally use DFF.SQL(...) to construct SQL statements and support constructing complex dynamic SQL statements.

For example, WHERE IN (...) with an uncertain number of values, or INSERT INTO ... VALUES ... for batch data insertion, etc.