--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/mpxplugins/serviceplugins/collectionplugins/mpxsqlitepodcastdbplugin/inc/mpxdbutil.h	Thu Dec 17 08:45:05 2009 +0200
@@ -0,0 +1,94 @@
+/*
+* Copyright (c) 2006 Nokia Corporation and/or its subsidiary(-ies).
+* All rights reserved.
+* This component and the accompanying materials are made available
+* under the terms of "Eclipse Public License v1.0"
+* which accompanies this distribution, and is available
+* at the URL "http://www.eclipse.org/legal/epl-v10.html".
+*
+* Initial Contributors:
+* Nokia Corporation - initial contribution.
+*
+* Contributors:
+*
+* Description:  The class MPXDbUtil which contains utilities functions
+*
+*/
+
+
+#ifndef MPXDBUTIL_H
+#define MPXDBUTIL_H
+
+// INCLUDES
+#include <mpxpodcastdefs.h> // Podcast specific
+
+// FORWARD DECLARATIONS
+class CMPXMedia;
+class CMPXMediaArray;
+class RSqlStatement;
+
+// CLASS DECLARATION
+
+/**
+* This static class contains utilities functions used by Podcast Collection
+*
+* @lib mpxpodcastdbplugin.lib
+*/
+class MPXDbUtil
+    {
+    public:
+        /**
+        * Create a media object with title, podcast type, podcast category
+        * and ID then append it to the media array
+        * @param aArray media array
+        * @param aTitle title
+        * @param aType attribute type
+        * @param aCat attribute category
+        * @param aPodcastType attribute podcast type
+        * @param aPodcastCat attribute podcast category
+        * @param aId unique ID
+        * @param aNonPermissibleActions bitmask specifying the non-permissible
+        *       actions for the entry
+        */
+        static void AppendMediaL(CMPXMediaArray& aArray, const TDesC& aTitle,
+            TMPXGeneralType aType, TMPXGeneralCategory aCat,
+            TMPXPodcastType aPodcastType, TMPXPodcastCategory aPodcastCat,
+            TMPXItemId aId = 0, TInt aNonPermissibleActions = 0);
+
+        /**
+        * Returns the Podcast field name for a specified category
+        * @param aCategory identifies the category
+        * @return corresponding field name
+        */
+        static TPtrC PodcastFieldNameForCategoryL(TMPXGeneralCategory aCategory);
+
+        /**
+        * Returns today's date (no hour, minutes, seconds)
+        * @return date value
+        */
+        static TTime Today();
+
+        /**
+        * Returns this month' start date (no hour, minutes, seconds)
+        * @return date value
+        */
+        static TTime MonthStart();
+
+        /**
+        * Returns the index of the current day in week (0-6)
+        * @return index value
+        */
+        static TInt DayNoInWeek();
+
+        /**
+        * Returns the table name for a specified category
+        * @param aCategory identifies the category
+        * @return corresponding table name
+        */
+        static TPtrC TableNameForCategoryL(TMPXGeneralCategory aCategory);
+    };
+
+#endif // MPXDBUTIL_H
+
+// End of File
+