summaryrefslogtreecommitdiffstats
path: root/tags/java-M1-20060522/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CompoundKeyTests.java
diff options
context:
space:
mode:
Diffstat (limited to 'tags/java-M1-20060522/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CompoundKeyTests.java')
-rw-r--r--tags/java-M1-20060522/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CompoundKeyTests.java100
1 files changed, 0 insertions, 100 deletions
diff --git a/tags/java-M1-20060522/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CompoundKeyTests.java b/tags/java-M1-20060522/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CompoundKeyTests.java
deleted file mode 100644
index 7a3ae9b5ed..0000000000
--- a/tags/java-M1-20060522/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/CompoundKeyTests.java
+++ /dev/null
@@ -1,100 +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;
-
-import org.apache.tuscany.das.rdb.ApplyChangesCommand;
-import org.apache.tuscany.das.rdb.Command;
-import org.apache.tuscany.das.rdb.Key;
-import org.apache.tuscany.das.rdb.test.data.OrderData;
-import org.apache.tuscany.das.rdb.test.data.OrderDetailsData;
-import org.apache.tuscany.das.rdb.test.framework.DasTest;
-
-import commonj.sdo.DataObject;
-
-/**
- * Tests for Compound Keys
- */
-public class CompoundKeyTests extends DasTest {
-
- protected void setUp() throws Exception {
- super.setUp();
-
- new OrderDetailsData(getAutoConnection()).refresh();
- new OrderData(getAutoConnection()).refresh();
- }
-
- protected void tearDown() throws Exception {
- super.tearDown();
- }
-
- public void testRead() throws Exception {
-
- Command getOrderDetails = Command.FACTORY
- .createCommand("Select * from ORDERDETAILS where ORDERID = :ORDERID AND PRODUCTID = :PRODUCTID");
- getOrderDetails.setConnection(getConnection());
-
- getOrderDetails.setParameterValue("ORDERID", new Integer(1));
- getOrderDetails.setParameterValue("PRODUCTID", new Integer(1));
-
- DataObject root = getOrderDetails.executeQuery();
-
- DataObject orderDetail = (DataObject) root.get("ORDERDETAILS[1]");
- assertEquals(1.1f, orderDetail.getFloat("PRICE"), 0.01);
-
- }
-
- public void testReadModifyWrite2() throws Exception {
-
- Command getOrderDetails = Command.FACTORY
- .createCommand("Select * from ORDERDETAILS where ORDERID = 1 AND PRODUCTID = 1");
- getOrderDetails.setConnection(getConnection());
- DataObject root = getOrderDetails.executeQuery();
-
- DataObject orderDetails = (DataObject) root.get("ORDERDETAILS[1]");
- assertEquals(1.1f, orderDetails.getFloat("PRICE"), 0.01);
-
- // Modify
- orderDetails.setFloat("PRICE", 0f);
-
- // Build apply changes command
- ApplyChangesCommand apply = Command.FACTORY.createApplyChangesCommand(getConfig("OrdersOrderDetailsConfig.xml"));
- apply.setConnection(getConnection());
-
- // Write
- apply.execute(root);
-
- // Verify
- root = getOrderDetails.executeQuery();
- orderDetails = root.getDataObject("ORDERDETAILS[1]");
- assertEquals(0f, orderDetails.getFloat("PRICE"), 0.01);
-
- }
-
- public void testReadOrdersAndDetails2() throws Exception {
-
- Command read = Command.FACTORY
- .createCommand("SELECT * FROM ANORDER LEFT JOIN ORDERDETAILS ON ANORDER.ID = ORDERDETAILS.ORDERID ORDER BY ANORDER.ID", getConfig("OrdersOrderDetailsConfig.xml"));
- read.setConnection(getConnection());
-
- DataObject root = read.executeQuery();
-
- DataObject firstOrder = root.getDataObject("ANORDER[1]");
- assertEquals(1, firstOrder.getInt("ID"));
- assertEquals(2, firstOrder.getList("ORDERDETAILS").size());
-
- }
-}