/*
* Copyright 2005 Werner Guttmann
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package ctf.jdo.tc20x;
import harness.CastorTestCase;
import harness.TestHarness;
import java.sql.Connection;
import java.sql.Statement;
import java.util.Collection;
import java.util.Iterator;
import jdo.JDOCategory;
import org.exolab.castor.jdo.Database;
import org.exolab.castor.jdo.OQLQuery;
import org.exolab.castor.jdo.PersistenceException;
import org.exolab.castor.jdo.QueryResults;
/**
* Tests that modification to read only objects are not persist in the
* database.
*/
public final class TestSelfRelationExtend extends CastorTestCase {
private static final String PARENT_TABLE_NAME = "tc200_self_relation_parent";
private static final String EXTEND_TABLE_NAME = "tc200_self_relation_extend";
private JDOCategory _category;
/**
* Constructor
* @param category the test suite that this test case belongs
*/
public TestSelfRelationExtend(final TestHarness category) {
super(category, "TC201", "Self-referential relation tests with extend hierarchy");
_category = (JDOCategory) category;
}
/**
* Get a JDO database
*/
public void setUp()
throws Exception {
Database db = _category.getDatabase();
db.begin();
Connection connection = db.getJdbcConnection();
connection.setAutoCommit(false);
// delete everything directly
Statement stmt = connection.createStatement();
stmt.executeUpdate("DELETE FROM " + PARENT_TABLE_NAME);
stmt.executeUpdate("DELETE FROM " + EXTEND_TABLE_NAME);
//insert data
stmt.execute("INSERT INTO " + PARENT_TABLE_NAME
+ " (id, name) VALUES (1, 'parent')");
stmt.execute("INSERT INTO " + PARENT_TABLE_NAME
+ " (id, name) VALUES (2, 'first child')");
stmt.execute("INSERT INTO " + PARENT_TABLE_NAME
+ " (id, name) VALUES (3, 'second child')");
stmt.execute("INSERT INTO " + EXTEND_TABLE_NAME
+ " (id) VALUES (1)");
stmt.execute("INSERT INTO " + EXTEND_TABLE_NAME
+ " (id, parent_id) VALUES (2, 1)");
stmt.execute("INSERT INTO " + EXTEND_TABLE_NAME
+ " (id, parent_id) VALUES (3, 1)");
db.commit();
}
public void runTest() throws PersistenceException {
testCreate();
testLoad();
// add loading parent to suite
// testLoadParent();
testOQLExtend();
testOQLParent();
testUpdateSimpleProperty();
}
/**
* this tests creating a folder
*/
public void testCreate() throws PersistenceException {
Database db = _category.getDatabase();
SelfRelationFolderExtend folder = new SelfRelationFolderExtend();
SelfRelationFolderExtend child = new SelfRelationFolderExtend();
SelfRelationFolderExtend grandChild = new SelfRelationFolderExtend();
SelfRelationFolderExtend greatGrandChild = new SelfRelationFolderExtend();
folder.setId(new Integer(5));
folder.setName("Test Folder");
child.setId(new Integer(6));
child.setName("Test Child");
folder.addChild(child);
grandChild.setId(new Integer(7));
grandChild.setName("Test Grandchild");
child.addChild(grandChild);
greatGrandChild.setId(new Integer(8));
greatGrandChild.setName("Test Greatgrandchild");
grandChild.addChild(greatGrandChild);
db.begin();
db.create(folder);
db.create(child);
db.create(grandChild);
db.create(greatGrandChild);
db.commit();
db.close();
}
/**
* This loads a folder
*/
public void testLoad() throws PersistenceException {
SelfRelationFolderExtend folder;
Database db = _category.getDatabase();
db.begin();
folder = (SelfRelationFolderExtend) db.load(
SelfRelationFolderExtend.class, new Integer(1));
assertEquals("parent", folder.getName());
assertEquals(1, folder.getId().intValue());
// assertNull(folder.getParent());
assertNotNull(folder.getChildren());
Iterator i = folder.getChildren().iterator();
assertNotNull(i);
assertTrue("No child loaded", i.hasNext());
int counter = 0;
// load first expected child, and assert its properties
assertTrue(i.hasNext());
SelfRelationFolderExtend child = (SelfRelationFolderExtend) i.next();
assertNotNull(child);
assertEquals(2, child.getId().intValue());
assertNotNull(child.getParent());
// assertEquals(1, child.getParent().getId().intValue());
counter++;
// load second expected child, and assert its properties
assertTrue(i.hasNext());
child = (SelfRelationFolderExtend) i.next();
assertNotNull(child);
assertEquals(3, child.getId().intValue());
assertNotNull(child.getParent());
// assertEquals(1, child.getParent().getId().intValue());
counter++;
assertTrue("At least two children should have been loaded.",
counter >= 2);
db.commit();
db.close();
}
/*
* This loads a folder
*/
public void testLoadParent() throws PersistenceException {
SelfRelationFolderParent folder;
//start transaction
Database db = _category.getDatabase();
db.begin();
//load a folder
folder = (SelfRelationFolderParent)
db.load(SelfRelationFolderParent.class, new Integer(1));
assertTrue(folder instanceof SelfRelationFolderExtend);
assertEquals(1, folder.getId().intValue());
assertEquals ("parent", folder.getName());
SelfRelationFolderExtend folderExtend =
(SelfRelationFolderExtend) folder;
assertNull(folderExtend.getParent());
assertNotNull(folderExtend.getChildren());
Iterator i = folderExtend.getChildren().iterator();
assertNotNull(i);
assertTrue("No child loaded", i.hasNext());
int counter = 0;
// load first expected child, and assert its properties
assertTrue (i.hasNext());
SelfRelationFolderExtend child = (SelfRelationFolderExtend) i.next();
assertNotNull (child);
assertEquals(2, child.getId().intValue());
assertNotNull(child.getParent());
assertEquals(1, child.getParent().getId().intValue());
counter++;
// load second expected child, and assert its properties
assertTrue (i.hasNext());
child = (SelfRelationFolderExtend) i.next();
assertNotNull (child);
assertEquals(3, child.getId().intValue());
assertNotNull(child.getParent());
assertEquals(1, child.getParent().getId().intValue());
counter++;
assertTrue("At least two children should have been loaded.", counter >= 2);
db.commit();
db.close();
}
public void testOQLExtend() throws PersistenceException {
OQLQuery oql;
QueryResults results;
Database db = _category.getDatabase();
db.begin();
oql = db.getOQLQuery("SELECT a FROM "
+ SelfRelationFolderExtend.class.getName() + " a");
results = oql.execute();
assertTrue(results.hasMore());
int counter = 0;
SelfRelationFolderExtend f;
f = (SelfRelationFolderExtend) results.next();
assertNotNull(f);
assertEquals(1, f.getId().intValue());
assertEquals("parent", f.getName());
counter++;
f = (SelfRelationFolderExtend) results.next();
assertNotNull(f);
assertEquals(2, f.getId().intValue());
assertEquals("first child", f.getName());
counter++;
f = (SelfRelationFolderExtend) results.next();
assertNotNull(f);
assertEquals(3, f.getId().intValue());
assertEquals("second child", f.getName());
counter++;
f = (SelfRelationFolderExtend) results.next();
assertNotNull(f);
assertEquals(5, f.getId().intValue());
assertEquals("Test Folder", f.getName());
counter++;
f = (SelfRelationFolderExtend) results.next();
assertNotNull(f);
assertEquals(6, f.getId().intValue());
assertEquals("Test Child", f.getName());
counter++;
f = (SelfRelationFolderExtend) results.next();
assertNotNull(f);
assertEquals(7, f.getId().intValue());
assertEquals("Test Grandchild", f.getName());
counter++;
f = (SelfRelationFolderExtend) results.next();
assertNotNull(f);
assertEquals(8, f.getId().intValue());
assertEquals("Test Greatgrandchild", f.getName());
counter++;
oql.close();
db.commit();
db.close();
assertEquals("At least 7 folders should have been returned", 7, counter);
}
public void testOQLParent() throws PersistenceException {
OQLQuery oql;
QueryResults results;
Database db = _category.getDatabase();
db.begin();
oql = db.getOQLQuery("SELECT a FROM "
+ SelfRelationFolderParent.class.getName() + " a");
results = oql.execute();
assertTrue(results.hasMore());
int counter = 0;
SelfRelationFolderParent f;
f = (SelfRelationFolderParent) results.next();
assertNotNull(f);
assertTrue(f instanceof SelfRelationFolderExtend);
assertEquals(1, f.getId().intValue());
assertEquals("parent", f.getName());
Collection children = ((SelfRelationFolderExtend) f).getChildren();
assertNotNull(children);
assertEquals(2, children.size());
counter++;
f = (SelfRelationFolderParent) results.next();
assertNotNull(f);
assertTrue(f instanceof SelfRelationFolderExtend);
assertEquals(2, f.getId().intValue());
assertEquals("first child", f.getName());
children = ((SelfRelationFolderExtend) f).getChildren();
assertNotNull(children);
assertEquals(0, children.size());
counter++;
f = (SelfRelationFolderParent) results.next();
assertNotNull(f);
assertTrue(f instanceof SelfRelationFolderExtend);
assertEquals(3, f.getId().intValue());
assertEquals("second child", f.getName());
children = ((SelfRelationFolderExtend) f).getChildren();
assertNotNull(children);
assertEquals(0, children.size());
counter++;
f = (SelfRelationFolderParent) results.next();
assertNotNull(f);
assertTrue(f instanceof SelfRelationFolderExtend);
assertEquals(5, f.getId().intValue());
assertEquals("Test Folder", f.getName());
children = ((SelfRelationFolderExtend) f).getChildren();
assertNotNull(children);
assertEquals(1, children.size());
counter++;
f = (SelfRelationFolderParent) results.next();
assertNotNull(f);
assertTrue(f instanceof SelfRelationFolderExtend);
assertEquals(6, f.getId().intValue());
assertEquals("Test Child", f.getName());
children = ((SelfRelationFolderExtend) f).getChildren();
assertNotNull(children);
assertEquals(1, children.size());
counter++;
f = (SelfRelationFolderParent) results.next();
assertNotNull(f);
assertTrue(f instanceof SelfRelationFolderExtend);
assertEquals(7, f.getId().intValue());
assertEquals("Test Grandchild", f.getName());
children = ((SelfRelationFolderExtend) f).getChildren();
assertNotNull(children);
assertEquals(1, children.size());
counter++;
f = (SelfRelationFolderParent) results.next();
assertNotNull(f);
assertTrue(f instanceof SelfRelationFolderExtend);
assertEquals(8, f.getId().intValue());
assertEquals("Test Greatgrandchild", f.getName());
children = ((SelfRelationFolderExtend) f).getChildren();
assertNotNull(children);
assertEquals(0, children.size());
counter++;
oql.close();
db.commit();
assertEquals("At least 7 folders should have been returned", 7, counter);
db.close();
}
/**
* This tests updating a folder
*/
public void testUpdateSimpleProperty() throws PersistenceException {
SelfRelationFolderExtend folder;
Database db = _category.getDatabase();
db.begin();
// load a folder, and assert its properties
folder = (SelfRelationFolderExtend) db.load(
SelfRelationFolderExtend.class, new Integer(6));
assertNotNull(folder);
assertEquals(6, folder.getId().intValue());
assertEquals("Test Child", folder.getName());
assertNotNull(folder.getParent());
assertNotNull(folder.getChildren());
assertEquals(1, folder.getChildren().size());
db.commit();
folder.setName("Test Update");
db.begin();
db.update(folder);
db.commit();
db.begin();
// load a folder, and assert its properties
folder = (SelfRelationFolderExtend) db.load(
SelfRelationFolderExtend.class, new Integer(6));
assertNotNull(folder);
assertEquals(6, folder.getId().intValue());
assertEquals("Test Update", folder.getName());
assertNotNull(folder.getParent());
assertNotNull(folder.getChildren());
assertEquals(1, folder.getChildren().size());
db.rollback();
db.close();
}
}