package org.eclipse.persistence.testing.tests.nonJDBC;
// javase imports
import java.io.FileInputStream;
import java.io.StringReader;
import java.math.BigDecimal;
import java.util.Properties;
import java.util.Vector;
import org.w3c.dom.Document;
// JUnit imports
import org.junit.BeforeClass;
import org.junit.Test;
import static org.junit.Assert.assertTrue;
import static org.junit.Assert.fail;
// EclipseLink imports
import org.eclipse.persistence.internal.helper.NonSynchronizedVector;
import org.eclipse.persistence.internal.sessions.factories.ObjectPersistenceWorkbenchXMLProject;
import org.eclipse.persistence.oxm.XMLContext;
import org.eclipse.persistence.oxm.XMLMarshaller;
import org.eclipse.persistence.platform.database.jdbc.JDBCTypes;
import org.eclipse.persistence.platform.database.oracle.plsql.OraclePLSQLTypes;
import org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall;
import org.eclipse.persistence.queries.DataReadQuery;
import org.eclipse.persistence.sessions.DatabaseRecord;
import org.eclipse.persistence.sessions.DatabaseSession;
import org.eclipse.persistence.sessions.Project;
import org.eclipse.persistence.sessions.Session;
import org.eclipse.persistence.sessions.factories.XMLProjectReader;
// Domain imports
import static org.eclipse.persistence.testing.tests.nonJDBC.NonJDBCTestHelper.buildTestProject;
import static org.eclipse.persistence.testing.tests.nonJDBC.NonJDBCTestHelper.buildWorkbenchXMLProject;
import static org.eclipse.persistence.testing.tests.nonJDBC.NonJDBCTestHelper.CONSTANT_PROJECT_BUILD_VERSION;
import static org.eclipse.persistence.testing.tests.nonJDBC.NonJDBCTestHelper.comparer;
import static org.eclipse.persistence.testing.tests.nonJDBC.NonJDBCTestHelper.TEST_DOT_PROPERTIES_KEY;
import static org.eclipse.persistence.testing.tests.nonJDBC.NonJDBCTestHelper.xmlParser;
/*
N == Non-JDBC type
j == JDBC type
i - IN parameter
o - OUT parameter
io - INOUT parameter
*/
public class NojiNoTestSet {
// testsuite fixture(s)
static ObjectPersistenceWorkbenchXMLProject workbenchXMLProject;
static Project project = null;
@BeforeClass
public static void setUpProjects() {
try {
Properties p = new Properties();
String testPropertiesPath = System.getProperty(TEST_DOT_PROPERTIES_KEY);
p.load(new FileInputStream(testPropertiesPath));
project = buildTestProject(p);
workbenchXMLProject = buildWorkbenchXMLProject();
}
catch (Exception e) {
fail("error setting up Project's database properties " + e.getMessage());
}
}
@Test
public void writeToXml() {
// PROCEDURE NOJINO(X OUT BINARY_INTEGER, Y IN VARCHAR, Z OUT BOOLEAN)
PLSQLStoredProcedureCall call = new PLSQLStoredProcedureCall();
call.setProcedureName("NojiNo");
call.addNamedOutputArgument("X", OraclePLSQLTypes.BinaryInteger);
call.addNamedArgument("Y", JDBCTypes.VARCHAR_TYPE, 40);
call.addNamedOutputArgument("Z", OraclePLSQLTypes.PLSQLBoolean);
DataReadQuery query = new DataReadQuery();
query.addArgument("Y", String.class);
query.setCall(call);
project.getDescriptor(Empty.class).getQueryManager().addQuery("NojiNo", query);
Project projectToXml = (Project)project.clone();
// trim off login 'cause it changes under test - this way, a comparison
// can be done to a control document
projectToXml.setDatasourceLogin(null);
XMLContext context = new XMLContext(workbenchXMLProject);
XMLMarshaller marshaller = context.createMarshaller();
Document doc = marshaller.objectToXML(projectToXml);
Document controlDoc = xmlParser.parse(new StringReader(NOJINO_PROJECT_XML));
assertTrue("control document not same as instance document",
comparer.isNodeEqual(controlDoc, doc));
}
public static final String NOJINO_PROJECT_XML =
"<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
"<eclipselink:object-persistence version=\"" + CONSTANT_PROJECT_BUILD_VERSION + "\"" + " xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"" + " xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"" + " xmlns:eclipselink=\"http://xmlns.oracle.com/ias/xsds/eclipselink\">" +
"<eclipselink:name>nonJDBCTestProject</eclipselink:name>" +
"<eclipselink:class-mapping-descriptors>" +
"<eclipselink:class-mapping-descriptor xsi:type=\"eclipselink:relational-class-mapping-descriptor\">" +
"<eclipselink:class>org.eclipse.persistence.testing.tests.nonJDBC.Empty</eclipselink:class>" +
"<eclipselink:alias>Empty</eclipselink:alias>" +
"<eclipselink:primary-key>" +
"<eclipselink:field table=\"EMPTY\" name=\"ID\" xsi:type=\"eclipselink:column\"/>" +
"</eclipselink:primary-key>" +
"<eclipselink:events xsi:type=\"eclipselink:event-policy\"/>" +
"<eclipselink:querying xsi:type=\"eclipselink:query-policy\">" +
"<eclipselink:queries>" +
"<eclipselink:query name=\"NojiNo\" xsi:type=\"eclipselink:data-read-query\">" +
"<eclipselink:arguments>" +
"<eclipselink:argument name=\"Y\">" +
"<eclipselink:type>java.lang.String</eclipselink:type>" +
"</eclipselink:argument>" +
"</eclipselink:arguments>" +
"<eclipselink:maintain-cache>false</eclipselink:maintain-cache>" +
"<eclipselink:call xsi:type=\"eclipselink:plsql-stored-procedure-call\">" +
"<eclipselink:procedure-name>NojiNo</eclipselink:procedure-name>" +
"<eclipselink:arguments>" +
"<eclipselink:argument xsi:type=\"eclipselink:plsql-type\" type-name=\"BinaryInteger\">" +
"<eclipselink:name>X</eclipselink:name>" +
"<eclipselink:index>0</eclipselink:index>" +
"<eclipselink:direction>OUT</eclipselink:direction>" +
"</eclipselink:argument>" +
"<eclipselink:argument xsi:type=\"eclipselink:jdbc-type\" type-name=\"VARCHAR_TYPE\">" +
"<eclipselink:name>Y</eclipselink:name>" +
"<eclipselink:index>1</eclipselink:index>" +
"<eclipselink:length>40</eclipselink:length>" +
"</eclipselink:argument>" +
"<eclipselink:argument xsi:type=\"eclipselink:plsql-type\" type-name=\"PLSQLBoolean\">" +
"<eclipselink:name>Z</eclipselink:name>" +
"<eclipselink:index>2</eclipselink:index>" +
"<eclipselink:direction>OUT</eclipselink:direction>" +
"</eclipselink:argument>" +
"</eclipselink:arguments>" +
"</eclipselink:call>" +
"<eclipselink:container xsi:type=\"eclipselink:list-container-policy\">" +
"<eclipselink:collection-type>java.util.Vector</eclipselink:collection-type>" +
"</eclipselink:container>" +
"</eclipselink:query>" +
"</eclipselink:queries>" +
"</eclipselink:querying>" +
"<eclipselink:attribute-mappings>" +
"<eclipselink:attribute-mapping xsi:type=\"eclipselink:direct-mapping\">" +
"<eclipselink:attribute-name>id</eclipselink:attribute-name>" +
"<eclipselink:field table=\"EMPTY\" name=\"ID\" xsi:type=\"eclipselink:column\"/>" +
"</eclipselink:attribute-mapping>" +
"</eclipselink:attribute-mappings>" +
"<eclipselink:descriptor-type>independent</eclipselink:descriptor-type>" +
"<eclipselink:instantiation/>" +
"<eclipselink:copying xsi:type=\"eclipselink:instantiation-copy-policy\"/>" +
"<eclipselink:tables>" +
"<eclipselink:table name=\"EMPTY\"/>" +
"</eclipselink:tables>" +
"</eclipselink:class-mapping-descriptor>" +
"</eclipselink:class-mapping-descriptors>" +
"</eclipselink:object-persistence>";
@Test
public void readFromXml() {
Project projectFromXML = XMLProjectReader.read(new StringReader(NOJINO_PROJECT_XML),
this.getClass().getClassLoader());
projectFromXML.setDatasourceLogin(project.getDatasourceLogin());
project = projectFromXML;
}
@SuppressWarnings("unchecked")
@Test
public void runQuery() {
Session s = project.createDatabaseSession();
s.dontLogMessages();
((DatabaseSession)s).login();
Object o = null;
Vector queryArgs = new NonSynchronizedVector();
queryArgs.add("test");
boolean worked = false;
String msg = null;
try {
o = s.executeQuery("NojiNo", Empty.class, queryArgs);
worked = true;
}
catch (Exception e) {
msg = e.getMessage();
}
assertTrue("invocation NojiNo failed: " + msg, worked);
Vector results = (Vector)o;
DatabaseRecord record = (DatabaseRecord)results.get(0);
BigDecimal bint2bigdec = (BigDecimal)record.get("X");
assertTrue("wrong bint2bigdec value", bint2bigdec.intValue() == 42);
Integer bool2int = (Integer)record.get("Z");
assertTrue("wrong bool2int value", bool2int.intValue() == 1);
((DatabaseSession)s).logout();
}
}