it.jrc.smart.fire.job.TestHibernateSessionManager.java Source code

Introduction

Here is the source code for it.jrc.smart.fire.job.TestHibernateSessionManager.java

Source

/*
 * Copyright (C) 2012 Wildlife Conservation Society
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy of
 * this software and associated documentation files (the "Software"), to deal in
 * the Software without restriction, including without limitation the rights to
 * use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies
 * of the Software, and to permit persons to whom the Software is furnished to do
 * so, subject to the following conditions:
 * 
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 * 
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE.
 */
package it.jrc.smart.fire.job;

import java.net.URL;
import java.text.DecimalFormat;
import java.text.NumberFormat;
import java.util.Calendar;
import java.util.List;

import net.sf.ehcache.config.CacheConfiguration;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.engine.spi.SessionFactoryImplementor;
import org.wcs.smart.ca.Agency;
import org.wcs.smart.ca.Area;
import org.wcs.smart.ca.ConservationArea;
import org.wcs.smart.ca.Employee;
import org.wcs.smart.ca.Label;
import org.wcs.smart.ca.Language;
import org.wcs.smart.ca.Rank;
import org.wcs.smart.ca.datamodel.Aggregation;
import org.wcs.smart.ca.datamodel.Attribute;
import org.wcs.smart.ca.datamodel.AttributeListItem;
import org.wcs.smart.ca.datamodel.AttributeTreeNode;
import org.wcs.smart.ca.datamodel.Category;
import org.wcs.smart.ca.datamodel.CategoryAttribute;
import org.wcs.smart.ca.datamodel.DmObject;

/**
 * All this to make the session manager instantiable from tests
 */
public class TestHibernateSessionManager {

    private static SessionFactory sessionFactory = null;

    private static final void createSessionFactory() {

        if (sessionFactory == null) {
            URL resource = Thread.currentThread().getContextClassLoader().getResource("hibernate.cfg.xml");
            Configuration config = new Configuration().configure(resource);

            config.setProperty("hibernate.connection.username", "smart_admin");
            config.setProperty("hibernate.connection.password", "smart_derby");

            //add mapping classes

            CacheConfiguration c;

            config.addAnnotatedClass(ConservationArea.class);
            config.addAnnotatedClass(Area.class);
            config.addAnnotatedClass(Language.class);
            config.addAnnotatedClass(Employee.class);
            config.addAnnotatedClass(Rank.class);
            config.addAnnotatedClass(Agency.class);
            config.addAnnotatedClass(Label.class);
            config.addAnnotatedClass(DmObject.class);
            config.addAnnotatedClass(Category.class);
            config.addAnnotatedClass(Attribute.class);
            config.addAnnotatedClass(CategoryAttribute.class);
            config.addAnnotatedClass(Aggregation.class);
            config.addAnnotatedClass(AttributeListItem.class);
            config.addAnnotatedClass(AttributeTreeNode.class);

            config.addAnnotatedClass(org.wcs.smart.ca.Projection.class);

            config.addAnnotatedClass(org.wcs.smart.observation.model.WaypointObservation.class);
            config.addAnnotatedClass(org.wcs.smart.observation.model.Waypoint.class);
            config.addAnnotatedClass(org.wcs.smart.observation.model.WaypointObservationAttribute.class);
            config.addAnnotatedClass(org.wcs.smart.observation.model.ObservationAttachment.class);
            config.addAnnotatedClass(org.wcs.smart.observation.model.WaypointAttachment.class);
            config.addAnnotatedClass(org.wcs.smart.observation.model.ObservationOptions.class);

            sessionFactory = config.buildSessionFactory();

            if (!((SessionFactoryImplementor) sessionFactory).getDialect().supportsSequences()) {
                //fail
                throw new IllegalStateException("You can't use this database - it does not support sequences");
            }
        }
    }

    /** Copied from HibernateManager **/
    private static NumberFormat ID_FORMATTER = new DecimalFormat("00000");

    public static void generateEmployeeId(Employee e, Session session) {

        Calendar c = Calendar.getInstance();
        c.setTime(e.getBirthDate());
        int year = c.get(Calendar.YEAR);

        String query = (((SessionFactoryImplementor) sessionFactory).getDialect()
                .getSequenceNextValString("smart.smart_user_id_seq"));
        List results = session.createSQLQuery(query).list();
        e.setId(year + "" + ID_FORMATTER.format(results.get(0)));
    }

    /**
     * Users are required to close the session when they are done with it.
     * @return
     */
    public static Session openSession() {
        if (sessionFactory == null) {
            createSessionFactory();
        }
        return sessionFactory.openSession();
    }
}