Calendar database: Difference between revisions
From Maemo Wiki
Jump to navigationJump to search
imported>pir2 New page: 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/... |
imported>pir2 No edit summary |
||
| 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 | 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. | ||
= Scripts = | |||
= Structure = | = Structure = | ||
== Tables & fields == | == Tables & fields == | ||
=== ALARM === | === ALARM === | ||
=== Id ==== | ==== Id ==== | ||
=== Trigger === | ==== Trigger ==== | ||
=== Repeat === | ==== Repeat ==== | ||
=== Duration === | ==== Duration ==== | ||
=== Action === | ==== Action ==== | ||
=== CookieId === | ==== CookieId ==== | ||
=== Attach === | ==== Attach ==== | ||
== Birthdays == | |||
=== Id === | === Birthdays === | ||
=== DayMonth === | ==== Id ==== | ||
=== Year === | ==== DayMonth ==== | ||
== Calendars == | ==== Year ==== | ||
=== CalendarId === | |||
Name | === Calendars === | ||
Colour | ==== CalendarId ==== | ||
IsVisible | ==== Name ==== | ||
IsReadonly | ==== Colour ==== | ||
CalendarType | ==== IsVisible ==== | ||
CalendarTune | ==== IsReadonly ==== | ||
CalendarVersion | ==== CalendarType ==== | ||
CalendarProfile | ==== CalendarTune ==== | ||
== Componentdetails == | ==== CalendarVersion ==== | ||
Id | ==== CalendarProfile ==== | ||
ComponentType | |||
Class | === Componentdetails === | ||
geo | ==== Id ==== | ||
Priority | ==== ComponentType ==== | ||
DateStamp | ==== Class ==== | ||
Sequence | ==== geo ==== | ||
Transparency | ==== Priority ==== | ||
Uid | ==== DateStamp ==== | ||
Url | ==== Sequence ==== | ||
Attach | ==== Transparency ==== | ||
Category | ==== Uid ==== | ||
Comment | ==== Url ==== | ||
Contact | ==== Attach ==== | ||
Related | ==== Category ==== | ||
Resources | ==== Comment ==== | ||
Percent | ==== Contact ==== | ||
Completed | ==== Related ==== | ||
== Components == | ==== Resources ==== | ||
Id | ==== Percent ==== | ||
CalendarId | ==== Completed ==== | ||
ComponentType | |||
Flags | === Components === | ||
SateStart | ==== Id ==== | ||
DateEnd | ==== CalendarId ==== | ||
Summary | ==== ComponentType ==== | ||
Location | ==== Flags ==== | ||
Description | ==== SateStart ==== | ||
Status | ==== DateEnd ==== | ||
uid | ==== Summary ==== | ||
Until | ==== Location ==== | ||
AllDay | ==== Description ==== | ||
CreatedTime | ==== Status ==== | ||
ModifiedTime | ==== uid ==== | ||
Tzid | ==== Until ==== | ||
TzOffset | ==== AllDay ==== | ||
== IDMAP == | ==== CreatedTime ==== | ||
LocalId | ==== ModifiedTime ==== | ||
ExternalId | ==== Tzid ==== | ||
== Instances == | ==== TzOffset ==== | ||
Id | |||
DateStart | === IDMAP === | ||
DateEnd | ==== LocalId ==== | ||
== Parameters == | ==== ExternalId ==== | ||
ComponentId | |||
PropertyType | === Instances === | ||
PropertyValue | ==== Id ==== | ||
ParamName | ==== DateStart ==== | ||
ParamValue | ==== DateEnd ==== | ||
== RECURSIVE == | |||
Id | === Parameters === | ||
Rrule | ==== ComponentId ==== | ||
Rdates | ==== PropertyType ==== | ||
Exdates | ==== PropertyValue ==== | ||
Exrule | ==== ParamName ==== | ||
RecurrenceId | ==== ParamValue ==== | ||
Rtype | |||
== TIMEZONE == | === RECURSIVE === | ||
Location | ==== Id ==== | ||
Tzid | ==== Rrule ==== | ||
DtStartStd | ==== Rdates ==== | ||
DtStartDst | ==== Exdates ==== | ||
TzOffsetStd | ==== Exrule ==== | ||
TzOffsetDst | ==== RecurrenceId ==== | ||
RRuleStd | ==== Rtype ==== | ||
RRuleDst | |||
TzName | === TIMEZONE === | ||
DSTFlag | ==== Location ==== | ||
== Trash == | ==== Tzid ==== | ||
ComponentId | ==== DtStartStd ==== | ||
CalendarId | ==== DtStartDst ==== | ||
ComponentType | ==== TzOffsetStd ==== | ||
DeletedTime | ==== TzOffsetDst ==== | ||
CreatedTime | ==== RRuleStd ==== | ||
== XProperties == | ==== RRuleDst ==== | ||
ComponentId | ==== TzName ==== | ||
XPropertyName | ==== DSTFlag ==== | ||
XPropertyValue | |||
== sqlite_sequence == | === Trash === | ||
name | ==== ComponentId ==== | ||
seq | ==== 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 === | |||
[[Category:Calendar]] | [[Category:Calendar]] | ||
Revision as of 00:03, 20 September 2010
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.
