com.fatwire.assetapi.query

Class AssetStatisticsStorage

java.lang.Object

com.fatwire.assetapi.query.AssetStatisticsStorage

@Exported
public class AssetStatisticsStorage
extends Object

The handler class for Asset statistics storage

Field Summary

Fields

Modifier and Type	Field and Description
static String	_ACTION_
static String	_ASSETID_
static String	_ASSETTYPE_
static String	_ASSIGNEE_
static String	_COMMENTS_
static String	_EDITOR_
static String	_SITE_
static String	_UPDATEDDATE_
protected String	selectSQL
static String	storageTable
protected static String	SystemInfo
protected String	tableExistSQL

Constructor Summary

Constructors

Constructor and Description
AssetStatisticsStorage(ICS ics)

Method Summary

Modifier and Type	Method and Description
protected void	callCatalogManager(FTValList lst)
void	clear()
protected void	createTbl()
void	deinstall() delete the storage table
protected void	deleteTbl()
protected void	enterReadLock()
protected void	enterWriteLock()
List<AssetStatistics>	getAssetStatistics(AssetId assetId, String siteName)
int	getContributionCounts(Date from, Date end, String assettype, String siteName)
Map<String,Integer>	getTopAssetsCount(Date from, Date end, String siteName, boolean contentAssetOnly)
Map<String,Integer>	getTopSearches(Date from, Date end, String siteName, boolean contentAssetOnly)
void	install() create the storage table for asset statistics and the indexes
protected boolean	isTableExist()
protected void	leaveReadLock()
protected void	leaveWriteLock()
IList	query(Date from, Date end, List<AssetStatisticsAction> actions, String userField, String username, String siteName, String what, String sqlEnd, boolean contentAssetOnly)
void	save(List<com.openmarket.basic.event.AssetStatisticsItem> statics)
List<AssetId>	selectCheckedOutAsset(Date from, Date end, String siteName) select a list of assets that was checked out for a given period of time, in the given site
int	selectCountContributedAsset(Date from, Date end, String username, String site, boolean contentAssetOnly)
int	selectCountCreatedAsset(Date from, Date end, String author, String siteName, boolean contentAssetOnly)
int	selectCountEditedAsset(Date from, Date end, String editor, String siteName, boolean contentAssetOnly) select the count of edited assets for a given period of time, by the given user in the given site
List<AssetId>	selectCreatedAsset(Date from, Date end, String author, String siteName, boolean contentAssetOnly) select a list of assets that was created for a given period of time, by the given user in the given site
List<AssetId>	selectEditedAsset(Date from, Date end, String editor, String siteName, boolean contentAssetOnly) select a list of edited assets for a given period of time, by the given user in the given site
Map<String,Integer>	selectTopContributions(Date from, Date end, String siteName, boolean contentAssetOnly)
Map<String,Integer>	selectTopCreates(Date from, Date end, String siteName, boolean contentAssetOnly)
Map<String,Integer>	selectTopEdits(Date from, Date end, String siteName, boolean contentAssetOnly)
List<AssetId>	selectWorkflowAsset(Date from, Date end, String assignee, String siteName, boolean contentAssetOnly) select a list of assets that was put into workflow for a given period of time, by the given user in the given site

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

storageTable

public static final String storageTable

See Also:

Constant Field Values

SystemInfo

protected static final String SystemInfo

See Also:

Constant Field Values

selectSQL

protected String selectSQL

tableExistSQL

protected String tableExistSQL

_ASSETTYPE_

public static final String _ASSETTYPE_

See Also:

Constant Field Values

_ASSETID_

public static final String _ASSETID_

See Also:

Constant Field Values

_SITE_

public static final String _SITE_

See Also:

Constant Field Values

_EDITOR_

public static final String _EDITOR_

See Also:

Constant Field Values

_UPDATEDDATE_

public static final String _UPDATEDDATE_

See Also:

Constant Field Values

_ASSIGNEE_

public static final String _ASSIGNEE_

See Also:

Constant Field Values

_COMMENTS_

public static final String _COMMENTS_

See Also:

Constant Field Values

_ACTION_

public static final String _ACTION_

See Also:

Constant Field Values

Constructor Detail

AssetStatisticsStorage

public AssetStatisticsStorage(ICS ics)

Method Detail

install

public void install()
             throws Exception

create the storage table for asset statistics and the indexes

Throws:

Exception

deinstall

public void deinstall()
               throws Exception

delete the storage table

Throws:

Exception

deleteTbl

