--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/upnpsharing/upnpsecurity/inc/server/upnpsecuritydbconnection.h	Thu Dec 17 08:52:00 2009 +0200
@@ -0,0 +1,203 @@
+/** @file
+ * Copyright (c) 2009 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 : SQLite Connection class
+ *
+ */
+
+#ifndef UPNPSECURITYDBCONNECTION_H
+#define UPNPSECURITYDBCONNECTION_H
+
+// INCLUDES
+#include <e32base.h>
+#include <sqldb.h>
+#include <f32file.h> //TDriveNumber
+
+class TInetAddr;
+
+// CLASS DECLARATION
+
+/**
+ * 
+ */
+class CUpnpSecurityDbConnection : public CBase
+    {
+    
+public:
+
+    /* Constructors and destructor. */
+
+    /**
+     * Creates new CUpnpSecurityDbConnection class and initializes 
+     * connection to SQLite.
+     * @return  pointer to CUpnpSecurityDbConnection class
+     */
+    static CUpnpSecurityDbConnection* NewL();
+
+    /**
+     * Creates new CUpnpSecurityDbConnection class and initializes 
+     * connection to SQLite and 
+     * leaves the instance in the cleanup stack.
+     * @return  pointer to CUpnpSecurityDbConnection class
+     */
+    static CUpnpSecurityDbConnection* NewLC();
+
+    /**
+     * Destructor.
+     */
+    virtual ~CUpnpSecurityDbConnection();
+
+public:
+    /**
+     * Open database.
+     */
+    TInt OpenDb( const TDesC& aDb );
+
+    /**
+     * Close opened database
+     */
+    void CloseDb();
+
+    /**
+     * Creates db file.
+     * @param aDb, Database filename and path
+     * @return error code
+     */
+    TInt CreateDbFile( const TDesC& aDb );
+
+    /**
+     * Validates database existence and format.
+     *
+     * @return ETrue if db valid
+     */
+    TBool Validate();
+
+    /**
+     * Executes sql command.
+     *
+     * @param aCommand, command to be executed
+     */
+    void ExecuteL( const TDesC8& aCommand );
+
+    /**
+     * Create tables.
+     */
+    void CreateTablesL();
+
+    /**
+     * Add item (IP address) to DB.
+     */
+    void AddIpAddressL( const TInetAddr& aIpAddress );
+
+    /**
+     * Add item (file name) to DB.
+     */
+    void AddFilenameL( const TDesC& aFilename );
+
+    /**
+     * Delete item (IP address) from DB.
+     */
+    void DeleteIpAddressL( const TInetAddr& aIpAddress );
+
+    /**
+     * Delete item (file name) from DB.
+     */
+    void DeleteFilenameL( const TDesC& aFilename );
+
+    /**
+     * Delete all items (IP addresses) from DB.
+     */
+    void DeleteAllIpAddressesL();
+
+    /**
+     * Delete all items (file names) from DB.
+     */
+    void DeleteAllFilenamesL();
+
+    /**
+     * Retreive data from DB.
+     */
+    void GetAllIpAddressesL( RArray<TInetAddr>& aAddressArray );
+
+    /**
+     * Retreive data from DB.
+     */
+    void GetAllFilenamesL( RPointerArray<HBufC>& aFilenameArray );
+
+    /**
+     * Prepare database for use, create new if not exist.
+     */
+    void OpenDatabaseL();
+
+private:
+
+    /**
+     * Constructor.
+     */
+    CUpnpSecurityDbConnection();
+
+    /**
+     * Second-phase constructor.
+     */
+    void ConstructL();
+    
+    /**
+     * Leaves if there is not enough disk space 
+     */
+    void EnsureDiskSpaceL();
+
+    /**
+     * Returns drive where db files are stored
+     */
+    TDriveNumber DatabaseDrive();
+    
+    /**
+     * Execute given db command
+     * 
+     * @param aCommand command do execute
+     * @param aType type of statement
+     */
+    void ExecStatementL( const TDesC8& aCommand );
+
+    /**
+     * Execute given db command
+     * 
+     * @param aCommand command do execute
+     * @param aTextToBind command text argument
+     */
+    void ExecStatementL( const TDesC8& aCommand, const TDesC& aTextToBind );
+    
+    /**
+     * Execute given db command
+     *
+     * @param aCommand command do execute
+     * @param aType command int argument 
+     */
+    void ExecStatementL( const TDesC8& aCommand, const TInt aIntToBind );
+    
+private:
+    // data
+
+    // iDatabase, interface to Sqlite database
+    RSqlDatabase iDatabase;
+
+    // database file name
+    TFileName iDbFileName;
+
+    //
+    RFs iFs;
+    
+    };
+
+#endif //  UPNPSECURITYDBCONNECTION
+// End of File