Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- cursor.execute("""
- SELECT DISTINCT ON ("monitoringengine_ui_objectpermission"."object_id")
- "monitoringengine_ui_account"."id" as "account_id",
- "monitoringengine_ui_account"."name"
- FROM "monitoringengine_ui_objectpermission"
- INNER JOIN "auth_permission"
- ON ("monitoringengine_ui_objectpermission"."permission_id" = "auth_permission"."id")
- INNER JOIN "auth_user_user_permissions"
- ON ("auth_permission"."id" = "auth_user_user_permissions"."permission_id")
- INNER JOIN "monitoringengine_ui_account"
- ON ("monitoringengine_ui_objectpermission"."object_id" = "monitoringengine_ui_account"."id")
- WHERE ( "auth_user_user_permissions"."user_id" = %(user_id)s
- AND "monitoringengine_ui_objectpermission"."content_type_id" = %(account_ct_id)s)
- GROUP BY
- "monitoringengine_ui_account"."id",
- "monitoringengine_ui_account"."name",
- "monitoringengine_ui_objectpermission"."object_id";""", {"user_id": user.id, "account_ct_id": account_ct.id})
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement