/*
* Copyright 2000-2012 JetBrains s.r.o.
*
* 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.
*/
package com.intellij.openapi.vcs.changes.dbCommitted;
import com.intellij.openapi.util.text.StringUtil;
import com.intellij.openapi.vcs.VcsException;
import com.intellij.util.ThrowableConvertor;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
/**
* Created with IntelliJ IDEA.
* User: Irina.Chernushina
* Date: 10/18/12
* Time: 5:30 PM
*/
public class SelectListsQueryHelper {
private final CacheJdbcConnection myConnection;
private final long myLast;
private final long myFirst;
private final Long myLocationId;
private final String mySubfolder;
private final boolean myNumberFake;
public SelectListsQueryHelper(final CacheJdbcConnection connection, RevisionId existingLast, RevisionId existingFirst, RevisionId last,
RevisionId first, final Long locationId, String subfolder) {
myConnection = connection;
myNumberFake = last.isNumberFake() && first.isNumberFake() && ! (last.isFake() && first.isFake());
myLast = operating(last, existingLast);
myFirst = operating(first, existingFirst);
myLocationId = locationId;
mySubfolder = subfolder;
}
private long operating(RevisionId last, RevisionId existing) {
assert ! existing.isFake();
if (myNumberFake) {
return last.isFake() ? existing.getTime() : last.getTime();
}
else {
// we allow only one bound to be specified
return last.isNumberFake() ? existing.getNumber() : last.getNumber();
}
}
public PreparedStatement createStatement() throws VcsException, SQLException {
if (myNumberFake) {
// by dates
if (StringUtil.isEmptyOrSpaces(mySubfolder)) {
// no subfolder constraint
return createDatesOnly();
} else {
return createDatesSubfolder();
}
} else {
// by numbers
if (StringUtil.isEmptyOrSpaces(mySubfolder)) {
// no subfolder constraint
return createNumbersOnly();
} else {
return createNumbersSubfolder();
}
}
}
private PreparedStatement createNumbersSubfolder() throws VcsException, SQLException {
final PreparedStatement impl =
createImpl(SqliteTables.PREPARED_NUMBERS_SUBFOLDER, " R." + SqliteTables.REVISION.NUMBER_INT + ">=? AND R." + SqliteTables.REVISION.NUMBER_INT + "<=? AND P." +
SqliteTables.PATHS.PATH + " LIKE ?");
impl.setLong(2, myFirst);
impl.setLong(3, myLast);
impl.setString(4, mySubfolder + "%");
return impl;
}
private PreparedStatement createNumbersOnly() throws VcsException, SQLException {
final PreparedStatement impl =
createImpl(SqliteTables.PREPARED_NUMBERS_ONLY, " R." + SqliteTables.REVISION.NUMBER_INT + ">=? AND R." + SqliteTables.REVISION.NUMBER_INT + "<=? ");
impl.setLong(2, myFirst);
impl.setLong(3, myLast);
return impl;
}
private PreparedStatement createDatesSubfolder() throws VcsException, SQLException {
final PreparedStatement impl =
createImpl(SqliteTables.PREPARED_DATES_SUBFOLDER, " R." + SqliteTables.REVISION.DATE + ">=? AND R." + SqliteTables.REVISION.DATE + "<=? AND P." +
SqliteTables.PATHS.PATH + " LIKE ?");
impl.setLong(2, myFirst);
impl.setLong(3, myLast);
impl.setString(4, mySubfolder + "%");
return impl;
}
private PreparedStatement createDatesOnly() throws VcsException, SQLException {
final PreparedStatement impl = createImpl(SqliteTables.PREPARED_DATES_ONLY, " R." + SqliteTables.REVISION.DATE + ">=? AND R." + SqliteTables.REVISION.DATE + "<=? ");
impl.setLong(2, myFirst);
impl.setLong(3, myLast);
return impl;
}
private PreparedStatement createImpl(final String queryName, final String whereClause) throws VcsException, SQLException {
final PreparedStatement statement = myConnection.getOrCreatePreparedStatement(queryName,
new ThrowableConvertor<Connection, PreparedStatement, SQLException>() {
@Override
public PreparedStatement convert(Connection connection)
throws SQLException {
return connection.prepareStatement("SELECT " +
SqliteTables.REVISION.RAW_DATA +
" , " + SqliteTables.REVISION.NUMBER_INT +
" FROM " +
SqliteTables.REVISION.TABLE_NAME +
" R INNER JOIN " +
SqliteTables.PATHS_2_REVS.TABLE_NAME +
" PR ON R." +
SqliteTables.REVISION.ID +
" = PR." +
SqliteTables.PATHS_2_REVS.REVISION_FK +
" , " +
SqliteTables.PATHS.TABLE_NAME +
" P ON PR." +
SqliteTables.PATHS_2_REVS.PATH_FK +
" = P." +
SqliteTables.PATHS.ID +
" WHERE R." +
SqliteTables.REVISION.ROOT_FK +
" = ? AND "
+
whereClause +
" ORDER BY " +
SqliteTables.REVISION.NUMBER_INT +
" DESC");
}
});
statement.setLong(1, myLocationId);
return statement;
}
}