The dropcomments filter removes
comments from statements within the event data.
| Pre-configured filter name |
dropcomments
| ||
| JavaScript Filter File |
tungsten-replicator/support/filters-javascript/dropcomments.js
| ||
| Property prefix |
replicator.filter.dropcomments
| ||
| Stage compatibility |
binlog-to-q,
q-to-dbms
| ||
| tpm Option compatibility |
--svc-extractor-filters,
--svc-applier-filters
| ||
| Data compatibility | Any event | ||
| Parameters | |||
| Parameter | Type | Default | Description |
Row changes do not have comments, so the filter only has to change the statement information, which is achieved by using a regular expression:
sqlOriginal = d.getQuery();
sqlNew = sqlOriginal.replaceAll("/\\*(?:.|[\\n\\r])*?\\*/","");
d.setQuery(sqlNew);To handle the case where the statement could only be a comment, the statement is removed:
if(sqlNew.trim().length()==0)
{
data.remove(i);
i--;
}