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: [email protected]
For additional commands, e-mail: [email protected]
