import org.nuiton.topia.persistence.support.TopiaSqlQuery;

 import org.nuiton.topia.service.migration.resources.MigrationVersionResource;

 import org.nuiton.topia.service.migration.resources.MigrationVersionResourceExecutor;

 import org.nuiton.version.Versions;

 import java.sql.Connection;

 import java.sql.PreparedStatement;

 import java.sql.ResultSet;

 import java.sql.SQLException;

 import java.util.Set;

 /**

                 // Must be a ## starting comment

                 continue;

             }

             String newComment = endIndex + 1 == comment.length() ? "NULL" : (String.format("'%s'", comment.substring(endIndex + 1).trim().replaceAll("'","''")));

             executor.writeSql(String.format("UPDATE observe_seine.trip t SET comment = %s, homeId = '%s', topiaVersion = topiaVersion + 1, lastUpdateDate = CURRENT_TIMESTAMP WHERE t.topiaId = '%s';", newComment, homeId, tripId));

         }