summaryrefslogtreecommitdiffstats
path: root/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/GeneratedId.java
diff options
context:
space:
mode:
Diffstat (limited to 'tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/GeneratedId.java')
-rw-r--r--tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/GeneratedId.java294
1 files changed, 0 insertions, 294 deletions
diff --git a/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/GeneratedId.java b/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/GeneratedId.java
deleted file mode 100644
index 28b9a2f1d8..0000000000
--- a/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/GeneratedId.java
+++ /dev/null
@@ -1,294 +0,0 @@
-/**
- *
- * Copyright 2005 The Apache Software Foundation or its licensors, as applicable.
- *
- * 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 org.apache.tuscany.das.rdb.test;
-
-/*
- * Generated IDs
- *
- *
- */
-
-import org.apache.tuscany.das.rdb.ApplyChangesCommand;
-import org.apache.tuscany.das.rdb.Command;
-import org.apache.tuscany.das.rdb.test.data.CompanyData;
-import org.apache.tuscany.das.rdb.test.data.DepartmentData;
-import org.apache.tuscany.das.rdb.test.framework.DasTest;
-
-import commonj.sdo.DataObject;
-
-public class GeneratedId extends DasTest {
-
- protected void setUp() throws Exception {
- super.setUp();
-
- new CompanyData(getAutoConnection()).refresh();
- new DepartmentData(getAutoConnection()).refresh();
-
- }
-
- protected void tearDown() throws Exception {
- super.tearDown();
- }
-
- // Test insert into row with generated ID
- public void testInsert() throws Exception {
-
- Command insert = Command.FACTORY.createCommand("insert into COMPANY (NAME) values (:NAME)");
- insert.setConnection(getConnection());
- insert.setParameterValue("NAME", "AAA Rental");
- insert.execute();
-
- // Verify insert
- // Verify
- Command select = Command.FACTORY.createCommand("Select ID, NAME from COMPANY");
- select.setConnection(getConnection());
- DataObject root = select.executeQuery();
-
- assertEquals(4, root.getList("COMPANY").size());
- assertTrue(root.getInt("COMPANY[1]/ID") > 0);
-
- }
-
- // Test back to back insertions with the same command
- public void testInsert2() throws Exception {
-
- Command insert = Command.FACTORY.createCommand("insert into COMPANY (NAME) values (:NAME)");
- insert.setConnection(getConnection());
- insert.setParameterValue("NAME", "AAA Rental");
- insert.execute();
-
- // insert another using same command
- insert.setParameterValue("NAME", "BBB Rental");
- insert.execute();
-
- // Verify insert
- // Verify
- Command select = Command.FACTORY.createCommand("Select ID, NAME from COMPANY");
- select.setConnection(getConnection());
- DataObject root = select.executeQuery();
-
- assertEquals(5, root.getList("COMPANY").size());
-
- }
-
- // Test ability to retrieve and utilize the generated key
- public void testInsert3() throws Exception {
-
- Command insert = Command.FACTORY.createCommand("insert into COMPANY (NAME) values (:NAME)");
- insert.setConnection(getConnection());
- insert.setParameterValue("NAME", "AAA Rental");
- insert.execute();
- Integer key = (Integer) insert.getParameterValue("generated_key");
-
- // Verify insert
- Command select = Command.FACTORY.createCommand("Select ID, NAME from COMPANY where ID = :ID");
- select.setConnection(getConnection());
- select.setParameterValue("ID", key);
- DataObject root = select.executeQuery();
- assertEquals(key, root.get("COMPANY[1]/ID"));
-
- }
-
- // Test ability to propogate generated values back to owning data objects
- public void testPropagateIds() throws Exception {
-
- Command select = Command.FACTORY.createCommand("Select * from COMPANY");
- select.setConnection(getConnection());
- DataObject root = select.executeQuery();
-
- // Create a new Company
- DataObject company = root.createDataObject("COMPANY");
- company.setString("NAME", "Do-rite Pest Control");
-
- // Create apply command
- ApplyChangesCommand apply = Command.FACTORY.createApplyChangesCommand(getConfig("CompanyConfig.xml"));
- apply.setConnection(getConnection());
-
- // verify pre-condition (id is not there until after flush)
- assertNull(company.get("ID"));
-
- // Flush changes
- apply.execute(root);
-
- // Save the id
- Integer id = (Integer) company.get("ID");
-
- // Verify the change
- select = Command.FACTORY.createCommand("Select * from COMPANY where ID = :ID");
- select.setConnection(getConnection());
- select.setParameterValue("ID", id);
- root = select.executeQuery();
- assertEquals("Do-rite Pest Control", root.getDataObject("COMPANY[1]").getString("NAME"));
-
- }
-
- /**
- * Same as above but metadata provided by XML config file
- */
- public void testPropagateIdsXML() throws Exception {
-
- Command select = Command.FACTORY.createCommand("Select * from COMPANY",
- getConfig("basicCompanyMapping.xml"));
- select.setConnection(getConnection());
- DataObject root = select.executeQuery();
-
- // Create a new Company
- DataObject company = root.createDataObject("COMPANY");
- company.setString("NAME", "Do-rite Pest Control");
-
- // Create apply command
- ApplyChangesCommand apply = Command.FACTORY
- .createApplyChangesCommand(getConfig("basicCompanyMapping.xml"));
- apply.setConnection(getConnection());
-
- // verify pre-condition (id is not there until after flush)
- assertNull(company.get("ID"));
-
- // Flush changes
- apply.execute(root);
-
- // Save the id
- Integer id = (Integer) company.get("ID");
-
- // Verify the change
- select = Command.FACTORY.createCommand("Select * from COMPANY where ID = :ID");
- select.setConnection(getConnection());
- select.setParameterValue("ID", id);
- root = select.executeQuery();
- assertEquals("Do-rite Pest Control", root.getDataObject("COMPANY[1]").getString("NAME"));
-
- }
-
- /**
- * Test ability to correctly flush heirarchy of objects that have generated
- * keys
- */
- public void testFlushCreateHeirarchy() throws Exception {
-
- String selectCompanys = "SELECT * FROM COMPANY LEFT JOIN DEPARTMENT ON COMPANY.ID = DEPARTMENT.COMPANYID";
-
- Command select = Command.FACTORY.createCommand(selectCompanys,
- getConfig("basicCompanyDepartmentMapping.xml"));
- select.setConnection(getConnection());
- DataObject root = select.executeQuery();
-
- // Create a new Company
- DataObject company = root.createDataObject("COMPANY");
- company.setString("NAME", "Do-rite Pest Control");
-
- // Create a new Department
- // Do not set ID or CompanyID since these are generated
- // ID INT, NAME VARCHAR(30), LOCATION VARCHAR(30), NUMBER VARCHAR(10),
- // COMPANYID INT, EOTM INT
- DataObject department = root.createDataObject("DEPARTMENT");
- department.setString("NAME", "Do-rite Pest Control");
- department.setString("LOCATION", "The boonies");
- department.setString("NUMBER", "101");
-
- // Associate the new department with the new company
- company.getList("departments").add(department);
-
- // Create apply command
- ApplyChangesCommand apply = Command.FACTORY
- .createApplyChangesCommand(getConfig("basicCompanyDepartmentMapping.xml"));
- apply.setConnection(getConnection());
-
- // Flush changes
- apply.execute(root);
-
- // Save the id
- Integer id = (Integer) company.get("ID");
-
- // Verify the change
- String selectString = "SELECT * FROM COMPANY LEFT JOIN DEPARTMENT ON COMPANY.ID = DEPARTMENT.COMPANYID WHERE COMPANY.ID = :ID";
-
- select = Command.FACTORY.createCommand(selectString);
- select.setConnection(getConnection());
- select.setParameterValue("ID", id);
- root = select.executeQuery();
- assertEquals("Do-rite Pest Control", root.getDataObject("COMPANY[1]").getString("NAME"));
-
- }
-
- /**
- * Test ability to correctly flush heirarchy of objects that have generated
- * keys even when a created object has legal but NULL property values
- */
- public void testFlushCreateHeirarchy2() throws Exception {
-
- String selectCompanys = "SELECT * FROM COMPANY LEFT JOIN DEPARTMENT ON COMPANY.ID = DEPARTMENT.COMPANYID";
-
- Command select = Command.FACTORY.createCommand(selectCompanys,
- getConfig("basicCompanyDepartmentMapping.xml"));
- select.setConnection(getConnection());
- DataObject root = select.executeQuery();
-
- // Create a new Company
- DataObject company = root.createDataObject("COMPANY");
- company.setString("NAME", "Do-rite Pest Control");
-
- // Create a new Department
- // Do not set ID or CompanyID since these are generated
- // ID INT, NAME VARCHAR(30), LOCATION VARCHAR(30), NUMBER VARCHAR(10),
- // COMPANYID INT, EOTM INT
- DataObject department = root.createDataObject("DEPARTMENT");
- department.setString("NAME", "Do-rite Pest Control");
- // Do not set this property to force storing NULL to DB
- // department.setString("LOCATION", "The boonies");
- department.setString("NUMBER", "101");
-
- // Associate the new department with the new company
- company.getList("departments").add(department);
-
- // Create apply command
- ApplyChangesCommand apply = Command.FACTORY
- .createApplyChangesCommand(getConfig("basicCompanyDepartmentMapping.xml"));
- apply.setConnection(getConnection());
-
- // Flush changes
- apply.execute(root);
-
- // Save the id
- Integer id = (Integer) company.get("ID");
-
- // Verify the change
- String selectString = "SELECT * FROM COMPANY LEFT JOIN DEPARTMENT ON COMPANY.ID = DEPARTMENT.COMPANYID WHERE COMPANY.ID = :ID";
-
- select = Command.FACTORY.createCommand(selectString);
- select.setConnection(getConnection());
- select.setParameterValue("ID", id);
- root = select.executeQuery();
- assertEquals("Do-rite Pest Control", root.getDataObject("COMPANY[1]").getString("NAME"));
-
- }
-
- // Test that error is thrown when no key has been generated (as in a select)
- public void testRead() throws Exception {
-
- Command select = Command.FACTORY.createCommand("Select * from COMPANY");
- select.setConnection(getConnection());
- select.executeQuery();
-
- try {
- select.getParameterValue("generated_id");
- fail("Should throw Error");
- } catch (RuntimeException e) {
- // OK
- }
- }
-
-} \ No newline at end of file
generated by cgit v1.2.3 (git 2.25.1) at 2024-06-11 00:59:15 +0000