set_attribute_for_user.sql
1-- set_attribute_for_user.sql
2BEGIN TRANSACTION;
3INSERT INTO attributes (key, value) VALUES (?, ?) ON CONFLICT DO NOTHING;
4INSERT INTO attribute_user (attribute_id, user_id)
5 VALUES (
6 (SELECT rowid FROM attributes WHERE key=? AND value=?)
7 , ?)
8ON CONFLICT
9 DO NOTHING;
10COMMIT;
11