\LibMelanie\SqlSqlCalendarRequests

Liste des requêtes SQL vers les calendriers

Summary

Methods

Properties

Constants

No public methods found

No public properties found

listAllEvents
listAllEventsFreebusy
getEvent
getListEvents
getListEventsNoMerge
getOptiListEvents
getCountEvents
updateEvent
updateMeetingEtag
insertEvent
deleteEvent
getCTag
getSyncToken

No protected methods found

No protected properties found

N/A

No private methods found

No private properties found

N/A

Constants

listAllEvents

listAllEvents ="SELECT k1.*, k2.event_creator_id as organizer_uid, k2.event_attendees as organizer_attendees, k2.calendar_id as organizer_calendar FROM kronolith_events k1 LEFT JOIN kronolith_events k2 ON k1.event_uid = k2.event_uid AND k1.organizer_calendar_id = k2.calendar_id WHERE k1.calendar_id = :calendar_id{event_range};" :string

listAllEventsFreebusy

listAllEventsFreebusy ="SELECT k1.* FROM kronolith_events k1 WHERE k1.calendar_id = :calendar_id{event_range};" :string

getEvent

getEvent ="SELECT k1.*, k2.event_creator_id as organizer_uid, k2.event_attendees as organizer_attendees, k2.calendar_id as organizer_calendar FROM kronolith_events k1 LEFT JOIN kronolith_events k2	ON k1.event_uid = k2.event_uid AND k1.organizer_calendar_id = k2.calendar_id WHERE k1.calendar_id = :calendar_id AND k1.event_uid = :event_uid;" :string

getListEvents

getListEvents ="SELECT {fields_list}, k2.event_creator_id as organizer_uid, k2.event_attendees as organizer_attendees, k2.calendar_id as organizer_calendar FROM kronolith_events k1 LEFT JOIN kronolith_events k2 ON k1.event_uid = k2.event_uid AND k1.organizer_calendar_id = k2.calendar_id WHERE {where_clause};" :string

getListEventsNoMerge

getListEventsNoMerge ="SELECT {fields_list} FROM kronolith_events k1 WHERE {where_clause};" :string

getOptiListEvents

getOptiListEvents ="SELECT {fields_list} FROM kronolith_events k1 WHERE {where_clause};" :string

getCountEvents

getCountEvents ="SELECT count(*) as events_count FROM kronolith_events k1 WHERE {where_clause};" :string

updateEvent

updateEvent ="UPDATE kronolith_events SET {event_set} WHERE calendar_id = :calendar_id AND event_uid = :event_uid;" :string

updateMeetingEtag

updateMeetingEtag ="UPDATE kronolith_events SET event_modified = event_modified + 1,  event_modified_json = event_modified_json + 1 WHERE event_uid = :event_uid;" :string

insertEvent

insertEvent ="INSERT INTO kronolith_events ({data_fields}) VALUES ({data_values});" :string

deleteEvent

deleteEvent ="DELETE FROM kronolith_events WHERE calendar_id = :calendar_id AND event_uid = :event_uid;" :string

getCTag

getCTag ="SELECT datatree_ctag as ctag FROM horde_datatree WHERE datatree_name = :calendar_id AND group_uid = 'horde.shares.kronolith'" :string

getSyncToken

getSyncToken ="SELECT datatree_synctoken as synctoken FROM horde_datatree WHERE datatree_name = :calendar_id AND group_uid = 'horde.shares.kronolith'" :string