| /* | |
| * Copyright (c) 2011, 2020 Oracle and/or its affiliates. All rights reserved. | |
| * | |
| * This program and the accompanying materials are made available under the | |
| * terms of the Eclipse Public License v. 2.0 which is available at | |
| * http://www.eclipse.org/legal/epl-2.0, | |
| * or the Eclipse Distribution License v. 1.0 which is available at | |
| * http://www.eclipse.org/org/documents/edl-v10.php. | |
| * | |
| * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause | |
| */ | |
| // Contributors: | |
| // Mike Norman - April 21, 2010 | |
| // fix for bug 309002 | |
| package dbws.testing.bindingmodel; | |
| //javase imports | |
| //java eXtension imports | |
| import javax.wsdl.WSDLException; | |
| //JUnit4 imports | |
| import org.junit.BeforeClass; | |
| import org.junit.Test; | |
| import static org.junit.Assert.assertTrue; | |
| //EclipseLink imports | |
| import org.eclipse.persistence.internal.xr.QueryOperation; | |
| import org.eclipse.persistence.internal.xr.SQLQueryHandler; | |
| //domain-specific (test) imports | |
| import dbws.testing.DBWSTestSuite; | |
| public class BindingModelTestSuite extends DBWSTestSuite { | |
| static final String OPERATION = "numLogXml"; | |
| static final String GROUP_BY_CLAUSE = | |
| "group by to_char(data, 'HH24') order by to_char(data, 'HH24') asc"; | |
| @BeforeClass | |
| public static void setUp() throws WSDLException { | |
| DBWS_BUILDER_XML_USERNAME = | |
| "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" + | |
| "<dbws-builder xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" + | |
| "<properties>" + | |
| "<property name=\"projectName\">bindingmodel</property>" + | |
| "<property name=\"logLevel\">off</property>" + | |
| "<property name=\"username\">"; | |
| DBWS_BUILDER_XML_PASSWORD = | |
| "</property><property name=\"password\">"; | |
| DBWS_BUILDER_XML_URL = | |
| "</property><property name=\"url\">"; | |
| DBWS_BUILDER_XML_DRIVER = | |
| "</property><property name=\"driver\">"; | |
| DBWS_BUILDER_XML_PLATFORM = | |
| "</property><property name=\"platformClassname\">"; | |
| DBWS_BUILDER_XML_MAIN = | |
| "</property>" + | |
| "</properties>" + | |
| "<sql " + | |
| "name=\"" + OPERATION + "\" " + | |
| "simpleXMLFormatTag=\"logXmlResult\" " + | |
| "xmlTag=\"numLogXml\" " + | |
| ">" + | |
| "<text><![CDATA[select to_char(data, 'HH24') as \"ora\", count(*) as \"num\" from " + | |
| "log_xml where trunc(data) = to_date(?, 'YYYY-MM-DD') and tipo = ? " + | |
| GROUP_BY_CLAUSE + "]]></text>" + | |
| "<binding name=\"data\" type=\"xsd:string\"/>" + | |
| "<binding name=\"tipo\" type=\"xsd:string\"/>" + | |
| "</sql>" + | |
| "</dbws-builder>"; | |
| builder = null; | |
| DBWSTestSuite.setUp("."); | |
| } | |
| @Test | |
| public void checkParsedSqlText() { | |
| QueryOperation queryOperation = | |
| (QueryOperation)builder.getXrServiceModel().getOperation(OPERATION); | |
| SQLQueryHandler sqlQueryHandler = (SQLQueryHandler)queryOperation.getQueryHandler(); | |
| String sqlString = sqlQueryHandler.getSqlString(); | |
| assertTrue("parse SQL text does not contain GROUP BY clause", | |
| sqlString.contains(GROUP_BY_CLAUSE)); | |
| } | |
| } |