appmixer.mysql.db.UpdatedRow
1.0.0
Public
| Field | Type | Description |
|---|---|---|
| Storage | select | Select a data store. The data store will be used to store data streamed from MySQL so that we can compare them later to detect updated rows. If you do not select a data store, one will be automatically created for you when the flow starts and deleted when the flow stops. If you do select a data store manually, you are responsible for clearing/deleting it when you don't need it anymore (note that the data in the data store is populated automatically, so any data left in the store affects the next flow run). |
| Record old values | toggle | Include each updated row previous value in the output. In order to do this, is necessary to download all the existing rows to the store, which can be detrimental with very large tables |
| Detect new rows while stopped | toggle | If this is set to true, rows that are updated while the flow was stopped will be processed next time the flow is started. |
| SQL Query | textarea | Enter an SQL query. If your query contains a ? character placeholder, then the UpdateRow component replaces the placeholder with the last timestamp (seconds since epoch) the component was triggered to query only data that has been added since the the last time the component was triggered. Note that the replaced timestamp is an integer, so you might need to use a function like UNIX_TIMESTAMP to make date comparisons. Also note that this is only possible if your result set contains an "updated_at" type of field. A typical use case is, e.g. select * from mytable where updated_at > FROM_UNIXTIME(?). If you do not provide the ? placeholder, then the component will always query all data periodically. |
| ID field in query result | text | A unique field from the query result set that will be used to check for new vs existing rows. |
| Reference Fields | text | A comma separated list of fields from the query result set that will be used to check for changes in rows. If you do not provide Reference Fields, any change in any field is detected. |
Dynamic variables loaded from /component/appmixer/mysql/db/UpdatedRowOutput?outPort=out