00001
00017 #ifndef __DB_CALLS_H__
00018 #define __DB_CALLS_H__
00019
00020 #define CALENDARS_TABLE "Calendars"
00021 #define COMPONENTS_TABLE "Components"
00022 #define COMPONENTDETAILS_TABLE "ComponentDetails"
00023 #define ALARM_TABLE "Alarm"
00024 #define RECURSIVE_TABLE "Recursive"
00025 #define SMARTCAL_TABLE "Components"
00026 #define TRASH_TABLE "Trash"
00027 #define PARAMS_TABLE "Parameters"
00028 #define XPROP_TABLE "XProperties"
00029 #define IDMAP_TABLE "IDMAP"
00030 #define UTILITY_TABLE "UTILITY"
00031
00032 #define CAL_FIELD_ID "CalendarId"
00033 #define CAL_FIELD_NAME "Name"
00034 #define CAL_FIELD_COLOR "Colour"
00035 #define CAL_FIELD_ISVISIBLE "IsVisible"
00036 #define CAL_FIELD_ISREADONLY "IsReadonly"
00037 #define CAL_FIELD_CALTYPE "CalendarType"
00038 #define CAL_FIELD_TUNE "CalendarTune"
00039 #define CAL_FIELD_VERSION "CalendarVersion"
00040 #define CAL_FIELD_PROFILE "CalendarProfile"
00041
00042 #define ENTRY_FIELD_CALID "CalendarId"
00043 #define ENTRY_FIELD_ID "Id"
00044 #define ENTRY_FIELD_TYPE "ComponentType"
00045 #define ENTRY_FIELD_FLAGS "Flags"
00046 #define ENTRY_FIELD_DTSTART "DateStart"
00047 #define ENTRY_FIELD_DTEND "DateEnd"
00048 #define ENTRY_FIELD_SUMMARY "Summary"
00049 #define ENTRY_FIELD_LOC "Location"
00050 #define ENTRY_FIELD_DESC "Description"
00051 #define ENTRY_FIELD_STATUS "Status"
00052 #define ENTRY_FIELD_UID "Uid"
00053 #define ENTRY_FIELD_UNTIL "Until"
00054 #define ENTRY_FIELD_ALLDAY "AllDay"
00055 #define ENTRY_FIELD_CRTIME "CreatedTime"
00056 #define ENTRY_FIELD_MODTIME "ModifiedTime"
00057
00058
00059 #define SMARTCAL_FIELD_CALID "CalendarId"
00060 #define SMARTCAL_FIELD_EUID "Uid"
00061 #define SMARTCAL_FIELD_FNAME "Summary"
00062 #define SMARTCAL_FIELD_BDAY "DateStart"
00063 #define SMARTCAL_FIELD_TYPE "ComponentType"
00064
00065 #define COMP_FIELD_ID "Id"
00066 #define COMP_FIELD_TYPE "ComponentType"
00067 #define COMP_FIELD_CLAS "Class"
00068 #define COMP_FIELD_GEO "Geo"
00069 #define COMP_FIELD_PRIO "Priority"
00070 #define COMP_FIELD_DTSTAMP "DateStamp"
00071 #define COMP_FIELD_SEQ "Sequence"
00072 #define COMP_FIELD_TRANSP "Transparency"
00073 #define COMP_FIELD_UID "Uid"
00074 #define COMP_FIELD_URL "Url"
00075 #define COMP_FIELD_ATTACH "Attach"
00076 #define COMP_FIELD_CATEGORY "Category"
00077 #define COMP_FIELD_COMMENT "Comment"
00078 #define COMP_FIELD_CONTACT "Contact"
00079 #define COMP_FIELD_RELATED "Related"
00080 #define COMP_FIELD_RESOURCES "Resources"
00081 #define COMP_FIELD_PERCENT "Percent"
00082 #define COMP_FIELD_COMPLETED "Completed"
00083 #define COMP_FIELD_XPROP "x-prop"
00084
00085 #define ORG_FIELD_ID "Id"
00086 #define ORG_FIELD_TYPE "ComponentType"
00087 #define ORG_FIELD_CNPARAM "CnParam"
00088 #define ORG_FIELD_DIRPARAM "DirParam"
00089 #define ORG_FIELD_SENTPARAM "SentByParam"
00090 #define ORG_FIELD_LANGPARAM "LanguageParam"
00091
00092 #define RECUR_FIELD_ID "Id"
00093 #define RECUR_RRULE "Rrule"
00094 #define RECUR_RDATES "Rdates"
00095 #define RECUR_EDATES "Exdates"
00096 #define RECUR_EXRULE "Exrule"
00097 #define RECUR_RECURID "RecurrenceId"
00098 #define RECUR_RTYPE "Rtype"
00099
00100 #define ATT_FIELD_ID "Id"
00101 #define ATT_FIELD_TYPE "ComponentType"
00102 #define ATT_FIELD_CUPARAM "CuTypeParam"
00103 #define ATT_FIELD_MEMPARAM "MemberParam"
00104 #define ATT_FIELD_ROLEPARAM "RoleParam"
00105 #define ATT_FIELD_ROLE_PARSTAT "ParticipationStatus"
00106 #define ATT_FIELD_RSVP "Rsvp"
00107 #define ATT_FIELD_DELTO "DelegatedTo"
00108 #define ATT_FIELD_DELFROM "DelegatedFrom"
00109 #define ATT_FIELD_SENTPARAM "SentBy"
00110 #define ATT_FIELD_CNPARAM "CnParam"
00111 #define ATT_FIELD_DIRPARAM "DirParam"
00112 #define ATT_FIELD_LANGPARAM "LanguageParam"
00113
00114 #define ALARM_FIELD_ID "Id"
00115 #define ALARM_FIELD_TRIGGER "Trigger"
00116 #define ALARM_FIELD_REPEAT "Repeat"
00117 #define ALARM_FIELD_DURATION "Duration"
00118 #define ALARM_FIELD_ACTION "Action"
00119 #define ALARM_FIELD_COOKIEID "CookieId"
00120 #define ALARM_FIELD_ATTACH "Attach"
00121 #define IMPORT "imported calendar-"
00122 #define SEMI_COLON ";"
00123 #define EXCLAMATION "!"
00124
00125
00126 #define TRASH_FIELD_ID "ComponentId"
00127 #define TRASH_FIELD_CALID "CalendarId"
00128 #define TRASH_FIELD_TYPE "ComponentType"
00129 #define TRASH_FIELD_TIME "DeletedTime"
00130 #define TRASH_FIELD_CTIME "CreatedTime"
00131
00132 #define PARAM_FIELD_ID "ComponentId"
00133 #define PARAM_FIELD_PROPNAME "PropertyType"
00134 #define PARAM_FIELD_PROPVALUE "PropertyValue"
00135 #define PARAM_FIELD_PARAMNAME "ParamName"
00136 #define PARAM_FIELD_PARAMVALUE "ParamValue"
00137
00138 #define XPROP_FIELD_ID "ComponentId"
00139 #define XPROP_FIELD_XPROPNAME "XPropertyName"
00140 #define XPROP_FIELD_XPROPVALUE "XPropertyValue"
00141
00142 #define IDMAP_FIELD_LOCALID "LocalId"
00143 #define IDMAP_FIELD_EXTID "ExternalId"
00144
00145 #define UTILITY_FIELD_NAME "Name"
00146 #define UTILITY_FIELD_VALUE "Value"
00147
00148 #define INSERT_CALENDAR "insert into Calendars (%s, %s, %s, %s, %s,%s, %s,%s) values (?, ?, ?, ?, ?,?,?,?)"
00149 #define INSERT_ENTRY "insert into Components ( %s,%s,%s,%s, %s, %s, %s, %s, %s, %s, %s,%s,%s,%s,%s) values (?,?,?,?,?, ?, ?, ?, ?, ?, ?, ?, ?,?,?)"
00150 #define INSERT_COMPONENT "insert into ComponentDetails (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) values (?, ?, ?, ? ,? ,?, ?, ?, ?, ? ,? ,?, ?, ?, ?, ? ,? ,?)"
00151 #define INSERT_RECURSIVE "insert into RECURSIVE ( %s, %s, %s, %s, %s, %s,%s) values ( ?, ?, ?, ?, ?, ?,?)"
00152 #define INSERT_ALARM "insert into ALARM ( %s,%s,%s, %s, %s, %s, %s) values (?,?, ?, ?, ?, ?, ?)"
00153
00154 #define INSERT_SMARTCAL "insert into Components (%s, %s, %s, %s, %s) values (?, ?, ?, ?, ?)"
00155 #define INSERT_TRASH "insert into Trash (%s, %s, %s, %s, %s) values (?, ?, ?, ?, ?)"
00156 #define INSERT_PARAM "insert into Parameters (%s,%s,%s,%s,%s) values (?,?,?,?,?)"
00157 #define INSERT_XPROP "insert into XProperties (%s,%s,%s) values (?,?,?)"
00158 #define INSERT_IDMAP "insert into IDMAP (%s,%s) values (?,?)"
00159 #define INSERT_UTILITY "insert into UTILITY (%s,%s) values (?,?)"
00160
00161
00162 #define UPDATE_PARAM "update Parameters set %s=?, %s=?, %s=? where %s=?"
00163 #define UPDATE_TABLE "update %s set %s=? where %s= ?"
00164 #define UPDATE_TABLE_AND "update %s set %s = ? where %s = ? AND %s = ?"
00165 #define UPDATE_TABLE_OR "update %s set %s = ? where %s = ? OR %s = ?"
00166 #define UPDATE_COLS_TABLE_AND "update %s set %s = ?, %s = ? where %s = ? AND %s = ?"
00167 #define UPDATE_COLS_TABLE_OR "update %s set %s = ?, %s = ? where %s = ? OR %s = ?"
00168 #define UPDATE_ALARM "update ALARM set %s=?, %s=?, %s=?, %s=?,%s=?,%s=? where %s=?"
00169 #define CALENDAR_UPDATE "update CALENDARS set %s=?, %s=?, %s=?, %s=?, %s=?,%s=?,%s = ?,%s=? where %s=%d"
00170 #define UPDATE_COMPONENTS "update Components set %s=?,%s=?,%s=?,%s=?,%s=?,%s=?, %s=?, %s=?, %s=?,%s=?,%s=?,%s=? ,%s=? where %s=?"
00171 #define UPDATE_COMPONENTDETAILS "update ComponentDetails set %s=?,%s=?,%s=?,%s=?,%s=?, %s=?, %s=?, %s=?,%s=?,%s=?, %s=?,%s=?,%s=?,%s=?,%s=?,%s=? where %s=?"
00172 #define UPDATE_RECURSIVE "update RECURSIVE set %s=?,%s=?,%s=?,%s=?,%s=?,%s=? where %s=?"
00173 #define UPDATE_SMARTCAL "update Components set %s=?, %s=? where %s=?"
00174 #define UPDATE_UTILITY "update UTILITY set %s=? where %s=?"
00175
00176 #define DELETE_TABLE "delete from %s where %s = ?"
00177 #define DELETE_TABLE_AND "delete from %s where %s = ? AND %s = ?"
00178 #define DELETE_TABLE_OR "delete from %s where %s = ? OR %s = ?"
00179 #define DEL_ROW_BY_CALID "delete from %s where %s in (select %s from Components where %s = %d)"
00180 #define DELETE_TABLE_PROP "delete from %s where %s = ? AND %s != ? AND %s != ?"
00181
00182 #define CREATE_CAL "CREATE TABLE IF NOT EXISTS Calendars(CalendarId INTEGER PRIMARY KEY,Name TEXT UNIQUE,\
00183 Colour INTEGER,IsVisible INTEGER,IsReadonly INTEGER,CalendarType INTEGER,\
00184 CalendarTune TEXT,CalendarVersion TEXT,CalendarProfile INTEGER)"
00185 #define CREATE_ENTRY "CREATE TABLE IF NOT EXISTS Components(Id TEXT,CalendarId INTEGER,\
00186 ComponentType INTEGER, Flags INTEGER, DateStart INTEGER, DateEnd INTEGER,\
00187 Summary TEXT, Location TEXT, Description TEXT, Status INTEGER,Uid TEXT , \
00188 Until INTEGER,AllDay INTEGER,CreatedTime INTEGER,ModifiedTime INTEGER)"
00189 #define CREATE_COMPONENT "CREATE TABLE IF NOT EXISTS ComponentDetails(Id TEXT, ComponentType INTEGER, \
00190 Class TEXT,Geo TEXT,Priority INTEGER, DateStamp TEXT, Sequence INTEGER,\
00191 Transparency TEXT, Uid INTEGER, Url TEXT,\
00192 Attach TEXT,Category TEXT, Comment TEXT, Contact TEXT, Related TEXT,\
00193 Resources TEXT, Percent INTEGER,Completed TEXT)"
00194 #define CREATE_ORGANIZER "CREATE TABLE IF NOT EXISTS ORGANIZER(Id TEXT, ComponentType INTEGER,\
00195 CnParam TEXT, DirParam TEXT, SentByParam TEXT, LanguageParam TEXT)"
00196
00197 #define CREATE_RECURSIVE "CREATE TABLE IF NOT EXISTS RECURSIVE (Id TEXT, Rrule text,Rdates text,\
00198 Exdates text,Exrule text,RecurrenceId integer,Rtype INTEGER)"
00199 #define CREATE_ATTENDEE "CREATE TABLE IF NOT EXISTS ATTENDEE(Id TEXT, ComponentType INTEGER,\
00200 CuTypeParam INTEGET,MemberParam TEXT,RoleParam INTEGER, \
00201 ParticipationStatus INTEGER, Rsvp INTEGER,DelegatedTo TEXT,DelegatedFrom TEXT,\
00202 SentBy TEXT, CnParam TEXT, DirParam TEXT, LanguageParam TEXT)"
00203 #define CREATE_ALARM "CREATE TABLE IF NOT EXISTS ALARM (Id TEXT, Trigger INTEGER, Repeat INTEGER,\
00204 Duration INTEGER, Action INTEGER,CookieId TEXT,Attach TEXT)"
00205 #define CREATE_TRASH "CREATE TABLE IF NOT EXISTS Trash (ComponentId TEXT, CalendarId INTEGER, \
00206 ComponentType INTEGER, DeletedTime INTEGER, CreatedTime INTEGER)"
00207 #define CREATE_PARAM "CREATE TABLE IF NOT EXISTS Parameters(ComponentId TEXT, PropertyType TEXT,\
00208 PropertyValue TEXT,ParamName TEXT,ParamValue TEXT)"
00209
00210 #define CREATE_XPROP "CREATE TABLE IF NOT EXISTS XProperties(ComponentId TEXT, XPropertyName TEXT ,\
00211 XPropertyValue TEXT)"
00212 #define CREATE_IDMAP "CREATE TABLE IF NOT EXISTS IDMAP(LocalId TEXT, ExternalId TEXT)"
00213 #define CREATE_UTILITY "CREATE TABLE IF NOT EXISTS UTILITY(Name TEXT,Value TEXT)"
00214
00215 #define SELECT_DOMAIN "select %s from %s where %s = \"%s\" "
00216 #define SELECT_DOMAIN_AND "select %s from %s where %s = %d AND %s = %d"
00217 #define SELECT_TAB_COND1 "select * from (%s,%s) where %s = \"%s\""
00218 #define SELECT_TAB_COND2 "select * from %s where %s = \"%s\""
00219 #define SELECT_TAB_COND_OR "select * from %s where %s = %d OR %s = %d"
00220 #define SELECT_TAB_COND_AND "select * from %s where %s = %d AND %s=%d"
00221 #define SELECT_TAB_COND_TODO "select * from %s where %s = %d AND %s=%d AND %s = %d"
00222 #define SELECT_TAB_COND_AND1 "select * from %s where %s = \"%s\" AND %s=\"%s\" "
00223 #define SELECT_TAB "select * from %s"
00224 #define SELECT_TWO_TAB "select * from %s %s"
00225 #define SELECT_THREE_TAB "select * from %s %s %s"
00226 #define SELECT_TAB_COND "select * from %s where %s = ?"
00227 #define SELECT_TAB_COND_STRING "select * from %s where %s = \"%s\""
00228 #define SELECT_TAB_OR1 "select * from (%s,%s) where %s = %d OR %s = %d"
00229 #define SELECT_TAB_AND "select * from %s where %s = ? AND %s = ?"
00230 #define SELECT_TAB_OR "select * from %s where %s = ? OR %s = ?"
00231 #define SELECT_RANGE "select * from %s where %s = %d AND %s >= %d AND %s <= %d"
00232 #define SELECT_MULTI_RANGE "select * from %s where %s = %d AND %s = %d AND %s >= %d AND %s <= %d"
00233 #define SELECT_INNER_JOIN "select components.*,componentdetails.* from components INNER JOIN componentdetails where components.Id=\"%s\" AND Components.Id=ComponentDetails.Id"
00234 #define SELECT_PRCR_OFFSET_LIMIT "select * from %s where %s = %d AND (%s = %d OR %s=%d) AND (%s = %d OR %s = %d) AND (%d < %s OR %d = %s) LIMIT %d OFFSET %d"
00235 #define SELECT_MRCR_OFFSET_LIMIT_UNION "select * from %s where %s = %d AND %s = %d AND %s >= %d AND %s <= %d AND (%s != %d AND %s != %d) union select * from %s where %s = %d AND %s = %d AND (%s = %d OR %s = %d) AND (%d < %s OR %d = %s) LIMIT %d OFFSET %d "
00236 #define SELECT_MRCR_OFFSET_LIMIT "select * from %s where %s = %d AND %s = %d AND %s >= %d AND %s <= %d AND (%s != %d AND %s != %d) LIMIT %d OFFSET %d"
00237 #define SELECT_MULTI_RANGE_MRCR "select * from %s where %s = %d AND %s = %d AND %s >= %d AND %s <= %d AND (%s != %d AND %s != %d)"
00238 #define SELECT_MULTI_RANGE_PRCR_CHECK "select * from %s where %s = %d AND (%s = %d OR %s=%d) AND (%s = %d OR %s = %d) AND (%d < %s OR %d = %s)"
00239 #define SELECT_MULTI_RANGE_PRCR "select * from %s where %s = %d AND (%s = %d OR %s=%d) AND (%s = %d OR %s = %d)"
00240 #define GET_EXPIRED_EVENTS "select %s from components where %s= %d and %s= %d and %s < %d"
00241 #define GET_EXPIRED_TODOS "select %s from components where %s= %d and %s= %d and %s = %d and %s < %d"
00242 #define GET_ADDED_ENTRIES "select %s from components where %s > %d AND %s=%d AND %s=%d"
00243 #define GET_MODIFIED_ENTRIES "select %s from components where %s < %d AND %s > %d and %s=%d AND %s=%d"
00244 #define GET_TODAYS_ALLDAY "select Id,calendarId,summary,DateStart from components where %s >= %d AND %s <= %d and %s=%d AND %s=%d"
00245 #define GET_ALLDAY_ENTRIES "select %s from components where %s >= %d AND %s <= %d and %s=%d AND %s=%d"
00246 #define GET_IMPORT_CALENDAR "select max(Name) from calendars where Name like \'%s\'"
00247 #define GET_CTIME_UID "select CreatedTime from Components where Id = \"%s\""
00248 #define GET_COMPID_FROM_TRASH "select ComponentId from TRASH where DeletedTime > %d AND CalendarId = %d AND ComponentType= %d"
00249 #define SELECT_PROP_AND "select * from Parameters where ComponentId=\"%s\" AND\
00250 PropertyType = \"%s\" AND PropertyValue = \"%s\""
00251 #define SELECT_DISTINCT_PROP "select distinct PropertyValue from Parameters where ComponentId = \"%s\" AND\
00252 PropertyType = \"%s\""
00253 #define SELECT_UPCOMING_EVENT "select Id,calendarId,summary,DateStart from components where ID not in (select Id from components where AllDay=%d AND DateStart <= %d AND DateEnd >= %d AND componentType = %d )AND DateStart >= %d AND ComponentType=%d ORDER BY DateStart,Summary LIMIT 1 OFFSET %d"
00254 #define SELECT_UPCOMING_TODO "select Id,calendarId,summary,DateStart from components where DateStart >= %d AND ComponentType=%d AND status =%d ORDER BY Datestart,summary LIMIT 1 OFFSET %d"
00255 #define INDEX_CALENDAR "CREATE INDEX IF NOT EXISTS IDX_CALENDAR on Calendars(CalendarId,Name)"
00256 #define INDEX_COMPONENT "CREATE INDEX IF NOT EXISTS IDX_COMPONENT on Components(Id,ComponentType,DateStart,DateEnd,status,Until,ModifiedTime)"
00257 #define INDEX_COMPONENT_DETAILS "CREATE INDEX IF NOT EXISTS IDX_DETAILS on ComponentDetails(Id,ComponentType)"
00258 #define INDEX_RECURSIVE "CREATE INDEX IF NOT EXISTS IDX_RECURSIVE on RECURSIVE(Id)"
00259 #define INDEX_ALARM "CREATE INDEX IF NOT EXISTS IDX_ALARM on ALARM(Id,CookieId)"
00260 #define INDEX_PARAM "CREATE INDEX IF NOT EXISTS IDX_PARAM on Parameters(ComponentId TEXT, PropertyType TEXT,PropertyValue,ParamName)"
00261 #define INDEX_TRASH "CREATE INDEX IF NOT EXISTS IDX_TRASH on TRASH(ComponentId,CalendarId,deletedTime)"
00262 #define SELECT_DUPLICATE_ENTRY "select Id from Components where summary = \"%s\" AND dateStart = %d AND ComponentType = %d AND CalendarId = %d "
00263 #define SELECT_DUPLICATE_EVENT "select Id from Components where summary = \"%s\" AND dateStart = %d AND ComponentType = %d AND CalendarId = %d AND \
00264 (location = \"%s\" OR location =\"\") and (Description =\"%s\" OR Description = \"\")"
00265 #define SELECT_ENTRY_RETAIN "select Id from components where ModifiedTime > %d and Id = \"%s\""
00266 #define SELECT_PREV_COMPONENT "select * from components where Id != \"%s\" AND DateStart < %d AND componentType = %d ORDER BY DateStart DESC,Summary DESC"
00267 #define SELECT_NEXT_COMPONENT "select * from components where Id != \"%s\" AND DateStart > %d AND componentType = %d ORDER BY DateStart,Summary"
00268 #define SELECT_MAX_FIELD "select value from UTILITY where Name= \"%s\""
00269 #define SELECT_PREV_NEXT_ALLDAY "select * from components where Allday =1 and DateStart <= %d and DateEnd>= %d ORDER BY Summary"
00270 #define SELECT_ALL_CALCOMP__UNION "select * from %s where %s = %d AND %s >= %d AND %s <= %d AND (%s != %d AND %s != %d) union select * from %s where %s = %d AND (%s = %d OR %s = %d) AND (%d < %s OR %d = %s) LIMIT %d OFFSET %d"
00271 #define SELECT_ACTIVE_ALARM "select Id from Alarm where Id in (select Id from components where calendarid = %d) AND CookieId != \"%s\" AND Trigger >= %d "
00272 #define SELECT_VISIBLE_ALARM "select Id from Alarm where Id in (select Id from components where calendarid = %d) AND CookieId = \"%s\" AND Trigger >= %d "
00273 #define SELECT_ALL_ENTRIES "select * from %s where %s = %d AND %s=%d LIMIT %d OFFSET %d"
00274 #if 0
00275 #define SELECT_EVENTS_TODOS_OFFSET_LIMIT_UNION "select * from %s where %s = %d AND (%s = %d OR %s=%d) AND (%s < %d AND %s > %d) AND (%s != %d AND %s != %d) union select * from %s where %s = %d AND (%s = %d OR %s=%d) AND (%s = %d OR %s = %d) AND (%d < %s OR %d = %s) LIMIT %d OFFSET %d "
00276 #endif
00277 #define SELECT_EVENTS_TODOS_OFFSET_LIMIT_UNION "select * from %s where %s = %d AND ((%s = %d AND %s < %d AND %s > %d) OR ( %s = %d AND %s >= %d AND %s <= %d )) AND (%s != %d AND %s != %d) union select * from %s where %s = %d AND (%s = %d OR %s=%d) AND (%s = %d OR %s = %d) AND (%d < %s OR %d = %s) LIMIT %d OFFSET %d "
00278
00279 #define GET_EXPIRED_NONRECURSIVE_EVENTS "select %s from components where %s= %d and %s= %d and %s < %d and ( %s != %d AND %s!=%d) "
00280 #define GET_EXPIRED_RECURSIVE_EVENTS "select %s from components where %s= %d and %s= %d and ( %s = %d OR %s=%d)"
00281
00282 #endif
00283
00284
00285
