Where is calendar name stored in sqlite?
Since Lightning doesn't periodically update published iCals, I've created a script to do it myself by querying the sqlite database. No problem, except that now I have a user with two calendars. I can find both cal_id's by "select distinct cal_id from cal_events", which gives me two 36 bytes strings, but which is for which calendar? I can figure it out by comparing my script output with the original published calendars, but that is time consuming and will require my manual intervention whenever a person happens to publish 2 or more calendars.
Is there something in the database, or some config file that correlates calendar name with cal_id? Of course, there must be or Lightning wouldn't be able to find the calendar data by calendar name! I guess the question is, where is is this kept and is it accessible by me?
Chosen solution
I found the answer by grepping the files in the Thunderbird Profiles directory:
.../Profiles/<myProfileName>/prefs.js
e.g.: prefs.js:user_pref("calendar.registry.2d738716-98a2-491b-b640-1b9d640a4135.name", "Holly's Calendar");
Read this answer in context 👍 0All Replies (2)
Really I am beyond my skill level with your questions. I suggest you ask them where developers hang out. like the mozilla.dev.apps.thunderbird newsgroup.
There is a google groups mirror here https://groups.google.com/forum/#!forum/mozilla.dev.apps.thunderbird
Modified by Matt
Chosen Solution
I found the answer by grepping the files in the Thunderbird Profiles directory:
.../Profiles/<myProfileName>/prefs.js
e.g.: prefs.js:user_pref("calendar.registry.2d738716-98a2-491b-b640-1b9d640a4135.name", "Holly's Calendar");