| /* |
| * 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()); |
| } |
| } |