pull_requests

Table actions

1 row where "created_at" is on date 2021-07-19 and user = 49699333

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date), closed_at (date), merged_at (date)

id ▼ node_id number state locked title user body created_at updated_at closed_at merged_at merge_commit_sha assignee milestone draft head base author_association repo url merged_by auto_merge
692596006 MDExOlB1bGxSZXF1ZXN0NjkyNTk2MDA2 1400 closed 0 Bump black from 21.6b0 to 21.7b0 dependabot[bot] 49699333 Bumps [black](https://github.com/psf/black) from 21.6b0 to 21.7b0. <details> <summary>Release notes</summary> <p><em>Sourced from <a href="https://github.com/psf/black/releases">black's releases</a>.</em></p> <blockquote> <h2>21.7b0</h2> <h3><em>Black</em></h3> <ul> <li>Configuration files using TOML features higher than spec v0.5.0 are now supported (<a href="https://github-redirect.dependabot.com/psf/black/issues/2301">#2301</a>)</li> <li>Add primer support and test for code piped into black via STDIN (<a href="https://github-redirect.dependabot.com/psf/black/issues/2315">#2315</a>)</li> <li>Fix internal error when <code>FORCE_OPTIONAL_PARENTHESES</code> feature is enabled (<a href="https://github-redirect.dependabot.com/psf/black/issues/2332">#2332</a>)</li> <li>Accept empty stdin (<a href="https://github-redirect.dependabot.com/psf/black/issues/2346">#2346</a>)</li> <li>Provide a more useful error when parsing fails during AST safety checks (<a href="https://github-redirect.dependabot.com/psf/black/issues/2304">#2304</a>)</li> </ul> <h3>Docker</h3> <ul> <li>Add new <code>latest_release</code> tag automation to follow latest black release on docker images (<a href="https://github-redirect.dependabot.com/psf/black/issues/2374">#2374</a>)</li> </ul> <h3>Integrations</h3> <ul> <li>The vim plugin now searches upwards from the directory containing the current buffer instead of the current working directory for pyproject.toml. (<a href="https://github-redirect.dependabot.com/psf/black/issues/1871">#1871</a>)</li> <li>The vim plugin now reads the correct string normalization option in pyproject.toml (<a href="https://github-redirect.dependabot.com/psf/black/issues/1869">#1869</a>)</li> <li>The vim plugin no longer crashes Black when there's boolean values in pyproject.toml (<a href="https://github-redirect.dependabot.com/psf/black/issues/1869">#1869</a>)</li> </ul> </blockquote> </details> <details> <summary>Changelog</summary> <p><em>Sourced from <a href="https://github.com/psf/black/blob/main/CHANGES.md">black's ch… 2021-07-19T13:13:41Z 2021-08-25T01:29:56Z 2021-08-25T01:29:55Z 2021-08-25T01:29:55Z a1a33bb5822214be1cebd98cd858b2058d91a4aa     0 e95c68592346e8602c2d4c68c8c7fef8bfb939c3 c73af5dd72305f6a01ea94a2c76d52e5e26de38b CONTRIBUTOR datasette 107914493 https://github.com/simonw/datasette/pull/1400    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [pull_requests] (
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [number] INTEGER,
   [state] TEXT,
   [locked] INTEGER,
   [title] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [body] TEXT,
   [created_at] TEXT,
   [updated_at] TEXT,
   [closed_at] TEXT,
   [merged_at] TEXT,
   [merge_commit_sha] TEXT,
   [assignee] INTEGER REFERENCES [users]([id]),
   [milestone] INTEGER REFERENCES [milestones]([id]),
   [draft] INTEGER,
   [head] TEXT,
   [base] TEXT,
   [author_association] TEXT,
   [repo] INTEGER REFERENCES [repos]([id]),
   [url] TEXT,
   [merged_by] INTEGER REFERENCES [users]([id])
, [auto_merge] TEXT);
CREATE INDEX [idx_pull_requests_merged_by]
    ON [pull_requests] ([merged_by]);
CREATE INDEX [idx_pull_requests_repo]
    ON [pull_requests] ([repo]);
CREATE INDEX [idx_pull_requests_milestone]
    ON [pull_requests] ([milestone]);
CREATE INDEX [idx_pull_requests_assignee]
    ON [pull_requests] ([assignee]);
CREATE INDEX [idx_pull_requests_user]
    ON [pull_requests] ([user]);