Calendar database

The calendar database can be found in /home/user/.calendar/calendardb. The goal of this wiki is to provide enough information on the calendar database in order to implement mass modifying/adding/deleting events verifying some criterias (string match in title, locations, comments for example). It could be easy then to write a small shell script using zenity and sqlite3 to perform this kind of tasks.

= Structure =

CalendarId
Name Colour IsVisible IsReadonly CalendarType CalendarTune CalendarVersion CalendarProfile

Componentdetails
Id ComponentType Class geo Priority DateStamp Sequence Transparency Uid Url Attach Category Comment Contact Related Resources Percent Completed

Components
Id CalendarId ComponentType Flags SateStart DateEnd Summary Location Description Status uid Until AllDay CreatedTime ModifiedTime Tzid TzOffset

IDMAP
LocalId ExternalId

Instances
Id DateStart DateEnd

Parameters
ComponentId PropertyType PropertyValue ParamName ParamValue

RECURSIVE
Id Rrule Rdates Exdates Exrule RecurrenceId Rtype

TIMEZONE
Location Tzid DtStartStd DtStartDst TzOffsetStd TzOffsetDst RRuleStd RRuleDst TzName DSTFlag

Trash
ComponentId CalendarId ComponentType DeletedTime CreatedTime

XProperties
ComponentId XPropertyName XPropertyValue

sqlite_sequence
name seq