Search in sources :

Example 86 with ReadAllQuery

use of org.eclipse.persistence.queries.ReadAllQuery in project eclipselink by eclipse-ee4j.

the class OracleObjecttypeTestSuite method setUp.

@BeforeClass
public static void setUp() throws SecurityException, NoSuchFieldException, IllegalArgumentException, IllegalAccessException {
    final String ddlCreateProp = System.getProperty(DATABASE_DDL_CREATE_KEY, DEFAULT_DATABASE_DDL_CREATE);
    if ("true".equalsIgnoreCase(ddlCreateProp)) {
        ddlCreate = true;
    }
    final String ddlDropProp = System.getProperty(DATABASE_DDL_DROP_KEY, DEFAULT_DATABASE_DDL_DROP);
    if ("true".equalsIgnoreCase(ddlDropProp)) {
        ddlDrop = true;
    }
    final String ddlDebugProp = System.getProperty(DATABASE_DDL_DEBUG_KEY, DEFAULT_DATABASE_DDL_DEBUG);
    if ("true".equalsIgnoreCase(ddlDebugProp)) {
        ddlDebug = true;
    }
    final String username = System.getProperty(DATABASE_USERNAME_KEY);
    if (username == null) {
        fail("error retrieving database username");
    }
    final String password = System.getProperty(DATABASE_PASSWORD_KEY);
    if (password == null) {
        fail("error retrieving database password");
    }
    final String url = System.getProperty(DATABASE_URL_KEY);
    if (url == null) {
        fail("error retrieving database url");
    }
    final String driver = System.getProperty(DATABASE_DRIVER_KEY);
    if (driver == null) {
        fail("error retrieving database driver");
    }
    Project orProject = new Project();
    orProject.setName("or-oracleobjecttype");
    ObjectRelationalDataTypeDescriptor addressORDescriptor = new ObjectRelationalDataTypeDescriptor();
    addressORDescriptor.setAlias("address");
    addressORDescriptor.useSoftCacheWeakIdentityMap();
    addressORDescriptor.setJavaClass(Address.class);
    addressORDescriptor.descriptorIsAggregate();
    addressORDescriptor.setStructureName("XR_ADDRESS_TYPE");
    addressORDescriptor.addFieldOrdering("STREET");
    addressORDescriptor.addFieldOrdering("CITY");
    addressORDescriptor.addFieldOrdering("PROV");
    addressORDescriptor.addDirectMapping("street", "STREET");
    addressORDescriptor.addDirectMapping("city", "CITY");
    addressORDescriptor.addDirectMapping("province", "PROV");
    orProject.addDescriptor(addressORDescriptor);
    ObjectRelationalDataTypeDescriptor employeeORDescriptor = new ObjectRelationalDataTypeDescriptor();
    employeeORDescriptor.useSoftCacheWeakIdentityMap();
    employeeORDescriptor.getQueryManager().checkCacheForDoesExist();
    employeeORDescriptor.setAlias("employee");
    employeeORDescriptor.setJavaClass(EmployeeWithAddress.class);
    employeeORDescriptor.addTableName("XR_EMP_ADDR");
    employeeORDescriptor.addPrimaryKeyFieldName("XR_EMP_ADDR.EMPNO");
    orProject.addDescriptor(employeeORDescriptor);
    DirectToFieldMapping idMapping = new DirectToFieldMapping();
    idMapping.setAttributeName("id");
    idMapping.setFieldName("XR_EMP_ADDR.EMPNO");
    employeeORDescriptor.addMapping(idMapping);
    DirectToFieldMapping firstNameMapping = new DirectToFieldMapping();
    firstNameMapping.setAttributeName("firstName");
    firstNameMapping.setFieldName("XR_EMP_ADDR.FNAME");
    employeeORDescriptor.addMapping(firstNameMapping);
    DirectToFieldMapping lastNameMapping = new DirectToFieldMapping();
    lastNameMapping.setAttributeName("lastName");
    lastNameMapping.setFieldName("XR_EMP_ADDR.LNAME");
    employeeORDescriptor.addMapping(lastNameMapping);
    StructureMapping addressMapping = new StructureMapping();
    addressMapping.setAttributeName("address");
    addressMapping.setReferenceClass(Address.class);
    addressMapping.setFieldName("ADDRESS");
    employeeORDescriptor.addMapping(addressMapping);
    ReadAllQuery readQuery = new ReadAllQuery(EmployeeWithAddress.class);
    readQuery.setName("getEmployeesByProv");
    readQuery.addArgument("X");
    StoredProcedureCall spCall = new StoredProcedureCall();
    spCall.setProcedureName("GET_EMPLOYEES_BY_PROV");
    spCall.addNamedArgument("X", "X", Types.STRUCT, "XR_ADDRESS_TYPE");
    spCall.useNamedCursorOutputAsResultSet("Y");
    readQuery.setCall(spCall);
    employeeORDescriptor.getQueryManager().addQuery("getEmployeesByProv", readQuery);
    ObjectPersistenceWorkbenchXMLProject runtimeProject = new ObjectPersistenceWorkbenchXMLProject();
    XMLTransformationMapping versionMapping = (XMLTransformationMapping) runtimeProject.getDescriptor(Project.class).getMappings().firstElement();
    TransformerBasedFieldTransformation versionTransformer = (TransformerBasedFieldTransformation) versionMapping.getFieldTransformations().get(0);
    Field transformerField = TransformerBasedFieldTransformation.class.getDeclaredField("transformer");
    transformerField.setAccessible(true);
    ConstantTransformer constantTransformer = (ConstantTransformer) transformerField.get(versionTransformer);
    constantTransformer.setValue(CONSTANT_PROJECT_BUILD_VERSION);
    XMLContext context = new XMLContext(runtimeProject);
    XMLMarshaller marshaller = context.createMarshaller();
    Document orProjectDoc = xmlPlatform.createDocument();
    marshaller.marshal(orProject, orProjectDoc);
    Document orProjectXMLDoc = xmlParser.parse(new StringReader(OBJECTTYPE_OR_PROJECT));
    assertTrue("OracleObjecttype java-built OR project not same as XML-built OR project.  Expected:\n" + documentToString(orProjectXMLDoc) + "\nActual:\n" + documentToString(orProjectDoc), comparer.isNodeEqual(orProjectXMLDoc, orProjectDoc));
    NamespaceResolver ns = new NamespaceResolver();
    ns.setDefaultNamespaceURI("urn:oracleobjecttype");
    Project oxProject = new Project();
    oxProject.setName("ox-oracleobjecttype");
    XMLLogin xmlLogin = new XMLLogin();
    xmlLogin.setPlatform(new DOMPlatform());
    xmlLogin.getProperties().remove("user");
    xmlLogin.getProperties().remove("password");
    oxProject.setLogin(xmlLogin);
    XMLDescriptor addressOXDescriptor = new XMLDescriptor();
    addressOXDescriptor.setAlias("address");
    addressOXDescriptor.setJavaClass(Address.class);
    addressOXDescriptor.setDefaultRootElement("address");
    addressOXDescriptor.setNamespaceResolver(ns);
    XMLSchemaURLReference schemaReference = new XMLSchemaURLReference();
    schemaReference.setSchemaContext("/addressType");
    schemaReference.setType(XMLSchemaReference.COMPLEX_TYPE);
    addressOXDescriptor.setSchemaReference(schemaReference);
    XMLDirectMapping streetMapping = new XMLDirectMapping();
    streetMapping.setAttributeName("street");
    XMLField streetField = new XMLField();
    streetField.setName("street/text()");
    streetField.setSchemaType(STRING_QNAME);
    streetMapping.setField(streetField);
    addressOXDescriptor.addMapping(streetMapping);
    XMLDirectMapping cityMapping = new XMLDirectMapping();
    cityMapping.setAttributeName("city");
    XMLField cityField = new XMLField();
    cityField.setName("city/text()");
    cityField.setSchemaType(STRING_QNAME);
    cityMapping.setField(cityField);
    addressOXDescriptor.addMapping(cityMapping);
    XMLDirectMapping provinceMapping = new XMLDirectMapping();
    provinceMapping.setAttributeName("province");
    XMLField provinceField = new XMLField();
    provinceField.setName("province/text()");
    provinceField.setSchemaType(STRING_QNAME);
    provinceMapping.setField(provinceField);
    addressOXDescriptor.addMapping(provinceMapping);
    oxProject.addDescriptor(addressOXDescriptor);
    XMLDescriptor employeeOXDescriptor = new XMLDescriptor();
    employeeOXDescriptor.setAlias("employee");
    employeeOXDescriptor.setJavaClass(EmployeeWithAddress.class);
    employeeOXDescriptor.setDefaultRootElement("employee");
    employeeOXDescriptor.setNamespaceResolver(ns);
    schemaReference = new XMLSchemaURLReference();
    schemaReference.setSchemaContext("/employeeType");
    schemaReference.setType(XMLSchemaReference.COMPLEX_TYPE);
    employeeOXDescriptor.setSchemaReference(schemaReference);
    XMLDirectMapping xmlIdMapping = new XMLDirectMapping();
    xmlIdMapping.setAttributeName("id");
    XMLField idField = new XMLField();
    idField.setName("id/text()");
    idField.setSchemaType(INT_QNAME);
    xmlIdMapping.setField(idField);
    employeeOXDescriptor.addMapping(xmlIdMapping);
    XMLDirectMapping xmlFirstNameMapping = new XMLDirectMapping();
    xmlFirstNameMapping.setAttributeName("firstName");
    XMLField firstNameField = new XMLField();
    firstNameField.setName("first-name/text()");
    firstNameField.setSchemaType(STRING_QNAME);
    xmlFirstNameMapping.setField(firstNameField);
    employeeOXDescriptor.addMapping(xmlFirstNameMapping);
    XMLDirectMapping xmlLastNameMapping = new XMLDirectMapping();
    xmlLastNameMapping.setAttributeName("lastName");
    XMLField lastNameField = new XMLField();
    lastNameField.setName("last-name/text()");
    lastNameField.setSchemaType(STRING_QNAME);
    xmlLastNameMapping.setField(lastNameField);
    employeeOXDescriptor.addMapping(xmlLastNameMapping);
    XMLCompositeObjectMapping xmlAddressMapping = new XMLCompositeObjectMapping();
    xmlAddressMapping.setAttributeName("address");
    xmlAddressMapping.setReferenceClass(Address.class);
    xmlAddressMapping.setXPath("address");
    employeeOXDescriptor.addMapping(xmlAddressMapping);
    oxProject.addDescriptor(employeeOXDescriptor);
    Document oxProjectDoc = xmlPlatform.createDocument();
    marshaller.marshal(oxProject, oxProjectDoc);
    Document oxProjectXMLDoc = xmlParser.parse(new StringReader(OBJECTTYPE_OX_PROJECT));
    assertTrue("OracleObjecttype java-built OX project not same as XML-built OX project.  Expected:\n" + documentToString(oxProjectXMLDoc) + "\nActual:\n" + documentToString(oxProjectDoc), comparer.isNodeEqual(oxProjectXMLDoc, oxProjectDoc));
    XRServiceFactory factory = new XRServiceFactory() {

        XRServiceFactory init() {
            parentClassLoader = ClassLoader.getSystemClassLoader();
            xrSchemaStream = new ByteArrayInputStream(OBJECTTYPE_SCHEMA.getBytes());
            return this;
        }

        @Override
        public void buildSessions() {
            Project orProject = XMLProjectReader.read(new StringReader(OBJECTTYPE_OR_PROJECT), parentClassLoader);
            DatabaseLogin login = new DatabaseLogin();
            login.setUserName(username);
            login.setPassword(password);
            login.setConnectionString(url);
            login.setDriverClassName(driver);
            login.setDatasourcePlatform(new Oracle11Platform());
            login.bindAllParameters();
            orProject.setDatasourceLogin(login);
            DatabaseSession ds = orProject.createDatabaseSession();
            ds.dontLogMessages();
            xrService.setORSession(ds);
            Project oxProject = XMLProjectReader.read(new StringReader(OBJECTTYPE_OX_PROJECT), parentClassLoader);
            xrService.setXMLContext(new XMLContext(oxProject));
            xrService.setOXSession(xrService.getXMLContext().getSession(0));
        }
    }.init();
    context = new XMLContext(new DBWSModelProject());
    XMLUnmarshaller unmarshaller = context.createUnmarshaller();
    DBWSModel model = (DBWSModel) unmarshaller.unmarshal(new StringReader(OBJECTTYPE_XRMODEL));
    xrService = factory.buildService(model);
    if (ddlCreate) {
        try {
            AllTests.runDdl(CREATE_DDL, ddlDebug);
        } catch (Exception e) {
        // e.printStackTrace();
        }
    }
}
Also used : TransformerBasedFieldTransformation(org.eclipse.persistence.internal.descriptors.TransformerBasedFieldTransformation) XMLMarshaller(org.eclipse.persistence.oxm.XMLMarshaller) DatabaseSession(org.eclipse.persistence.sessions.DatabaseSession) ReadAllQuery(org.eclipse.persistence.queries.ReadAllQuery) XMLLogin(org.eclipse.persistence.oxm.XMLLogin) Oracle11Platform(org.eclipse.persistence.platform.database.oracle.Oracle11Platform) Document(org.w3c.dom.Document) StructureMapping(org.eclipse.persistence.mappings.structures.StructureMapping) Field(java.lang.reflect.Field) XMLField(org.eclipse.persistence.oxm.XMLField) DBWSModelProject(org.eclipse.persistence.dbws.DBWSModelProject) ObjectPersistenceWorkbenchXMLProject(org.eclipse.persistence.internal.sessions.factories.ObjectPersistenceWorkbenchXMLProject) XMLDescriptor(org.eclipse.persistence.oxm.XMLDescriptor) StringReader(java.io.StringReader) XMLUnmarshaller(org.eclipse.persistence.oxm.XMLUnmarshaller) ObjectRelationalDataTypeDescriptor(org.eclipse.persistence.mappings.structures.ObjectRelationalDataTypeDescriptor) DirectToFieldMapping(org.eclipse.persistence.mappings.DirectToFieldMapping) XMLField(org.eclipse.persistence.oxm.XMLField) DOMPlatform(org.eclipse.persistence.oxm.platform.DOMPlatform) DBWSModel(org.eclipse.persistence.dbws.DBWSModel) StoredProcedureCall(org.eclipse.persistence.queries.StoredProcedureCall) XMLContext(org.eclipse.persistence.oxm.XMLContext) XMLSchemaURLReference(org.eclipse.persistence.oxm.schema.XMLSchemaURLReference) XMLTransformationMapping(org.eclipse.persistence.oxm.mappings.XMLTransformationMapping) ConstantTransformer(org.eclipse.persistence.mappings.transformers.ConstantTransformer) SQLException(java.sql.SQLException) ObjectPersistenceWorkbenchXMLProject(org.eclipse.persistence.internal.sessions.factories.ObjectPersistenceWorkbenchXMLProject) Project(org.eclipse.persistence.sessions.Project) DBWSModelProject(org.eclipse.persistence.dbws.DBWSModelProject) DatabaseLogin(org.eclipse.persistence.sessions.DatabaseLogin) XRServiceFactory(org.eclipse.persistence.internal.xr.XRServiceFactory) XMLDirectMapping(org.eclipse.persistence.oxm.mappings.XMLDirectMapping) ByteArrayInputStream(java.io.ByteArrayInputStream) NamespaceResolver(org.eclipse.persistence.oxm.NamespaceResolver) XMLCompositeObjectMapping(org.eclipse.persistence.oxm.mappings.XMLCompositeObjectMapping) BeforeClass(org.junit.BeforeClass)

Example 87 with ReadAllQuery

use of org.eclipse.persistence.queries.ReadAllQuery in project eclipselink by eclipse-ee4j.

the class STI_JoinedAttributeTest method testProjectJoinTeamMembers.

public void testProjectJoinTeamMembers() {
    ReadAllQuery query = new ReadAllQuery();
    query.setReferenceClass(STI_Project.class);
    ReadAllQuery controlQuery = (ReadAllQuery) query.clone();
    query.addJoinedAttribute(query.getExpressionBuilder().anyOf("teamMembers"));
    String errorMsg = executeQueriesAndCompareResults(controlQuery, query);
    if (errorMsg.length() > 0) {
        failTest(errorMsg);
    }
}
Also used : ReadAllQuery(org.eclipse.persistence.queries.ReadAllQuery)

Example 88 with ReadAllQuery

use of org.eclipse.persistence.queries.ReadAllQuery in project eclipselink by eclipse-ee4j.

the class STI_JoinedAttributeTest method testEmployeeJoinProjects.

public void testEmployeeJoinProjects() {
    ReadAllQuery query = new ReadAllQuery();
    query.setReferenceClass(STI_Employee.class);
    ReadAllQuery controlQuery = (ReadAllQuery) query.clone();
    query.addJoinedAttribute(query.getExpressionBuilder().anyOf("projects"));
    String errorMsg = executeQueriesAndCompareResults(controlQuery, query);
    if (errorMsg.length() > 0) {
        failTest(errorMsg);
    }
}
Also used : ReadAllQuery(org.eclipse.persistence.queries.ReadAllQuery)

Example 89 with ReadAllQuery

use of org.eclipse.persistence.queries.ReadAllQuery in project eclipselink by eclipse-ee4j.

the class STI_JoinedAttributeTest method testProjectOuterJoinTeamLeaderTeamMembersWhereProjectName.

public void testProjectOuterJoinTeamLeaderTeamMembersWhereProjectName() {
    ReadAllQuery query = new ReadAllQuery();
    query.setReferenceClass(STI_Project.class);
    query.setSelectionCriteria(query.getExpressionBuilder().get("name").equal("Problem Reporting System").or(query.getExpressionBuilder().get("name").equal("Bleep Blob")));
    ReadAllQuery controlQuery = (ReadAllQuery) query.clone();
    Expression teamLeader = query.getExpressionBuilder().getAllowingNull("teamLeader");
    query.addJoinedAttribute(teamLeader);
    Expression teamMembers = query.getExpressionBuilder().anyOfAllowingNone("teamMembers");
    query.addJoinedAttribute(teamMembers);
    String errorMsg = executeQueriesAndCompareResults(controlQuery, query);
    if (errorMsg.length() > 0) {
        failTest(errorMsg);
    }
}
Also used : Expression(org.eclipse.persistence.expressions.Expression) ReadAllQuery(org.eclipse.persistence.queries.ReadAllQuery)

