Advertisement
Guest User

Untitled

a guest
Jul 25th, 2014
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.08 KB | None | 0 0
  1.         cursor.execute("""
  2.        SELECT DISTINCT ON ("monitoringengine_ui_objectpermission"."object_id")
  3.            "monitoringengine_ui_account"."id" as "account_id",
  4.            "monitoringengine_ui_account"."name"
  5.        FROM "monitoringengine_ui_objectpermission"
  6.        INNER JOIN "auth_permission"
  7.            ON ("monitoringengine_ui_objectpermission"."permission_id" = "auth_permission"."id")
  8.        INNER JOIN "auth_user_user_permissions"
  9.            ON ("auth_permission"."id" = "auth_user_user_permissions"."permission_id")
  10.        INNER JOIN "monitoringengine_ui_account"
  11.            ON ("monitoringengine_ui_objectpermission"."object_id" = "monitoringengine_ui_account"."id")
  12.        WHERE ( "auth_user_user_permissions"."user_id" = %(user_id)s
  13.            AND "monitoringengine_ui_objectpermission"."content_type_id" = %(account_ct_id)s)
  14.        GROUP BY
  15.            "monitoringengine_ui_account"."id",
  16.            "monitoringengine_ui_account"."name",
  17.            "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