--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/fotaapplication/fotaserver/FotaServer/inc/FotaDB.h Thu Dec 17 09:07:52 2009 +0200
@@ -0,0 +1,282 @@
+/*
+* Copyright (c) 2005 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: Header file for fotadb
+*
+*/
+
+
+
+
+#ifndef __CFOTADB_H___
+#define __CFOTADB_H___
+
+// INCLUDES
+#include <d32dbms.h>
+#include <fotaengine.h>
+#include "FotaIPCTypes.h"
+
+
+// CONSTANTS
+// see fotaipctypes.h for field descriptions
+_LIT(KDatabaseName,"FotaState");
+
+_LIT(KSelectAll,"SELECT * FROM State" );
+_LIT(KSelect_where_packageid,"SELECT * FROM State WHERE PkgID=%d" );
+_LIT(KCreateTable, "CREATE TABLE State ( Id COUNTER, PkgID INTEGER NOT \
+ NULL, Result INTEGER, State INTEGER NOT NULL, ProfileID INTEGER,\
+ PkgURL LONG VARCHAR, PkgName CHAR(255),Version CHAR(255), SmlTryCount INTEGER, \
+ SessionType INTEGER, IapId INTEGER, PkgSize UNSIGNED INTEGER, UpdateLtr BIT)");
+_LIT(KAlterTable, "ALTER TABLE State ADD (SessionType INTEGER, IapId INTEGER, PkgSize UNSIGNED INTEGER, UpdateLtr BIT)");
+_LIT(KTblState, "State");
+
+_LIT(KColPkgId, "PkgID");
+_LIT(KColResult, "Result");
+_LIT(KColState, "State");
+_LIT(KColProfileId, "ProfileID");
+_LIT(KColPkgUrl, "PkgURL");
+_LIT(KColPkgName, "PkgName");
+_LIT(KColVersion, "Version");
+_LIT(KColSmlTryCount, "SmlTryCount");
+_LIT(KColSessionType, "SessionType");
+_LIT(KColIapId, "IapId");
+_LIT(KColPkgSize, "PkgSize");
+_LIT(KColUpdateLtr, "UpdateLtr");
+
+// DATATYPES
+enum TFDBFields
+{
+ EFDBResult = 0x01,
+ EFDBState = 0x02,
+ EFDBProfileId = 0x04,
+ EFDBPkgUrl = 0x08,
+ EFDBPkgName = 0x10,
+ EFDBVersion = 0x20,
+ EFDBSmlTryCount = 0x40,
+ EFDBSessionType = 0x80,
+ EFDBIapId = 0x100,
+ EFDBPkgSize = 0x200,
+ EFDBUpdateLtr = 0x400
+};
+//Number of attributes in fotastate table
+const TUint KNoOfDBFields = 13;
+
+// FORWARD DECLARATION
+class CPackageState;
+
+
+/**
+ * Database class
+ *
+ * @lib fotaserver
+ * @since S60 v3.1
+ */
+NONSHARABLE_CLASS(CFotaDB): public CBase
+ {
+ friend class CPackageState;
+public:
+ CFotaDB();
+
+ virtual ~CFotaDB();
+
+ static CFotaDB* NewL();
+
+ /**
+ * Create database
+ *
+ * @since S60 v3.1
+ * @param None
+ * @return none
+ */
+ void CreateDatabaseL();
+
+
+ /**
+ * Open database
+ *
+ * @since S60 v3.1
+ * @param None
+ * @return Error code
+ */
+ void OpenDBL();
+
+ /**
+ * Close database and commit changes
+ *
+ * @since S60 v3.1
+ * @param None
+ * @return none
+ */
+ void CloseAndCommitDB();
+
+
+ /**
+ * Checks if DB is open
+ *
+ * @since S60 v3.1
+ * @param None
+ * @return TBool - is database open
+ */
+ TBool IsOpen();
+
+
+ /**
+ * Add new package state to database
+ *
+ * @since S60 v3.1
+ * @param aState State
+ * @param aPkgURL URL
+ * @return None
+ */
+ void AddPackageStateL( const TPackageState& aState
+ ,const TDesC8& aPkgURL );
+
+
+ /**
+ * Get state from db
+ *
+ * @since S60 v3.1
+ * @param aPkgId Package ID
+ * @return State object
+ */
+ TPackageState GetStateL( const TInt aPkgId );
+
+
+ /** Sets state of package specified by packageid. If state doesnt exist,
+ * it is added to db.
+ * @since S60 v3.1
+ * @param aState source data to be set
+ * @param aPkgURL URL
+ * @param aChangedFields Changed fields. Tells what columns from aState
+ * are to be set.
+ * @return None
+ */
+ void SetStateL( TPackageState& aState
+ ,const TDesC8& aPkgURL, TUint aChangedFields );
+
+
+ /**
+ * Deletes state from database
+ *
+ * @since S60 v3.1
+ * @param aPkgId Package ID
+ * @return Error code
+ */
+ TInt DeleteStateL( const TInt aPkgId);
+
+
+ /**
+ * Gets all states from database
+ *
+ * @since S60 v3.1
+ * @param aStates On return, all states
+ * @return Error code
+ */
+ void GetAllL(RArray<TInt>& aStates);
+
+private:
+
+ void ConstructL();
+
+
+ /**
+ * Converts database row to TPackageState
+ *
+ * @since S60 v3.1
+ * @param aPkgUrl URL
+ * @param aView Database view. Must be ready&prepared for data
+ * extraction
+ * @return State
+ */
+ TPackageState RowToStateL(HBufC8*& aPkgUrl,const RDbView& aView);
+
+
+ /**
+ * Inserts TPackageState to database view
+ *
+ * @since S60 v3.1
+ * @param aPkg Source package
+ * @param aPkgURL Url
+ * @param aView Database view. Must be ready&prepared for data writing
+ * @return None
+ */
+ void StateToRowL (const TPackageState& aPkg, const TDesC8& aPkgURL
+ ,RDbView& aView);
+
+ /**
+ * Adds new attributes to fota table for enabling suspend and resume of download. They include -
+ * DM session type, IAP used during download, total Package size and Update-after-download information.
+ *
+ * @since S60 v3.2
+ * @return None
+ */
+ void AlterTableIfRequiredL();
+
+ /**
+ * Sets the retry count from the cenrep
+ *
+ * @since S60 v5.0
+ * @param package state
+ * @return None
+ */
+
+ void SetRetryCount(TPackageState& aState);
+
+ /**
+ * Determines the char need for db queries
+ *
+ * @since S60 v5.0
+ * @param aChangedFields change fields
+ * @param aState package states
+ * @param aPkgURL
+ * @return None
+ */
+ TInt DetermineCharNeeded(TInt aChangedFields,TPackageState& aState,const TDesC8& aPkgURL);
+
+private:
+
+ /**
+ * File server session
+ */
+ RFs iFSSession;
+
+
+ /**
+ * Reference to database
+ */
+ RDbNamedDatabase iStateDB;
+
+
+ /**
+ * Columns
+ */
+ CDbColSet* iColSet;
+
+
+ /**
+ * Table
+ */
+ RDbTable iTable;
+
+ /**
+ * Is the db open?
+ */
+ TBool iIsOpen;
+
+ /**
+ * Is fota table alter done?
+ */
+ TBool iTableAltercheck;
+ };
+
+#endif // FOTADB_H