Skip to content

Instantly share code, notes, and snippets.

@lduboeuf
Last active May 17, 2024 09:42
Show Gist options
  • Save lduboeuf/3d67a95c1e2ecc5e8972480625693d8b to your computer and use it in GitHub Desktop.
Save lduboeuf/3d67a95c1e2ecc5e8972480625693d8b to your computer and use it in GitHub Desktop.
Contact sync
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+ bin it 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
python3 -m radicale --storage-filesystem-folder=~/.var/lib/radicale/collections --config "" --server-hosts 0.0.0.0:5232
@lduboeuf
Copy link
Author

BT test:
hcitool scan -> bt address
https://github.com/bmwcarit/pypbap

@lduboeuf
Copy link
Author

lduboeuf commented May 16, 2024

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/

@lduboeuf
Copy link
Author

dconf:
dconf list /org/nemomobile/contacts/

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment