Cleaning up sandbox

git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@898604 13f79535-47bb-0310-9956-ffa450edef68

4 files changed, 195 insertions, 0 deletions

diff --git a/sandbox/lresende/backup/organization-das/src/main/resources/organization-spring-context.xml b/sandbox/lresende/backup/organization-das/src/main/resources/organization-spring-context.xml
new file mode 100644
index 0000000000..c814afe28b
--- /dev/null
+++ b/sandbox/lresende/backup/organization-das/src/main/resources/organization-spring-context.xml
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<beans xmlns="http://www.springframework.org/schema/beans"
+       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+       xmlns:sca="http://www.springframework.org/schema/sca"
+       xsi:schemaLocation="
+       http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
+       http://www.springframework.org/schema/sca http://www.springframework.org/schema/sca/spring-sca.xsd">
+
+    <sca:service name="OrganizationService"
+		type="organization.services.OrganizationService" target="OrganizationServiceBean"/>
+
+    <bean id="OrganizationServiceBean" class="organization.services.OrganizationServiceImpl">
+        <property name="organizationDataService" ref="OrganizationDataServiceBean"/>
+    </bean>
+	
+    <bean id="OrganizationDataServiceBean" class="organization.das.OrganizationDataServiceImpl">
+    	
+    </bean>	
+</beans>
diff --git a/sandbox/lresende/backup/organization-das/src/main/resources/organization.composite b/sandbox/lresende/backup/organization-das/src/main/resources/organization.composite
new file mode 100644
index 0000000000..0113ccf8a0
--- /dev/null
+++ b/sandbox/lresende/backup/organization-das/src/main/resources/organization.composite
@@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<composite xmlns="http://www.osoa.org/xmlns/sca/1.0"
+	targetNamespace="http://org.soa.services"
+	xmlns:soa="http://org.soa.services"
+	name="Organization-Service-Composite">
+    
+  	<service name="OrganizationService" promote="OrganizationServiceComponent/OrganizationService">
+    	<binding.ws/>
+  	</service>
+  	
+    <component name="OrganizationServiceComponent">
+    	<implementation.spring location="organization-spring-context.xml"/>
+    	<service name="OrganizationService"/>
+  	</component>
+  
+  	<component name="OrganizationDataServiceComponent">
+    	<implementation.spring location="organization-spring-context.xml"/>
+  	</component>
+    
+
+</composite>
diff --git a/sandbox/lresende/backup/organization-das/src/main/resources/organizationConfiguration.xml b/sandbox/lresende/backup/organization-das/src/main/resources/organizationConfiguration.xml
new file mode 100644
index 0000000000..2104c37404
--- /dev/null
+++ b/sandbox/lresende/backup/organization-das/src/main/resources/organizationConfiguration.xml
@@ -0,0 +1,87 @@
+<?xml version="1.0" encoding="ASCII"?>
+<Config xmlns="http:///org.apache.tuscany.das.rdb/config.xsd">
+	
+	<!--ConnectionInfo>
+		<ConnectionProperties
+			driverClass="org.apache.derby.jdbc.EmbeddedDriver"
+			databaseURL="jdbc:derby:target/organization_db; create = true"
+			loginTimeout="600000"/>
+	</ConnectionInfo-->
+	
+	
+	<Command name="getAllOrganizations" SQL="select * from ORGANIZATIONTYPELIST" kind="Select">
+		<ResultDescriptor columnName="ORGANIZATIONTYPEID" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.IntObject"/>
+		<ResultDescriptor columnName="CODE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="DISPLAYVALUE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="DESCRIPTION" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="ISEDITABLE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.Type"/>
+	</Command>
+	
+	<Command name="findOrganization" SQL="select * from ORGANIZATIONTYPELIST where ORGANIZATIONTYPEID = ? " kind="Select">
+		<ResultDescriptor columnName="ORGANIZATIONTYPEID" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.IntObject"/>
+		<ResultDescriptor columnName="CODE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="DISPLAYVALUE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="DESCRIPTION" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="ISEDITABLE" tableName="ORGANIZATIONTYPELIST" columnType="commonj.sdo.Integer"/>
+	</Command>
+	
+	<Command name="getAllAccounts" SQL="select * from ACCOUNT" kind="Select">
+		<ResultDescriptor columnName="ACCOUNT_ID" tableName="ACCOUNT" columnType="commonj.sdo.IntObject"/>
+		<ResultDescriptor columnName="ACCOUNTTYPE_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="ACCOUNT_NAME" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="WEB_SITE_ADDRESS" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="STREET_ADDRESS_1" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="STREET_ADDRESS_2" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="STREET_ADDRESS_3" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="CITY" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="STATE_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="POSTAL_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="COUNTRY_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="PHONE_NUMBER" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="FAX_NUMBER" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="NOTE" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+	</Command>
+	
+	<Command name="getAccountByID" SQL="select * from ACCOUNT where ACCOUNT_ID = ?" kind="Select">
+		<ResultDescriptor columnName="ACCOUNT_ID" tableName="ACCOUNT" columnType="commonj.sdo.IntObject"/>
+		<ResultDescriptor columnName="ACCOUNTTYPE_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="ACCOUNT_NAME" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="WEB_SITE_ADDRESS" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="STREET_ADDRESS_1" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="STREET_ADDRESS_2" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="STREET_ADDRESS_3" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="CITY" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="STATE_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="POSTAL_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="COUNTRY_CD" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="PHONE_NUMBER" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="FAX_NUMBER" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+		<ResultDescriptor columnName="NOTE" tableName="ACCOUNT" columnType="commonj.sdo.String"/>
+	</Command>
+	
+	<Table tableName="ORGANIZATIONTYPELIST">
+		<Column columnName="ORGANIZATIONTYPEID" primaryKey="true" generated="true"/>
+		<Column columnName="CODE" />
+		<Column columnName="DISPLAYVALUE" />
+		<Column columnName="DESCRIPTION" />
+		<Column columnName="ISEDITABLE" />
+	</Table>
+	
+	<Table tableName="ACCOUNT">
+		<Column columnName="ACCOUNT_ID" primaryKey="true" generated="true"/>
+		<Column columnName="ACCOUNTTYPE_CD" />
+		<Column columnName="ACCOUNT_NAME" />
+		<Column columnName="WEB_SITE_ADDRESS" />
+		<Column columnName="STREET_ADDRESS_1" />
+		<Column columnName="STREET_ADDRESS_2" />
+		<Column columnName="STREET_ADDRESS_3" />
+		<Column columnName="CITY" />
+		<Column columnName="STATE_CD" />
+		<Column columnName="POSTAL_CD" />
+		<Column columnName="COUNTRY_CD" />
+		<Column columnName="PHONE_NUMBER" />
+		<Column columnName="FAX_NUMBER" />
+		<Column columnName="NOTE" />
+	</Table>
+	
+</Config>
\ No newline at end of file
diff --git a/sandbox/lresende/backup/organization-das/src/main/resources/sdo-types.xsd b/sandbox/lresende/backup/organization-das/src/main/resources/sdo-types.xsd
new file mode 100644
index 0000000000..0b287bda24
--- /dev/null
+++ b/sandbox/lresende/backup/organization-das/src/main/resources/sdo-types.xsd
@@ -0,0 +1,66 @@
+
+<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
+    targetNamespace="http://org/soa/types"
+    xmlns:tns="http://org/soa/types"
+    elementFormDefault="qualified">
+    
+    <xsd:element name="Organization" type="OrganizationType"/>
+    
+    <xsd:complexType name="OrganizationType">
+        <xsd:sequence>
+        	<xsd:element name="ORGANIZATIONTYPEID" type="xsd:int" />
+            <xsd:element name="CODE" type="xsd:string" />
+            <xsd:element name="DISPLAYVALUE" type="xsd:string" />
+            <xsd:element name="DESCRIPTION" type="xsd:string" />
+            <xsd:element name="ISEDITABLE" type="xsd:int" />
+        </xsd:sequence>
+    </xsd:complexType>
+    
+    <xsd:element name="Address" type="AddressType"/>
+    
+    <xsd:complexType name="AddressType">
+        <xsd:sequence>
+        	<xsd:element name="ADDRESS_ID" type="xsd:int" />
+            <xsd:element name="ADDRESSTYPE_CD" type="xsd:string" />
+            <xsd:element name="STREET_ADDRESS_1" type="xsd:string" />
+            <xsd:element name="STREET_ADDRESS_2" type="xsd:string" />
+            <xsd:element name="STREET_ADDRESS_3" type="xsd:string" />
+            <xsd:element name="CITY" type="xsd:string" />
+            <xsd:element name="STATE_CD" type="xsd:string" />
+            <xsd:element name="POSTAL_CD" type="xsd:string" />
+            <xsd:element name="COUNTRY_CD" type="xsd:string" />
+        </xsd:sequence>
+    </xsd:complexType>
+    
+    <xsd:element name="SchemaInfo" type="SchemaInfoType"/>
+    
+    <xsd:complexType name="SchemaInfoType">
+        <xsd:sequence>
+        	<xsd:element name="USERNAME" type="xsd:string" />
+            <xsd:element name="PASSWORD" type="xsd:string" />
+            <xsd:element name="SCHEMA" type="xsd:string" />
+        </xsd:sequence>
+    </xsd:complexType>
+    
+    <xsd:element name="Account" type="AccountType"/>
+    
+    <xsd:complexType name="AccountType">
+        <xsd:sequence>
+        	<xsd:element name="ACCOUNT_ID" type="xsd:string"/>
+			<xsd:element name="ACCOUNTTYPE_CD" type="xsd:string"/>
+			<xsd:element name="ACCOUNT_NAME" type="xsd:string"/>
+			<xsd:element name="WEB_SITE_ADDRESS" type="xsd:string"/>
+			<xsd:element name="STREET_ADDRESS_1" type="xsd:string"/>
+			<xsd:element name="STREET_ADDRESS_2" type="xsd:string"/>
+			<xsd:element name="STREET_ADDRESS_3" type="xsd:string"/>
+			<xsd:element name="CITY" type="xsd:string"/>
+			<xsd:element name="STATE_CD" type="xsd:string"/>
+			<xsd:element name="POSTAL_CD" type="xsd:string"/>
+			<xsd:element name="COUNTRY_CD" type="xsd:string"/>
+			<xsd:element name="PHONE_NUMBER" type="xsd:string"/>
+			<xsd:element name="FAX_NUMBER" type="xsd:string"/>
+			<xsd:element name="NOTE" type="xsd:string"/>
+        </xsd:sequence>
+    </xsd:complexType>
+    
+</xsd:schema>
\ No newline at end of file