Editing Calendar database
Warning: You are not logged in.
Your IP address will be recorded in this page's edit history.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
The [[Open development/Maemo roadmap/Fremantle|Maemo 5]] 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. | The [[Open development/Maemo roadmap/Fremantle|Maemo 5]] 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 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). | + | 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). |
- | + | ||
+ | == [[#toc|Scripts]] == | ||
+ | |||
== [[#toc|Structure]] == | == [[#toc|Structure]] == | ||
=== [[#toc|Tables & fields]] === | === [[#toc|Tables & fields]] === | ||
+ | ---- | ||
==== [[#toc|ALARM]] ==== | ==== [[#toc|ALARM]] ==== | ||
- | + | ---- | |
===== Id ===== | ===== Id ===== | ||
===== Trigger ===== | ===== Trigger ===== | ||
Line 16: | Line 19: | ||
===== Attach ===== | ===== Attach ===== | ||
+ | ---- | ||
==== [[#toc|Birthdays]] ==== | ==== [[#toc|Birthdays]] ==== | ||
+ | ---- | ||
+ | ===== Id ===== | ||
+ | ===== DayMonth ===== | ||
+ | ===== Year ===== | ||
- | {| class="wikitable" | + | ---- |
- | + | ==== [[#toc|Calendars]] ==== | |
+ | ---- | ||
+ | ===== CalendarId ===== | ||
+ | ===== Name ===== | ||
+ | ===== Colour ===== | ||
+ | :{| class="wikitable" | ||
|- | |- | ||
- | + | | 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 ===== |
+ | :{| class="wikitable" | ||
+ | |- | ||
+ | | 0 || not visible | ||
+ | |- | ||
+ | | 1 || visible | ||
+ | |- | ||
+ | |} | ||
- | {| class="wikitable" | + | ===== IsReadonly ===== |
- | + | :{| class="wikitable" | |
|- | |- | ||
- | + | | 0 || writeable | |
|- | |- | ||
- | | | + | | 1 || not writeable |
|- | |- | ||
- | | | + | |} |
+ | |||
+ | ===== CalendarType ===== | ||
+ | :{| class="wikitable" | ||
|- | |- | ||
- | | | + | | 0 || local |
|- | |- | ||
- | | | + | | 1 || intelligent |
|- | |- | ||
- | | | + | | 2 || |
|- | |- | ||
- | | | + | | 3 || private |
+ | |- | ||
+ | | 4 || synchronized | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | ===== CalendarTune ===== | ||
+ | :{| class="wikitable" | ||
|- | |- | ||
- | | | + | | <txt> || path to the calendar alarm sound |
|- | |- | ||
- | | | + | | <code>/usr/share/sounds/ui-calendar_alarm_default.aac</code> || default alarm |
|- | |- | ||
- | |||
|} | |} | ||
- | ==== | + | ===== CalendarVersion ===== |
+ | ===== CalendarProfile ===== | ||
+ | ---- | ||
+ | ==== [[#toc|ComponentDetails]] ==== | ||
+ | ---- | ||
===== Id ===== | ===== Id ===== | ||
===== ComponentType ===== | ===== ComponentType ===== | ||
Line 77: | Line 122: | ||
===== Completed ===== | ===== Completed ===== | ||
+ | ---- | ||
==== [[#toc|Components]] ==== | ==== [[#toc|Components]] ==== | ||
+ | ---- | ||
+ | ===== Id ===== | ||
+ | :{| class="wikitable" | ||
+ | |- | ||
+ | | <int> || primary key | ||
+ | |- | ||
+ | |} | ||
+ | ===== CalendarId ===== | ||
+ | :{| class="wikitable" | ||
+ | |- | ||
+ | | <int> || [[#CalendarId|calendar identifier]] associated to the component | ||
+ | |- | ||
+ | |} | ||
- | {| class="wikitable" | + | ===== ComponentType ===== |
- | + | :{| class="wikitable" | |
|- | |- | ||
- | + | | 1 || event | |
|- | |- | ||
- | | | + | | 2 || task |
|- | |- | ||
- | | | + | | 3 || note |
|- | |- | ||
- | | | + | | 4 || birthday |
|- | |- | ||
- | | Flags | + | |} |
+ | |||
+ | ===== Flags ===== | ||
+ | ===== DateStart ===== | ||
+ | :{| class="wikitable" | ||
|- | |- | ||
- | | | + | | <int> || UTC start date in Unix Time Format (number of seconds since 01/01/1970) |
|- | |- | ||
- | | DateEnd | | + | |} |
+ | |||
+ | ===== DateEnd ===== | ||
+ | :{| class="wikitable" | ||
|- | |- | ||
- | | | + | | -1 || undefined |
|- | |- | ||
- | | | + | | <int> || UTC end date in Unix Time Format (number of seconds since 01/01/1970) |
|- | |- | ||
- | | | + | |} |
+ | |||
+ | ===== Summary ===== | ||
+ | :{| class="wikitable" | ||
|- | |- | ||
- | | | + | | <txt> || title [event, task, note, birthday] |
|- | |- | ||
- | | | + | |} |
+ | |||
+ | ===== Location ===== | ||
+ | :{| class="wikitable" | ||
|- | |- | ||
- | | | + | | <txt> || location [event] |
|- | |- | ||
- | | | + | |} |
+ | |||
+ | ===== Description ===== | ||
+ | :{| class="wikitable" | ||
|- | |- | ||
- | | | + | | <txt> || comments [event, task, note] |
|- | |- | ||
- | | | + | |} |
+ | |||
+ | ===== Status ===== | ||
+ | :{| class="wikitable" | ||
|- | |- | ||
- | | | + | | -1 || undefined [event, note] |
+ | |- | ||
+ | | 0 || uncomplete [task] | ||
+ | |- | ||
+ | | 1 || complete [task] | ||
+ | |- | ||
+ | | <yyyy> || year [birthday] | ||
|- | |- | ||
- | |||
|} | |} | ||
- | ==== | + | ===== Uid ===== |
+ | ===== Until ===== | ||
+ | :{| class="wikitable" | ||
+ | |- | ||
+ | | -1 || none [event, task, note] | ||
+ | |- | ||
+ | | <int> || end date of a recurrence [event, birthday] | ||
+ | |- | ||
+ | | 2145913199 || end of calendar / limit of the Unix Time Format | ||
+ | |} | ||
+ | ===== AllDay ===== | ||
+ | :{| class="wikitable" | ||
+ | |- | ||
+ | | 0 || in limited time [event, task, note] | ||
+ | |- | ||
+ | | 1 || all day [event, birthday] | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | ===== CreatedTime ===== | ||
+ | :{| class="wikitable" | ||
+ | |- | ||
+ | | <int> || date of creation | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | ===== ModifiedTime ===== | ||
+ | :{| class="wikitable" | ||
+ | |- | ||
+ | | <int> || last date of modification | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | ===== Tzid ===== | ||
+ | :{| class="wikitable" | ||
+ | |- | ||
+ | | <txt> || time zone identifier | ||
+ | |- | ||
+ | | :Europe/Paris || France time zone | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | ===== TzOffset ===== | ||
+ | :{| class="wikitable" | ||
+ | |- | ||
+ | | <txt> || time zone offset in seconds compared to UTC | ||
+ | |- | ||
+ | | 7200 || France time zone offset (2 hours) | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | ---- | ||
+ | |||
+ | ==== [[#toc|IDMAP]] ==== | ||
+ | ---- | ||
===== LocalId ===== | ===== LocalId ===== | ||
===== ExternalId ===== | ===== ExternalId ===== | ||
+ | ---- | ||
==== [[#toc|Instances]] ==== | ==== [[#toc|Instances]] ==== | ||
- | + | ---- | |
===== Id ===== | ===== Id ===== | ||
===== DateStart ===== | ===== DateStart ===== | ||
===== DateEnd ===== | ===== DateEnd ===== | ||
+ | ---- | ||
==== [[#toc|Parameters]] ==== | ==== [[#toc|Parameters]] ==== | ||
- | + | ---- | |
===== ComponentId ===== | ===== ComponentId ===== | ||
===== PropertyType ===== | ===== PropertyType ===== | ||
Line 138: | Line 277: | ||
===== ParamValue ===== | ===== ParamValue ===== | ||
+ | ---- | ||
==== [[#toc|RECURSIVE]] ==== | ==== [[#toc|RECURSIVE]] ==== | ||
- | + | ---- | |
===== Id ===== | ===== Id ===== | ||
===== Rrule ===== | ===== Rrule ===== | ||
Line 148: | Line 288: | ||
===== Rtype ===== | ===== Rtype ===== | ||
+ | ---- | ||
==== [[#toc|TIMEZONE]] ==== | ==== [[#toc|TIMEZONE]] ==== | ||
- | + | ---- | |
===== Location ===== | ===== Location ===== | ||
===== Tzid ===== | ===== Tzid ===== | ||
Line 161: | Line 302: | ||
===== DSTFlag ===== | ===== DSTFlag ===== | ||
- | + | ---- | |
==== [[#toc|Trash]] ==== | ==== [[#toc|Trash]] ==== | ||
- | + | ---- | |
===== ComponentId ===== | ===== ComponentId ===== | ||
===== CalendarId ===== | ===== CalendarId ===== | ||
Line 170: | Line 311: | ||
===== CreatedTime ===== | ===== CreatedTime ===== | ||
+ | ---- | ||
==== [[#toc|XProperties]] ==== | ==== [[#toc|XProperties]] ==== | ||
- | + | ---- | |
===== ComponentId ===== | ===== ComponentId ===== | ||
===== XPropertyName ===== | ===== XPropertyName ===== | ||
===== XPropertyValue ===== | ===== XPropertyValue ===== | ||
+ | ---- | ||
==== [[#toc|sqlite_sequence]] ==== | ==== [[#toc|sqlite_sequence]] ==== | ||
- | + | ---- | |
===== name ===== | ===== name ===== | ||
===== seq ===== | ===== seq ===== | ||
+ | |||
=== [[#toc|Indices]] === | === [[#toc|Indices]] === |
Learn more about Contributing to the wiki.