/**
* Copyright 1999-2009 The Pegadi Team
*
* 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 org.pegadi.articlesearch;
import no.dusken.common.model.Person;
import org.pegadi.sqlsearch.SearchTerm;
import java.util.Arrays;
import java.util.List;
/**
* This class imlements a search based on a journalist.
*
* @author Eirik Bjorsnos <bjorsnos@underdusken.no>
*/
public class JournalistTerm extends SearchTerm implements java.io.Serializable {
/**
* The reference of the journalist to search for
*/
private final String journalistRef;
/**
* Constructor takes the reference of a specific journalist.
*
* @param journalistRef The username of the Journalist
*/
public JournalistTerm(String journalistRef) {
this.journalistRef = journalistRef;
}
public JournalistTerm(Person person) {
this.journalistRef = person.getUsername();
}
/**
* Generates the WHERE part of the SQL query (without including the string
* "WHERE").
*
* @return The WHERE clause
*/
public String whereClause() {
return String.format("(Article.refJournalist = '%s' OR CoJournalists.refJournalist = '%s')", journalistRef, journalistRef);
}
/**
* Returns the names of the tables involved in this search.
*
* @return A String[] containing the involved tables. The array may contain
* multiple instances of each table name.
*/
public List<String> getTables() {
return Arrays.asList("Article LEFT JOIN CoJournalists ON Article.ID=CoJournalists.refArticle");
}
public List<String> getIgnoreTables() {
return Arrays.asList("Article", "CoJournalists");
}
}