it.eng.spagobi.tools.dataset.dao
Class DataSetDAOImpl

java.lang.Object
  extended by it.eng.spagobi.commons.dao.AbstractHibernateDAO
      extended by it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl
All Implemented Interfaces:
ISpagoBIDao, IDataSetDAO

public class DataSetDAOImpl
extends AbstractHibernateDAO
implements IDataSetDAO


Field Summary
static java.lang.String FILE_DS_TYPE
           
static java.lang.String JCLASS_DS_TYPE
           
static java.lang.String JDBC_DS_TYPE
           
static java.lang.String QBE_DS_TYPE
           
static java.lang.String SCRIPT_DS_TYPE
           
static java.lang.String WS_DS_TYPE
           
 
Constructor Summary
DataSetDAOImpl()
           
 
Method Summary
 SbiDataSetHistory copyDataSetHistory(SbiDataSetHistory hibDataSet)
          copy a dataset history
 java.lang.Integer countBIObjAssociated(java.lang.Integer dsId)
          Counts number of BIObj associated.
 java.lang.Integer countDatasets()
          Counts number of existent DataSets
 void deleteAllInactiveDataSetVersions(java.lang.Integer dsID)
          Delete all inactive dataset versions.
 void deleteDataSet(java.lang.Integer dsID)
          Delete data set.
 boolean deleteInactiveDataSetVersion(java.lang.Integer dsVerionID)
          Delete the inactive dataset version.
 java.lang.Integer getHigherVersionNumForDS(java.lang.Integer dsId)
          Returns the Higher Version Number of a selected DS
 boolean hasBIObjAssociated(java.lang.String dsId)
          Checks for bi obj associated.
 java.lang.Integer insertDataSet(GuiGenericDataSet dataSet)
          Insert data set.
 it.eng.spagobi.tools.dataset.bo.IDataSet loadActiveDataSetByLabel(java.lang.String label)
          Load data set by label.
 it.eng.spagobi.tools.dataset.bo.IDataSet loadActiveIDataSetByID(java.lang.Integer dsId)
          Load data set by id.
 java.util.List loadAllActiveDataSets()
          Load all active data sets.
 GuiGenericDataSet loadDataSetById(java.lang.Integer dsId)
          Load data set by id.
 GuiGenericDataSet loadDataSetByLabel(java.lang.String dsLabel)
          Load data set by id.
 java.util.List<GuiGenericDataSet> loadFilteredDatasetList(java.lang.String hsql, java.lang.Integer offset, java.lang.Integer fetchSize)
           
 java.util.List<GuiGenericDataSet> loadPagedDatasetList(java.lang.Integer offset, java.lang.Integer fetchSize)
          Returns List of all existent IDataSets with current active version
 java.util.List<SbiDataSetConfig> loadPagedSbiDatasetConfigList(java.lang.Integer offset, java.lang.Integer fetchSize)
          Returns List of all existent SbiDataSetConfig elements (NO DETAIL, only name, label, descr...).
 void modifyDataSet(GuiGenericDataSet dataSet)
          Modify data set.
 GuiGenericDataSet restoreOlderDataSetVersion(java.lang.Integer dsId, java.lang.Integer dsVersion)
          Restore an Older Version of the dataset
 GuiGenericDataSet toDataSet(it.eng.spagobi.tools.dataset.bo.IDataSet iDataSet)
          From the IDataSet as input, return the corrispondent GuiGenericDataSet object.
 GuiGenericDataSet toDataSet(SbiDataSetHistory hibDataSet)
           
 GuiDataSetDetail toDataSetDetail(SbiDataSetHistory hibDataSet)
           
 it.eng.spagobi.tools.dataset.bo.IDataSet toIDataSet(SbiDataSetHistory hibDataSet)
          From the hibernate DataSet as input, gives the corrispondent DataSet object.
 
Methods inherited from class it.eng.spagobi.commons.dao.AbstractHibernateDAO
getSession, getUserProfile, logException, rollbackIfActiveAndClose, setUserID, setUserProfile, updateSbiCommonInfo4Insert, updateSbiCommonInfo4Update
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface it.eng.spagobi.commons.dao.ISpagoBIDao
getUserProfile, setUserID, setUserProfile
 

Field Detail

JDBC_DS_TYPE

public static final java.lang.String JDBC_DS_TYPE
See Also:
Constant Field Values

FILE_DS_TYPE

public static final java.lang.String FILE_DS_TYPE
See Also:
Constant Field Values

SCRIPT_DS_TYPE

public static final java.lang.String SCRIPT_DS_TYPE
See Also:
Constant Field Values

JCLASS_DS_TYPE

public static final java.lang.String JCLASS_DS_TYPE
See Also:
Constant Field Values

