/*
* #%L
* Service Activity Monitoring :: Server
* %%
* Copyright (C) 2011 - 2012 Talend Inc.
* %%
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
* #L%
*/
package org.talend.esb.sam.server.persistence.dialects;
import org.springframework.jdbc.support.incrementer.DataFieldMaxValueIncrementer;
/**
* Class to make Spring spaghetti.
*
* @author zubairov
*
*/
public abstract class AbstractDatabaseDialect implements DatabaseDialect {
private DataFieldMaxValueIncrementer incrementer;
/* (non-Javadoc)
* @see org.talend.esb.sam.server.persistence.dialects.DatabaseDialect#getIncrementer()
*/
@Override
public DataFieldMaxValueIncrementer getIncrementer() {
return incrementer;
}
/**
* Injector method for Spring.
*
* @param incrementer the new incrementer
*/
public void setIncrementer(DataFieldMaxValueIncrementer incrementer) {
this.incrementer = incrementer;
}
/* (non-Javadoc)
* @see org.talend.esb.sam.server.persistence.dialects.DatabaseDialect#getDataQuery(org.talend.esb.sam.server.persistence.dialects.QueryFilter)
*/
@Override
public String getDataQuery(QueryFilter filter) {
String query = getQuery();
String whereClause = filter.getWhereClause();
String result = null;
if (whereClause != null && whereClause.length() > 0) {
result = query.replaceAll(SUBSTITUTION_STRING, " AND " + whereClause);
} else {
result = query.replaceAll(SUBSTITUTION_STRING, "");
}
return result;
}
/**
* This method should return a query string with {@link #SUBSTITUTION_STRING} placeholder
* for where clause.
*
* @return the query
*/
abstract String getQuery();
/**
* This method should return a query string with {@link #SUBSTITUTION_STRING} placeholder
* for where clause.
*
* @return the count query
*/
public String getCountQuery() {
final String CountQuery = "SELECT COUNT(GROUPQ.MI_FLOW_ID) FROM (SELECT MI_FLOW_ID FROM EVENTS WHERE (MI_FLOW_ID IS NOT NULL) "
+ SUBSTITUTION_STRING + " GROUP BY MI_FLOW_ID) GROUPQ";
return CountQuery;
}
}