/** @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 : SQL clause definitions

 *

 */

#ifndef __UPNPSECSQLCLAUSEDEF_H__

#define __UPNPSECSQLCLAUSEDEF_H__

// CONSTANTS

///////////////////////////////////////////////////////////////////

// DROP CLAUSES

///////////////////////////////////////////////////////////////////

_LIT8( KUpnpSecSqlDropAddressList, "DROP TABLE IF EXISTS AddressList;");

_LIT8( KUpnpSecSqlDropFileList, "DROP TABLE IF EXISTS FileList;" );

///////////////////////////////////////////////////////////////////

// CREATE CLAUSES FOR TABLES

///////////////////////////////////////////////////////////////////

_LIT8( KUpnpSecSqlCreateAddressList, 

    "CREATE TABLE IF NOT EXISTS AddressList("

        "Ip                 INTEGER PRIMARY KEY);"

        );

_LIT8( KUpnpSecSqlCreateFileList, 

    "CREATE TABLE IF NOT EXISTS FileList("

        "Filename          TEXT PRIMARY KEY);"

        );

///////////////////////////////////////////////////////////////////

// INSERT STATEMENTS

///////////////////////////////////////////////////////////////////

//

// Inserting ip address into AddressList table

_LIT8( KUpnpSecSqlInsertIpAddress,

    "INSERT INTO AddressList( " 

    "Ip ) "

    "VALUES( ? );"

    );

// Inserting filename into FileList table

_LIT8( KUpnpSecSqlInsertFile,

    "INSERT INTO FileList( " 

    "Filename ) "

    "VALUES( ? );"

    );

///////////////////////////////////////////////////////////////////

// SELECT STATEMENTS

///////////////////////////////////////////////////////////////////

//

// Select all ip addresses from AddressList table

_LIT8( KUpnpSecSqlSelectAllIpAddresses,

    "SELECT Ip FROM AddressList "

    );

// Select all filenames from FileList table

_LIT8( KUpnpSecSqlSelectAllFiles, "SELECT Filename FROM FileList " 

    );

_LIT8( KUpnpSecSqlValidateTableExistence, "SELECT count(*) FROM AddressList, FileList;" );

// ---------------------------------------------------------------------------

// DELETE STATEMENTS

// ---------------------------------------------------------------------------

//

_LIT8( KUpnpSecSqlDeleteIpAddress, 

    "DELETE FROM AddressList "

    "WHERE Ip = ? ;"

    );

_LIT8( KUpnpSecSqlDeleteAllIpAddresses, 

    "DELETE FROM AddressList;"

    );

_LIT8( KUpnpSecSqlDeleteFile, 

    "DELETE FROM FileList "

    "WHERE Filename = ? ;"

    );

_LIT8( KUpnpSecSqlDeleteAllFiles, 

    "DELETE FROM FileList;"

    );

///////////////////////////////////////////////////////////////////

// MISC DEFINITIONS

///////////////////////////////////////////////////////////////////

//

_LIT16( KUpnpSecSqlIp, "Ip" );

_LIT16( KUpnpSecSqlFilename, "Filename" );

#endif // __UPNPSECSQLCLAUSEDEF_H__

// End of File