docstest.java

另外一种持久性o/m软件

package org.apache.torque;

/*
 * Copyright 2001-2004 The Apache Software Foundation.
 *
 * 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.
 */

import java.util.List;

import org.apache.torque.test.Author;
import org.apache.torque.test.AuthorPeer;
import org.apache.torque.test.Book;
import org.apache.torque.test.BookPeer;
import org.apache.torque.util.BasePeer;
import org.apache.torque.util.Criteria;

/**
 * Runtime tests to make sure that the code which is supplied
 * in the documentation actually works ;-)
 *
 * @author <a href="mailto:[e-mail]">Thomas Fischer</a>
 * @version $Id: DocsTest.java,v 1.4 2005/03/19 06:25:27 tfischer Exp $
 */
public class DocsTest extends BaseRuntimeTestCase
{
    public static final String AUTHOR_1_NAME = "Joshua Bloch";
    
    public static final String AUTHOR_2_NAME = "W. Stevens";

    public static final String AUTHOR_3_NAME = "Author without book";
    
    public static final String BOOK_1_TITLE = "Effective Java";
    
    public static final String BOOK_1_ISBN = "0-618-12902-2";
    
    public static final String BOOK_2_TITLE = "TCP/IP Illustrated";
    
    public static final String BOOK_2_ISBN = "0-201-63346-9";
  
    public static final String BOOK_3_TITLE = "TCP/IP Illustrated";
    
    public static final String BOOK_3_ISBN = "0-201-63354-X";
        
    /**
     * Creates a new instance.
     */
    public DocsTest(String name)
    {
        super(name);
    }

    public void setUp()
    {
        super.setUp();

        // clean the books database
        Criteria criteria = new Criteria();
        criteria.add(BookPeer.BOOK_ID, (Long) null, Criteria.NOT_EQUAL);
        try 
        {
            BookPeer.doDelete(criteria);
        }
        catch(Exception e) 
        {
            e.printStackTrace();
            fail("cleaning books : Exception caught : " 
                     + e.getClass().getName() 
                     + " : " + e.getMessage());
        }
        criteria.clear();
        criteria.add(
                AuthorPeer.AUTHOR_ID, 
                (Long) null, Criteria.NOT_EQUAL);
        try 
        {
            AuthorPeer.doDelete(criteria);
        }
        catch(Exception e) 
        {
            e.printStackTrace();
            fail("cleaning authors : Exception caught : " 
                     + e.getClass().getName() 
                     + " : " + e.getMessage());
        }
        
        
        // insert some data into the database
        // taken from tutorial step 4 with some changes
        try 
        {  
            Author bloch = new Author();
            bloch.setName(AUTHOR_1_NAME);
            bloch.save();

            Author stevens = new Author();
            stevens.setName(AUTHOR_2_NAME);
            AuthorPeer.doInsert(stevens);

            Author withoutBook = new Author();
            withoutBook.setName(AUTHOR_3_NAME);
            AuthorPeer.doInsert(withoutBook);

            Book effective = new Book();
            effective.setTitle(BOOK_1_TITLE);
            effective.setIsbn(BOOK_1_ISBN);
            effective.setAuthor(bloch);
            effective.save();

            Book tcpip = new Book();
            tcpip.setTitle(BOOK_2_TITLE);
            tcpip.setIsbn(BOOK_2_ISBN);
            tcpip.setAuthorId(stevens.getAuthorId());
            tcpip.save();

            Book tcpipVolTwo = new Book();
            tcpipVolTwo.setTitle(BOOK_3_TITLE);
            tcpipVolTwo.setIsbn(BOOK_3_ISBN);
            tcpipVolTwo.setAuthorId(stevens.getAuthorId());
            tcpipVolTwo.save();

        }
        catch (Exception e) {
            e.printStackTrace();
            fail("Exception caught : " 
                     + e.getClass().getName() 
                     + " : " + e.getMessage());
        }
    }

    /**
     * Criteria howto, section "Order by".
     */
    public void testCriteriaOrderBy() 
    {
        List books = null;
        try 
        {
            Criteria criteria = new Criteria();
            criteria.addAscendingOrderByColumn(BookPeer.TITLE);
            criteria.addAscendingOrderByColumn(BookPeer.ISBN);
    
            books = BookPeer.doSelect(criteria);            
        }
        catch (Exception e) 
        { 
            e.printStackTrace();
            fail("Exception caught : " 
                     + e.getClass().getName() 
                     + " : " + e.getMessage());
        }
        
        Book book = (Book) books.get(0);
        assertTrue(
                "title of first book is not"
                + BOOK_1_TITLE
                + " but "
                + book.getTitle(),
                BOOK_1_TITLE.equals(book.getTitle())
                );

        book = (Book) books.get(2);
        assertTrue(
                "ISBN of third book is not"
                + BOOK_3_ISBN
                + " but "
                + book.getIsbn(),
                BOOK_3_ISBN.equals(book.getIsbn()));
    }
    
