Bots From Extension: mysql_v2
MySQL - Read, Write and Update tables in MySQL / MariaDB
This extension provides 8 bots.
Bot @mysqlv2:append
Bot Position In Pipeline: Sink
MySQL - add a new record to an existing database table
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Database Name | |
| table* | Text | Table Name | |
| retry_count | Text | 0 | Number of times to retry on failure. |
| retry_interval | Text | 10 | Seconds to wait before retrying on failure. |
Bot @mysqlv2:create-table
Bot Position In Pipeline: Sink
MySQL - create tables
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Database name | |
| table_name* | Text | Table name | |
| retry_count | Text | 0 | Number of times to retry on failure. |
| retry_interval | Text | 10 | Seconds to wait before retrying on failure. |
Bot @mysqlv2:delete
Bot Position In Pipeline: Sink
MySQL - delete records from database table
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Database Name | |
| table* | Text | Database table name | |
| delete_query | Text | where clause - query for deleting rows in table |
Bot @mysqlv2:list-dbtables
Bot Position In Pipeline: Source
MySQL - get database tables
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname | Text | Database Name |
Bot @mysqlv2:meta
Bot Position In Pipeline: Source
MySQL - get database table schema
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Database Name | |
| table* | Text | Table Name |
Bot @mysqlv2:native-query
Bot Position In Pipeline: Source Sink
MySQL - Run native SQL query on the Database.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Specify a Database name | |
| query* | Text | Enter native MYSQL query to create, | |
| charset_type | Text | latin1 | Specify charset type,default type will be 'latin1' |
| _skip_errors | Text | no | Specify 'yes' or 'no'. If 'yes', do not bailout if the query results in error. |
| retry_count | Text | 0 | Number of times to retry on failure. |
| retry_interval | Text | 10 | Seconds to wait before retrying on failure. |
Bot #mysqlv2:read
Bot Position In Pipeline: Sink
MySQL - query the data from a database table. Expects 'table' and 'dbname' columns from input dataset; Optional 'limit' can also be provided (default 1000); Optional 'charset_type' can also be provided (default latin1)
This bot expects Full CFXQL.
Bot translates the Query to native query of the Data source supported by this extension.
Bot @mysqlv2:update
Bot Position In Pipeline: Sink
MySQL - update an existing record within a database table
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dbname* | Text | Database Name | |
| table* | Text | Table Name | |
| replace_record | Text | yes | Specify yes/no to replace/update existing record |
| update_columns | Text | Specify comma separated columns that has to update, by default all the columns will be updated | |
| charset_type | Text | utf8 | Specify charset type,default type will be 'utf8' |
| retry_count | Text | 0 | Number of times to retry on failure. |
| retry_interval | Text | 10 | Seconds to wait before retrying on failure. |