Skip to content

Instantly share code, notes, and snippets.

@MatMoore
Last active May 22, 2017 14:13
Show Gist options
  • Save MatMoore/5ac8232cb6d3089a30c0015af80ff7d9 to your computer and use it in GitHub Desktop.
Save MatMoore/5ac8232cb6d3089a30c0015af80ff7d9 to your computer and use it in GitHub Desktop.
Publishing api editions with null public updated at
irb(main):015:0> pp Edition.where(public_updated_at: nil).group("DATE(updated_at)", "publishing_app").order('DATE(updated_at)').count; nil
{[Mon, 29 Feb 2016, "short-url-manager"]=>54,
[Mon, 29 Feb 2016, "hmrc-manuals-api"]=>16,
[Mon, 29 Feb 2016, "whitehall"]=>9,
[Mon, 29 Feb 2016, "service-manual-publisher"]=>48,
[Mon, 29 Feb 2016, "policy-publisher"]=>5,
[Mon, 29 Feb 2016, "contacts"]=>4,
[Tue, 08 Mar 2016, "collections-publisher"]=>1,
[Thu, 10 Mar 2016, "collections-publisher"]=>1096,
[Thu, 12 May 2016, "collections-publisher"]=>1097,
[Mon, 11 Jul 2016, "collections-publisher"]=>12,
[Tue, 12 Jul 2016, "collections-publisher"]=>1097,
[Thu, 28 Jul 2016, "whitehall"]=>302,
[Wed, 31 Aug 2016, "specialist-publisher"]=>126,
[Wed, 31 Aug 2016, "service-manual-publisher"]=>1,
[Tue, 27 Sep 2016, "collections-publisher"]=>1098,
[Fri, 30 Sep 2016, "collections-publisher"]=>5,
[Mon, 03 Oct 2016, "collections-publisher"]=>31,
[Tue, 04 Oct 2016, "collections-publisher"]=>2,
[Wed, 05 Oct 2016, "collections-publisher"]=>2,
[Fri, 07 Oct 2016, "collections-publisher"]=>4,
[Sat, 08 Oct 2016, "collections-publisher"]=>2,
[Mon, 10 Oct 2016, "collections-publisher"]=>6,
[Wed, 12 Oct 2016, "collections-publisher"]=>1,
[Wed, 26 Oct 2016, "specialist-publisher"]=>1,
[Fri, 28 Oct 2016, "collections-publisher"]=>1,
[Fri, 04 Nov 2016, "collections-publisher"]=>2,
[Sat, 05 Nov 2016, "collections-publisher"]=>1,
[Sun, 06 Nov 2016, "collections-publisher"]=>1,
[Sun, 13 Nov 2016, "collections-publisher"]=>1,
[Mon, 14 Nov 2016, "collections-publisher"]=>1,
[Fri, 18 Nov 2016, "collections-publisher"]=>1,
[Sun, 20 Nov 2016, "collections-publisher"]=>2,
[Mon, 21 Nov 2016, "collections-publisher"]=>1,
[Tue, 22 Nov 2016, "specialist-publisher"]=>2,
[Wed, 23 Nov 2016, "specialist-publisher"]=>2,
[Sat, 26 Nov 2016, "collections-publisher"]=>2,
[Mon, 28 Nov 2016, "specialist-publisher"]=>1,
[Tue, 29 Nov 2016, "collections-publisher"]=>3,
[Thu, 01 Dec 2016, "collections-publisher"]=>1,
[Thu, 01 Dec 2016, "specialist-publisher"]=>1,
[Thu, 08 Dec 2016, "specialist-publisher"]=>1,
[Thu, 15 Dec 2016, "specialist-publisher"]=>4,
[Mon, 19 Dec 2016, "specialist-publisher"]=>1,
[Wed, 21 Dec 2016, "specialist-publisher"]=>1,
[Wed, 21 Dec 2016, "collections-publisher"]=>1,
[Sat, 31 Dec 2016, "collections-publisher"]=>1,
[Wed, 04 Jan 2017, "collections-publisher"]=>1,
[Fri, 06 Jan 2017, "manuals-publisher"]=>2,
[Fri, 13 Jan 2017, "manuals-publisher"]=>6,
[Sat, 14 Jan 2017, "specialist-publisher"]=>1,
[Wed, 18 Jan 2017, "manuals-publisher"]=>1,
[Wed, 18 Jan 2017, "collections-publisher"]=>1,
[Thu, 26 Jan 2017, "manuals-publisher"]=>1,
[Fri, 27 Jan 2017, "manuals-publisher"]=>9,
[Mon, 30 Jan 2017, "manuals-publisher"]=>16,
[Tue, 31 Jan 2017, "manuals-publisher"]=>1,
[Wed, 01 Feb 2017, "specialist-publisher"]=>1,
[Mon, 06 Feb 2017, "specialist-publisher"]=>1,
[Tue, 07 Feb 2017, "specialist-publisher"]=>4,
[Thu, 09 Feb 2017, "specialist-publisher"]=>30,
[Fri, 10 Feb 2017, "specialist-publisher"]=>5,
[Mon, 13 Feb 2017, "specialist-publisher"]=>15,
[Mon, 13 Feb 2017, "need-api"]=>4418,
[Tue, 14 Feb 2017, "specialist-publisher"]=>174,
[Wed, 15 Feb 2017, "specialist-publisher"]=>10,
[Wed, 15 Feb 2017, "maslow"]=>1,
[Thu, 16 Feb 2017, "specialist-publisher"]=>28,
[Fri, 17 Feb 2017, "specialist-publisher"]=>880,
[Sat, 18 Feb 2017, "collections-publisher"]=>1,
[Mon, 20 Feb 2017, "specialist-publisher"]=>41,
[Tue, 21 Feb 2017, "specialist-publisher"]=>70,
[Tue, 21 Feb 2017, "short-url-manager"]=>1,
[Wed, 22 Feb 2017, "specialist-publisher"]=>41,
[Thu, 23 Feb 2017, "specialist-publisher"]=>3,
[Thu, 23 Feb 2017, "service-manual-publisher"]=>1,
[Fri, 24 Feb 2017, "maslow"]=>3,
[Fri, 24 Feb 2017, "specialist-publisher"]=>81,
[Mon, 27 Feb 2017, "specialist-publisher"]=>1,
[Tue, 28 Feb 2017, "specialist-publisher"]=>1,
[Wed, 01 Mar 2017, "specialist-publisher"]=>3,
[Wed, 01 Mar 2017, "service-manual-publisher"]=>1,
[Thu, 02 Mar 2017, "service-manual-publisher"]=>1,
[Thu, 02 Mar 2017, "specialist-publisher"]=>16,
[Thu, 02 Mar 2017, "collections-publisher"]=>2,
[Fri, 03 Mar 2017, "specialist-publisher"]=>2,
[Mon, 06 Mar 2017, "specialist-publisher"]=>11,
[Tue, 07 Mar 2017, "specialist-publisher"]=>3,
[Wed, 08 Mar 2017, "specialist-publisher"]=>1,
[Thu, 09 Mar 2017, "specialist-publisher"]=>2,
[Mon, 13 Mar 2017, "specialist-publisher"]=>1,
[Tue, 14 Mar 2017, "specialist-publisher"]=>6,
[Wed, 15 Mar 2017, "specialist-publisher"]=>7,
[Thu, 16 Mar 2017, "specialist-publisher"]=>7,
[Fri, 17 Mar 2017, "maslow"]=>1,
[Fri, 17 Mar 2017, "specialist-publisher"]=>20,
[Mon, 20 Mar 2017, "specialist-publisher"]=>361,
[Tue, 21 Mar 2017, "maslow"]=>1,
[Tue, 21 Mar 2017, "specialist-publisher"]=>37,
[Wed, 22 Mar 2017, "specialist-publisher"]=>2,
[Wed, 22 Mar 2017, "manuals-publisher"]=>1,
[Thu, 23 Mar 2017, "specialist-publisher"]=>4,
[Fri, 24 Mar 2017, "specialist-publisher"]=>4,
[Mon, 27 Mar 2017, "specialist-publisher"]=>570,
[Tue, 28 Mar 2017, "specialist-publisher"]=>24,
[Wed, 29 Mar 2017, "specialist-publisher"]=>6,
[Wed, 29 Mar 2017, "collections-publisher"]=>1,
[Thu, 30 Mar 2017, "collections-publisher"]=>1,
[Thu, 30 Mar 2017, "specialist-publisher"]=>15,
[Fri, 31 Mar 2017, "specialist-publisher"]=>3,
[Mon, 03 Apr 2017, "manuals-publisher"]=>15,
[Mon, 03 Apr 2017, "specialist-publisher"]=>2,
[Tue, 04 Apr 2017, "manuals-publisher"]=>7,
[Tue, 04 Apr 2017, "specialist-publisher"]=>2,
[Wed, 05 Apr 2017, "specialist-publisher"]=>4,
[Thu, 06 Apr 2017, "specialist-publisher"]=>14,
[Fri, 07 Apr 2017, "specialist-publisher"]=>2,
[Mon, 10 Apr 2017, "specialist-publisher"]=>4,
[Tue, 11 Apr 2017, "manuals-publisher"]=>2,
[Tue, 11 Apr 2017, "specialist-publisher"]=>14,
[Wed, 12 Apr 2017, "specialist-publisher"]=>43,
[Thu, 13 Apr 2017, "manuals-publisher"]=>1,
[Thu, 13 Apr 2017, "specialist-publisher"]=>6,
[Tue, 18 Apr 2017, "manuals-publisher"]=>28,
[Tue, 18 Apr 2017, "specialist-publisher"]=>9,
[Wed, 19 Apr 2017, "service-manual-publisher"]=>1,
[Wed, 19 Apr 2017, "specialist-publisher"]=>8,
[Thu, 20 Apr 2017, "specialist-publisher"]=>12,
[Fri, 21 Apr 2017, "specialist-publisher"]=>15,
[Mon, 24 Apr 2017, "specialist-publisher"]=>84,
[Tue, 25 Apr 2017, "specialist-publisher"]=>72,
[Wed, 26 Apr 2017, "manuals-publisher"]=>19,
[Wed, 26 Apr 2017, "service-manual-publisher"]=>1,
[Wed, 26 Apr 2017, "specialist-publisher"]=>66,
[Thu, 27 Apr 2017, "specialist-publisher"]=>55,
[Fri, 28 Apr 2017, "specialist-publisher"]=>42,
[Fri, 28 Apr 2017, "manuals-publisher"]=>4,
[Tue, 02 May 2017, "specialist-publisher"]=>118,
[Wed, 03 May 2017, "manuals-publisher"]=>12,
[Wed, 03 May 2017, "specialist-publisher"]=>53,
[Thu, 04 May 2017, "specialist-publisher"]=>80,
[Thu, 04 May 2017, "need-api"]=>1,
[Fri, 05 May 2017, "specialist-publisher"]=>48,
[Fri, 05 May 2017, "manuals-publisher"]=>1,
[Mon, 08 May 2017, "specialist-publisher"]=>9,
[Mon, 08 May 2017, "manuals-publisher"]=>2,
[Tue, 09 May 2017, "collections-publisher"]=>2,
[Tue, 09 May 2017, "specialist-publisher"]=>3,
[Wed, 10 May 2017, "maslow"]=>1,
[Wed, 10 May 2017, "specialist-publisher"]=>19,
[Thu, 11 May 2017, "specialist-publisher"]=>6,
[Fri, 12 May 2017, "specialist-publisher"]=>11,
[Mon, 15 May 2017, "manuals-publisher"]=>2,
[Mon, 15 May 2017, "specialist-publisher"]=>25,
[Tue, 16 May 2017, "manuals-publisher"]=>14,
[Tue, 16 May 2017, "specialist-publisher"]=>106,
[Wed, 17 May 2017, "manuals-publisher"]=>4,
[Wed, 17 May 2017, "specialist-publisher"]=>131,
[Thu, 18 May 2017, "specialist-publisher"]=>99,
[Thu, 18 May 2017, "manuals-publisher"]=>7,
[Fri, 19 May 2017, "specialist-publisher"]=>1800,
[Fri, 19 May 2017, "manuals-publisher"]=>3,
[Mon, 22 May 2017, "specialist-publisher"]=>20}
=> nil
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment