package org.eclipse.persistence.testing.tests.dynamic.simple.mappings; | |
import static junit.framework.Assert.assertEquals; | |
import static junit.framework.Assert.assertNotNull; | |
import static junit.framework.Assert.fail; | |
import junit.framework.Assert; | |
import org.eclipse.persistence.descriptors.ClassDescriptor; | |
import org.eclipse.persistence.dynamic.DynamicClassLoader; | |
import org.eclipse.persistence.dynamic.DynamicEntity; | |
import org.eclipse.persistence.dynamic.DynamicHelper; | |
import org.eclipse.persistence.dynamic.DynamicType; | |
import org.eclipse.persistence.dynamic.DynamicTypeBuilder; | |
import org.eclipse.persistence.exceptions.DatabaseException; | |
import org.eclipse.persistence.exceptions.DynamicException; | |
import org.eclipse.persistence.expressions.ExpressionBuilder; | |
import org.eclipse.persistence.logging.SessionLog; | |
import org.eclipse.persistence.mappings.DirectToFieldMapping; | |
import org.eclipse.persistence.mappings.OneToOneMapping; | |
import org.eclipse.persistence.queries.ReportQuery; | |
import org.eclipse.persistence.sessions.DatabaseSession; | |
import org.eclipse.persistence.sessions.Project; | |
import org.eclipse.persistence.sessions.Session; | |
import org.eclipse.persistence.sessions.UnitOfWork; | |
import org.eclipse.persistence.testing.tests.dynamic.DynamicTestHelper; | |
import org.eclipse.persistence.testing.tests.dynamic.EclipseLinkORMTest; | |
import org.eclipse.persistence.tools.schemaframework.SchemaManager; | |
import org.junit.After; | |
import org.junit.AfterClass; | |
import org.junit.Test; | |
public class SimpleTypes_OneToOne extends EclipseLinkORMTest { | |
@Test | |
public void verifyConfig() throws Exception { | |
DynamicHelper helper = new DynamicHelper(getSharedSession()); | |
ClassDescriptor descriptorA = helper.getSession().getClassDescriptorForAlias("SimpleA"); | |
assertNotNull("No descriptor found for alias='SimpleA'", descriptorA); | |
DynamicType simpleTypeA = helper.getType("SimpleA"); | |
assertNotNull("'SimpleA' EntityType not found", simpleTypeA); | |
assertEquals(descriptorA, simpleTypeA.getDescriptor()); | |
DirectToFieldMapping a_id = (DirectToFieldMapping) descriptorA.getMappingForAttributeName("id"); | |
assertEquals(int.class, a_id.getAttributeClassification()); | |
DirectToFieldMapping a_value1 = (DirectToFieldMapping) descriptorA.getMappingForAttributeName("value1"); | |
assertEquals(String.class, a_value1.getAttributeClassification()); | |
ClassDescriptor descriptorB = helper.getSession().getClassDescriptorForAlias("SimpleB"); | |
assertNotNull("No descriptor found for alias='SimpleB'", descriptorB); | |
DynamicType simpleTypeB = helper.getType("SimpleB"); | |
assertNotNull("'SimpleB' EntityType not found", simpleTypeB); | |
assertEquals(descriptorB, simpleTypeB.getDescriptor()); | |
DirectToFieldMapping b_id = (DirectToFieldMapping) descriptorB.getMappingForAttributeName("id"); | |
assertEquals(int.class, b_id.getAttributeClassification()); | |
DirectToFieldMapping b_value1 = (DirectToFieldMapping) descriptorB.getMappingForAttributeName("value1"); | |
assertEquals(String.class, b_value1.getAttributeClassification()); | |
OneToOneMapping a_b = (OneToOneMapping) descriptorA.getMappingForAttributeName("b"); | |
assertEquals(descriptorB, a_b.getReferenceDescriptor()); | |
} | |
@Test | |
public void createSimpleA() { | |
DynamicHelper helper = new DynamicHelper(getSharedSession()); | |
Session session = getSession(); | |
DynamicType simpleTypeA = helper.getType("SimpleA"); | |
Assert.assertNotNull(simpleTypeA); | |
DynamicEntity simpleInstance = simpleTypeA.newDynamicEntity(); | |
simpleInstance.set("id", 1); | |
simpleInstance.set("value1", "A1"); | |
UnitOfWork uow = session.acquireUnitOfWork(); | |
uow.registerNewObject(simpleInstance); | |
uow.commit(); | |
ReportQuery countQuery = helper.newReportQuery("SimpleA", new ExpressionBuilder()); | |
countQuery.addCount(); | |
countQuery.setShouldReturnSingleValue(true); | |
int simpleCount = ((Number) session.executeQuery(countQuery)).intValue(); | |
Assert.assertEquals(1, simpleCount); | |
} | |
@Test | |
public void createSimpleB() { | |
DynamicHelper helper = new DynamicHelper(getSharedSession()); | |
Session session = getSession(); | |
DynamicType simpleTypeB = helper.getType("SimpleB"); | |
Assert.assertNotNull(simpleTypeB); | |
DynamicEntity simpleInstance = simpleTypeB.newDynamicEntity(); | |
simpleInstance.set("id", 1); | |
simpleInstance.set("value1", "B1"); | |
UnitOfWork uow = session.acquireUnitOfWork(); | |
uow.registerNewObject(simpleInstance); | |
uow.commit(); | |
ReportQuery countQuery = helper.newReportQuery("SimpleB", new ExpressionBuilder()); | |
countQuery.addCount(); | |
countQuery.setShouldReturnSingleValue(true); | |
int simpleCount = ((Number) session.executeQuery(countQuery)).intValue(); | |
Assert.assertEquals(1, simpleCount); | |
} | |
@Test | |
public void createSimpleAwithSimpleB() { | |
DynamicHelper helper = new DynamicHelper(getSharedSession()); | |
Session session = getSession(); | |
DynamicType simpleTypeA = helper.getType("SimpleA"); | |
Assert.assertNotNull(simpleTypeA); | |
DynamicType simpleTypeB = helper.getType("SimpleB"); | |
Assert.assertNotNull(simpleTypeB); | |
Assert.assertNotNull(session.getDescriptorForAlias("SimpleB")); | |
DynamicEntity simpleInstanceB = simpleTypeB.newDynamicEntity(); | |
simpleInstanceB.set("id", 2); | |
simpleInstanceB.set("value1", "B2"); | |
DynamicEntity simpleInstanceA = simpleTypeA.newDynamicEntity(); | |
simpleInstanceA.set("id", 2); | |
simpleInstanceA.set("value1", "A2"); | |
simpleInstanceA.set("b", simpleInstanceB); | |
UnitOfWork uow = session.acquireUnitOfWork(); | |
uow.registerNewObject(simpleInstanceA); | |
uow.registerNewObject(simpleInstanceB); | |
uow.commit(); | |
assertEquals(2, getQuerySQLTracker(session).getTotalSQLINSERTCalls()); | |
// There is no reason for a shallow insert and an update in this mapping | |
assertEquals("No update expected for new objects with 1:1", 0, getQuerySQLTracker(session).getTotalSQLUPDATECalls()); | |
ReportQuery countQuery = helper.newReportQuery("SimpleB", new ExpressionBuilder()); | |
countQuery.addCount(); | |
countQuery.setShouldReturnSingleValue(true); | |
Assert.assertEquals(1, ((Number) session.executeQuery(countQuery)).intValue()); | |
countQuery = helper.newReportQuery("SimpleA", new ExpressionBuilder()); | |
countQuery.addCount(); | |
countQuery.setShouldReturnSingleValue(true); | |
Assert.assertEquals(1, ((Number) session.executeQuery(countQuery)).intValue()); | |
} | |
/* | |
* Invalid relationship set | |
*/ | |
@Test | |
public void createSimpleAwithSimpleA() { | |
DynamicHelper helper = new DynamicHelper(getSharedSession()); | |
DynamicType simpleTypeA = helper.getType("SimpleA"); | |
Assert.assertNotNull(simpleTypeA); | |
DynamicEntity simpleInstanceA1 = simpleTypeA.newDynamicEntity(); | |
simpleInstanceA1.set("id", 1); | |
simpleInstanceA1.set("value1", "A1"); | |
DynamicEntity simpleInstanceA2 = simpleTypeA.newDynamicEntity(); | |
simpleInstanceA2.set("id", 2); | |
simpleInstanceA2.set("value1", "A2"); | |
try { | |
simpleInstanceA2.set("b", simpleInstanceA1); | |
} catch (DynamicException e){ | |
return; | |
} | |
fail("DynamicException expected for invalid set of 'b'"); | |
} | |
@Override | |
protected DatabaseSession createSharedSession() { | |
Project project = new Project(DynamicTestHelper.getTestLogin()); | |
DatabaseSession shared = project.createDatabaseSession(); | |
DynamicHelper helper = new DynamicHelper(shared); | |
DynamicClassLoader dcl = helper.getDynamicClassLoader(); | |
Class<?> simpleTypeB = dcl.createDynamicClass("model.SimpleB"); | |
DynamicTypeBuilder bFactory = new DynamicTypeBuilder(simpleTypeB, null, "SIMPLE_TYPE_B"); | |
bFactory.setPrimaryKeyFields("SID"); | |
bFactory.addDirectMapping("id", int.class, "SID"); | |
bFactory.addDirectMapping("value1", String.class, "VAL_1"); | |
Class<?> simpleTypeA = dcl.createDynamicClass("model.SimpleA"); | |
DynamicTypeBuilder aFactory = new DynamicTypeBuilder(simpleTypeA, null, "SIMPLE_TYPE_A"); | |
aFactory.setPrimaryKeyFields("SID"); | |
aFactory.addDirectMapping("id", int.class, "SID"); | |
aFactory.addDirectMapping("value1", String.class, "VAL_1"); | |
aFactory.addOneToOneMapping("b", bFactory.getType(), "B_FK"); | |
helper.addTypes(false, true, aFactory.getType(), bFactory.getType()); | |
shared.getSessionLog().setLevel(SessionLog.FINE); | |
shared.login(); | |
new SchemaManager(shared).replaceDefaultTables(); | |
return shared; | |
} | |
@After | |
public void clearDynamicTables() { | |
getSharedSession().executeNonSelectingSQL("DELETE FROM SIMPLE_TYPE_A"); | |
getSharedSession().executeNonSelectingSQL("DELETE FROM SIMPLE_TYPE_B"); | |
} | |
@AfterClass | |
public static void shutdown() { | |
try { | |
sharedSession.executeNonSelectingSQL("DROP TABLE SIMPLE_TYPE_A CASCADE CONSTRAINTS"); | |
sharedSession.executeNonSelectingSQL("DROP TABLE SIMPLE_TYPE_B CASCADE CONSTRAINTS"); | |
} catch (DatabaseException dbe) { | |
// ignore | |
} | |
} | |
} |