|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectit.eng.spagobi.commons.dao.AbstractHibernateDAO
it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl
public class DataSetDAOImpl
Implement CRUD operations over spagobi datsets
Field Summary |
---|
Fields inherited from class it.eng.spagobi.commons.dao.AbstractHibernateDAO |
---|
TENANT_FILTER_NAME |
Constructor Summary | |
---|---|
DataSetDAOImpl()
|
Method Summary | |
---|---|
SbiDataSet |
copyDataSet(SbiDataSet hibDataSet)
copy a dataset |
java.lang.Integer |
countBIObjAssociated(java.lang.Integer dsId)
Counts number of BIObj associated. |
java.lang.Integer |
countDatasets()
Counts number of existent DataSets |
boolean |
deleteAllInactiveDataSetVersions(java.lang.Integer datasetId)
Delete all inactive versions of dataset whose id is equal to datasetId |
void |
deleteDataSet(java.lang.Integer datasetId)
Delete data set whose ID is equal to datasetId if it is not referenced by
some analytical documents. |
boolean |
deleteInactiveDataSetVersion(java.lang.Integer datasetVersionNum,
java.lang.Integer dsId)
Delete the dataset version whose id is equal to datasetVersionId if and
only if it is inactive. |
java.lang.Integer |
getHigherVersionNumForDS(java.lang.Integer dsId)
Returns the Higher Version Number of a selected DS |
boolean |
hasBIKpiAssociated(java.lang.String dsId)
Checks for bi kpi associated. |
boolean |
hasBILovAssociated(java.lang.String dsId)
Checks for bi lovs associated. |
boolean |
hasBIObjAssociated(java.lang.String dsId)
Checks for bi obj associated. |
java.lang.Integer |
insertDataSet(it.eng.spagobi.tools.dataset.bo.IDataSet 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 id)
|
java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> |
loadAllActiveDataSets()
|
java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> |
loadAllActiveDataSetsByOwner(java.lang.String owner)
Load all data set by owner. |
java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> |
loadAllActiveDataSetsByOwnerAndType(java.lang.String owner,
java.lang.String type)
Load all data set by owner. |
it.eng.spagobi.tools.dataset.bo.IDataSet |
loadDataSetById(java.lang.Integer id)
Load data set by id. |
it.eng.spagobi.tools.dataset.bo.IDataSet |
loadDataSetByLabel(java.lang.String label)
Load data set by id. |
it.eng.spagobi.tools.dataset.bo.IDataSet |
loadDataSetByOwner(java.lang.String owner)
Load data set by owner. |
java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> |
loadFilteredDatasetList(java.lang.String hsql,
java.lang.Integer offset,
java.lang.Integer fetchSize)
|
java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> |
loadFilteredDatasetList(java.lang.String hsql,
java.lang.Integer offset,
java.lang.Integer fetchSize,
java.lang.String owner)
|
java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> |
loadPagedDatasetList(java.lang.Integer offset,
java.lang.Integer fetchSize)
Returns List of all existent IDataSets with current active version |
java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> |
loadPagedDatasetList(java.lang.Integer offset,
java.lang.Integer fetchSize,
java.lang.String owner)
Returns List of all existent IDataSets with current active version for the owner |
java.util.List<SbiDataSet> |
loadPagedSbiDatasetConfigList(java.lang.Integer offset,
java.lang.Integer fetchSize)
Returns List of all existent SbiDataSet elements (NO DETAIL, only name, label, descr...). |
void |
modifyDataSet(it.eng.spagobi.tools.dataset.bo.IDataSet dataSet)
Modify data set. |
it.eng.spagobi.tools.dataset.bo.IDataSet |
restoreOlderDataSetVersion(java.lang.Integer dsId,
java.lang.Integer dsVersion)
Restore an Older Version of the dataset |
it.eng.spagobi.tools.dataset.bo.IDataSet |
toGuiGenericDataSet(it.eng.spagobi.tools.dataset.bo.IDataSet iDataSet)
Deprecated. |
Methods inherited from class it.eng.spagobi.commons.dao.AbstractHibernateDAO |
---|
commitIfActiveAndClose, disableTenantFilter, enableTenantFilter, getSession, getTenant, getUserProfile, logException, rollbackIfActiveAndClose, setTenant, 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, setTenant, setUserID, setUserProfile |
Constructor Detail |
---|
public DataSetDAOImpl()
Method Detail |
---|
public java.lang.Integer insertDataSet(it.eng.spagobi.tools.dataset.bo.IDataSet dataSet)
insertDataSet
in interface IDataSetDAO
dataSet
- the a data setit.eng.spagobi.tools.dataset.dao.IDataSetDAO#insertDataSet(it.eng.spagobi.tools.dataset.bo.AbstractDataSet)
public java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> loadAllActiveDataSets()
loadAllActiveDataSets
in interface IDataSetDAO
public java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> loadAllActiveDataSetsByOwner(java.lang.String owner)
loadAllActiveDataSetsByOwner
in interface IDataSetDAO
ower
- the owner
List#loadActiveDataSetByOwner(string)
public java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> loadAllActiveDataSetsByOwnerAndType(java.lang.String owner, java.lang.String type)
loadAllActiveDataSetsByOwnerAndType
in interface IDataSetDAO
ower
- the owner
List#loadActiveDataSetByOwner(string)
public it.eng.spagobi.tools.dataset.bo.IDataSet loadActiveDataSetByLabel(java.lang.String label)
loadActiveDataSetByLabel
in interface IDataSetDAO
label
- the label
it.eng.spagobi.tools.dataset.dao.IDataSetDAO#loadDataSetByLabel(string)
public it.eng.spagobi.tools.dataset.bo.IDataSet loadActiveIDataSetByID(java.lang.Integer id)
loadActiveIDataSetByID
in interface IDataSetDAO
public java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> loadFilteredDatasetList(java.lang.String hsql, java.lang.Integer offset, java.lang.Integer fetchSize)
loadFilteredDatasetList
in interface IDataSetDAO
public java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> loadFilteredDatasetList(java.lang.String hsql, java.lang.Integer offset, java.lang.Integer fetchSize, java.lang.String owner)
loadFilteredDatasetList
in interface IDataSetDAO
public java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> loadPagedDatasetList(java.lang.Integer offset, java.lang.Integer fetchSize)
loadPagedDatasetList
in interface IDataSetDAO
offset
- starting elementfetchSize
- number of elements to retrieve
it.eng.spago.error.EMFUserError
- the EMF user errorpublic java.util.List<it.eng.spagobi.tools.dataset.bo.IDataSet> loadPagedDatasetList(java.lang.Integer offset, java.lang.Integer fetchSize, java.lang.String owner)
loadPagedDatasetList
in interface IDataSetDAO
offset
- starting elementfetchSize
- number of elements to retrieve
it.eng.spago.error.EMFUserError
- the EMF user errorpublic it.eng.spagobi.tools.dataset.bo.IDataSet loadDataSetById(java.lang.Integer id)
loadDataSetById
in interface IDataSetDAO
dsID
- the ds id
it.eng.spago.error.EMFUserError
- the EMF user errorpublic it.eng.spagobi.tools.dataset.bo.IDataSet loadDataSetByLabel(java.lang.String label)
loadDataSetByLabel
in interface IDataSetDAO
label
- the ds label
it.eng.spago.error.EMFUserError
- the EMF user errorpublic it.eng.spagobi.tools.dataset.bo.IDataSet loadDataSetByOwner(java.lang.String owner)
loadDataSetByOwner
in interface IDataSetDAO
owner
- the ds owner
it.eng.spago.error.EMFUserError
- the EMF user errorpublic java.util.List<SbiDataSet> loadPagedSbiDatasetConfigList(java.lang.Integer offset, java.lang.Integer fetchSize)
loadPagedSbiDatasetConfigList
in interface IDataSetDAO
offset
- starting elementfetchSize
- number of elements to retrieve
it.eng.spago.error.EMFUserError
- the EMF user errorpublic java.lang.Integer countBIObjAssociated(java.lang.Integer dsId)
countBIObjAssociated
in interface IDataSetDAO
dsId
- the ds id
it.eng.spago.error.EMFUserError
- the EMF user errorpublic java.lang.Integer countDatasets()
countDatasets
in interface IDataSetDAO
it.eng.spago.error.EMFUserError
- the EMF user errorpublic boolean hasBIObjAssociated(java.lang.String dsId)
hasBIObjAssociated
in interface IDataSetDAO
dsId
- the ds id
it.eng.spago.error.EMFUserError
- the EMF user errorit.eng.spagobi.tools.dataSet.dao.IDataSetDAO#hasBIObjAssociated(java.lang.String)
public boolean hasBIKpiAssociated(java.lang.String dsId)
hasBIKpiAssociated
in interface IDataSetDAO
dsId
- the ds id
it.eng.spago.error.EMFUserError
- the EMF user errorit.eng.spagobi.tools.dataSet.dao.IDataSetDAO#hasBIObjAssociated(java.lang.String)
public boolean hasBILovAssociated(java.lang.String dsId)
hasBILovAssociated
in interface IDataSetDAO
dsId
- the ds id
it.eng.spago.error.EMFUserError
- the EMF user errorit.eng.spagobi.tools.dataSet.dao.IDataSetDAO#hasBIObjAssociated(java.lang.String)
public void modifyDataSet(it.eng.spagobi.tools.dataset.bo.IDataSet dataSet)
modifyDataSet
in interface IDataSetDAO
aDataSet
- the a data set
it.eng.spago.error.EMFUserError
- the EMF user errorit.eng.spagobi.tools.dataset.dao.IDataSetDAO#modifyDataSet(it.eng.spagobi.tools.dataset.bo.AbstractDataSet)
public java.lang.Integer getHigherVersionNumForDS(java.lang.Integer dsId)
getHigherVersionNumForDS
in interface IDataSetDAO
dsId
- the a data set ID
it.eng.spago.error.EMFUserError
- the EMF user errorpublic void deleteDataSet(java.lang.Integer datasetId)
datasetId
if it is not referenced by
some analytical documents.
deleteDataSet
in interface IDataSetDAO
datasetId
- the ID of the dataset to delete. Cannot be null.
SpagoBIDOAException
- if the dataset is referenced by at least one analytical documentpublic it.eng.spagobi.tools.dataset.bo.IDataSet restoreOlderDataSetVersion(java.lang.Integer dsId, java.lang.Integer dsVersion)
restoreOlderDataSetVersion
in interface IDataSetDAO
dsId
- the a data set IDdsVersion
- the a data set Version
it.eng.spago.error.EMFUserError
- the EMF user errorpublic boolean deleteInactiveDataSetVersion(java.lang.Integer datasetVersionNum, java.lang.Integer dsId)
datasetVersionId
if and
only if it is inactive.
deleteInactiveDataSetVersion
in interface IDataSetDAO
datasetVersionId
- the id of the version of the dataset to delete. Cannot be null.
datasetVersionId
is deleted from database.
false otherwise (the version does not exist or it exists but it is active).public boolean deleteAllInactiveDataSetVersions(java.lang.Integer datasetId)
datasetId
deleteAllInactiveDataSetVersions
in interface IDataSetDAO
datasetId
- the id of the of the dataset whose incative version must be deleted
datasetId
have
been succesfully deleted from database. false otherwise (i.e. the dtaset does not have any inactive versions)public it.eng.spagobi.tools.dataset.bo.IDataSet toGuiGenericDataSet(it.eng.spagobi.tools.dataset.bo.IDataSet iDataSet)
toGuiGenericDataSet
in interface IDataSetDAO
public SbiDataSet copyDataSet(SbiDataSet hibDataSet)
copyDataSet
in interface IDataSetDAO
hibDataSet
-
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |