summaryrefslogtreecommitdiffstats
path: root/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CorrectedDefectTests.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/CorrectedDefectTests.java')
-rw-r--r--tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CorrectedDefectTests.java244
1 files changed, 0 insertions, 244 deletions
diff --git a/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CorrectedDefectTests.java b/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CorrectedDefectTests.java
deleted file mode 100644
index c7aa9cbb6d..0000000000
--- a/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CorrectedDefectTests.java
+++ /dev/null
@@ -1,244 +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;
-
-/*
- * These tests attempt to duplicate customer reported errors and then to verify
- * any necessary fix.
- *
- */
-
-import java.util.Iterator;
-import java.util.Random;
-
-import org.apache.tuscany.das.rdb.ApplyChangesCommand;
-import org.apache.tuscany.das.rdb.Command;
-import org.apache.tuscany.das.rdb.CommandGroup;
-import org.apache.tuscany.das.rdb.SDODataTypes;
-import org.apache.tuscany.das.rdb.test.data.CompanyData;
-import org.apache.tuscany.das.rdb.test.data.CompanyDeptData;
-import org.apache.tuscany.das.rdb.test.data.CustomerData;
-import org.apache.tuscany.das.rdb.test.data.DepartmentData;
-import org.apache.tuscany.das.rdb.test.data.OrderData;
-import org.apache.tuscany.das.rdb.test.framework.DasTest;
-
-import commonj.sdo.DataObject;
-
-public class CorrectedDefectTests extends DasTest {
-
- protected void setUp() throws Exception {
- super.setUp();
- new CustomerData(getAutoConnection()).refresh();
- new OrderData(getAutoConnection()).refresh();
-
- new CompanyData(getAutoConnection()).refresh();
- new DepartmentData(getAutoConnection()).refresh();
- new CompanyDeptData(getAutoConnection()).refresh();
-
- }
-
- protected void tearDown() throws Exception {
- super.tearDown();
- }
-
- /**
- * Dilton's bug for adding new child data object
- */
- public void testAddNewOrder() throws Exception {
-
- // Read some customers and related orders
- Command select = Command.FACTORY.createCommand(
- "SELECT * FROM CUSTOMER LEFT JOIN ANORDER ON CUSTOMER.ID = ANORDER.CUSTOMER_ID",
- getConfig("CustomersOrdersConfig.xml"));
- select.setConnection(getConnection());
-
- DataObject root = select.executeQuery();
-
- DataObject cust = root.getDataObject("CUSTOMER[1]");
-
- // Save ID and Order Count
- int custID = cust.getInt("ID");
- int custOrderCount = cust.getList("orders").size();
-
- // Create a new Order and add to customer1
- DataObject order = root.createDataObject("ANORDER");
-
- order.set("ID", new Integer(99));
- order.set("PRODUCT", "The 99th product");
- order.set("QUANTITY", new Integer(99));
- cust.getList("orders").add(order);
-
- assertEquals(custOrderCount + 1, cust.getList("orders").size());
- // Build apply changes command
- ApplyChangesCommand apply = Command.FACTORY.createApplyChangesCommand(getConfig("CustomersOrdersConfig.xml"));
- apply.setConnection(getConnection());
-
- // Flush changes
- apply.execute(root);
-
- // verify cust1 relationship updates
- select = Command.FACTORY
- .createCommand("SELECT * FROM CUSTOMER LEFT JOIN ANORDER ON CUSTOMER.ID = ANORDER.CUSTOMER_ID where CUSTOMER.ID = :ID",getConfig("CustomersOrdersConfig.xml"));
- select.setConnection(getConnection());
- select.setParameterValue("ID", new Integer(custID));
- root = select.executeQuery();
-
- assertEquals(custOrderCount + 1, root.getList("CUSTOMER[1]/orders").size());
-
- }
-
- public void testDiltonsInsertWorkaround() throws Exception {
-
- // String sql = "insert into conmgt.serverstatus (statusid,
- // managedserverid, timestamp) values (316405209, 316405209, '2005-11-23
- // 19:29:52.636')";
- // String sql = "insert into conmgt.serverstatus (managedserverid,
- // timestamp) values (316405209, '2005-11-23 19:29:52.636')";
- String sql = "insert into conmgt.serverstatus (managedserverid, timestamp) values (:serverid, :timestamp)";
-
- Command insert = Command.FACTORY.createCommand(sql);
- insert.setParameterValue("serverid", new Integer(316405209));
- insert.setParameterValue("timestamp", "2005-11-23 19:29:52.636");
- insert.setConnection(getConnection());
- insert.execute();
-
- // Verify
- Command select = Command.FACTORY.createCommand("Select * from conmgt.serverstatus");
- select.setConnection(getConnection());
- DataObject root = select.executeQuery();
- assertEquals(1, root.getList("SERVERSTATUS").size());
-
- }
-
- public void testWASDefect330118() throws Exception {
-
- // Create the group and set common connection
- CommandGroup commandGroup = CommandGroup.FACTORY
- .createCommandGroup(getConfig("CustomersOrdersConfig.xml"));
- commandGroup.setConnection(getConnection());
-
- // Read all customers and add one
- Command read = commandGroup.getCommand("all customers");
- DataObject root = read.executeQuery();
- int numCustomers = root.getList("CUSTOMER").size();
-
- DataObject newCust = root.createDataObject("CUSTOMER");
- newCust.set("ID", new Integer(100));
- newCust.set("ADDRESS", "5528 Wells Fargo Drive");
- newCust.set("LASTNAME", "Gerkin");
-
- // Now delete this new customer
- newCust.delete();
-
- ApplyChangesCommand apply = commandGroup.getApplyChangesCommand();
- apply.execute(root);
-
- // Verify
- root = read.executeQuery();
- assertEquals(numCustomers, root.getList("CUSTOMER").size());
-
- }
-
- /**
- * Should be able to explicitly set a parameter to null. But, should require
- * that the parameter type is set.
- */
- public void testDiltonsNullParameterBug1() throws Exception {
-
- Command insert = Command.FACTORY.createCommand("insert into CUSTOMER values (:ID, :LASTNAME, :ADDRESS)");
- insert.setConnection(getConnection());
- insert.setParameterValue("ID", new Integer(10));
- insert.setParameterValue("LASTNAME", null);
- insert.setParameterType("LASTNAME", SDODataTypes.STRING);
- insert.setParameterValue("ADDRESS", "5528 Wells Fargo Dr");
- insert.execute();
-
- // Verify
- Command select = Command.FACTORY.createCommand("Select * from CUSTOMER where ID = 10");
- select.setConnection(getConnection());
- DataObject root = select.executeQuery();
- assertEquals(1, root.getList("CUSTOMER").size());
- assertEquals("5528 Wells Fargo Dr", root.get("CUSTOMER[1]/ADDRESS"));
-
- }
-
- /**
- * Error by not setting a parameter
- */
- public void testDiltonsNullParameterBug2() throws Exception {
-
- Command insert = Command.FACTORY.createCommand("insert into CUSTOMER values (:ID, :LASTNAME, :ADDRESS)");
- insert.setConnection(getConnection());
- insert.setParameterValue("ID", new Integer(10));
- // insert.setParameterValue("LASTNAME", null);
- insert.setParameterValue("ADDRESS", "5528 Wells Fargo Dr");
-
- try {
- insert.execute();
- fail();
- } catch (RuntimeException e) {
- // Expected since "LASTNAME" parameter not set
- }
- }
-
- /**
- * Set parameter to empty string
- */
- public void testDiltonsNullParameterBug3() throws Exception {
-
- Command insert = Command.FACTORY.createCommand("insert into CUSTOMER values (:ID, :LASTNAME, :ADDRESS)");
- insert.setConnection(getConnection());
- insert.setParameterValue("ID", new Integer(10));
- insert.setParameterValue("LASTNAME", "");
- insert.setParameterValue("ADDRESS", "5528 Wells Fargo Dr");
- insert.execute();
-
- // Verify
- Command select = Command.FACTORY.createCommand("Select * from CUSTOMER where ID = 10");
- select.setConnection(getConnection());
- DataObject root = select.executeQuery();
- assertEquals(1, root.getList("CUSTOMER").size());
- assertEquals("5528 Wells Fargo Dr", root.get("CUSTOMER[1]/ADDRESS"));
-
- }
-
- public void testUpdateChildThatHasGeneratedKey() throws Exception {
-
- CommandGroup commandGroup = CommandGroup.FACTORY.createCommandGroup(getConfig("CompanyConfig.xml"));
-
- // Read a specific company based on the known ID
- Command readCust = commandGroup.getCommand("all companies and departments");
- DataObject root = readCust.executeQuery();
- DataObject lastCustomer = root.getDataObject("COMPANY[3]");
- Iterator i = lastCustomer.getList("departments").iterator();
- Random generator = new Random();
- int random = generator.nextInt(1000) + 1;
- DataObject department;
- while (i.hasNext()) {
- department = (DataObject) i.next();
- // System.out.println("Modifying department: " +
- // department.getString("NAME"));
- department.setString("NAME", "Dept-" + random);
- random = random + 1;
- }
-
- ApplyChangesCommand apply = commandGroup.getApplyChangesCommand();
- apply.execute(root);
-
- }
-
-} \ No newline at end of file
generated by cgit v1.2.3 (git 2.25.1) at 2024-06-11 03:44:05 +0000