Calendar database

m (CalendarTune)
(wikify section headings)
Line 1: Line 1:
-
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 tasks.
+
The calendar database can be found in <code>/home/user/.calendar/calendardb</code>. The goal of this article 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 tasks.
-
If you want to help editing this wiki and writing useful informations on fields or new scripts, feel free to copy your own database on your computer and analyze it with some tools like "SQLite Database Browser" (Linux/Debian).
+
If you want to help editing this article and writing useful informations on fields or new scripts, feel free to copy your own database on your computer and analyze it with some tools like "SQLite Database Browser" (Linux/Debian).
-
= Scripts =
+
== Scripts ==
-
= Structure =
+
== Structure ==
-
== Tables & fields ==
+
=== Tables & fields ===
-
=== ALARM ===
+
==== ALARM ====
-
==== Id ====
+
===== Id =====
-
==== Trigger ====
+
===== Trigger =====
-
==== Repeat ====
+
===== Repeat =====
-
==== Duration ====
+
===== Duration =====
-
==== Action ====
+
===== Action =====
-
==== CookieId ====
+
===== CookieId =====
-
==== Attach ====
+
===== Attach =====
-
=== Birthdays ===
+
==== Birthdays ====
-
==== Id ====
+
===== Id =====
-
==== DayMonth ====
+
===== DayMonth =====
-
==== Year ====
+
===== Year =====
-
=== Calendars ===
+
==== Calendars ====
-
==== CalendarId ====
+
===== CalendarId =====
-
==== Name ====
+
===== Name =====
-
==== Colour ====
+
===== Colour =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 49: Line 49:
|}
|}
-
==== IsVisible ====
+
===== IsVisible =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 58: Line 58:
|}
|}
-
==== IsReadonly ====
+
===== IsReadonly =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 67: Line 67:
|}
|}
-
==== CalendarType ====
+
===== CalendarType =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 82: Line 82:
|}
|}
-
==== CalendarTune ====
+
===== CalendarTune =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
| <txt> || path to the calendar alarm sound
| <txt> || path to the calendar alarm sound
|-
|-
-
| /usr/share/sounds/ui-calendar_alarm_default.aac || default alarm
+
| <code>/usr/share/sounds/ui-calendar_alarm_default.aac</code> || default alarm
|-
|-
|}
|}
-
==== CalendarVersion ====
+
===== CalendarVersion =====
-
==== CalendarProfile ====
+
===== CalendarProfile =====
-
=== ComponentDetails ===
+
==== ComponentDetails ====
-
==== Id ====
+
===== Id =====
-
==== ComponentType ====
+
===== ComponentType =====
-
==== Class ====
+
===== Class =====
-
==== Geo ====
+
===== Geo =====
-
==== Priority ====
+
===== Priority =====
-
==== DateStamp ====
+
===== DateStamp =====
-
==== Sequence ====
+
===== Sequence =====
-
==== Transparency ====
+
===== Transparency =====
-
==== Uid ====
+
===== Uid =====
-
==== Url ====
+
===== Url =====
-
==== Attach ====
+
===== Attach =====
-
==== Category ====
+
===== Category =====
-
==== Comment ====
+
===== Comment =====
-
==== Contact ====
+
===== Contact =====
-
==== Related ====
+
===== Related =====
-
==== Resources ====
+
===== Resources =====
-
==== Percent ====
+
===== Percent =====
-
==== Completed ====
+
===== Completed =====
-
=== Components ===
+
==== Components ====
-
==== Id ====
+
===== Id =====
-
==== CalendarId ====
+
===== CalendarId =====
-
==== ComponentType ====
+
===== ComponentType =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 130: Line 130:
|}
|}
-
==== Flags ====
+
===== Flags =====
-
==== DateStart ====
+
===== DateStart =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 138: Line 138:
|}
|}
-
==== DateEnd ====
+
===== DateEnd =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 147: Line 147:
|}
|}
-
==== Summary ====
+
===== Summary =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 154: Line 154:
|}
|}
-
==== Location ====
+
===== Location =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 161: Line 161:
|}
|}
-
==== Description ====
+
===== Description =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 168: Line 168:
|}
|}
-
==== Status ====
+
===== Status =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 181: Line 181:
|}
|}
-
==== Uid ====
+
===== Uid =====
-
==== Until ====
+
===== Until =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 192: Line 192:
|}
|}
-
==== AllDay ====
+
===== AllDay =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 201: Line 201:
|}
|}
-
==== CreatedTime ====
+
===== CreatedTime =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 208: Line 208:
|}
|}
-
==== ModifiedTime ====
+
===== ModifiedTime =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 215: Line 215:
|}
|}
-
==== Tzid ====
+
===== Tzid =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 224: Line 224:
|}
|}
-
==== TzOffset ====
+
===== TzOffset =====
:{| class="wikitable"
:{| class="wikitable"
|-
|-
Line 233: Line 233:
|}
|}
-
=== IDMAP ===
+
==== IDMAP ====
-
==== LocalId ====
+
===== LocalId =====
-
==== ExternalId ====
+
===== ExternalId =====
-
=== Instances ===
+
==== Instances ====
-
==== Id ====
+
===== Id =====
-
==== DateStart ====
+
===== DateStart =====
-
==== DateEnd ====
+
===== DateEnd =====
-
=== Parameters ===
+
==== Parameters ====
-
==== ComponentId ====
+
===== ComponentId =====
-
==== PropertyType ====
+
===== PropertyType =====
-
==== PropertyValue ====
+
===== PropertyValue =====
-
==== ParamName ====
+
===== ParamName =====
-
==== ParamValue ====
+
===== ParamValue =====
-
=== RECURSIVE ===
+
==== RECURSIVE ====
-
==== Id ====
+
===== Id =====
-
==== Rrule ====
+
===== Rrule =====
-
==== Rdates ====
+
===== Rdates =====
-
==== Exdates ====
+
===== Exdates =====
-
==== Exrule ====
+
===== Exrule =====
-
==== RecurrenceId ====
+
===== RecurrenceId =====
-
==== Rtype ====
+
===== Rtype =====
-
=== TIMEZONE ===
+
==== TIMEZONE ====
-
==== Location ====
+
===== Location =====
-
==== Tzid ====
+
===== Tzid =====
-
==== DtStartStd ====
+
===== DtStartStd =====
-
==== DtStartDst ====
+
===== DtStartDst =====
-
==== TzOffsetStd ====
+
===== TzOffsetStd =====
-
==== TzOffsetDst ====
+
===== TzOffsetDst =====
-
==== RRuleStd ====
+
===== RRuleStd =====
-
==== RRuleDst ====
+
===== RRuleDst =====
-
==== TzName ====
+
===== TzName =====
-
==== DSTFlag ====
+
===== DSTFlag =====
-
=== Trash ===
+
==== Trash ====
-
==== ComponentId ====
+
===== ComponentId =====
-
==== CalendarId ====
+
===== CalendarId =====
-
==== ComponentType ====
+
===== ComponentType =====
-
==== DeletedTime ====
+
===== DeletedTime =====
-
==== CreatedTime ====
+
===== CreatedTime =====
-
=== XProperties ===
+
==== XProperties ====
-
==== ComponentId ====
+
===== ComponentId =====
-
==== XPropertyName ====
+
===== XPropertyName =====
-
==== XPropertyValue ====
+
===== XPropertyValue =====
-
=== sqlite_sequence ===
+
==== sqlite_sequence ====
-
==== name ====
+
===== name =====
-
==== seq ====
+
===== seq =====
-
== Indices ==
+
=== Indices ===
-
=== IDX_ALARM ===
+
==== IDX_ALARM ====
-
=== IDX_BIRTHDAYS_DATE ===
+
==== IDX_BIRTHDAYS_DATE ====
-
=== IDX_BIRTHDAYS_IDS ===
+
==== IDX_BIRTHDAYS_IDS ====
-
=== IDX_CALENDAR ===
+
==== IDX_CALENDAR ====
-
=== IDX_COMPONENT ===
+
==== IDX_COMPONENT ====
-
=== IDX_DETAILS ===
+
==== IDX_DETAILS ====
-
=== IDX_INST ===
+
==== IDX_INST ====
-
=== IDX_RECURSIVE ===
+
==== IDX_RECURSIVE ====
-
=== IDX_TIMEZONE ===
+
==== IDX_TIMEZONE ====
-
=== IDX_TRASH ===
+
==== IDX_TRASH ====
[[Category:Calendar]]
[[Category:Calendar]]

