1 files changed, 133 insertions, 0 deletions
diff --git a/sandbox/event/modules/implementation-data-xml/src/test/java/org/apache/tuscany/sca/implementation/data/DATATestCase.java b/sandbox/event/modules/implementation-data-xml/src/test/java/org/apache/tuscany/sca/implementation/data/DATATestCase.java
new file mode 100644
index 0000000000..4010cb63d3
--- /dev/null
+++ b/sandbox/event/modules/implementation-data-xml/src/test/java/org/apache/tuscany/sca/implementation/data/DATATestCase.java
@@ -0,0 +1,133 @@
+/*
+ * 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.sca.implementation.data;
+
+import java.io.FileInputStream;
+
+import javax.xml.stream.XMLInputFactory;
+import javax.xml.stream.XMLStreamReader;
+
+import junit.framework.TestCase;
+
+import org.apache.tuscany.sca.databinding.xml.XMLStreamReader2String;
+import org.apache.tuscany.sca.host.embedded.SCADomain;
+import org.apache.tuscany.sca.implementation.data.DATA;
+
+/**
+ * Tests the DAS service
+ *
+ * @version $Rev$ $Date$
+ */
+public class DATATestCase extends TestCase {
+    private SCADomain scaDomain;
+    private DATA dataService;
+    
+    /**
+     * @throws java.lang.Exception
+     */
+    @Override
+    protected void setUp() throws Exception {
+        scaDomain = SCADomain.newInstance("data.composite");
+        dataService = scaDomain.getService(DATA.class, "DataComponent/COMPANY_DATA");
+    }
+    
+    /**
+     * @throws java.lang.Exception
+     */
+    @Override
+    protected void tearDown() throws Exception {
+        scaDomain.close();
+    }
+    
+    public void testInsert() throws Exception {
+        System.out.println(">testInsert");
+
+        //Read and process the XML file
+        FileInputStream fileInputStream = new FileInputStream("src/test/resources/insert.xml");
+        XMLStreamReader reader = XMLInputFactory.newInstance().createXMLStreamReader(fileInputStream);
+
+        int result = dataService.insert(reader);
+        assertEquals(result,2);
+
+        System.out.println("Number of rows inserted: "+result);
+
+        reader.close();
+    }
+
+    public void testGet() throws Exception {
+        
+        System.out.println(">testGet");
+        
+        XMLStreamReader reader = dataService.get(null);
+        assertNotNull(reader);
+        String xml = new XMLStreamReader2String().transform(reader, null);
+        System.out.println(xml);
+        reader.close();
+    }
+
+    public void testUpdate() throws Exception {
+
+        System.out.println(">testUpdate");
+
+        //Read and process the XML file
+        FileInputStream fileInputStream = new FileInputStream("src/test/resources/update.xml");
+        XMLStreamReader reader = XMLInputFactory.newInstance().createXMLStreamReader(fileInputStream);
+
+        int result = dataService.update(reader);
+        assertEquals(result,1);
+        System.out.println("Number of rows affected: "+result);
+
+        reader.close();
+    }
+
+    public void testGetByID() throws Exception {
+        System.out.println(">testGetByID");
+
+        Integer companyID = new Integer(4);
+
+        XMLStreamReader reader = dataService.get(companyID.toString());
+        assertNotNull(reader);
+        String xml = new XMLStreamReader2String().transform(reader, null);
+        System.out.println(xml);
+        reader.close();
+    }
+
+    public void testDeleteByID() throws Exception {
+        System.out.println(">testDeleteByID");
+
+        Integer companyID = new Integer(4);
+        int result = dataService.delete(companyID.toString());
+        assertEquals(result,1);
+        System.out.println("Number of rows deleted: "+result);
+    }
+
+    public void testDelete() throws Exception {
+        System.out.println(">testDelete");
+
+        int result = dataService.delete(null);
+        assertEquals(result,4);
+        System.out.println("Number of rows deleted: "+result);
+
+        System.out.println("recreating database...");
+        //Helper.createDB();
+        System.out.println("done!");
+    }
+    
+}