Mercurial Mercurial > oss > MCL > sf > app > location / diff
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
eventsui/eventsengine/inc/evtconsts.h
branchRCL_3
changeset 17 1fc85118c3ae
parent 16 8173571d354e
child 18 870918037e16 
--- a/eventsui/eventsengine/inc/evtconsts.h	Thu Aug 19 09:48:36 2010 +0300
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,190 +0,0 @@
-/*
-* 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:  Constants for project Storage API
-*
-*/
-
-
-#ifndef EVTCONSTS_H
-#define EVTCONSTS_H
-
-//-- Database Names
-_LIT(KEventsDbSecureFName, "c:[2001E663]EvtStorage.db");
-
-//-- Config 
-_LIT8(KServerConfigString, ";cache_size =  1024 ;page_size =1024 ;encoding =  \"UTF-8\" ");
-
-//===============================
-// Create Table:
-//===============================
-_LIT8(KCreateEventTable, "\
-CREATE TABLE Event(\
-EventId INTEGER,\
-Status INTEGER,\
-Subject VARCHAR(160) DEFAULT NULL,\
-Place VARCHAR(160) DEFAULT NULL,\
-Radius REAL,\
-Description VARCHAR(160) DEFAULT NULL,\
-Repeat BOOLEAN)\
-");
-
-_LIT8(KCreateActionTable, "\
-CREATE TABLE Action(\
-Id INTEGER PRIMARY KEY,\
-Action VARCHAR(160) DEFAULT NULL,\
-EvtId INTEGER)\
-");
-//===============================
-// Indexes:
-//===============================
-_LIT8(KCreateEventStatusSubjectIndex, "CREATE INDEX EventStatus ON Event (Status)");
-_LIT8(KCreateEventEvtIdIndex, "CREATE INDEX EventEvtID ON Event (EventId)");
-_LIT8(KCreateActionEvtIdIndex, "CREATE INDEX ActionID ON Action (EvtId)");
-
-//===============================
-// Trigger: for Action and Place
-//===============================
-//-- Foreign Key Preventing insert
-_LIT8(KCreateTriggerActionEventInsert, "\
-CREATE TRIGGER fki_Action_EvtId_Event_EventId\
-BEFORE INSERT ON [Action]\
-FOR EACH ROW BEGIN\
-  SELECT RAISE(ROLLBACK, 'insert on table \"Action\" violates foreign key constraint \"fki_Action_EvtId_Event_EventId\"')\
-  WHERE NEW.EvtId IS NOT NULL AND (SELECT EventId FROM Event WHERE EventId = NEW.EvtId) IS NULL;\
-END;\
-");
-
-//-- Foreign key preventing update
-_LIT8(KCreateTriggerActionEventUpdate, "\
-CREATE TRIGGER fku_Action_EvtId_Event_EventId\
-BEFORE UPDATE ON [Action] \
-FOR EACH ROW BEGIN\
-    SELECT RAISE(ROLLBACK, 'update on table \"Action\" violates foreign key constraint \"fku_Action_EvtId_Event_EventId\"')\
-      WHERE NEW.EvtId IS NOT NULL AND (SELECT EventId FROM Event WHERE EventId = NEW.EvtId) IS NULL;\
-END;\
-");
-
-//-- Cascading Delete
-_LIT8(KCreateTriggerActionEventDelete, "\
-CREATE TRIGGER fkdc_Action_EvtId_Event_EventId\
-BEFORE DELETE ON Event \
-FOR EACH ROW BEGIN\
-    DELETE FROM Action WHERE Action.EvtId = OLD.EventId;\
-END;\
-");
-
-//-- Drop Trigger
-_LIT8(KDropTriggerActionEventInsert, "\
-DROP TRIGGER fki_Action_EvtId_Event_EventId;\
-");
-_LIT8(KDropTriggerActionEventUpdate, "\
-DROP TRIGGER fku_Action_EvtId_Event_EventId;\
-");
-_LIT8(KDropTriggerActionEventDelete, "\
-DROP TRIGGER fkdc_Action_EvtId_Event_EventId;\
-");
-
-//===============================
-// Queries: 
-//===============================
-
-// Define Literals that are used in Query
-_LIT(KId, ":IdVal");
-_LIT(KEventId, ":EventIdVal");
-_LIT(KStatus, ":StatusVal");
-_LIT(KSubject, ":SubjectVal");
-_LIT(KPlace, ":PlaceVal");
-_LIT(KRadius, ":RadiusVal");
-_LIT(KUnit, ":UnitVal");
-_LIT(KDescription, ":DescVal");
-_LIT(KRepeat, ":RepeatVal");
-_LIT(KAction, ":ActionVal");
-_LIT(KEvtId, ":EvtIdVal");
-
-// Query to select Event based on LBT's event Id
-_LIT8(KSelectEventFromEventId, "SELECT Event.Status,Event.Subject,Event.Place,Event.Radius,Event.Description,Event.Repeat,Action.Id,Action.Action,Action.EvtId FROM Event INNER JOIN Action ON (Event.EventId=:EventIdVal AND Event.EventId=Action.EvtId);");
-
-// Query to select All Events - Only Basic Information
-_LIT8(KSelectBasicEvent, "SELECT Event.EventId,Event.Status,Event.Subject,Event.Place,Event.Repeat FROM Event ORDER BY Status,Subject COLLATE CompareC3;");
-
-// Query to select All Events based on Status - Only Basic Information
-_LIT8(KSelectBasicEventOnStatus, "SELECT Event.EventId,Event.Status,Event.Subject,Event.Place,Event.Repeat FROM Event WHERE Event.Status=:StatusVal ORDER BY Event.Subject COLLATE CompareC3;");
-
-// Query to select All Events based on Status
-_LIT8(KSelectEventOnStatus, "SELECT Event.EventId,Event.Status,Event.Subject,Event.Place,Event.Radius,Event.Description,Event.Repeat,Action.Action,Action.Id,Action.EvtId FROM Event INNER JOIN Action ON (Event.EventId=Action.EvtId) WHERE Event.Status=:StatusVal ORDER BY Event.Subject COLLATE CompareC3;");
-
-// Query to check the prsence of Event
-_LIT8(KSelectEvent, "SELECT EventId FROM Event WHERE Event.EventId=:EventIdVal;");
-
-// Query to select All Action based on Status
-_LIT8(KSelectAction, "SELECT Id FROM Action WHERE Action.Id=:IdVal;");
-
-// Query to select Action based on Event Id
-_LIT8(KSelectActionFromEvent, "SELECT Id FROM Action WHERE Action.EvtId=:EvtIdVal;");
-
-// Query to Insert an Event into Event Table
-_LIT8(KInsertEvent, "INSERT INTO Event(EventId,Status,Subject,Place,Radius,Description,Repeat) VALUES(:EventIdVal,:StatusVal,:SubjectVal,:PlaceVal,:RadiusVal,:DescVal,:RepeatVal)");
-
-// Query to Insert an Action into Action Table
-_LIT8(KInsertAction, "INSERT INTO Action(Action,EvtId) VALUES(:ActionVal,:EvtIdVal)");
-
-// Queries to Inserts using TSqlRowSetUtil
-_LIT(KInsertEventRowDesc, "INSERT INTO Event(EventId) VALUES(%ld)"); // Not Used
-_LIT(KInsertActionRowDesc, "INSERT INTO Action(EvtId) VALUES(%d)");
-_LIT(KInsertEventDesc, "INSERT INTO Event(EventId,Status,Subject,Place,Radius,Description,Repeat) VALUES(%ld,%d,'%S','%S',%f,'%S',%d)");
-_LIT(KInsertActionDesc, "INSERT INTO Action(Action,EvtId) VALUES('%S',%d)");
-
-// Query to Update Event table based on Event/Trigger Id
-_LIT8(KUpdateEvent, "UPDATE Event SET Status=:StatusVal,Subject=:SubjectVal,Place=:PlaceVal,Radius=:RadiusVal,Description=:DescVal,Repeat=:RepeatVal WHERE EventId=:EventIdVal");
-
-// Query to Update Action table based on Event/Trigger Id
-_LIT8(KUpdateAction, "UPDATE Action SET Action=:ActionVal,EvtId=:EvtIdVal WHERE Id=:IdVal");
-
-// Query to Update Event status based on Event/Trigger Id
-_LIT8(KUpdateEventStatus, "UPDATE Event SET Status=:StatusVal WHERE EventId=:EventIdVal");
-
-// Query to Delete Action based on Event/Trigger Id
-_LIT8(KDeleteAction, "DELETE FROM Action WHERE Action.EvtId=:EvtIdVal");
-
-// Query to Delete Event based on Event/Trigger Id
-_LIT8(KDeleteEvent, "DELETE FROM Event WHERE Event.EventId=:EventIdVal");
-
-// -- New Strings for Delete Multiple
-// OR String
-_LIT8(KOr, " OR ");
-
-// AND String
-_LIT8(KAnd, " AND ");
-
-// AND String
-_LIT8(KWhere, " WHERE ");
-
-// Action String Id
-_LIT8(KMultiActionId, "Action.EvtId = ");
-
-// Event String Id
-_LIT8(KMultiEventId, "Event.EventId = ");
-
-// Query to Delete Action based on Event/Trigger Id
-_LIT8(KDeleteMultiAction, "DELETE FROM Action WHERE ");
-
-// Query to Delete Event based on Event/Trigger Id
-_LIT8(KDeleteMultiEvent, "DELETE FROM Event WHERE ");
-
-// Query to Delete Action based on Event/Trigger Id
-_LIT8(KUpdateMultiStatus, "UPDATE Event SET Status = ");
-
-#endif      // EVTCONSTS_H
-
-// End of File
MCL/sf/app/location