diff options
Diffstat (limited to 'tests/org.eclipse.emf.teneo.commontest/src/org/eclipse/emf/teneo/test/emf/annotations/JoinColumnsAction.java')
| -rwxr-xr-x | tests/org.eclipse.emf.teneo.commontest/src/org/eclipse/emf/teneo/test/emf/annotations/JoinColumnsAction.java | 163 |
1 files changed, 163 insertions, 0 deletions
diff --git a/tests/org.eclipse.emf.teneo.commontest/src/org/eclipse/emf/teneo/test/emf/annotations/JoinColumnsAction.java b/tests/org.eclipse.emf.teneo.commontest/src/org/eclipse/emf/teneo/test/emf/annotations/JoinColumnsAction.java new file mode 100755 index 000000000..264e428ae --- /dev/null +++ b/tests/org.eclipse.emf.teneo.commontest/src/org/eclipse/emf/teneo/test/emf/annotations/JoinColumnsAction.java @@ -0,0 +1,163 @@ +/** + * <copyright> Copyright (c) 2005, 2006, 2007, 2008 Springsite BV (The Netherlands) and others All rights + * reserved. This program and the accompanying materials are made available under the terms of the + * Eclipse Public License v1.0 which accompanies this distribution, and is available at + * http://www.eclipse.org/legal/epl-v10.html Contributors: Martin Taal </copyright> $Id: + * JoinColumnsAction.java,v 1.4 2007/02/01 12:35:36 mtaal Exp $ + */ + +package org.eclipse.emf.teneo.test.emf.annotations; + +import java.sql.Connection; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.sql.Statement; +import java.util.Properties; + +import org.eclipse.emf.teneo.PersistenceOptions; +import org.eclipse.emf.teneo.annotations.pannotation.InheritanceType; +import org.eclipse.emf.teneo.samples.emf.annotations.joincolumns.Child; +import org.eclipse.emf.teneo.samples.emf.annotations.joincolumns.House; +import org.eclipse.emf.teneo.samples.emf.annotations.joincolumns.JoincolumnsFactory; +import org.eclipse.emf.teneo.samples.emf.annotations.joincolumns.JoincolumnsPackage; +import org.eclipse.emf.teneo.samples.emf.annotations.joincolumns.Parent; +import org.eclipse.emf.teneo.samples.emf.annotations.joincolumns.Person; +import org.eclipse.emf.teneo.test.AbstractTestAction; +import org.eclipse.emf.teneo.test.StoreTestException; +import org.eclipse.emf.teneo.test.stores.TestStore; + +/** + * Testcase + * + * @author <a href="mailto:mtaal@elver.org">Martin Taal</a> + * @version $Revision: 1.11 $ + */ +public class JoinColumnsAction extends AbstractTestAction { + /** + * Constructor + */ + public JoinColumnsAction() { + super(JoincolumnsPackage.eINSTANCE); + } + + /** Checks the version column */ + protected void checkVersion(TestStore store) { + } + + /** + * Can be overridden by subclass returns properties which control the or layer. Such as setting + * of eager loading. + */ + @Override + public Properties getExtraConfigurationProperties() { + final Properties props = new Properties(); + props.setProperty(PersistenceOptions.VERSION_COLUMN_NAME, "myversion"); + props.setProperty(PersistenceOptions.JOIN_TABLE_FOR_NON_CONTAINED_ASSOCIATIONS, "true"); + return props; + } + + /** Creates an item, an address and links them to a po. */ + @Override + public void doAction(TestStore store) { + final JoincolumnsFactory factory = JoincolumnsFactory.eINSTANCE; + { + store.beginTransaction(); + final Parent parent = factory.createParent(); + parent.setFirstName("John"); + parent.setLastName("Smith"); + final Child child1 = factory.createChild(); + child1.setFirstName("Johnny"); + child1.setLastName("Smith"); + parent.getChildren().add(child1); + final Child child2 = factory.createChild(); + child2.setFirstName("Jane"); + child2.setLastName("Smith"); + parent.getChildren().add(child2); + store.store(parent.getChildren()); + store.store(parent); + + House h = factory.createHouse(); + h.setOwner(parent); + h.getVisitors().add(parent); + h.getVisitors().add(child2); + store.store(h); + + // now create some friends + Person f1 = factory.createPerson(); + f1.setFirstName("friend"); + f1.setLastName("one"); + Person f2 = factory.createPerson(); + f2.setFirstName("friend"); + f2.setLastName("two"); + Person f3 = factory.createPerson(); + f3.setFirstName("friend"); + f3.setLastName("three"); + Person f4 = factory.createPerson(); + f4.setFirstName("friend"); + f4.setLastName("four"); + + f1.getFriends().add(f2); + f1.getFriends().add(f3); + f1.getFriends().add(f4); + + f2.getFriends().add(f3); + f2.getFriends().add(f4); + + f4.getFriends().add(f1); + f4.getFriends().add(f2); + f4.getFriends().add(f3); + + f3.getFriends().add(f2); + f3.getFriends().add(f4); + + store.store(f1); + store.commitTransaction(); + } + + // read again + { + store.beginTransaction(); + final Parent parent = store.getObject(Parent.class); + assertEquals(2, parent.getChildren().size()); + assertEquals("Johnny", parent.getChildren().get(0).getFirstName()); + assertEquals("Jane", parent.getChildren().get(1).getFirstName()); + final House h = store.getObject(House.class); + assertEquals(parent, h.getOwner()); + assertTrue(h.getVisitors().contains(parent)); + assertEquals(2, h.getVisitors().size()); + assertTrue(h.getVisitors().contains(parent.getChildren().get(1))); + store.commitTransaction(); + } + + // check version column and foreign keys + Connection conn = null; + Statement stmt = null; + try { + try { + conn = store.getConnection(); + stmt = conn.createStatement(); + + checkVersion(store); + + // depending on the inheritance strategy the foreign key is stored in different + // table + if (store.getInheritanceType() == InheritanceType.SINGLE_TABLE) { + final ResultSet rs = stmt.executeQuery("select myParentFirstName from person"); + assertTrue(rs.next()); + } else { + final ResultSet rs = stmt.executeQuery("select myParentFirstName from child"); + assertTrue(rs.next()); + } + } finally { + if (stmt != null) { + stmt.close(); + } + if (conn != null) { + conn.close(); + } + } + } catch (final SQLException e) { + throw new StoreTestException("Sql exception when checking db schema", e); + } + } +}
\ No newline at end of file |