WS_DS_TYPE

public static final java.lang.String WS_DS_TYPE
See Also:
Constant Field Values

QBE_DS_TYPE

public static final java.lang.String QBE_DS_TYPE
See Also:
Constant Field Values
Constructor Detail

DataSetDAOImpl

public DataSetDAOImpl()
Method Detail

deleteDataSet

public void deleteDataSet(java.lang.Integer dsID)
                   throws it.eng.spago.error.EMFUserError
Delete data set.

Specified by:
deleteDataSet in interface IDataSetDAO
Parameters:
dsID - the a data set ID
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

deleteInactiveDataSetVersion

public boolean deleteInactiveDataSetVersion(java.lang.Integer dsVerionID)
                                     throws it.eng.spago.error.EMFUserError
Delete the inactive dataset version.

Specified by:
deleteInactiveDataSetVersion in interface IDataSetDAO
Parameters:
dsVerionID - the a data set version ID
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

deleteAllInactiveDataSetVersions

public void deleteAllInactiveDataSetVersions(java.lang.Integer dsID)
                                      throws it.eng.spago.error.EMFUserError
Delete all inactive dataset versions.

Specified by:
deleteAllInactiveDataSetVersions in interface IDataSetDAO
Parameters:
dsID - the a data set fo which all old versions need to eb deleted
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

insertDataSet

public java.lang.Integer insertDataSet(GuiGenericDataSet dataSet)
                                throws it.eng.spago.error.EMFUserError
Insert data set.

Specified by:
insertDataSet in interface IDataSetDAO
Parameters:
dataSet - the a data set
Throws:
it.eng.spago.error.EMFUserError - the EMF user error
See Also:
it.eng.spagobi.tools.dataset.dao.IDataSetDAO#insertDataSet(it.eng.spagobi.tools.dataset.bo.AbstractDataSet)

restoreOlderDataSetVersion

public GuiGenericDataSet restoreOlderDataSetVersion(java.lang.Integer dsId,
                                                    java.lang.Integer dsVersion)
                                             throws it.eng.spago.error.EMFUserError
Restore an Older Version of the dataset

Specified by:
restoreOlderDataSetVersion in interface IDataSetDAO
Parameters:
dsId - the a data set ID
dsVersion - the a data set Version
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

getHigherVersionNumForDS

public java.lang.Integer getHigherVersionNumForDS(java.lang.Integer dsId)
                                           throws it.eng.spago.error.EMFUserError
Returns the Higher Version Number of a selected DS

Specified by:
getHigherVersionNumForDS in interface IDataSetDAO
Parameters:
dsId - the a data set ID
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

modifyDataSet

public void modifyDataSet(GuiGenericDataSet dataSet)
                   throws it.eng.spago.error.EMFUserError
Modify data set.

Specified by:
modifyDataSet in interface IDataSetDAO
Parameters:
aDataSet - the a data set
Throws:
it.eng.spago.error.EMFUserError - the EMF user error
See Also:
it.eng.spagobi.tools.dataset.dao.IDataSetDAO#modifyDataSet(it.eng.spagobi.tools.dataset.bo.AbstractDataSet)

loadPagedSbiDatasetConfigList

public java.util.List<SbiDataSetConfig> loadPagedSbiDatasetConfigList(java.lang.Integer offset,
                                                                      java.lang.Integer fetchSize)
                                                               throws it.eng.spago.error.EMFUserError
Returns List of all existent SbiDataSetConfig elements (NO DETAIL, only name, label, descr...).

Specified by:
loadPagedSbiDatasetConfigList in interface IDataSetDAO
Parameters:
offset - starting element
fetchSize - number of elements to retrieve
Returns:
List of all existent SbiDataSetConfig
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

loadFilteredDatasetList

public java.util.List<GuiGenericDataSet> loadFilteredDatasetList(java.lang.String hsql,
                                                                 java.lang.Integer offset,
                                                                 java.lang.Integer fetchSize)
                                                          throws it.eng.spago.error.EMFUserError
Specified by:
loadFilteredDatasetList in interface IDataSetDAO
Throws:
it.eng.spago.error.EMFUserError

loadPagedDatasetList

public java.util.List<GuiGenericDataSet> loadPagedDatasetList(java.lang.Integer offset,
                                                              java.lang.Integer fetchSize)
                                                       throws it.eng.spago.error.EMFUserError
Returns List of all existent IDataSets with current active version

Specified by:
loadPagedDatasetList in interface IDataSetDAO
Parameters:
offset - starting element
fetchSize - number of elements to retrieve
Returns:
List of all existent IDataSets with current active version
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

toDataSet

public GuiGenericDataSet toDataSet(SbiDataSetHistory hibDataSet)
                            throws it.eng.spago.error.EMFUserError