    /**
     * Criteria howto, section "Order by".
     */
    public void testCriteriaJoins() 
    {
        // inner joins
        List bookAuthors = null;
        try 
        {
            Criteria criteria = new Criteria();
            criteria.addJoin(
                    AuthorPeer.AUTHOR_ID, 
                    BookPeer.AUTHOR_ID, 
                    Criteria.INNER_JOIN);
  
            bookAuthors = AuthorPeer.doSelect(criteria);
            
            // from Details section
            Author author = (Author) bookAuthors.get(0);
            List books = author.getBooks();
        }
        catch (Exception e) 
        { 
            e.printStackTrace();
            fail("inner join : Exception caught : " 
                     + e.getClass().getName() 
                     + " : " + e.getMessage());
        }
        
        assertTrue(
                "inner join : size of bookAuthors is not 3, but"
                + bookAuthors.size(),
                bookAuthors.size() == 3);
        
        // test explicit sql statements from details section
        List result = null;
        try 
        {
            result = BasePeer.executeQuery(
                    "SELECT book.* FROM book "
                    + "INNER JOIN author "
                    + "ON book.AUTHOR_ID=author.AUTHOR_ID");
        }
        catch (Exception e) 
        { 
            e.printStackTrace();
            fail("Explicit SQL query 1 : Exception caught : " 
                     + e.getClass().getName() 
                     + " : " + e.getMessage());
        }
        
        assertTrue(
            "Explicit SQL query 1 : size of result is not 3, but"
            + result.size(),
            result.size() == 3);

        result = null;
        try 
        {
            result = BasePeer.executeQuery(
                    "SELECT book.* FROM book,author "
                    + "WHERE book.AUTHOR_ID=author.AUTHOR_ID");
        }
        catch (Exception e) 
        { 
            e.printStackTrace();
            fail("Explicit SQL query 2 : Exception caught : " 
                     + e.getClass().getName() 
                     + " : " + e.getMessage());
        }
        
        assertTrue(
            "Explicit SQL query 2 : size of result is not 3, but"
            + result.size(),
            result.size() == 3);
        
        // test left outer join
        bookAuthors = null;
        try 
        {
              Criteria criteria = new Criteria();
              criteria.addJoin(
                      AuthorPeer.AUTHOR_ID, 
                      BookPeer.AUTHOR_ID, 
                      Criteria.LEFT_JOIN);
              bookAuthors = AuthorPeer.doSelect(criteria);
        }
        catch (Exception e) 
        { 
            e.printStackTrace();
            fail("left join : Exception caught : " 
                     + e.getClass().getName() 
                     + " : " + e.getMessage());
        }

        assertTrue(
            "left join : size of bookAuthors is not 4, but"
            + bookAuthors.size(),
            bookAuthors.size() == 4);

    }
    
    /**
     * Criteria Howto, section "Distinct".
     */
    public void testDistinct() 
    {
        List bookAuthors = null;
        try 
        {
            Criteria criteria = new Criteria();
            criteria.addJoin(
                    AuthorPeer.AUTHOR_ID, 
                    BookPeer.AUTHOR_ID, 
                    Criteria.INNER_JOIN);
            criteria.setDistinct();
        
            bookAuthors = AuthorPeer.doSelect(criteria);
        }
        catch (Exception e) 
        { 
            e.printStackTrace();
            fail("Exception caught : " 
                     + e.getClass().getName() 
                     + " : " + e.getMessage());
        }
        assertTrue(
            "size of bookAuthors is not 2, but"
            + bookAuthors.size(),
            bookAuthors.size() == 2);
    }
    
    /**
     * Criteria Howto, section "Join & Order & Distinct".
     */
    public void testJoinOrderDistinct() 
    {
        List bookAuthors = null;
        try 
        {
            Criteria criteria = new Criteria();
            criteria.addJoin(
                    AuthorPeer.AUTHOR_ID, 
                    BookPeer.AUTHOR_ID, 
                    Criteria.INNER_JOIN);
            criteria.setDistinct();
            criteria.addAscendingOrderByColumn(AuthorPeer.NAME);
                  
            bookAuthors = AuthorPeer.doSelect(criteria);
        }
        catch (Exception e) 
        { 
            e.printStackTrace();
            fail("Exception caught : " 
                     + e.getClass().getName() 
                     + " : " + e.getMessage());
        }
        assertTrue(
            "size of bookAuthors is not 2, but"
            + bookAuthors.size(),
            bookAuthors.size() == 2);
        
        Author author = (Author) bookAuthors.get(0);
        assertTrue(
            "Author of first book is not"
            + AUTHOR_1_NAME
            + " but "
            + author.getName(),
            AUTHOR_1_NAME.equals(author.getName()));
  
        author = (Author) bookAuthors.get(1);
        assertTrue(
            "Author of second book is not"
            + AUTHOR_2_NAME
            + " but "
            + author.getName(),
            AUTHOR_2_NAME.equals(author.getName()));
    }
}