https://dev.entrouvert.org/https://dev.entrouvert.org/favicon.ico?15861920342015-12-16T11:31:51ZRedmine Entr’ouvertAuthentic 2 - Development #9324: Permission needs unique index and partial unique indexes to prevent duplicate due to get_or_create()https://dev.entrouvert.org/issues/9324?journal_id=386952015-12-16T11:31:51ZBenjamin Dauvergne
<ul><li><strong>Statut</strong> changé de <i>Nouveau</i> à <i>Solution déployée</i></li></ul><p>To find and remove existing duplicates:<br /><pre>delete from a2_rbac_permission where id in (select p.id from a2_rbac_role_permissions as rp right outer join a2_rbac_permission p on rp.permission_id = p.id left outer join a2_rbac_role as r on r.admin_scope_ct_id = 66 and r.admin_scope_id = p.id where rp.id is null and r.id is null);
</pre></p>
<pre>
commit 8a23dc8be0f9b1dd0995da6479bf439b9fc7c1e2
Author: Benjamin Dauvergne <bdauvergne@entrouvert.com>
Date: Mon Dec 14 14:46:04 2015 +0100
a2_rbac: add a partial index to prevent duplicate permissions (fixes #9234)
</pre> Authentic 2 - Development #9324: Permission needs unique index and partial unique indexes to prevent duplicate due to get_or_create()https://dev.entrouvert.org/issues/9324?journal_id=387072015-12-16T13:26:35ZBenjamin Dauvergne
<ul></ul><p>Le admin_scope_ct_id dans ma requête est à chercher dans django_content_type, c'est l'id du modèle a2_rbac.permission.</p> Authentic 2 - Development #9324: Permission needs unique index and partial unique indexes to prevent duplicate due to get_or_create()https://dev.entrouvert.org/issues/9324?journal_id=931882017-12-06T14:32:34ZBenjamin Dauvergne
<ul><li><strong>Statut</strong> changé de <i>Solution déployée</i> à <i>Fermé</i></li></ul>