ค้นหาฝ่ายสนับสนุน

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 คนมีปัญหานี้
  • 9 ครั้งที่ดู
  • ตอบกลับล่าสุดโดย 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

การตอบกลับทั้งหมด (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");