blob: 0aae29c69b9ca81d008b06d08d9ca2dec84c0e63 [file] [log] [blame]
/*
* Copyright 2005 The Apache Software Foundation.
*
* 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.apache.jdo.tck.query.api;
import java.math.BigDecimal;
import java.util.Arrays;
import java.util.List;
import javax.jdo.Query;
import org.apache.jdo.tck.JDO_Test;
import org.apache.jdo.tck.pc.company.CompanyModelReader;
import org.apache.jdo.tck.pc.company.FullTimeEmployee;
import org.apache.jdo.tck.pc.company.Person;
import org.apache.jdo.tck.query.QueryTest;
import org.apache.jdo.tck.query.result.classes.FullName;
import org.apache.jdo.tck.util.BatchTestRunner;
/**
*<B>Title:</B> Change Query.
*<BR>
*<B>Keywords:</B> query
*<BR>
*<B>Assertion ID:</B> A14.5-15.
*<BR>
*<B>Assertion Description: </B>
* The Query instance returned from this method can be modified
* by the application, just like any other Query instance.
*/
public class ChangeQuery extends QueryTest {
/** */
private static final String ASSERTION_FAILED =
"Assertion A14.5-15 (ChangeQuery) failed: ";
/**
* The <code>main</code> is called when the class
* is directly executed from the command line.
* @param args The arguments passed to the program.
*/
public static void main(String[] args) {
BatchTestRunner.run(ChangeQuery.class);
}
/** */
public void testPositive() {
Query query = getPM().newNamedQuery(Person.class, "changeQuery");
// change query
query.setResult("firstname, lastname");
query.setResultClass(FullName.class);
query.setClass(FullTimeEmployee.class);
String filter = "salary > 1000 & projects.contains(p) & " +
"p.budget > limit";
query.setFilter(filter);
String imports = "import org.apache.jdo.tck.pc.company.Project; " +
"import java.math.BigDecimal;";
query.declareImports(imports);
query.declareVariables("Project p");
query.declareParameters("BigDecimal limit");
query.setOrdering("personid ASCENDING");
query.setRange(0, 5);
String singleStringQuery =
"SELECT firstname, lastname INTO FullName FROM FullTimeEmployee " +
"WHERE salary > 1000 & projects.contains(p) & " +
"p.budget > limit " +
"VARIABLES Project p PARAMETERS BigDecimal limit " +
"ORDER BY personid ASCENDING RANGE 0, 5";
// query parameters
Object[] parameters = {new BigDecimal("2000")};
// expected result
List expectedResult = Arrays.asList(new Object[] {
new FullName("emp1First", "emp1Last"),
new FullName("emp2First", "emp2Last"),
new FullName("emp5First", "emp5Last")});
// execute query
executeJDOQuery(ASSERTION_FAILED, query, singleStringQuery, true,
parameters, expectedResult, true);
}
/**
* @see JDO_Test#localSetUp()
*/
protected void localSetUp() {
addTearDownClass(CompanyModelReader.getTearDownClasses());
loadAndPersistCompanyModel(getPM());
}
}