svn commit: r892169 - in /ofbiz/trunk/framework/sql: build.xml src/org/ofbiz/sql/test/ src/org/ofbiz/sql/test/SQLTest.java src/org/ofbiz/sql/test/TestSelect.sql

[doogie-3]

Author: doogie
Date: Fri Dec 18 08:02:53 2009
New Revision: 892169

URL: http://svn.apache.org/viewvc?rev=892169&view=rev
Log:
Add start of sql testing, just printing them for now.

Added:
    ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/
    ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/SQLTest.java
    ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/TestSelect.sql
Modified:
    ofbiz/trunk/framework/sql/build.xml

Modified: ofbiz/trunk/framework/sql/build.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/sql/build.xml?rev=892169&r1=892168&r2=892169&view=diff
==============================================================================
--- ofbiz/trunk/framework/sql/build.xml (original)
+++ ofbiz/trunk/framework/sql/build.xml Fri Dec 18 08:02:53 2009
@@ -37,6 +37,17 @@
         <pathelement location="build/gen-src/javacc"/>
         <pathelement location="build/gen-src/jjtree"/>
     </path>
+    <path id="test.class.path">
+        <path refid="local.class.path"/>
+       <fileset dir="../base/lib" includes="*.jar"/>
+       <fileset dir="../base/lib/commons" includes="*.jar"/>
+       <fileset dir="../base/lib/j2eespecs" includes="*.jar"/>
+       <pathelement location="config"/>
+       <pathelement location="src"/>
+    </path>
+    <filelist id="test.classes" dir="${src.dir}">
+        <file name="org/ofbiz/sql/test/SQLTest.java"/>
+    </filelist>
 
     <!-- ================================================================== -->
     <!-- Compilation of the source files                                                                                                                         -->

Added: ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/SQLTest.java
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/SQLTest.java?rev=892169&view=auto
==============================================================================
--- ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/SQLTest.java (added)
+++ ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/SQLTest.java Fri Dec 18 08:02:53 2009
@@ -0,0 +1,46 @@
+/*
+ * 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.ofbiz.sql.test;
+
+import java.net.URL;
+import java.util.Collections;
+import java.util.List;
+import java.util.Map;
+
+import javolution.util.FastList;
+import javolution.util.FastMap;
+
+import junit.framework.TestCase;
+
+import org.ofbiz.sql.Parser;
+import org.ofbiz.sql.SQLSelect;
+import org.ofbiz.sql.SQLStatement;
+
+public class SQLTest extends TestCase {
+    public SQLTest(String name) {
+        super(name);
+    }
+
+    public void testFoo() throws Exception {
+        List statements = new Parser(getClass().getResourceAsStream("TestSelect.sql")).SQLFile();
+        for (Object statement: statements) {
+            System.err.println(statement);
+        }
+    }
+}

Added: ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/TestSelect.sql
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/TestSelect.sql?rev=892169&view=auto
==============================================================================
--- ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/TestSelect.sql (added)
+++ ofbiz/trunk/framework/sql/src/org/ofbiz/sql/test/TestSelect.sql Fri Dec 18 08:02:53 2009
@@ -0,0 +1,44 @@
+/*
+ * 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.
+ */
+
+SELECT
+ a.*,
+ b.firstName,
+ b.lastName
+FROM
+ Party a JOIN Person b ON a.partyId = b.partyId
+WHERE
+ a.partyTypeId = 'PERSON'
+ AND
+ b.lastName LIKE ?lastName
+HAVING
+ b.firstName LIKE '%foo%'
+OFFSET 5
+LIMIT 10
+;
+SELECT
+ a.partyTypeId,
+ COUNT(a.partyId) AS count
+FROM
+ Party a LEFT JOIN Person b USING partyId
+ LEFT JOIN PartyGroup c USING partyId
+GROUP BY
+ partyTypeId
+;
+