PublicationTermTest.java

/**
 * 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 junit.framework.TestCase;
import org.pegadi.sqlsearch.ComparisonTerm;

import java.text.SimpleDateFormat;
import java.util.Date;

public class PublicationTermTest extends TestCase {


    Date today = new Date();

    String date;

    public void setUp() {


        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");

        date = format.format(today);
    }

    public void testGetQueryWithRef() {
        String query = "SELECT Article.ID FROM Article WHERE Article.refPublication = 7";

        PublicationTerm term = new PublicationTerm(7);
        assertEquals(query,
                term.getQuery("Article.ID"));
    }


    public void testGetQueryWithDate() {
        String query = "SELECT Article.ID FROM Article, Publication WHERE (Article.refPublication = Publication.ID AND Publication.releaseDate >= '" + date + "')";


        PublicationTerm term = new PublicationTerm(ComparisonTerm.Comparison.GE, today);

        assertEquals(query,
                term.getQuery("Article.ID"));
    }


}