Throws:
it.eng.spago.error.EMFUserError

toDataSetDetail

public GuiDataSetDetail toDataSetDetail(SbiDataSetHistory hibDataSet)
                                 throws it.eng.spago.error.EMFUserError
Throws:
it.eng.spago.error.EMFUserError

copyDataSetHistory

public SbiDataSetHistory copyDataSetHistory(SbiDataSetHistory hibDataSet)
                                     throws it.eng.spago.error.EMFUserError
copy a dataset history

Specified by:
copyDataSetHistory in interface IDataSetDAO
Parameters:
hibDataSet -
Returns:
Throws:
it.eng.spago.error.EMFUserError

toDataSet

public GuiGenericDataSet toDataSet(it.eng.spagobi.tools.dataset.bo.IDataSet iDataSet)
                            throws it.eng.spago.error.EMFUserError
From the IDataSet as input, return the corrispondent GuiGenericDataSet object.

Specified by:
toDataSet in interface IDataSetDAO
Parameters:
iDataSet - The IDataSet
Returns:
The corrispondent GuiGenericDataSet object
Throws:
it.eng.spago.error.EMFUserError

countBIObjAssociated

public java.lang.Integer countBIObjAssociated(java.lang.Integer dsId)
                                       throws it.eng.spago.error.EMFUserError
Counts number of BIObj associated.

Specified by:
countBIObjAssociated in interface IDataSetDAO
Parameters:
dsId - the ds id
Returns:
Integer, number of BIObj associated
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

countDatasets

public java.lang.Integer countDatasets()
                                throws it.eng.spago.error.EMFUserError
Counts number of existent DataSets

Specified by:
countDatasets in interface IDataSetDAO
Returns:
Integer, number of existent DataSets
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

hasBIObjAssociated

public boolean hasBIObjAssociated(java.lang.String dsId)
                           throws it.eng.spago.error.EMFUserError
Checks for bi obj associated.

Specified by:
hasBIObjAssociated in interface IDataSetDAO
Parameters:
dsId - the ds id
Returns:
true, if checks for bi obj associated
Throws:
it.eng.spago.error.EMFUserError - the EMF user error
See Also:
it.eng.spagobi.tools.dataSet.dao.IDataSetDAO#hasBIObjAssociated(java.lang.String)

loadDataSetById

public GuiGenericDataSet loadDataSetById(java.lang.Integer dsId)
                                  throws it.eng.spago.error.EMFUserError
Load data set by id.

Specified by:
loadDataSetById in interface IDataSetDAO
Parameters:
dsID - the ds id
Returns:
the data set as genericGuiDataset
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

loadDataSetByLabel

public GuiGenericDataSet loadDataSetByLabel(java.lang.String dsLabel)
                                     throws it.eng.spago.error.EMFUserError
Load data set by id.

Specified by:
loadDataSetByLabel in interface IDataSetDAO
Parameters:
dsLabel - the ds label
Returns:
the data set as genericGuiDataset
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

loadActiveIDataSetByID

public it.eng.spagobi.tools.dataset.bo.IDataSet loadActiveIDataSetByID(java.lang.Integer dsId)
                                                                throws it.eng.spago.error.EMFUserError
Load data set by id.

Specified by:
loadActiveIDataSetByID in interface IDataSetDAO
Parameters:
dsID - the ds id
Returns:
the data set
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

loadActiveDataSetByLabel

public it.eng.spagobi.tools.dataset.bo.IDataSet loadActiveDataSetByLabel(java.lang.String label)
                                                                  throws it.eng.spago.error.EMFUserError
Load data set by label.

Specified by:
loadActiveDataSetByLabel in interface IDataSetDAO
Parameters:
label - the label
Returns:
the data set
Throws:
it.eng.spago.error.EMFUserError - the EMF user error
See Also:
it.eng.spagobi.tools.dataset.dao.IDataSetDAO#loadDataSetByLabel(string)

loadAllActiveDataSets

public java.util.List loadAllActiveDataSets()
                                     throws it.eng.spago.error.EMFUserError
Load all active data sets.

Specified by:
loadAllActiveDataSets in interface IDataSetDAO
Returns:
the list
Throws:
it.eng.spago.error.EMFUserError - the EMF user error

toIDataSet

public it.eng.spagobi.tools.dataset.bo.IDataSet toIDataSet(SbiDataSetHistory hibDataSet)
                                                    throws it.eng.spago.error.EMFUserError
From the hibernate DataSet as input, gives the corrispondent DataSet object.

Specified by:
toIDataSet in interface IDataSetDAO
Parameters:
hibDataSet - The hybernate data set
Returns:
The corrispondent DataSet object
Throws:
it.eng.spago.error.EMFUserError