blob: a0cd20c73db81b882128e7296fd8a22e40b0437f [file] [log] [blame]
/*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You 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
<<<<<<< Updated upstream
*
* 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
=======
*
* https://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
>>>>>>> Stashed changes
* limitations under the License.
*/
package org.apache.jdo.tck.query.api;
import java.math.BigDecimal;
import javax.jdo.Query;
import org.apache.jdo.tck.pc.company.CompanyModelReader;
import org.apache.jdo.tck.pc.company.Employee;
import org.apache.jdo.tck.pc.company.FullTimeEmployee;
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> Single String Query. <br>
* <B>Keywords:</B> query <br>
* <B>Assertion ID:</B> A14.6-23. <br>
* <B>Assertion Description: </B> The single string query is first parsed to yield the result,
* result class, filter, variable list, parameter list, import list, grouping, ordering, and range.
* Then, the values specified in APIs setResult, setResultClass, setFilter, declareVariables,
* declareParamters, declareImports, setGrouping, setOrdering, and setRange override the
* corresponding settings from the single string query.
*/
public class SingleStringQuery extends QueryTest {
/** */
private static final String ASSERTION_FAILED = "Assertion A14.6-23 (SingleStringQuery) failed: ";
private static final String SINGLE_STRING_QUERY =
"SELECT UNIQUE firstname, lastname "
+ "INTO FullName "
+ "FROM FullTimeEmployee "
+ "WHERE salary > 1000 & "
+ " projects.contains(p) & p.budget > limit & "
+ " firstname == 'emp1First' "
+ "VARIABLES Project p "
+ "PARAMETERS BigDecimal limit "
+ "import org.apache.jdo.tck.query.result.classes.FullName; "
+ "import org.apache.jdo.tck.pc.company.FullTimeEmployee; "
+ "import org.apache.jdo.tck.pc.company.Project; "
+ "import java.math.BigDecimal; "
+ "GROUP BY firstname, lastname "
+ "ORDER BY lastname ASCENDING "
+ "RANGE 0,5";
/** The expected results of valid queries. */
private final Object[] expectedResult = {
new FullName("emp1First", "emp1Last"),
getTransientCompanyModelInstancesAsList(Employee.class, "emp1", "emp2", "emp5")
};
/** Parameters of valid queries. */
private final Object[][] parameters = {{new BigDecimal("2000")}};
/**
* 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(SingleStringQuery.class);
}
/** */
@SuppressWarnings("unchecked")
public void testPositive() {
int index = 0;
Query<FullTimeEmployee> query = getPM().newQuery(SINGLE_STRING_QUERY);
executeJDOQuery(
ASSERTION_FAILED,
query,
SINGLE_STRING_QUERY,
true,
parameters[index],
expectedResult[index],
true);
index = 1;
String singleStringQuery = "SELECT FROM FullTimeEmployee";
query.setUnique(false);
query.setResult(null);
query.setResultClass(null);
query.setClass(FullTimeEmployee.class);
query.setFilter(null);
query.declareVariables(null);
query.declareParameters(null);
query.declareImports(null);
query.setGrouping(null);
query.setOrdering(null);
query.setRange(null);
executeJDOQuery(
ASSERTION_FAILED, query, singleStringQuery, false, null, expectedResult[index], true);
}
/**
* @see org.apache.jdo.tck.JDO_Test#localSetUp()
*/
@Override
protected void localSetUp() {
addTearDownClass(CompanyModelReader.getTearDownClasses());
loadAndPersistCompanyModel(getPM());
}
}