protected void deleteTbl()
                  throws Exception

Throws:

Exception

createTbl

protected void createTbl()
                  throws Exception

Throws:

Exception

selectEditedAsset

public List<AssetId> selectEditedAsset(Date from,
                                       Date end,
                                       String editor,
                                       String siteName,
                                       boolean contentAssetOnly)

select a list of edited assets for a given period of time, by the given user in the given site

Parameters:

from - the start of interested period

end - the end of interested period

editor - the name of the editor

siteName - the site name

contentAssetOnly - whether only Content assets are interested or not

Returns:

a list of asset ids

selectCountEditedAsset

public int selectCountEditedAsset(Date from,
                                  Date end,
                                  String editor,
                                  String siteName,
                                  boolean contentAssetOnly)

select the count of edited assets for a given period of time, by the given user in the given site

Parameters:

from - the start of interested period

end - the end of interested period

editor - the name of the editor

siteName - the site name

contentAssetOnly - whether only Content assets are interested or not

Returns:

an int of count

selectWorkflowAsset

public List<AssetId> selectWorkflowAsset(Date from,
                                         Date end,
                                         String assignee,
                                         String siteName,
                                         boolean contentAssetOnly)

select a list of assets that was put into workflow for a given period of time, by the given user in the given site

Parameters:

from - the start of interested period

end - the end of interested period

assignee - the name of the assignee

siteName - the site name

contentAssetOnly - whether only Content assets are interested or not

Returns:

a list of asset ids

selectCheckedOutAsset

public List<AssetId> selectCheckedOutAsset(Date from,
                                           Date end,
                                           String siteName)

select a list of assets that was checked out for a given period of time, in the given site

Parameters:

from - the start of interested period

end - the end of interested period

siteName - the site name

Returns:

a list of asset ids

selectCreatedAsset

public List<AssetId> selectCreatedAsset(Date from,
                                        Date end,
                                        String author,
                                        String siteName,
                                        boolean contentAssetOnly)

select a list of assets that was created for a given period of time, by the given user in the given site

Parameters:

from - the start of interested period

end - the end of interested period

author - the name of the author

siteName - the site name

contentAssetOnly - whether only Content assets are interested or not

Returns:

a list of asset ids

selectCountCreatedAsset

public int selectCountCreatedAsset(Date from,
                                   Date end,
                                   String author,
                                   String siteName,
                                   boolean contentAssetOnly)

selectTopEdits

public Map<String,Integer> selectTopEdits(Date from,
                                          Date end,
                                          String siteName,
                                          boolean contentAssetOnly)

selectTopCreates

public Map<String,Integer> selectTopCreates(Date from,
                                            Date end,
                                            String siteName,
                                            boolean contentAssetOnly)

save

public void save(List<com.openmarket.basic.event.AssetStatisticsItem> statics)

query

public IList query(Date from,
                   Date end,
                   List<AssetStatisticsAction> actions,
                   String userField,
                   String username,
                   String siteName,
                   String what,
                   String sqlEnd,
                   boolean contentAssetOnly)

callCatalogManager

protected void callCatalogManager(FTValList lst)
                           throws Exception

Throws:

Exception

isTableExist

protected boolean isTableExist()

enterWriteLock

protected void enterWriteLock()
                       throws Exception

Throws:

Exception

leaveWriteLock

protected void leaveWriteLock()
                       throws Exception

Throws:

Exception

enterReadLock

protected void enterReadLock()
                      throws Exception

Throws:

Exception

leaveReadLock

protected void leaveReadLock()
                      throws Exception

Throws:

Exception

selectTopContributions

public Map<String,Integer> selectTopContributions(Date from,
                                                  Date end,
                                                  String siteName,
                                                  boolean contentAssetOnly)

selectCountContributedAsset

public int selectCountContributedAsset(Date from,
                                       Date end,
                                       String username,
                                       String site,
                                       boolean contentAssetOnly)

clear

public void clear()
           throws Exception

Throws:

Exception

getAssetStatistics

public List<AssetStatistics> getAssetStatistics(AssetId assetId,
                                                String siteName)

getContributionCounts

public int getContributionCounts(Date from,
                                 Date end,
                                 String assettype,
                                 String siteName)

getTopSearches

public Map<String,Integer> getTopSearches(Date from,
                                          Date end,
                                          String siteName,
                                          boolean contentAssetOnly)

getTopAssetsCount

public Map<String,Integer> getTopAssetsCount(Date from,
                                             Date end,
                                             String siteName,
                                             boolean contentAssetOnly)