set_permission_for_attribute.sql
1-- set_permission_for_attribute.sql
2BEGIN TRANSACTION;
3INSERT INTO attributes (key, value) VALUES (?, ?) ON CONFLICT DO NOTHING;
4INSERT INTO permissions (resource_type, resource_id, attribute_id, permissions)
5 VALUES (
6 ?,
7 ?,
8 (SELECT rowid FROM attributes WHERE key=? AND value=?),
9 ?
10 )
11ON CONFLICT
12 DO UPDATE SET permissions=excluded.permissions;
13COMMIT;
14