org.springframework.jdbc.object.GenericSqlQueryTests.java Source code

Introduction

Here is the source code for org.springframework.jdbc.object.GenericSqlQueryTests.java

Source

/*
 * Copyright 2002-2008 the original author or authors.
 *
 * 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.
 */

package org.springframework.jdbc.object;

import static org.easymock.EasyMock.createMock;
import static org.easymock.EasyMock.expect;
import static org.easymock.EasyMock.expectLastCall;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.easymock.EasyMock;
import org.apache.commons.logging.LogFactory;
import org.junit.Test;
import org.junit.After;
import org.junit.Before;
import org.junit.runners.JUnit4;
import org.junit.runner.RunWith;

import org.springframework.jdbc.AbstractJdbcTests;
import org.springframework.jdbc.Customer;
import org.springframework.jdbc.datasource.TestDataSourceWrapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;

/**
 * @author Thomas Risberg
 */
@RunWith(JUnit4.class)
public class GenericSqlQueryTests extends AbstractJdbcTests {

    private static final String SELECT_ID_FORENAME_NAMED_PARAMETERS_PARSED = "select id, forename from custmr where id = ? and country = ?";

    private final boolean debugEnabled = LogFactory.getLog(JdbcTemplate.class).isDebugEnabled();

    private PreparedStatement mockPreparedStatement;
    private ResultSet mockResultSet;

    private BeanFactory bf;

    @Before
    public void setUp() throws Exception {
        super.setUp();
        mockPreparedStatement = createMock(PreparedStatement.class);
        mockResultSet = createMock(ResultSet.class);
        this.bf = new XmlBeanFactory(
                new ClassPathResource("org/springframework/jdbc/object/GenericSqlQueryTests-context.xml"));
        TestDataSourceWrapper testDataSource = (TestDataSourceWrapper) bf.getBean("dataSource");
        testDataSource.setTarget(mockDataSource);
    }

    @After
    public void tearDown() throws Exception {
        super.tearDown();
        if (shouldVerify()) {
            EasyMock.verify(mockPreparedStatement);
            EasyMock.verify(mockResultSet);
        }
    }

    protected void replay() {
        super.replay();
        EasyMock.replay(mockPreparedStatement);
        EasyMock.replay(mockResultSet);
    }

    @Test
    public void testPlaceHoldersCustomerQuery() throws SQLException {
        SqlQuery query = (SqlQuery) bf.getBean("queryWithPlaceHolders");
        testCustomerQuery(query, false);
    }

    @Test
    public void testNamedParameterCustomerQuery() throws SQLException {
        SqlQuery query = (SqlQuery) bf.getBean("queryWithNamedParameters");
        testCustomerQuery(query, true);
    }

    private void testCustomerQuery(SqlQuery query, boolean namedParameters) throws SQLException {
        expect(mockResultSet.next()).andReturn(true);
        expect(mockResultSet.getInt("id")).andReturn(1);
        expect(mockResultSet.getString("forename")).andReturn("rod");
        expect(mockResultSet.next()).andReturn(false);
        mockResultSet.close();
        expectLastCall();

        mockPreparedStatement.setObject(1, new Integer(1), Types.INTEGER);
        expectLastCall();
        mockPreparedStatement.setString(2, "UK");
        expectLastCall();
        expect(mockPreparedStatement.executeQuery()).andReturn(mockResultSet);
        if (debugEnabled) {
            expect(mockPreparedStatement.getWarnings()).andReturn(null);
        }
        mockPreparedStatement.close();
        expectLastCall();

        mockConnection.prepareStatement(SELECT_ID_FORENAME_NAMED_PARAMETERS_PARSED);
        ctrlConnection.setReturnValue(mockPreparedStatement);

        replay();

        List l;
        if (namedParameters) {
            Map<String, Object> params = new HashMap<String, Object>(2);
            params.put("id", new Integer(1));
            params.put("country", "UK");
            l = query.executeByNamedParam(params);
        } else {
            Object[] params = new Object[] { new Integer(1), "UK" };
            l = query.execute(params);
        }
        assertTrue("Customer was returned correctly", l.size() == 1);
        Customer cust = (Customer) l.get(0);
        assertTrue("Customer id was assigned correctly", cust.getId() == 1);
        assertTrue("Customer forename was assigned correctly", cust.getForename().equals("rod"));
    }

}