Patch Detail
get:
Show a patch.
patch:
Update a patch.
put:
Update a patch.
GET /api/patches/806543/?format=api
{ "id": 806543, "url": "http://patchwork.ozlabs.org/api/patches/806543/?format=api", "web_url": "http://patchwork.ozlabs.org/project/patchwork/patch/1503920358-26652-2-git-send-email-jk@ozlabs.org/", "project": { "id": 16, "url": "http://patchwork.ozlabs.org/api/projects/16/?format=api", "name": "Patchwork", "link_name": "patchwork", "list_id": "patchwork.lists.ozlabs.org", "list_email": "patchwork@lists.ozlabs.org", "web_url": "http://jk.ozlabs.org/projects/patchwork/", "scm_url": "git://github.com/getpatchwork/patchwork", "webscm_url": "https://github.com/getpatchwork/patchwork", "list_archive_url": "", "list_archive_url_format": "", "commit_url_format": "" }, "msgid": "<1503920358-26652-2-git-send-email-jk@ozlabs.org>", "list_archive_url": null, "date": "2017-08-28T11:39:18", "name": "[2/2] lib/sql: fix permissions for v2.0.0 on postgres", "commit_ref": null, "pull_url": null, "state": "accepted", "archived": false, "hash": "4098f51d821130126917c96f96ed7130eeef98a2", "submitter": { "id": 1, "url": "http://patchwork.ozlabs.org/api/people/1/?format=api", "name": "Jeremy Kerr", "email": "jk@ozlabs.org" }, "delegate": null, "mbox": "http://patchwork.ozlabs.org/project/patchwork/patch/1503920358-26652-2-git-send-email-jk@ozlabs.org/mbox/", "series": [ { "id": 144, "url": "http://patchwork.ozlabs.org/api/series/144/?format=api", "web_url": "http://patchwork.ozlabs.org/project/patchwork/list/?series=144", "date": "2017-08-28T11:39:17", "name": "[1/2] tests: Run FuzzTest within a transaction", "version": 1, "mbox": "http://patchwork.ozlabs.org/series/144/mbox/" } ], "comments": "http://patchwork.ozlabs.org/api/patches/806543/comments/", "check": "pending", "checks": "http://patchwork.ozlabs.org/api/patches/806543/checks/", "tags": {}, "related": [], "headers": { "Return-Path": "<patchwork-bounces+incoming=patchwork.ozlabs.org@lists.ozlabs.org>", "X-Original-To": [ "incoming@patchwork.ozlabs.org", "patchwork@lists.ozlabs.org" ], "Delivered-To": [ "patchwork-incoming@bilbo.ozlabs.org", "patchwork@lists.ozlabs.org" ], "Received": [ "from lists.ozlabs.org (lists.ozlabs.org [103.22.144.68])\n\t(using TLSv1.2 with cipher ADH-AES256-GCM-SHA384 (256/256 bits))\n\t(No client certificate requested)\n\tby ozlabs.org (Postfix) with ESMTPS id 3xgqZM51tlz9sD9\n\tfor <incoming@patchwork.ozlabs.org>;\n\tMon, 28 Aug 2017 21:40:11 +1000 (AEST)", "from lists.ozlabs.org (lists.ozlabs.org [IPv6:2401:3900:2:1::3])\n\tby lists.ozlabs.org (Postfix) with ESMTP id 3xgqZM3qzdzDqBd\n\tfor <incoming@patchwork.ozlabs.org>;\n\tMon, 28 Aug 2017 21:40:11 +1000 (AEST)", "from ozlabs.org (bilbo.ozlabs.org [103.22.144.67])\n\t(using TLSv1.2 with cipher ADH-AES256-GCM-SHA384 (256/256 bits))\n\t(No client certificate requested)\n\tby lists.ozlabs.org (Postfix) with ESMTPS id 3xgqYw5ykKzDq77\n\tfor <patchwork@lists.ozlabs.org>;\n\tMon, 28 Aug 2017 21:39:48 +1000 (AEST)", "by ozlabs.org (Postfix, from userid 1023)\n\tid 3xgqYw5454z9sD9; Mon, 28 Aug 2017 21:39:48 +1000 (AEST)" ], "Authentication-Results": [ "ozlabs.org;\n\tdkim=fail reason=\"signature verification failed\" (2048-bit key;\n\tsecure) header.d=ozlabs.org header.i=@ozlabs.org header.b=\"DoNvx7Xa\";\n\tdkim-atps=neutral", "lists.ozlabs.org;\n\tdkim=fail reason=\"signature verification failed\" (2048-bit key;\n\tsecure) header.d=ozlabs.org header.i=@ozlabs.org header.b=\"DoNvx7Xa\";\n\tdkim-atps=neutral", "lists.ozlabs.org; dkim=pass (2048-bit key;\n\tsecure) header.d=ozlabs.org header.i=@ozlabs.org header.b=\"DoNvx7Xa\"; \n\tdkim-atps=neutral" ], "DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/simple; d=ozlabs.org; s=201707; \n\tt=1503920388; bh=q07SyA5h5ynF4e731xl14ImbB9jPxjskqMBLAfPwk1o=;\n\th=From:To:Subject:Date:In-Reply-To:References:From;\n\tb=DoNvx7Xae51tmIkRORh0GxQFmQNsUwBzwtHLXXn44wMKd+pv+zA3xpvKD+kGi0AqZ\n\tSfwepsx/ksh9lyua1tYkuAZVNCbsNILk2sid5K2ucXR0A6yOIJO52YqIrLRWaXZF81\n\tQ3kETppcn7TXVyu5qAreu1zDR1rTpoYFtf7usbvejjTGQdAIAhmt7TzMVca4JECDAH\n\tKYQBIR+cLfioXiOmGXCcJuXD3SQcgwXkPwKuoS9LijDVjczSSID6pV2KDIPSvdhkYm\n\tj0cJsSZ2Sr7eryuEefKe3/VkqvYwufvuA2/8/BJYAGMqTh+DVlXojTM414/d80rP2V\n\tH94J2iwFcM60Q==", "From": "Jeremy Kerr <jk@ozlabs.org>", "To": "patchwork@lists.ozlabs.org", "Subject": "[PATCH 2/2] lib/sql: fix permissions for v2.0.0 on postgres", "Date": "Mon, 28 Aug 2017 19:39:18 +0800", "Message-Id": "<1503920358-26652-2-git-send-email-jk@ozlabs.org>", "X-Mailer": "git-send-email 2.7.4", "In-Reply-To": "<1503920358-26652-1-git-send-email-jk@ozlabs.org>", "References": "<1503920358-26652-1-git-send-email-jk@ozlabs.org>", "X-BeenThere": "patchwork@lists.ozlabs.org", "X-Mailman-Version": "2.1.23", "Precedence": "list", "List-Id": "Patchwork development <patchwork.lists.ozlabs.org>", "List-Unsubscribe": "<https://lists.ozlabs.org/options/patchwork>,\n\t<mailto:patchwork-request@lists.ozlabs.org?subject=unsubscribe>", "List-Archive": "<http://lists.ozlabs.org/pipermail/patchwork/>", "List-Post": "<mailto:patchwork@lists.ozlabs.org>", "List-Help": "<mailto:patchwork-request@lists.ozlabs.org?subject=help>", "List-Subscribe": "<https://lists.ozlabs.org/listinfo/patchwork>,\n\t<mailto:patchwork-request@lists.ozlabs.org?subject=subscribe>", "MIME-Version": "1.0", "Content-Type": "text/plain; charset=\"utf-8\"", "Content-Transfer-Encoding": "base64", "Errors-To": "patchwork-bounces+incoming=patchwork.ozlabs.org@lists.ozlabs.org", "Sender": "\"Patchwork\"\n\t<patchwork-bounces+incoming=patchwork.ozlabs.org@lists.ozlabs.org>" }, "content": "Some tables are no longer present, and others that are used by the web\ninterface and mail parser need access permissions added.\n\nThis change was required to get patchwork going on patchwork.ozlabs.org;\nthere may be other permissions required, that we haven't hit yet. So,\nsome review would be good here.\n\nAlso: it's unlikely that we need DELETE for the mail parser, but I'm not\nconfident enough to remove that at the moment.\n\nSigned-off-by: Jeremy Kerr <jk@ozlabs.org>\n---\n lib/sql/grant-all.postgres.sql | 17 ++++++++---------\n 1 file changed, 8 insertions(+), 9 deletions(-)", "diff": "diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql\nindex 405ba44..c709866 100644\n--- a/lib/sql/grant-all.postgres.sql\n+++ b/lib/sql/grant-all.postgres.sql\n@@ -12,6 +12,7 @@ GRANT SELECT, UPDATE, INSERT, DELETE ON\n \tauth_group,\n \tauth_user_user_permissions,\n \tauth_permission,\n+\tauthtoken_token,\n \tpatchwork_emailconfirmation,\n \tpatchwork_state,\n \tpatchwork_comment,\n@@ -47,9 +48,7 @@ GRANT SELECT, UPDATE ON\n \tpatchwork_bundle_id_seq,\n \tpatchwork_bundlepatch_id_seq,\n \tpatchwork_comment_id_seq,\n-\tpatchwork_submission_id_seq,\n \tpatchwork_patch_id_seq,\n-\tpatchwork_coverletter_id_seq,\n \tpatchwork_series_id_seq,\n \tpatchwork_seriespatch_id_seq,\n \tpatchwork_seriesreference_id_seq,\n@@ -69,16 +68,17 @@ TO \"www-data\";\n -- cover letters) and series\n GRANT INSERT, SELECT ON\n \tpatchwork_submission,\n-\tpatchwork_patch,\n \tpatchwork_coverletter,\n-\tpatchwork_series,\n \tpatchwork_seriespatch,\n \tpatchwork_seriesreference,\n \tpatchwork_comment,\n-\tpatchwork_person\n+\tpatchwork_event\n TO \"nobody\";\n GRANT INSERT, SELECT, UPDATE, DELETE ON\n-\tpatchwork_patchtag\n+\tpatchwork_patchtag,\n+\tpatchwork_patch,\n+\tpatchwork_series,\n+\tpatchwork_person\n TO \"nobody\";\n GRANT SELECT ON\n \tpatchwork_project,\n@@ -87,15 +87,14 @@ GRANT SELECT ON\n \tpatchwork_delegationrule\n TO \"nobody\";\n GRANT UPDATE, SELECT ON\n-\tpatchwork_submission_id_seq,\n \tpatchwork_patch_id_seq,\n-\tpatchwork_coverletter_id_seq,\n \tpatchwork_series_id_seq,\n \tpatchwork_seriespatch_id_seq,\n \tpatchwork_seriesreference_id_seq,\n \tpatchwork_person_id_seq,\n \tpatchwork_comment_id_seq,\n-\tpatchwork_patchtag_id_seq\n+\tpatchwork_patchtag_id_seq,\n+\tpatchwork_event_id_seq\n TO \"nobody\";\n \n COMMIT;\n", "prefixes": [ "2/2" ] }