org.etudes.component.app.melete.MeleteLicenseDB.java Source code

Introduction

Here is the source code for org.etudes.component.app.melete.MeleteLicenseDB.java

Source

/**********************************************************************************
 *
 * $URL: https://source.sakaiproject.org/contrib/etudes/melete/tags/2.8.2/melete-impl/src/java/org/etudes/component/app/melete/MeleteLicenseDB.java $
 * $Id: MeleteLicenseDB.java 56408 2008-12-19 21:16:52Z rashmi@etudes.org $
 ***********************************************************************************
 *
 * Copyright (c) 2008 Etudes, Inc.
 *
 * Portions completed before September 1, 2008 Copyright (c) 2004, 2005, 2006, 2007, 2008 Foothill College, ETUDES Project
 *
 * 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.etudes.component.app.melete;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import org.hibernate.Hibernate;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Restrictions;

public class MeleteLicenseDB implements Serializable {
    ArrayList licenseTypes;
    private HibernateUtil hibernateUtil;
    private Log logger = LogFactory.getLog(MeleteLicenseDB.class);

    public MeleteLicenseDB() {
    }

    public ArrayList getLicenseTypes() {
        List licenseTypes = new ArrayList();
        try {
            Session session = getHibernateUtil().currentSession();
            StringBuffer query = new StringBuffer();
            query.append("from MeleteLicense");
            licenseTypes = session.createQuery(query.toString()).list();
            getHibernateUtil().closeSession();
        } catch (HibernateException he) {
            logger.error(he.toString());
        }

        return (ArrayList) licenseTypes;
    }

    /**
     * fetches ccLicense
     * @return
     */
    public List getCcLicense() {

        List ccLicenceList = new ArrayList();
        try {
            Session session = getHibernateUtil().currentSession();

            StringBuffer query = new StringBuffer();
            query.append("from CcLicense");
            ccLicenceList = session.createQuery(query.toString()).list();
            getHibernateUtil().closeSession();
        } catch (HibernateException he) {
            logger.error(this + he.toString());
        }

        return ccLicenceList;
    }

    public void createCcLicense(ArrayList ccLicenses) {
        saveData(ccLicenses);
    }

    /**
     * creates ModuleLicense
     *
     * @param moduleLicense -
     *            ModuleLicense
     */
    public void createMeleteLicense(ArrayList moduleLicenses) {
        saveData(moduleLicenses);

    }

    /**
     * @param obj
     */
    private void saveData(ArrayList objs) {
        Transaction tx = null;
        try {
            Session session = hibernateUtil.currentSession();

            tx = session.beginTransaction();
            for (int i = 0; i < objs.size(); i++) {
                Object obj = objs.get(i);
                session.save(obj);
            }
            tx.commit();
        } catch (HibernateException he) {
            try {
                if (tx != null)
                    tx.rollback();
            } catch (HibernateException e) {
                logger.error(e.toString());
            }
            logger.error(he.toString());
        } finally {
            try {
                hibernateUtil.closeSession();
            } catch (HibernateException e) {
                logger.error(e.toString());
            }
        }
    }

    /**
     * called from backing bean addModulePage to get the license url and license name
     * @param reqAttr
     * @param allowCmrcl
     * @param allowMod
     * @return
     */
    public String[] fetchCcLicenseURL(Boolean reqAttr, Boolean allowCmrcl, Integer allowMod) {
        String[] licenseInfo = new String[2];
        try {

            Session session = getHibernateUtil().currentSession();
            CcLicense Cc = (CcLicense) session.createCriteria(CcLicense.class)
                    .add(Restrictions.sqlRestriction("req_attr=?", reqAttr, Hibernate.BOOLEAN))
                    .add(Restrictions.sqlRestriction("allow_Cmrcl=?", allowCmrcl, Hibernate.BOOLEAN))
                    .add(Restrictions.sqlRestriction("allow_Mod=?", allowMod, Hibernate.INTEGER)).list().get(0);
            licenseInfo[0] = Cc.getUrl();
            licenseInfo[1] = Cc.getName();
            getHibernateUtil().closeSession();
        } catch (Exception ex) {
            //ex.printStackTrace();
            logger.error(ex.toString());
        }
        return licenseInfo;
    }

    //    add by rashmi to fetch license name for export
    public String fetchCcLicenseName(String licenseUrl) {
        String licenseInfo = null;
        try {
            logger.debug("MeleteLicenseDB:fetchCcLicenseName");
            Session session = getHibernateUtil().currentSession();
            Query q = session.createQuery("select ccl.name from CcLicense ccl where ccl.url =:url");
            q.setParameter("url", licenseUrl);
            licenseInfo = (String) q.uniqueResult();
            getHibernateUtil().closeSession();
        } catch (Exception ex) {
            //ex.printStackTrace();
            logger.error(ex.toString());
        }
        return licenseInfo;
    }

    //    add by rashmi
    public CcLicense fetchCcLicenseUrl(String name) {
        CcLicense licenseInfo = null;
        try {
            logger.debug("MeleteLicenseDB:fetchCcLicenseUrl " + name);
            Session session = getHibernateUtil().currentSession();
            Query q = session.createQuery("from CcLicense ccl1 where ccl1.name =:name");
            q.setParameter("name", name);
            licenseInfo = (CcLicense) q.uniqueResult();
            getHibernateUtil().closeSession();
        } catch (Exception ex) {
            //ex.printStackTrace();
            logger.error(ex.toString());
        }
        return licenseInfo;
    }

    /**
     * @return Returns the hibernateUtil.
     */
    public HibernateUtil getHibernateUtil() {
        return hibernateUtil;
    }

    /**
     * @param hibernateUtil The hibernateUtil to set.
     */
    public void setHibernateUtil(HibernateUtil hibernateUtil) {
        this.hibernateUtil = hibernateUtil;
    }

}