Contact sync

contact-sync buteo & mkcal

syncevolution:
syncevolution --print-databases
syncevolution --remove-database backend=evolution-calendar database=f2636fba81f637f5591563e57913ca38cdd306d3

Buteo debug:
systemctl --user set-environment QT_LOGGING_RULES="buteo.*.debug=true"
systemctl --user restart msyncd.service
Account service:
sudo systemctl restart accounts-daemon.service
db: /home/phablet/.config/libaccounts-glib/accounts.db
Buteo profiles:
/etc/buteo/profiles/sync/* 
They are copied when creating the account with address-book-app in .local/share/system/privileged/msyncd/

Sqlite db:
/home/phablet/.local/share/system/privileged/Contacts/qtcontacts-sqlite/contacts.db


No way to identify reliably the current birthday calendar



Buteo social sync: google calendars and contacts
buteo plugins use the service name which is the file name of the service ( under /usr/share/accounts/service/lomiri ) and must be set explicitely "google-contacts" for contacts and "google-calendars" for calendar.

Buteo caldav and carrdav sync:
buteo plugins use the service type, and must be set to "carddav" and "caldav" respectively, -> application configuration must be defined with it:
e.g lomiri-calendar-app.application:
<service-type id="caldav">
      <description>Synchronize your calendar</description>
</service-type>

The buteo profile and service link is done with the configuration in /etc/buteo/profiles/sync 
e.g: <key name="remote_service_name" value="lomiri-nextcloud-caldav"/>

But for google, the sync profile file name must be the same as the service name...

radicale

python3 -m radicale --storage-filesystem-folder=~/.var/lib/radicale/collections --config "" --server-hosts 0.0.0.0:5232

sqlite3 /home/phablet/.local/share/system/privileged/Contacts/qtcontacts-sqlite/contacts.db
.load libSqliteIcu.so sqlite3_icu_init

SELECT icu_load_collation('fr_FR', 'localeCollation');

sqlite> CREATE VIRTUAL TABLE enrondata1 USING fts3(content TEXT);
sqlite> INSERT INTO enrondata1 "eloise";
Error: near ""eloise"": syntax error
sqlite> INSERT INTO enrondata1 VALUES ("eloise");
sqlite> INSERT INTO enrondata1 VALUES ("éloise");
sqlite> SELECT * FROM enrondata1 WHERE content LIKE 'e%';
eloise
sqlite> SELECT * FROM enrondata1 WHERE content like('e%');
eloise
sqlite> SELECT * FROM enrondata1 WHERE content like('é%');

https://blog.slucas.fr/blog/sqlite-icu-extension-1/

dconf:
dconf list /org/nemomobile/contacts/

dconf read /org/nemomobile/contacts/group-property
dconf write /org/nemomobile/contacts/group-property "'lastName'"

change schedule of a sync profile:

dbus-send --session --type=method_call --print-reply --dest=com.meego.msyncd /synchronizer com.meego.msyncd.setSyncSchedule string:'4037861233' string:''

get alarms:
sqlite3 /home/phablet/.local/share/system/privileged/msyncd/alarms.db.sqlite "SELECT * FROM alarms;"

online account debug:
https://github.com/ubports/docs.ubports.com/blob/526b569eb0f1279abcd2937a062b48a0546230e2/systemdev/online-accounts.rst#L10
export OAU_LOGGING_LEVEL=2
export OAU_DAEMON_TIMEOUT=9999
/usr/bin/lomiri-online-accounts-service