1 files changed, 222 insertions, 0 deletions
diff --git a/das-java/tags/1.0-incubating-beta2/rdb/src/test/java/org/apache/tuscany/das/rdb/test/ConverterTests.java b/das-java/tags/1.0-incubating-beta2/rdb/src/test/java/org/apache/tuscany/das/rdb/test/ConverterTests.java
new file mode 100644
index 0000000000..b300b85192
--- /dev/null
+++ b/das-java/tags/1.0-incubating-beta2/rdb/src/test/java/org/apache/tuscany/das/rdb/test/ConverterTests.java
@@ -0,0 +1,222 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you 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 java.text.DateFormat;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
+import java.util.Date;
+
+import org.apache.tuscany.das.rdb.Command;
+import org.apache.tuscany.das.rdb.DAS;
+import org.apache.tuscany.das.rdb.test.customer.Customer;
+import org.apache.tuscany.das.rdb.test.customer.CustomerFactory;
+import org.apache.tuscany.das.rdb.test.data.CustomerData;
+import org.apache.tuscany.das.rdb.test.data.OrderData;
+import org.apache.tuscany.das.rdb.test.framework.DasTest;
+
+import commonj.sdo.DataObject;
+import commonj.sdo.helper.HelperContext;
+import commonj.sdo.impl.HelperProvider;
+/**
+ * Tests the Converter framwork
+ */
+public class ConverterTests extends DasTest {
+
+    private static DateFormat myformat = new SimpleDateFormat("yyyy.MM.dd");
+
+    private static Date kbday;
+
+    private static Date tbday;
+
+    protected void setUp() throws Exception {
+        super.setUp();
+        new CustomerData(getAutoConnection()).refresh();
+        new OrderData(getAutoConnection()).refresh();
+    }
+
+    protected void tearDown() throws Exception {
+        super.tearDown();
+    }
+
+    static {
+        try {
+            kbday = myformat.parse("1957.09.27");
+            tbday = myformat.parse("1966.12.20");
+        } catch (ParseException e) {
+            throw new RuntimeException(e);
+        }
+    }
+
+    /**
+     * This tests the use of an arbitrary converter. The column converted is a VARCAHAR. ResultSetShape is used to specify that the property will be a
+     * SDODataTypes.DATE.
+     * 
+     * So this example uses a converter that transforms a string column into a date property and conversely, a date property back to a string for the
+     * underlying column.
+     * 
+     * The converter returns 1957.09.27 if the column value is "Williams" and 1966.12.20 if the value is "Pavick"
+     * 
+     * On write, the converter returns "Pavick" if the property value is 1966.12.20 and "Williams" if the property value is 1957.09.27
+     * 
+     */
+    public void testArbitraryConverter() throws Exception {
+        DAS das = DAS.FACTORY.createDAS(getConfig("CustomerConfigWithConverter.xml"), getConnection());
+
+        // Create and initialize command to read customers
+        Command read = das.getCommand("testArbitraryConverter");
+
+        // Read
+        DataObject root = read.executeQuery();
+
+        // Verify
+        assertEquals(kbday, root.getDate("CUSTOMER[1]/LASTNAME"));
+
+        // Modify
+        root.setDate("CUSTOMER[1]/LASTNAME", tbday);
+
+        das.applyChanges(root);
+
+        // Read
+        root = read.executeQuery();
+
+        // Verify
+        assertEquals(tbday, root.getDate("CUSTOMER[1]/LASTNAME"));
+
+    }
+
+    public void testInvalidConverter1() throws Exception {
+
+        DAS das = DAS.FACTORY.createDAS(getConfig("InvalidConverter.xml"), getConnection());
+
+        // Build the select command to read a specific customer and related
+        // orders
+        Command select = das
+                .createCommand("SELECT * FROM CUSTOMER LEFT JOIN ANORDER " + "ON CUSTOMER.ID = ANORDER.CUSTOMER_ID where CUSTOMER.ID = ?");
+
+        // Parameterize the command
+        select.setParameter(1, new Integer(1));
+
+        // Get the graph
+        try {
+            select.executeQuery();
+        } catch (Exception ex) {
+            assertEquals("java.lang.ClassNotFoundException: not.a.valid.class", ex.getMessage());
+        }
+
+    }
+
+    public void testInvalidConverter2() throws Exception {
+
+    	HelperContext context = HelperProvider.getDefaultContext();
+    	CustomerFactory.INSTANCE.register(context);
+        DAS das = DAS.FACTORY.createDAS(getConfig("InvalidConverter.xml"), getConnection());
+
+        // Build the select command to read a specific customer and related
+        // orders
+        Command select = das.createCommand("SELECT * FROM ANORDER");
+
+        // Get the graph
+
+        DataObject root = select.executeQuery();
+        DataObject order = root.getDataObject("AnOrder[1]");
+
+        Customer customer = (Customer) root.createDataObject("Customer");
+        customer.setID(700);
+        customer.setLastName("Daniel");
+        customer.setAddress("an address");
+
+        customer.getOrders().add(order);
+
+        try {
+            das.applyChanges(root);
+        } catch (Exception ex) {
+            assertEquals("java.lang.ClassNotFoundException: not.a.valid.class", ex.getMessage());
+        }
+
+    }
+
+    /**
+     * This tests the use of a converter that does not produce a new "type". Instead it 
+     * modifies the original value before storing to the database.  In this exampe, the
+     * converter restores the original value on read.
+     * 
+     * This is illustrated by obfuscating the lastname value before it is stored to the database and 
+     * deobfuscating on read.
+     * 
+     */
+    public void testConverter3() throws Exception {
+        DAS das = DAS.FACTORY.createDAS(getConfig("CustomerConfigWithConverter2.xml"), getConnection());
+
+        // Create and initialize command to read customers
+        Command read = das.getCommand("getFirstCustomer");
+
+        // Read
+        DataObject root = read.executeQuery();
+        
+        //Modify
+        root.setString("CUSTOMER[1]/LASTNAME", "Some new name");
+       
+        das.applyChanges(root);
+
+        // Read
+        root = read.executeQuery();
+
+        // Verify that I can read back the deobfuscated value
+        assertEquals("Some new name", root.getString("CUSTOMER[1]/LASTNAME"));
+        
+        //Now read directly without applying the converter to ensure that the value was obfuscated 
+        //in the database.
+        DAS das2 = DAS.FACTORY.createDAS(getConnection());
+        Command directRead = das2.createCommand("select * from CUSTOMER where ID = 1");
+        root = directRead.executeQuery();
+
+        assertEquals("Fbzr arj anzr", root.getString("CUSTOMER[1]/LASTNAME"));
+        assertEquals(obfuscate("Some new name"), root.getString("CUSTOMER[1]/LASTNAME"));
+
+    }
+
+    // Utilities
+    
+    private String obfuscate (String original) throws Exception {
+        return toRot13(original);
+    }
+ 
+    private String deobfuscate (String obfuscated) throws Exception {
+        return toRot13(obfuscated);
+    }    
+    
+    //A simple, reversible, obfuscation algorithm using a ROT13 implementation
+    private String toRot13(String original) throws Exception {
+
+        int abyte = 0;
+        byte[] buffer = original.getBytes("ISO-8859-1");
+
+        for (int i = 0; i < buffer.length; i++) {
+            abyte = buffer[i];
+            int cap = abyte & 32;
+            abyte &= ~cap;
+            abyte = ((abyte >= 'A') && (abyte <= 'Z') ? ((abyte - 'A' + 13) % 26 + 'A') : abyte) | cap;
+            buffer[i] = (byte) abyte;
+        }
+        
+        return new String(buffer, "ISO-8859-1");
+    }
+
+}