dropcomments.js Filter

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

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--;
}