SpagoBI - The Business Intelligence Free Platform

Copyright (C) 2005-2008 Engineering Ingegneria Informatica S.p.A.

This library is free software; you can redistribute it and/or

modify it under the terms of the GNU Lesser General Public

License as published by the Free Software Foundation; either

version 2.1 of the License, or (at your option) any later version.

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.

You should have received a copy of the GNU Lesser General Public

License along with this library; if not, write to the Free Software

Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA

**/

* Implements methods to insert exported metadata into the exported database

*/

  static private Logger logger = Logger.getLogger(ExporterMetadata.class);

  private List biObjectToInsert=null;

  // list of ids of models that have an attribute with value filled.

  List modelsWithAttributeValued = null;

  /**

   * Insert a domain into the exported database.

   *

   * @param domain Domain object to export

   * @param session Hibernate session for the exported database

   *

   * @throws EMFUserError the EMF user error

   */

  public void insertDomain(Domain domain, Session session) throws EMFUserError {

    logger.debug("IN");

    try {

      Transaction tx = session.beginTransaction();

      Query hibQuery = session.createQuery(" from SbiDomains where valueId = " + domain.getValueId());

      List hibList = hibQuery.list();

      if(!hibList.isEmpty()) {

        return;

      }

      SbiDomains hibDomain = new SbiDomains(domain.getValueId());

      hibDomain.setDomainCd(domain.getDomainCode());

      hibDomain.setDomainNm(domain.getDomainName());

      hibDomain.setValueCd(domain.getValueCd());

      hibDomain.setValueDs(domain.getValueDescription());

      hibDomain.setValueNm(domain.getValueName());

      session.save(hibDomain);

      tx.commit();

    } catch (Exception e) {

      logger.error("Error while inserting domain into export database ",e);

      throw new EMFUserError(EMFErrorSeverity.ERROR, "8005", "component_impexp_messages");

    }finally{

      logger.debug("OUT");

    } 

  }

  /**

   * Insert a Object Metadata Category into the exported database.

   *

   * @param objMetadata ObjMetadata object to export

   * @param session Hibernate session for the exported database

   *

   * @throws EMFUserError the EMF user error

   */

  public void insertObjMetadata(ObjMetadata objMetadata, Session session) throws EMFUserError {

    logger.debug("IN");

    try {

      Transaction tx = session.beginTransaction();

      Query hibQuery = session.createQuery(" from SbiObjMetadata where objMetaId = " + objMetadata.getObjMetaId());

      List hibList = hibQuery.list();

      if(!hibList.isEmpty()) {

        return;

      }

      SbiObjMetadata hibObjMeta = new SbiObjMetadata();

      hibObjMeta.setObjMetaId(objMetadata.getObjMetaId());

      hibObjMeta.setCreationDate(objMetadata.getCreationDate());

      hibObjMeta.setDescription(objMetadata.getDescription());

      hibObjMeta.setLabel(objMetadata.getLabel());

      hibObjMeta.setName(objMetadata.getName());

      if(objMetadata.getDataType() != null){

        SbiDomains dataType=(SbiDomains)session.load(SbiDomains.class, objMetadata.getDataType());

        hibObjMeta.setDataType(dataType);

      }

      session.save(hibObjMeta);

      tx.commit();

    } catch (Exception e) {

      logger.error("Error while inserting objMetadata into export database ",e);

      throw new EMFUserError(EMFErrorSeverity.ERROR, "8005", "component_impexp_messages");

    }finally{

      logger.debug("OUT");

    } 

  }

  /**

   * Insert a Object Metadata Content into the exported database.

   *

   * @param objMetadataContent ObjMetadataContent object to export

   * @param session Hibernate session for the exported database

   *

   * @throws EMFUserError the EMF user error

   */

  public void insertObjMetacontent(ObjMetacontent objMetacontent, Session session) throws EMFUserError {

    logger.debug("IN");

    try {

      Query hibQuery = session.createQuery(" from SbiObjMetacontents where objMetacontentId = " + objMetacontent.getObjMetacontentId());

      List hibList = hibQuery.list();

      if(!hibList.isEmpty()) {

        return;

      }

      // first of all insert binary content

      if (objMetacontent.getBinaryContentId() != null) {

        // get the content     

        IBinContentDAO binContentDAO = DAOFactory.getBinContentDAO();

        byte[] content = binContentDAO.getBinContent(objMetacontent.getBinaryContentId());

        insertBinContet(objMetacontent.getBinaryContentId(), content, session);

      }

      Transaction tx = session.beginTransaction();

      SbiObjMetacontents hibObjMetacontents = new SbiObjMetacontents();

      hibObjMetacontents.setObjMetacontentId(objMetacontent.getObjMetacontentId());

      hibObjMetacontents.setCreationDate(objMetacontent.getCreationDate());

      hibObjMetacontents.setLastChangeDate(objMetacontent.getLastChangeDate());

      hibObjMetacontents.setObjmetaId(objMetacontent.getObjmetaId());

      // get the object to insert if present

      if (objMetacontent.getBiobjId() != null) {

        SbiObjects sbiObjects = (SbiObjects) session.load(SbiObjects.class, objMetacontent.getBiobjId());

        hibObjMetacontents.setSbiObjects(sbiObjects);

        logger.debug("inserted sbi " + objMetacontent.getBiobjId() + " Object metacontent");

      }

      // get the sub object to insert if present

      if (objMetacontent.getSubobjId() != null) {

        SbiSubObjects sbiSubObjects = (SbiSubObjects) session.load(SbiSubObjects.class, objMetacontent.getSubobjId());

        hibObjMetacontents.setSbiSubObjects(sbiSubObjects);

        logger.debug("inserted sbi " + objMetacontent.getSubobjId() + " SubObject metacontent");

      }

      // get the content

      if (objMetacontent.getBinaryContentId() != null) {

        SbiBinContents sbiBinContents = (SbiBinContents) session.load(SbiBinContents.class, objMetacontent.getBinaryContentId());

        hibObjMetacontents.setSbiBinContents(sbiBinContents);

        // insert the binary content!!       

        logger.debug("inserted sbi " + objMetacontent.getBinaryContentId() + " Binary Content metacontent");

      }

      session.save(hibObjMetacontents);

      tx.commit();

    } catch (Exception e) {

      logger.error("Error while inserting objMetadataContent into export database ",e);

      throw new EMFUserError(EMFErrorSeverity.ERROR, "8005", "component_impexp_messages");

    }finally{

      logger.debug("OUT");

    } 

  }

  /**

   * Insert data source.

   *

   * @param ds the ds

   * @param session the session

   *

   * @throws EMFUserError the EMF user error

   */

  public void insertDataSource(IDataSource ds, Session session) throws EMFUserError {

    logger.debug("IN");

    try {

      Transaction tx = session.beginTransaction();

      Query hibQuery = session.createQuery(" from SbiDataSource where dsId = " + ds.getDsId());

      List hibList = hibQuery.list();

      if(!hibList.isEmpty()) {

        return;

      }

      SbiDomains dialect=(SbiDomains)session.load(SbiDomains.class, ds.getDialectId());

      SbiDataSource hibDS = new SbiDataSource(ds.getDsId());

      hibDS.setDescr(ds.getDescr());

      hibDS.setDriver(ds.getDriver());

      hibDS.setJndi(ds.getJndi());

      hibDS.setLabel(ds.getLabel());

      hibDS.setPwd(ds.getPwd());

      hibDS.setUrl_connection(ds.getUrlConnection());

      hibDS.setUser(ds.getUser());

      hibDS.setDialect(dialect);

      hibDS.setSchemaAttribute(ds.getSchemaAttribute());

      hibDS.setMultiSchema(ds.getMultiSchema());   

      // va aggiunto il legame con gli engine e il doc ????

      session.save(hibDS);

      tx.commit();

    } catch (Exception e) {

      logger.error("Error while inserting dataSource into export database " , e);

      throw new EMFUserError(EMFErrorSeverity.ERROR, "8005", "component_impexp_messages");

    }finally{

      logger.debug("OUT");

    }

  }

  /**

   * Insert data set if not already present

   * @param dataSet the a data set

   * @throws EMFUserError the EMF user error

   * @see it.eng.spagobi.tools.dataset.dao.IDataSetDAO#insertDataSet(it.eng.spagobi.tools.dataset.bo.AbstractDataSet)

   */

  public void insertDataSet(GuiGenericDataSet dataSet, Session session) throws EMFUserError {

    logger.debug("IN");

    Transaction tx = null;

    Transaction tx2 = null;

    Transaction tx3 = null;

   

    try {

      // check if it's not already present a dataset with id  dataSet.getDsId

      Query hibQuery = session.createQuery(" from SbiDataSetConfig where dsId = " + dataSet.getDsId());

      List hibList = hibQuery.list();

      if(!hibList.isEmpty()) {

          logger.debug("dataset with id "+dataSet.getDsId()+" already inserted");

        return;

      }

     

      SbiDataSetHistory hibDataSetHistory =null;

      if(dataSet!=null){

        // get active dataset

        GuiDataSetDetail dataSetActiveDetail = dataSet.getActiveDetail();

        if(dataSetActiveDetail instanceof FileDataSetDetail){

          hibDataSetHistory=new SbiFileDataSet();

          if(((FileDataSetDetail)dataSetActiveDetail).getFileName()!=null){

            ((SbiFileDataSet)hibDataSetHistory).setFileName(((FileDataSetDetail)dataSetActiveDetail).getFileName());

          }

        } 

        else if(dataSetActiveDetail instanceof QueryDataSetDetail){

          hibDataSetHistory=new SbiQueryDataSet();

          if(((QueryDataSetDetail)dataSetActiveDetail).getQuery()!=null){

            ((SbiQueryDataSet)hibDataSetHistory).setQuery(((QueryDataSetDetail)dataSetActiveDetail).getQuery().toString());

          }

          if(((QueryDataSetDetail)dataSetActiveDetail).getDataSourceLabel()!=null){

            SbiDataSource hibDataSource = null;

            String dataSourceLabel = ((QueryDataSetDetail)dataSetActiveDetail).getDataSourceLabel();

            if(dataSourceLabel!=null && !dataSourceLabel.equals("")){

              IDataSourceDAO dataSourceDao = DAOFactory.getDataSourceDAO();

              IDataSource ds = dataSourceDao.loadDataSourceByLabel(dataSourceLabel);

              insertDataSource(ds, session);       

              Criterion labelCriterrion = Expression.eq("label", dataSourceLabel);

              Criteria criteria = session.createCriteria(SbiDataSource.class);

              criteria.add(labelCriterrion); 

              hibDataSource = (SbiDataSource) criteria.uniqueResult();

              ((SbiQueryDataSet)hibDataSetHistory).setDataSource(hibDataSource); 

            }