1 files changed, 54 insertions, 0 deletions
diff --git a/sca-java-1.x/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/commands/ReadCustomersByLastnameCommand.java b/sca-java-1.x/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/commands/ReadCustomersByLastnameCommand.java
new file mode 100644
index 0000000000..09a6147118
--- /dev/null
+++ b/sca-java-1.x/tags/java-M1-final/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/commands/ReadCustomersByLastnameCommand.java
@@ -0,0 +1,54 @@
+/**
+ *
+ *  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.commands;
+
+import org.apache.tuscany.das.rdb.config.Column;
+import org.apache.tuscany.das.rdb.config.Config;
+import org.apache.tuscany.das.rdb.config.ConfigFactory;
+import org.apache.tuscany.das.rdb.config.Table;
+import org.apache.tuscany.das.rdb.config.impl.ConfigFactoryImpl;
+import org.apache.tuscany.das.rdb.impl.ReadCommandImpl;
+
+
+public class ReadCustomersByLastnameCommand extends ReadCommandImpl {
+
+	private static final String sqlString = "select * from CUSTOMER where LASTNAME = :LASTNAME";
+	private static final Config mapping;
+	
+	static {
+		ConfigFactory factory = ConfigFactoryImpl.eINSTANCE;
+		mapping = factory.createConfig();
+		Table t = factory.createTable();
+		Column id = factory.createColumn();
+		id.setName("ID");
+		id.setPrimaryKey(true);
+		Column lastname = factory.createColumn();
+		lastname.setName("LASTNAME");
+		Column address = factory.createColumn();
+		address.setName("ADDRESS");
+		
+		t.getColumn().add(id);
+		t.getColumn().add(lastname);
+		t.getColumn().add(address);
+		t.setName("CUSTOMER");
+		mapping.getTable().add(t);
+	}
+	
+	public ReadCustomersByLastnameCommand() {
+		super(sqlString, mapping);
+	}
+}