eu.trentorise.opendata.ckanalyze.managers.PersistencyManager.java Source code

Introduction

Here is the source code for eu.trentorise.opendata.ckanalyze.managers.PersistencyManager.java

Source

/**
* *****************************************************************************
* Copyright 2012-2013 Trento Rise (www.trentorise.eu/)
*
* All rights reserved. This program and the accompanying materials are made
* available under the terms of the GNU Lesser General Public License (LGPL)
* version 2.1 which accompanies this distribution, and is available at
*
* http://www.gnu.org/licenses/lgpl-2.1.html
*
* This library is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
* details.
*
*******************************************************************************
*/

package eu.trentorise.opendata.ckanalyze.managers;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;

import eu.trentorise.opendata.ckanalyze.jpa.Catalog;
import eu.trentorise.opendata.ckanalyze.jpa.CatalogStringDistribution;
import eu.trentorise.opendata.ckanalyze.jpa.Datatype;
import eu.trentorise.opendata.ckanalyze.jpa.ResourceDatatypesCount;
import eu.trentorise.opendata.ckanalyze.jpa.Resource;
import eu.trentorise.opendata.ckanalyze.jpa.ResourceStringDistribution;

/**
 * Provide access to the database
 * 
 * @author Alberto Zanella <a.zanella@trentorise.eu> Last modified by azanella
 *         On 12/lug/2013
 */
public final class PersistencyManager {
    private static SessionFactory sf = null;
    private static ServiceRegistry sr = null;

    private PersistencyManager() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * Obtain the instance of configured sessionFactory to perform Hibernate
     * query on DB
     * 
     * @return instance of sessionFactory
     */
    public static SessionFactory getSessionFactory() {
        if (sf == null) {
            sf = configure().buildSessionFactory(sr);

        }
        return sf;
    }

    /**
     * Configuration method, here you have to put your annotated class in order
     * to be processed from Hibernate
     * 
     * @return configuration instance
     */
    private static synchronized Configuration configure() {
        Configuration configuration = new Configuration();
        configuration.addAnnotatedClass(CatalogStringDistribution.class);
        configuration.addAnnotatedClass(ResourceStringDistribution.class);
        configuration.addAnnotatedClass(Catalog.class);
        configuration.addAnnotatedClass(Resource.class);
        configuration.addAnnotatedClass(Datatype.class);
        configuration.addAnnotatedClass(ResourceDatatypesCount.class);
        configuration.addAnnotatedClass(eu.trentorise.opendata.ckanalyze.jpa.Configuration.class);
        PluralNamingStrategy strategy = new PluralNamingStrategy();
        configuration.setNamingStrategy(strategy);
        configuration.configure();
        sr = new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildServiceRegistry();
        return configuration;
    }

    public static void insert(Object o) {
        Session ss = PersistencyManager.getSessionFactory().openSession();
        ss.beginTransaction();
        ss.persist(o);
        ss.getTransaction().commit();
        ss.close();
    }

    public static void update(Object o) {
        Session ss = PersistencyManager.getSessionFactory().openSession();
        ss.beginTransaction();
        ss.update(o);
        ss.getTransaction().commit();
        ss.close();
    }

    public static void insertInOneCommit(List<Object> os) {
        Session ss = PersistencyManager.getSessionFactory().openSession();
        ss.beginTransaction();
        for (Object object : os) {
            ss.persist(object);
        }
        ss.getTransaction().commit();
        ss.close();
    }

    public static Datatype getDatatypeByName(String name) {
        String hql = "FROM Datatype WHERE name = :name";
        Session ss = PersistencyManager.getSessionFactory().openSession();
        Query query = ss.createQuery(hql);
        query.setParameter("name", name);
        @SuppressWarnings("unchecked")
        List<Datatype> results = (List<Datatype>) query.list();
        if (results.isEmpty()) {
            ss.close();
            return null;
        } else {
            Datatype retval = results.get(0);
            ss.close();
            return retval;
        }
    }

}