org.joda.time.contrib.hibernate.TestPersistentLocalTime.java Source code

Introduction

Here is the source code for org.joda.time.contrib.hibernate.TestPersistentLocalTime.java

Source

/*
 *  Copyright 2001-2012 Stephen Colebourne
 *
 *  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.joda.time.contrib.hibernate;

import java.io.File;
import java.sql.Connection;
import java.sql.SQLException;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.jdbc.Work;
import org.joda.time.LocalTime;

public class TestPersistentLocalTime extends HibernateTestCase {
    private LocalTime[] writeReadTimes = new LocalTime[] { new LocalTime(14, 2, 25), new LocalTime(23, 59, 59, 999),
            new LocalTime(0, 0, 0), new LocalTime(12, 02, 15) };

    public void testSimpleStore() throws SQLException {
        SessionFactory factory = getSessionFactory();

        Session session = factory.openSession();

        for (int i = 0; i < writeReadTimes.length; i++) {
            LocalTime writeReadTime = writeReadTimes[i];

            Event event = new Event();
            event.setId(i);
            event.setLocalTime(writeReadTime);
            event.setLocalTime2(writeReadTime);
            event.setLocalTime3(writeReadTime);
            event.setLocalTime4(writeReadTime);

            session.save(event);
        }

        session.flush();
        session.doWork(new Work() {
            public void execute(Connection connection) throws SQLException {
                connection.commit();
            }
        });
        session.close();

        for (int i = 0; i < writeReadTimes.length; i++) {
            LocalTime writeReadTime = writeReadTimes[i];

            session = factory.openSession();
            Event eventReread = (Event) session.get(Event.class, new Integer(i));

            assertNotNull("get failed - event#'" + i + "'not found", eventReread);
            assertNotNull("get failed - returned null", eventReread.getLocalTime());
            assertNotNull("get failed - returned null", eventReread.getLocalTime2());
            assertNotNull("get failed - returned null", eventReread.getLocalTime3());
            assertNotNull("get failed - returned null", eventReread.getLocalTime4());

            // we might loose the millis, depends on database
            assertEquals("get failed - returned different time (TIME)", writeReadTime.getMillisOfDay() / 1000,
                    eventReread.getLocalTime().getMillisOfDay() / 1000);

            assertEquals("get failed - returned different time (INT)", writeReadTime.getMillisOfDay(),
                    eventReread.getLocalTime2().getMillisOfDay());

            assertEquals("get failed - returned different time (STRING)", writeReadTime.getMillisOfDay(),
                    eventReread.getLocalTime3().getMillisOfDay());

            assertEquals("get failed - returned different time (TIMESTAMP)", writeReadTime.getMillisOfDay(),
                    eventReread.getLocalTime4().getMillisOfDay());

            session.close();
        }
    }

    protected void setupConfiguration(Configuration cfg) {
        cfg.addFile(new File("src/test/java/org/joda/time/contrib/hibernate/event.hbm.xml"));
        cfg.addFile(new File("src/test/java/org/joda/time/contrib/hibernate/eventTZ.hbm.xml"));
    }
}