/*
* Copyright (c) 2008 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:  
 *  Version     : %version: 8 % << Don't touch! Updated by Synergy at check-out.
 *
*/


#ifndef C_CPSSQL_H
#define C_CPSSQL_H

//Insert Data
//Update Data


_LIT( KSQLUpdate, "UPDATE CP_MAIN_TABLE SET " );
_LIT( KSQLUpdateData, "Data = :Data " );
_LIT( KSQLUpdateAction, "Action = :Action " );
_LIT( KSQLUpdateExpirationDate, "Expiration_date = :Expiration_date " );
_LIT( KSQLUpdateFlag, "Flag = :Flag " );
_LIT( KSQLUpdateWhere, "WHERE Id = :Id  " );
_LIT( KComma, ",  " );

_LIT( KSQLUpdateRegistry, "UPDATE CP_PUBLISHER_TABLE SET " );

_LIT( KSQLInsert,
    "INSERT INTO CP_MAIN_TABLE (Publisher,Content_type,Content_id,Expiration_date,Access_List,Data,Action) VALUES ( \
					            :Publisher,\
                                :Content_type,\
                                :Content_id,\
                                :Expiration_date,\
                                :Access_List,\
                                :Data,\
                                :Action )" );

_LIT( KSQLInsertToRegistry,
    "INSERT INTO CP_PUBLISHER_TABLE (Publisher,Content_type,Content_id,Flag,Access_List,Data,Action) VALUES ( \
					            :Publisher,\
                                :Content_type,\
                                :Content_id,\
                                :Flag,\
                                :Access_List,\
                                :Data,\
                                :Action )" );

//Delete Data
_LIT( KSQLDelete, "DELETE FROM CP_MAIN_TABLE" );
_LIT( KSQLDeleteFromRegistry, "DELETE FROM CP_PUBLISHER_TABLE" );

//Get Data
_LIT( KSQLGetLastInsertId, "SELECT last_insert_rowid() ");

_LIT( KSQLGetList, 
    "SELECT Id,Publisher,Content_type,Content_id,Expiration_date,Access_List,Data,Action FROM CP_MAIN_TABLE");
_LIT( KSQLGetIds,
    "SELECT Id,Publisher,Content_type,Content_id,Access_List FROM CP_MAIN_TABLE");
_LIT( KSQLGetIdsRegistry, 
    "SELECT Id,Publisher,Content_type,Content_id,Access_List,Flag FROM CP_PUBLISHER_TABLE" );
_LIT( KSQLGetAction, 
    "SELECT Action FROM CP_MAIN_TABLE WHERE ");

_LIT( KSQLGetListFromRegistry, 
    "SELECT Id,Publisher,Content_type,Content_id,Access_List,Flag,Data,Action FROM CP_PUBLISHER_TABLE");
_LIT( KSQLGetIdsFromRegistry, 
    "SELECT Id,Publisher,Content_type,Content_id FROM CP_PUBLISHER_TABLE");
_LIT( KSQLGetActionFromRegistry, 
    "SELECT Id,Action FROM CP_PUBLISHER_TABLE WHERE ");

_LIT( KSQLGetFlag ,"Flag <> 0");
_LIT( KSQLGetPublisher ,"Publisher = :Publisher");
_LIT( KSQLGetContentType ,"Content_type = :Content_type");
_LIT( KSQLGetContentId ,"Content_id = :Content_id");
_LIT( KSQLGetId ,"Id = :Id");
_LIT( KAnd," AND ");

_LIT( KSQLFetchId, 
    "SELECT Id FROM CP_MAIN_TABLE WHERE Publisher =:Publisher AND Content_type=:Content_type AND Content_id =:Content_id");
_LIT( KSQLFetchIds, 
    "SELECT Publisher,Content_type,Content_id,Access_List FROM CP_MAIN_TABLE WHERE Id =:Id");

_LIT( KSQLFetchIdFromRegistry,
    "SELECT Id FROM CP_PUBLISHER_TABLE WHERE Publisher =:Publisher AND Content_type=:Content_type AND Content_id =:Content_id" );
_LIT( KSQLFetchIdsFromRegistry,
    "SELECT Publisher,Content_type,Content_id,Access_List FROM CP_PUBLISHER_TABLE WHERE Id =:Id" );

_LIT( KSQLPublisher, ":Publisher" );
_LIT( KSQLContent_type, ":Content_type" );
_LIT( KSQLContent_id, ":Content_id" );
_LIT( KSQLExpiration_date, ":Expiration_date" );
_LIT( KSQLFlag, ":Flag" );
_LIT( KSQLData, ":Data" );
_LIT( KSQLAction, ":Action" );
_LIT( KSQLAccessList, ":Access_List" );
_LIT( KSQLId, ":Id" );

_LIT( KSQLOrderRecent, " ORDER BY Id DESC" );
_LIT( KSQLOrderPublisher, " ORDER BY Publisher" );
_LIT( KSQLOrderContent, " ORDER BY Content_type" );
_LIT( KSQLOrderContentId, " ORDER BY Content_id" );

_LIT( KColumnId, "Id" );
_LIT( KColumnPublisher, "Publisher" );
_LIT( KColumnContent_type, "Content_type" );
_LIT( KColumnContent_id, "Content_id" );
_LIT( KColumnAccessList, "Access_List" );
_LIT( KColumnExpiration_date, "Expiration_date" );
_LIT( KColumnFlag, "Flag" );
_LIT( KColumnData, "Data" );
_LIT( KColumnAction, "Action" );

_LIT( KWhere, " WHERE ");

_LIT8( KList, "List" );

#endif //C_CPSSQL_H