*  Copyright 2006 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.

*/

* @author Jeff Butler

*

*/

    @Test

    public void testFieldsOnlyInsert() {

        FieldsonlyDAO dao = getFieldsonlyDAO();

        try {

            Fieldsonly record = new Fieldsonly();

            record.setDoublefield(11.22);

            record.setFloatfield(33.44);

            record.setIntegerfield(5);

            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();

            example.createCriteria().andIntegerfieldEqualTo(5);

            List<Fieldsonly> answer = dao.selectByExample(example);

            assertEquals(1, answer.size());

            Fieldsonly returnedRecord = answer.get(0);

            assertEquals(record.getIntegerfield(), returnedRecord

                    .getIntegerfield());

            assertEquals(record.getDoublefield(), returnedRecord

                    .getDoublefield());

            assertEquals(record.getFloatfield(), returnedRecord.getFloatfield());

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testFieldsOnlySelectByExample() {

        FieldsonlyDAO dao = getFieldsonlyDAO();

        try {

            Fieldsonly record = new Fieldsonly();

            record.setDoublefield(11.22);

            record.setFloatfield(33.44);

            record.setIntegerfield(5);

            dao.insert(record);

            record = new Fieldsonly();

            record.setDoublefield(44.55);

            record.setFloatfield(66.77);

            record.setIntegerfield(8);

            dao.insert(record);

            record = new Fieldsonly();

            record.setDoublefield(88.99);

            record.setFloatfield(100.111);

            record.setIntegerfield(9);

            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();

            example.createCriteria().andIntegerfieldGreaterThan(5);

            List<Fieldsonly> answer = dao.selectByExample(example);

            assertEquals(2, answer.size());

            example = new FieldsonlyExample();

            answer = dao.selectByExample(example);

            assertEquals(3, answer.size());

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testFieldsOnlySelectByExampleNoCriteria() {

        FieldsonlyDAO dao = getFieldsonlyDAO();

        try {

            Fieldsonly record = new Fieldsonly();

            record.setDoublefield(11.22);

            record.setFloatfield(33.44);

            record.setIntegerfield(5);

            dao.insert(record);

            record = new Fieldsonly();

            record.setDoublefield(44.55);

            record.setFloatfield(66.77);

            record.setIntegerfield(8);

            dao.insert(record);

            record = new Fieldsonly();

            record.setDoublefield(88.99);

            record.setFloatfield(100.111);

            record.setIntegerfield(9);

            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();

            example.createCriteria();

            List<Fieldsonly> answer = dao.selectByExample(example);

            assertEquals(3, answer.size());

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testFieldsOnlyDeleteByExample() {

        FieldsonlyDAO dao = getFieldsonlyDAO();

        try {

            Fieldsonly record = new Fieldsonly();

            record.setDoublefield(11.22);

            record.setFloatfield(33.44);

            record.setIntegerfield(5);

            dao.insert(record);

            record = new Fieldsonly();

            record.setDoublefield(44.55);

            record.setFloatfield(66.77);

            record.setIntegerfield(8);

            dao.insert(record);

            record = new Fieldsonly();

            record.setDoublefield(88.99);

            record.setFloatfield(100.111);

            record.setIntegerfield(9);

            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();

            example.createCriteria().andIntegerfieldGreaterThan(5);

            int rows = dao.deleteByExample(example);

            assertEquals(2, rows);

            example = new FieldsonlyExample();

            List<Fieldsonly> answer = dao.selectByExample(example);

            assertEquals(1, answer.size());

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testFieldsOnlyCountByExample() {

        FieldsonlyDAO dao = getFieldsonlyDAO();

        try {

            Fieldsonly record = new Fieldsonly();

            record.setDoublefield(11.22);

            record.setFloatfield(33.44);

            record.setIntegerfield(5);

            dao.insert(record);

            record = new Fieldsonly();

            record.setDoublefield(44.55);

            record.setFloatfield(66.77);

            record.setIntegerfield(8);

            dao.insert(record);

            record = new Fieldsonly();

            record.setDoublefield(88.99);

            record.setFloatfield(100.111);

            record.setIntegerfield(9);

            dao.insert(record);

            FieldsonlyExample example = new FieldsonlyExample();

            example.createCriteria().andIntegerfieldGreaterThan(5);

            int rows = dao.countByExample(example);

            assertEquals(2, rows);

            example.clear();

            rows = dao.countByExample(example);

            assertEquals(3, rows);

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testPKOnlyInsert() {

        PkonlyDAO dao = getPkonlyDAO();

        try {

            PkonlyKey key = new PkonlyKey();

            key.setId(1);

            key.setSeqNum(3);

            dao.insert(key);

            PkonlyExample example = new PkonlyExample();

            List<PkonlyKey> answer = dao.selectByExample(example);

            assertEquals(1, answer.size());

            PkonlyKey returnedRecord = answer.get(0);

            assertEquals(key.getId(), returnedRecord.getId());

            assertEquals(key.getSeqNum(), returnedRecord.getSeqNum());

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testPKOnlyDeleteByPrimaryKey() {

        PkonlyDAO dao = getPkonlyDAO();

        try {

            PkonlyKey key = new PkonlyKey();

            key.setId(1);

            key.setSeqNum(3);

            dao.insert(key);

            key = new PkonlyKey();

            key.setId(5);

            key.setSeqNum(6);

            dao.insert(key);

            PkonlyExample example = new PkonlyExample();

            List<PkonlyKey> answer = dao.selectByExample(example);

            assertEquals(2, answer.size());

            key = new PkonlyKey();

            key.setId(5);

            key.setSeqNum(6);

            int rows = dao.deleteByPrimaryKey(key);

            assertEquals(1, rows);

            answer = dao.selectByExample(example);

            assertEquals(1, answer.size());

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testPKOnlyDeleteByExample() {

        PkonlyDAO dao = getPkonlyDAO();

        try {

            PkonlyKey key = new PkonlyKey();

            key.setId(1);

            key.setSeqNum(3);

            dao.insert(key);

            key = new PkonlyKey();

            key.setId(5);

            key.setSeqNum(6);

            dao.insert(key);

            key = new PkonlyKey();

            key.setId(7);

            key.setSeqNum(8);

            dao.insert(key);

            PkonlyExample example = new PkonlyExample();

            example.createCriteria().andIdGreaterThan(4);

            int rows = dao.deleteByExample(example);

            assertEquals(2, rows);

            example = new PkonlyExample();

            List<PkonlyKey> answer = dao.selectByExample(example);

            assertEquals(1, answer.size());

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testPKOnlySelectByExample() {

        PkonlyDAO dao = getPkonlyDAO();

        try {

            PkonlyKey key = new PkonlyKey();

            key.setId(1);

            key.setSeqNum(3);

            dao.insert(key);

            key = new PkonlyKey();

            key.setId(5);

            key.setSeqNum(6);

            dao.insert(key);

            key = new PkonlyKey();

            key.setId(7);

            key.setSeqNum(8);

            dao.insert(key);

            PkonlyExample example = new PkonlyExample();

            example.createCriteria().andIdGreaterThan(4);

            List<PkonlyKey> answer = dao.selectByExample(example);

            assertEquals(2, answer.size());

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testPKOnlySelectByExampleNoCriteria() {

        PkonlyDAO dao = getPkonlyDAO();

        try {

            PkonlyKey key = new PkonlyKey();

            key.setId(1);

            key.setSeqNum(3);

            dao.insert(key);

            key = new PkonlyKey();

            key.setId(5);

            key.setSeqNum(6);

            dao.insert(key);

            key = new PkonlyKey();

            key.setId(7);

            key.setSeqNum(8);

            dao.insert(key);

            PkonlyExample example = new PkonlyExample();

            example.createCriteria();

            List<PkonlyKey> answer = dao.selectByExample(example);

            assertEquals(3, answer.size());

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testPKOnlyCountByExample() {

        PkonlyDAO dao = getPkonlyDAO();

        try {

            PkonlyKey key = new PkonlyKey();

            key.setId(1);

            key.setSeqNum(3);

            dao.insert(key);

            key = new PkonlyKey();

            key.setId(5);

            key.setSeqNum(6);

            dao.insert(key);

            key = new PkonlyKey();

            key.setId(7);

            key.setSeqNum(8);

            dao.insert(key);

            PkonlyExample example = new PkonlyExample();

            example.createCriteria().andIdGreaterThan(4);

            int rows = dao.countByExample(example);

            assertEquals(2, rows);

            example.clear();

            rows = dao.countByExample(example);

            assertEquals(3, rows);

        } catch (SQLException e) {

            fail(e.getMessage());

        }

    }

    @Test

    public void testPKFieldsInsert() throws SQLException {

        PkfieldsDAO dao = getPkfieldsDAO();

        Pkfields record = new Pkfields();

        record.setDatefield(new Date());

        record.setDecimal100field(10L);

        record.setDecimal155field(new BigDecimal("15.12345"));

        record.setDecimal30field((short) 3);

        record.setDecimal60field(6);

        record.setFirstname("Jeff");

        record.setId1(1);

        record.setId2(2);

        record.setLastname("Butler");

        record.setTimefield(new Date());

        record.setTimestampfield(new Date());

        dao.insert(record);

        PkfieldsKey key = new PkfieldsKey();

        key.setId1(1);

        key.setId2(2);

        Pkfields returnedRecord = dao.selectByPrimaryKey(key);

        assertNotNull(returnedRecord);

        assertTrue(datesAreEqual(record.getDatefield(), returnedRecord

                .getDatefield()));

        assertEquals(record.getDecimal100field(), returnedRecord

                .getDecimal100field());

        assertEquals(record.getDecimal155field(), returnedRecord

                .getDecimal155field());

        assertEquals(record.getDecimal30field(), returnedRecord

                .getDecimal30field());

        assertEquals(record.getDecimal60field(), returnedRecord

                .getDecimal60field());

        assertEquals(record.getFirstname(), returnedRecord.getFirstname());

        assertEquals(record.getId1(), returnedRecord.getId1());

        assertEquals(record.getId2(), returnedRecord.getId2());

        assertEquals(record.getLastname(), returnedRecord.getLastname());

        assertTrue(timesAreEqual(record.getTimefield(), returnedRecord

                .getTimefield()));

        assertEquals(record.getTimestampfield(), returnedRecord

                .getTimestampfield());

    }

    @Test

    public void testPKFieldsUpdateByPrimaryKey() {

        PkfieldsDAO dao = getPkfieldsDAO();

        try {

            Pkfields record = new Pkfields();

            record.setFirstname("Jeff");