Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Developers List" <torque-dev@db.apache.org>
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r1308140 - in /db/torque/torque4/trunk/torque-test/src:
 main/schema/view-schema.xml
 test/java/org/apache/torque/generated/dataobject/ViewTest.java
Date: Sun, 01 Apr 2012 15:37:39 -0000
To: torque-commits@db.apache.org
From: tfischer@apache.org
Message-Id: <20120401153740.13B0F23889BB@eris.apache.org>

Author: tfischer
Date: Sun Apr  1 15:37:39 2012
New Revision: 1308140

URL: http://svn.apache.org/viewvc?rev=1308140&view=rev
Log:
TORQUE-175: test case for reading from view

Added:
    db/torque/torque4/trunk/torque-test/src/main/schema/view-schema.xml
    db/torque/torque4/trunk/torque-test/src/test/java/org/apache/torque/generated/dataobject/ViewTest.java

Added: db/torque/torque4/trunk/torque-test/src/main/schema/view-schema.xml
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-test/src/main/schema/view-schema.xml?rev=1308140&view=auto
==============================================================================
--- db/torque/torque4/trunk/torque-test/src/main/schema/view-schema.xml (added)
+++ db/torque/torque4/trunk/torque-test/src/main/schema/view-schema.xml Sun Apr  1 15:37:39 2012
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="ISO-8859-1" standalone="no" ?>
+<!--
+ 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.
+-->
+
+<database name="@DATABASE_DEFAULT@"
+    defaultIdMethod="@DATABASE_ID_METHOD@"
+    xmlns="http://db.apache.org/torque/4.0/templates/database"
+    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+    xsi:schemaLocation="http://db.apache.org/torque/4.0/templates/database 
+        http://db.apache.org/torque/4.0/templates/database.xsd">
+
+  <view name="BOOK_AUTHORS" sqlSuffix="from book join author on book.author_id=author.author_id">
+    <column name="book_id" type="INTEGER" select="book.book_id"/>
+    <column name="author_id" type="INTEGER" select="author.author_id"/>
+    <column name="book_title" type="VARCHAR" select="book.title"/>
+    <column name="author_name" type="VARCHAR" select="author.name"/>
+  </view>
+
+
+</database>

Added: db/torque/torque4/trunk/torque-test/src/test/java/org/apache/torque/generated/dataobject/ViewTest.java
URL: http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-test/src/test/java/org/apache/torque/generated/dataobject/ViewTest.java?rev=1308140&view=auto
==============================================================================
--- db/torque/torque4/trunk/torque-test/src/test/java/org/apache/torque/generated/dataobject/ViewTest.java (added)
+++ db/torque/torque4/trunk/torque-test/src/test/java/org/apache/torque/generated/dataobject/ViewTest.java Sun Apr  1 15:37:39 2012
@@ -0,0 +1,63 @@
+package org.apache.torque.generated.dataobject;
+
+/*
+ * 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.
+ */
+
+import java.util.List;
+
+import org.apache.torque.BaseDatabaseTestCase;
+import org.apache.torque.criteria.Criteria;
+import org.apache.torque.test.Author;
+import org.apache.torque.test.BookAuthors;
+import org.apache.torque.test.BookAuthorsPeer;
+
+/**
+ * Tests whether the save methods work in the db object classes.
+ *
+ * @version $Id: DataTest.java 1103512 2011-05-15 19:37:41Z tfischer $
+ */
+public class ViewTest extends BaseDatabaseTestCase
+{
+    /**
+     * Tests that we can select from the view.
+     *
+     * @throws Exception if a database error occurs.
+     */
+    public void testSelect() throws Exception
+    {
+        // prepare
+        cleanBookstore();
+        List<Author> bookstoreContent = insertBookstoreData();
+        Criteria criteria = new Criteria();
+        criteria.addAscendingOrderByColumn(BookAuthorsPeer.AUTHOR_ID);
+        criteria.addAscendingOrderByColumn(BookAuthorsPeer.BOOK_ID);
+
+        // execute
+        List<BookAuthors> result = BookAuthorsPeer.doSelect(criteria);
+
+        // verify
+        assertEquals(100, result.size());
+        assertEquals("Author 1", result.get(0).getAuthorName());
+        assertEquals("Book 1 - Author 1" , result.get(0).getBookTitle());
+        assertEquals("Author 10", result.get(99).getAuthorName());
+        assertEquals("Book 10 - Author 10" , result.get(99).getBookTitle());
+
+        verifyBookstore(bookstoreContent); // db not changed
+    }
+}


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org