সহায়তা খুঁজুন

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

আরও জানুন

Where is calendar name stored in sqlite?

  • 2 উত্তরসমূহ
  • 1 এই সমস্যাটি আছে
  • 6 দেখুন
  • শেষ জবাব দ্বারা Mark Foley

more options

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?

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?

সমাধান চয়ন করুন

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");

প্রেক্ষাপটে এই উত্তরটি পড়ুন। 👍 0

All Replies (2)

more options

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

Matt দ্বারা পরিমিত

more options

চয়ন করা সমাধান

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");