Revision as of 08:07, 20 September 2010

The calendar database can be found in /home/user/.calendar/calendardb. The goal of this article 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 tasks.

If you want to help editing this article and writing useful informations on fields or new scripts, feel free to copy your own database on your computer and analyze it with some tools like "SQLite Database Browser" (Linux/Debian).

Contents

Scripts

Structure

Tables & fields

ALARM

Id
Trigger
Repeat
Duration
Action
CookieId
Attach

Birthdays

Id
DayMonth
Year

Calendars

CalendarId
Name
Colour
0 dark blue
1 green
2 dark pink
3 orange
4 purple
5 yellow
6 white
7 light blue
8 light pink
9 yellow-green
IsVisible
0 not visible
1 visible
IsReadonly
0 writeable
1 not writeable
CalendarType
0 local
1 intelligent
2
3 private
4 synchronized
CalendarTune
<txt> path to the calendar alarm sound
/usr/share/sounds/ui-calendar_alarm_default.aac default alarm
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
1 event
2 task
3 note
4 birthday
Flags
DateStart
<int> UTC start date in Unix Time Format (number of seconds since 01/01/1970)
DateEnd
-1 undefined
<int> UTC end date in Unix Time Format (number of seconds since 01/01/1970)
Summary
<txt> title [event, task, note, birthday]
Location
<txt> location [event]
Description
<txt> comments [event, task, note]
Status
-1 undefined [event, note]
0 uncomplete [task]
1 complete [task]
<yyyy> year [birthday]
Uid
Until
-1 none [event, task, note]
<int> end date of a recurrence [event, birthday]
2145913199 end of calendar / limit of the Unix Time Format
AllDay
0 in limited time [event, task, note]
1 all day [event, birthday]
CreatedTime
<int> date of creation
ModifiedTime
<int> last date of modification
Tzid
<txt> time zone identifier
 :Europe/Paris France time zone
TzOffset
<txt> time zone offset in seconds compared to UTC
7200 France time zone offset (2 hours)

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

Indices

IDX_ALARM

IDX_BIRTHDAYS_DATE

IDX_BIRTHDAYS_IDS

IDX_CALENDAR

IDX_COMPONENT

IDX_DETAILS

IDX_INST

IDX_RECURSIVE

IDX_TIMEZONE

IDX_TRASH