openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/relations/TestManyEagerSQL.java

/*
 * 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.apache.openjpa.persistence.relations;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.Query;

import org.apache.openjpa.persistence.OpenJPAEntityManager;
import org.apache.openjpa.persistence.test.SQLListenerTestCase;

import junit.textui.TestRunner;


public class TestManyEagerSQL
    extends SQLListenerTestCase {

    @Override
    public void setUp() {
        setUp(DROP_TABLES,
            OneManyEagerParent.class, OneManyEagerChild.class,
            OneManyLazyChild.class, OneOneParent.class,
            OneOneChild.class);

        EntityManager em = emf.createEntityManager();
        em.getTransaction().begin();

        for (int j = 0; j < 2; j++) {
            OneManyEagerParent parent = new OneManyEagerParent();
            parent.setName("parent"+j);
            for (int i = 0; i < 2; i++) {
                OneManyEagerChild child = new OneManyEagerChild();
                child.setName("eagerchild" + i);
                parent.addEagerChild(child);
                em.persist(child);
                OneManyLazyChild lazychild = new OneManyLazyChild();
                lazychild.setName("lazychild" + i);
                parent.addLazyChild(lazychild);
                em.persist(lazychild);
            }
            em.persist(parent);
        }

        for (int i = 0; i < 3; i++) {
        	OneOneParent parent = new OneOneParent();
        	parent.setName("parent" + i);
        	OneOneChild child = new OneOneChild();
        	child.setName("child" + i);
        	parent.setChild(child);
        	child.setParent(parent);
        	em.persist(child);
        	em.persist(parent);
        }

        em.flush();
        em.getTransaction().commit();
        em.close();
    }

    public void testManyToOneEagerQuery() {
        sql.clear();

        OpenJPAEntityManager em = emf.createEntityManager();
        String query = "select c FROM OneManyEagerChild c";
        Query q = em.createQuery(query);
        List list = q.getResultList();
        assertEquals(4, list.size());

        // Expected SQLs:
        //   SELECT t0.id, t0.optLock, t0.name, t1.id, t1.optLock, t1.name
        //       FROM OneManyEagerChild t0
        //       LEFT OUTER JOIN OneManyEagerParent t1 ON t0.PARENT_ID = t1.id
        //   SELECT t0.id, t0.optLock, t0.name FROM OneManyEagerChild t0
        //       WHERE t0.PARENT_ID = ? ORDER BY t0.name ASC [params=(long) 2]
        //   SELECT t0.id, t0.optLock, t0.name, t0.PARENT_ID
        //       FROM OneManyLazyChild t0 WHERE t0.PARENT_ID = ?
        //       ORDER BY t0.name ASC [params=(long) 2]
        //   SELECT t0.id, t0.optLock, t0.name FROM OneManyEagerChild t0
        //       WHERE t0.PARENT_ID = ? ORDER BY t0.name ASC [params=(long) 1]
        //   SELECT t0.id, t0.optLock, t0.name, t0.PARENT_ID
        //       FROM OneManyLazyChild t0 WHERE t0.PARENT_ID = ?
        //       ORDER BY t0.name ASC [params=(long) 1]

        assertEquals(5, sql.size());

        sql.clear();

        for (Object o : list) {
            OneManyEagerChild child = (OneManyEagerChild) o;
            assertEquals(2, child.getParent().getLazyChildren().size());
            assertEquals(2, child.getParent().getEagerChildren().size());
        }
        assertEquals(0, sql.size());

        em.close();
    }

    public void testManyToOneLazyQuery() {
        sql.clear();

        OpenJPAEntityManager em = emf.createEntityManager();
        String query = "select c FROM OneManyLazyChild c";
        Query q = em.createQuery(query);
        List list = q.getResultList();
        assertEquals(4, list.size());

        // Expected SQL:
        // SELECT t0.id, t0.optLock, t0.name, t0.PARENT_ID
        //     FROM OneManyLazyChild t0
        assertEquals(1, sql.size());

        sql.clear();

        for (Object o : list) {
            OneManyLazyChild child = (OneManyLazyChild) o;
            assertEquals(2, child.getParent().getLazyChildren().size());
            assertEquals(2, child.getParent().getEagerChildren().size());
        }

        // Expected SQLs: (fired on child.getParent())
        //  SELECT t0.optLock, t0.name, t1.PARENT_ID, t1.id, t1.optLock, t1.name
        //      FROM OneManyEagerParent t0
        //      LEFT OUTER JOIN OneManyEagerChild t1 ON t0.id = t1.PARENT_ID
        //      WHERE t0.id = ?
        //      ORDER BY t1.PARENT_ID ASC, t1.name ASC [params=(long) 252]
        //  SELECT t0.id, t0.optLock, t0.name, t0.PARENT_ID
        //      FROM OneManyLazyChild t0 WHERE t0.PARENT_ID = ?
        //      ORDER BY t0.name ASC [params=(long) 252]
        //  SELECT t0.optLock, t0.name, t1.PARENT_ID, t1.id, t1.optLock, t1.name
        //      FROM OneManyEagerParent t0
        //      LEFT OUTER JOIN OneManyEagerChild t1 ON t0.id = t1.PARENT_ID
        //      WHERE t0.id = ?
        //      ORDER BY t1.PARENT_ID ASC, t1.name ASC [params=(long) 251]
        //  SELECT t0.id, t0.optLock, t0.name, t0.PARENT_ID
        //      FROM OneManyLazyChild t0 WHERE t0.PARENT_ID = ?
        //      ORDER BY t0.name ASC [params=(long) 251]

        assertEquals(4, sql.size());

        em.close();
    }

    public void testOneToManyEagerQuery() {
        sql.clear();

        OpenJPAEntityManager em = emf.createEntityManager();
        String query = "select p FROM OneManyEagerParent p";
        Query q = em.createQuery(query);
        List list = q.getResultList();
        assertEquals(2, list.size());

        // Expected SQLs:
        //   SELECT t0.id, t0.optLock, t0.name FROM OneManyEagerParent t0
        //   SELECT t0.id, t1.id, t1.optLock, t1.name FROM OneManyEagerParent t0
        //       INNER JOIN OneManyEagerChild t1 ON t0.id = t1.PARENT_ID
        //       ORDER BY t0.id ASC, t1.name ASC
        //   SELECT t0.id, t1.id, t1.optLock, t1.name, t1.PARENT_ID
        //       FROM OneManyEagerParent t0
        //       INNER JOIN OneManyLazyChild t1 ON t0.id = t1.PARENT_ID
        //       ORDER BY t0.id ASC, t1.name ASC

        assertEquals(3, sql.size());

        sql.clear();

        for (Object o : list) {
            OneManyEagerParent p = (OneManyEagerParent) o;
            long id = p.getId();
            assertEquals(2, p.getEagerChildren().size());
            assertEquals(p, p.getEagerChildren().get(0).getParent());
            assertEquals(p, p.getEagerChildren().get(1).getParent());
            assertEquals(id, p.getEagerChildren().get(0).getParent().getId());
            assertEquals(id, p.getEagerChildren().get(1).getParent().getId());
            assertEquals("eagerchild0", p.getEagerChildren().get(0).getName());
            assertEquals("eagerchild1", p.getEagerChildren().get(1).getName());
            assertEquals(2, p.getLazyChildren().size());
            assertEquals(p, p.getLazyChildren().get(0).getParent());
            assertEquals(p, p.getLazyChildren().get(1).getParent());
            assertEquals(id, p.getLazyChildren().get(0).getParent().getId());
            assertEquals(id, p.getLazyChildren().get(1).getParent().getId());
            assertEquals("lazychild0", p.getLazyChildren().get(0).getName());
            assertEquals("lazychild1", p.getLazyChildren().get(1).getName());
        }

        assertEquals(0, sql.size());
        em.close();
    }

    public void testOneToOneParentQuery() {
        sql.clear();

        OpenJPAEntityManager em = emf.createEntityManager();
        String query = "select p FROM OneOneParent p";
        Query q = em.createQuery(query);
        List list = q.getResultList();
        assertEquals(3, list.size());

        // Expected SQLs:
        //   SELECT t0.id, t0.optLock, t1.id, t1.optLock, t1.name, t0.name
        //   FROM OneOneParent t0
        //   LEFT OUTER JOIN OneOneChild t1 ON t0.id = t1.PARENT_ID

        assertEquals(1, sql.size());

        sql.clear();

        for (Object o : list) {
            OneOneParent p = (OneOneParent) o;
            assertEquals(p, p.getChild().getParent());
        }

        assertEquals(0, sql.size());
        em.close();
    }

    public void testOneToOneChildQuery() {
        sql.clear();

        OpenJPAEntityManager em = emf.createEntityManager();
        String query = "select c FROM OneOneChild c";
        Query q = em.createQuery(query);
        List list = q.getResultList();
        assertEquals(3, list.size());

        // Expected SQLs:
        //   SELECT t0.id, t0.optLock, t1.id, t1.optLock, t1.name, t0.name
        //   FROM OneOneParent t0
        //   LEFT OUTER JOIN OneOneChild t1 ON t0.id = t1.PARENT_ID

        assertEquals(1, sql.size());

        sql.clear();

        for (Object o : list) {
            OneOneChild c = (OneOneChild) o;
            assertEquals(c, c.getParent().getChild());
        }

        assertEquals(0, sql.size());
        em.close();
    }

    public static void main(String[] args) {
        TestRunner.run(TestManyEagerSQL.class);
    }
}