Avatar for Username

Prohledat stránky podpory

Vyhněte se podvodům. Za účelem poskytnutí podpory vás nikdy nežádáme, abyste zavolali nebo poslali SMS na nějaké telefonní číslo nebo abyste sdělili své osobní údaje. Jakékoliv podezřelé chování nám prosím nahlaste pomocí odkazu „Nahlásit zneužití“.

Zjistit více

Toto vlákno bylo archivováno. Pokud potřebujete pomoci, založte prosím nový dotaz.

Where is calendar name stored in sqlite?

  • 2 odpovědi
  • 1 má tento problém
  • 6 zobrazení
  • Poslední odpověď od Mark Foley

Mark Foley
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?

Zvolené řešení

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

Přečíst dotaz v kontextu 👍 0

Všechny odpovědi (2)

Matt
Matt
  • Moderator
  • Top 10 Contributor
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

Upravil uživatel Matt dne

Mark Foley
Mark Foley Autor dotazu
more options

Zvolené řešení

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