From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id BDD0C1382C5 for ; Tue, 20 Mar 2018 04:25:37 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 04735E0903; Tue, 20 Mar 2018 04:25:31 +0000 (UTC) Received: from smtp.gentoo.org (dev.gentoo.org [IPv6:2001:470:ea4a:1:5054:ff:fec7:86e4]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id A26C5E08F7 for ; Tue, 20 Mar 2018 04:25:30 +0000 (UTC) Received: from katipo2.lan (unknown [203.86.205.69]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: kentnl) by smtp.gentoo.org (Postfix) with ESMTPSA id 380D8335C2C for ; Tue, 20 Mar 2018 04:25:28 +0000 (UTC) Date: Tue, 20 Mar 2018 17:24:51 +1300 From: Kent Fredric To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] bug queue size over time Message-ID: <20180320172451.34e031cb@katipo2.lan> In-Reply-To: <1f457642-b419-7398-db92-366f4908fbab@gentoo.org> References: <1f457642-b419-7398-db92-366f4908fbab@gentoo.org> Organization: Gentoo X-Mailer: Claws Mail 3.15.1-dirty (GTK+ 2.24.31; x86_64-pc-linux-gnu) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@lists.gentoo.org Reply-to: gentoo-dev@lists.gentoo.org MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; boundary="Sig_/KiX_.jU30UJPyY1qnILUO5y"; protocol="application/pgp-signature" X-Archives-Salt: 016dfcbe-21b8-4c1d-bf83-aebbe7469043 X-Archives-Hash: 116a7b1edcdd43ac9d3410c69b66d77b --Sig_/KiX_.jU30UJPyY1qnILUO5y Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Mon, 19 Mar 2018 19:33:11 -0700 "Pawe=C5=82 Hajdan, Jr." wrote: > Is it possible to get graphs of bugs.g.o bug queue size for certain > query (e.g. by assignee) over time? >=20 > Best, > Pawe=C5=82 >=20 The *data* is there to do it, but its a bit of a pain, you have to extract all the individual "changed" events and then use that to reason about each individual bugs state at a given time, and use *that* to deduce how many open bugs there *were* at a historical moment. And that's a lot of painful queries for the REST API. I've done something like this before with Perl bugs[1], but again, very painful, slow and time consuming. This sort of thing would be *much* easier if we could have direct bulk access to the underlying MYSQL store, but that's a tricky thing to do becau= se: 1. Its MySQL 2. Some bugs have visibility restrictions that have to be factored for ---- Note: these pages are very browser taxing: 1: https://docs.google.com/spreadsheets/d/1mm8iYE77SRh-q2jOfKNSWHUetswEABJa= wp-94UyTHio/edit?usp=3Dsharing =20 --Sig_/KiX_.jU30UJPyY1qnILUO5y Content-Type: application/pgp-signature Content-Description: OpenPGP digital signature -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEEPZazbI/qrFT1o9rn6FQySxNmqCAFAlqwjSAACgkQ6FQySxNm qCBIrQ/9G3m3z0kguntJY4IPtGMTzbV0HS5Ckw3eQ2hzv1J1zDIP+5qk1IUEyVPJ +MXXZMLhiFsbF2+KQ1Yl+VWADXXz45TXuTbzk9bnK85T0afmeed8kA+H+EcbYw6B Ad0DXsFh0MweO4E6miWPe0mxYQEVpoG0AQLj2G1NDYpaBNYy5pOGt58c6AEVlfbK CQ4aASAcQVfMozj5dg80GjJEXJN64F2xQzLDmzGUPDf0NagFXidFQTanbNSvSbZX cjfGfEDFwb5NTKug4PYyhOmMO8xvCEtMXS64HpWyBjZ+DSClQzr27AvYKPtLmbi2 QeLIElEhsPYBfrBjBqh3lhnqdoB6lwaK/VAAyexIdoosffhldCJRu7PEkVA4QeHm REANIHFvQMi2wBwtU0R6X2hrItahtE0gxP+G30//K9kimctfucw7EYkFDCTVZDg7 uv0JKs1KAL4VrGNZURAdCOd5rxJ6hQbTVP/bSXGvuXSuCWXtf1jtb89C+tDN3qsm F2xf/pEvfqHLxJPONo/8nCgElwxBWB81fRfBlw0lzn0B4fj5JNIpytg7DGN4KrzF d7P6XIh3mXOBWvRghHNDjoLWQTP9Jxq6+zLSjueantibVztHZMg14rxMeWpyRz9v nC2KQ0Nn7nFBgwABqWgEoYjBYeEf6uEM3XZjDTEdGqXBZ0TaiO8= =WQiU -----END PGP SIGNATURE----- --Sig_/KiX_.jU30UJPyY1qnILUO5y--