diff options
Diffstat (limited to 'das-java/tags/1.0-incubating-beta1-rc1/samples/dbconfig/src/test')
2 files changed, 116 insertions, 0 deletions
diff --git a/das-java/tags/1.0-incubating-beta1-rc1/samples/dbconfig/src/test/java/org/apache/tuscany/das/rdb/dbconfig/DBInitializerTestCase.java b/das-java/tags/1.0-incubating-beta1-rc1/samples/dbconfig/src/test/java/org/apache/tuscany/das/rdb/dbconfig/DBInitializerTestCase.java new file mode 100644 index 0000000000..3bd0bae407 --- /dev/null +++ b/das-java/tags/1.0-incubating-beta1-rc1/samples/dbconfig/src/test/java/org/apache/tuscany/das/rdb/dbconfig/DBInitializerTestCase.java @@ -0,0 +1,69 @@ +/*
+ * 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.dbconfig;
+
+import junit.framework.TestCase;
+
+
+
+/**
+ * Tests the Converter framwork
+ */
+public class DBInitializerTestCase extends TestCase {
+
+ protected void setUp() throws Exception {
+ super.setUp();
+ }
+
+ protected void tearDown() throws Exception {
+ super.tearDown();
+ }
+
+
+ public void testCreateDatabase() throws Exception {
+ DBInitializer dbInitializer = new DBInitializer("dbConfig.xml");
+ dbInitializer.initializeDatabase(true);
+ }
+
+ public void something() throws Exception {
+// try{
+// //DBInitHelper dbInit = new DBInitHelper("DBConfig.xml");
+// DBInitializer dbInit = new DBInitializer(new FileInputStream("c:/DBConfig.xml"));
+// dbInit.initializeDatabase(true);
+//
+// System.out.println("check schema created:"+dbInit.isDatabaseReady());
+// System.out.println("check data created:"+dbInit.isDataCreated());
+//
+// dbInit.deleteData();
+// System.out.println("check data created after deleteData:"+dbInit.isDataCreated());
+//
+// dbInit.deleteSchema();
+// System.out.println("after deleteSchema check schema created:"+dbInit.isDatabaseReady());
+//
+// dbInit.createSchema(false);
+// System.out.println("check schema created after createSchema:"+dbInit.isDatabaseReady());
+//
+// dbInit.refreshData(true);
+// System.out.println("check data created after refreshData:"+dbInit.isDataCreated());
+// }catch(Exception e){
+// e.printStackTrace();
+// }
+ }
+}
diff --git a/das-java/tags/1.0-incubating-beta1-rc1/samples/dbconfig/src/test/resources/dbConfig.xml b/das-java/tags/1.0-incubating-beta1-rc1/samples/dbconfig/src/test/resources/dbConfig.xml new file mode 100644 index 0000000000..18eb5b429d --- /dev/null +++ b/das-java/tags/1.0-incubating-beta1-rc1/samples/dbconfig/src/test/resources/dbConfig.xml @@ -0,0 +1,47 @@ +<?xml version="1.0" encoding="ASCII"?>
+<!--
+ 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.
+ -->
+<DBConfig xmlns="http:///org.apache.tuscany.das.rdb/dbconfig.xsd">
+ <ConnectionInfo>
+ <ConnectionProperties
+ driverClass="org.apache.derby.jdbc.EmbeddedDriver"
+ databaseURL="jdbc:derby:target/dastest; create = true"
+ loginTimeout="600000"/>
+ </ConnectionInfo>
+ <Table name="COMPANY" SQLCreate="CREATE TABLE COMPANY (ID INT PRIMARY KEY NOT NULL, NAME VARCHAR(30), EOTMID INTEGER)">
+ <row>51, 'ACME Publishing', 0</row>
+ <row>52, 'Do-rite plumbing', 0</row>
+ <row>53, 'MegaCorp', 0</row>
+ </Table>
+ <Table name="DEPARTMENT" SQLCreate="CREATE TABLE DEPARTMENT (ID INT PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY, NAME VARCHAR(30),LOCATION VARCHAR(30), DEPNUMBER VARCHAR(10),COMPANYID INT)">
+ <row>'Advanced Technologies', 'NY', '123', 1</row>
+ <row>'Default Name', '', '', 51</row>
+ <row>'Default Name', '', '', 51</row>
+ <row>'Default Name', '', '', 51</row>
+ <row>'Default Name', '', '', 51</row>
+ <row>'Default Name', '', '', 51</row>
+ <row>'Default Name', '', '', 51</row>
+ </Table>
+ <Table name="EMPLOYEE" SQLCreate="CREATE TABLE EMPLOYEE (ID INT PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY,NAME VARCHAR(30),SN VARCHAR(10), MANAGER SMALLINT, DEPARTMENTID INT)">
+ <row>'John Jones','E0001',0,12</row>
+ <row>'Mary Smith','E0002',1,null</row>
+ <row>'Jane Doe','E0003',0,12</row>
+ <row>'Al Smith','E0004',1,12</row>
+ </Table>
+</DBConfig>
|