You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by do...@apache.org on 2009/12/18 09:02:54 UTC
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
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
+;
+