Example 90 with ReadAllQuery

use of org.eclipse.persistence.queries.ReadAllQuery in project eclipselink by eclipse-ee4j.

the class STI_JoinedAttributeTest method testProjectJoinTeamLeaderWhereTeamLeaderNotNull.

public void testProjectJoinTeamLeaderWhereTeamLeaderNotNull() {
    ReadAllQuery query = new ReadAllQuery();
    query.setReferenceClass(STI_Project.class);
    Expression teamLeader = query.getExpressionBuilder().get("teamLeader");
    query.setSelectionCriteria(teamLeader.notNull());
    ReadAllQuery controlQuery = (ReadAllQuery) query.clone();
    query.addJoinedAttribute(teamLeader);
    String errorMsg = executeQueriesAndCompareResults(controlQuery, query);
    if (errorMsg.length() > 0) {
        failTest(errorMsg);
    }
}
Also used : Expression(org.eclipse.persistence.expressions.Expression) ReadAllQuery(org.eclipse.persistence.queries.ReadAllQuery)

Aggregations

ReadAllQuery (org.eclipse.persistence.queries.ReadAllQuery)440 Expression (org.eclipse.persistence.expressions.Expression)278 ExpressionBuilder (org.eclipse.persistence.expressions.ExpressionBuilder)265 List (java.util.List)202 EntityManager (jakarta.persistence.EntityManager)135 JpaEntityManager (org.eclipse.persistence.jpa.JpaEntityManager)119 Vector (java.util.Vector)112 ArrayList (java.util.ArrayList)88 Spatial (org.eclipse.persistence.testing.models.spatial.jgeometry.wrapped.Spatial)82 SpatialParameters (org.eclipse.persistence.expressions.spatial.SpatialParameters)81 Employee (org.eclipse.persistence.testing.models.jpa.advanced.Employee)62 ReportQuery (org.eclipse.persistence.queries.ReportQuery)57 SimpleSpatial (org.eclipse.persistence.testing.models.spatial.jgeometry.SimpleSpatial)47 WrappedSpatial (org.eclipse.persistence.testing.models.spatial.jgeometry.wrapped.WrappedSpatial)44 SQLReader (org.eclipse.persistence.testing.tests.spatial.jgeometry.SQLReader)41 JGeometry (oracle.spatial.geometry.JGeometry)30 CriteriaBuilder (jakarta.persistence.criteria.CriteriaBuilder)29 ReadObjectQuery (org.eclipse.persistence.queries.ReadObjectQuery)28 UnitOfWork (org.eclipse.persistence.sessions.UnitOfWork)27 Query (jakarta.persistence.Query)25