pull_requests

Table actions

2 rows where user = 80737

✎ 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
687298112 MDExOlB1bGxSZXF1ZXN0Njg3Mjk4MTEy 1392 closed 0 Update deploying.rst aslakr 80737 Use same base url for Apache as in the example 2021-07-11T08:43:19Z 2021-07-13T17:42:31Z 2021-07-13T17:42:27Z 2021-07-13T17:42:27Z 4054e96a3914e821d0880a40a7284aaa9db1eaaa     0 f57a8ab0905bb85a9334fe4bf87e2cd736c78cbb f83c84fd51d144036924ae77d99f12b0a69e7e6f CONTRIBUTOR datasette 107914493 https://github.com/simonw/datasette/pull/1392    
687304242 MDExOlB1bGxSZXF1ZXN0Njg3MzA0MjQy 1393 closed 0 Update deploying.rst aslakr 80737 Example on how to use Unix domain socket option on Apache. Not testet. (Usually I would have used [`ProxyPassReverse`](https://httpd.apache.org/docs/current/mod/mod_proxy.html#proxypassreverse) in combination with `ProxyPass` , i.e. ```apache ProxyPass /my-datasette/ http://127.0.0.1:8009/my-datasette/ ProxyPassReverse /my-datasette/ http://127.0.0.1:8009/my-datasette/ ``` and ```apache ProxyPass /my-datasette/ unix:/tmp/datasette.sock|http://localhost/my-datasette/ ProxyPassReverse /my-datasette/ unix:/tmp/datasette.sock|http://localhost/my-datasette/ ``` ) 2021-07-11T09:32:16Z 2021-07-13T18:32:49Z 2021-07-13T18:32:49Z 2021-07-13T18:32:49Z d71cac498138ddd86f18607b9043e70286ea884a     0 1bbb577e9e10e0225ab885d72defcbf6517cc096 f83c84fd51d144036924ae77d99f12b0a69e7e6f CONTRIBUTOR datasette 107914493 https://github.com/simonw/datasette/pull/1393    

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]);