The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
TypeScript analyticsbibusiness-intelligencebusinessintelligenceclojuredashboarddatadata-analysisdata-visualizationdatabasemetabasemysqlpostgrespostgresqlreportingslacksql-editorvisualization
DELETE FROM permissions
WHERE id IN (
SELECT p.id
FROM permissions p
LEFT OUTER JOIN collection c
ON p.object = '/collection/' || c.id || '/' OR p.object = '/collection/' || c.id || '/read/'
WHERE c.id IS NULL AND REGEXP_LIKE(p.object, '^/collection/\d+/(read/)?$')
);
UPDATE permissions p SET collection_id = (
SELECT id
FROM collection c
WHERE p.object = '/collection/' || c.id || '/'
OR p.object = '/collection/' || c.id || '/read/'
),
perm_value = CASE
WHEN object like '/collection/%/read/' THEN 'read'
ELSE 'read-and-write'
END,
perm_type = 'perms/collection-access'
WHERE object LIKE '/collection/%';