pull_requests

Table actions

3 rows where milestone = 3268330

✎ 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
290897104 MDExOlB1bGxSZXF1ZXN0MjkwODk3MTA0 518 closed 0 Port Datasette from Sanic to ASGI + Uvicorn simonw 9599 Most of the code here was fleshed out in comments on #272 (Port Datasette to ASGI) - this pull request will track the final pieces: - [x] Update test harness to more correctly simulate the `raw_path` issue - [x] Use `raw_path` so table names containing `/` can work correctly - [x] Bug: JSON not served with correct content-type - [x] Get ?_trace=1 working again - [x] Replacement for `@app.listener("before_server_start")` - [x] Bug: `/fixtures/table%2Fwith%2Fslashes.csv?_format=json` downloads as CSV - [x] Replace Sanic request and response objects with my own classes, so I can remove Sanic dependency - [x] Final code tidy-up before merging to master 2019-06-23T15:18:42Z 2019-06-24T13:42:50Z 2019-06-24T03:13:09Z 2019-06-24T03:13:09Z ba8db9679f3bd2454c9e76e7e6c352126848b57a simonw 9599 Datasette 1.0 3268330 0 b794554a26ddc81bd772c4422d80d5ee863e92b0 35429f90894321eda7f2db31b9ea7976f31f73ac OWNER datasette 107914493 https://github.com/simonw/datasette/pull/518    
379192258 MDExOlB1bGxSZXF1ZXN0Mzc5MTkyMjU4 683 closed 0 .execute_write() and .execute_write_fn() methods on Database simonw 9599 See #682 - [x] Come up with design for `.execute_write()` and `.execute_write_fn()` - [x] Build some quick demo plugins to exercise the design - [x] Write some unit tests - [x] Write the documentation 2020-02-24T19:51:58Z 2020-05-30T18:40:20Z 2020-02-25T04:45:08Z 2020-02-25T04:45:08Z a093c5f79fa034a97d2ad8b606745dd3b80365af   Datasette 1.0 3268330 0 ec6e2edfe18446c9d77e3f30efbc299d27ea5c1b 411056c4c43e74f2b3d0e3bc1175e7998516b1b3 OWNER datasette 107914493 https://github.com/simonw/datasette/pull/683    
426891471 MDExOlB1bGxSZXF1ZXN0NDI2ODkxNDcx 796 closed 0 New WIP writable canned queries simonw 9599 Refs #698. Replaces #703 Still todo: - [x] Unit tests - ~~Figure out `.json` mode~~ - [x] Flash message solution - ~~CSRF protection~~ - [x] Better error message display on errors - [x] Documentation - ~~Maybe widgets?~~ I'll do these later 2020-06-03T00:08:00Z 2020-06-03T15:16:52Z 2020-06-03T15:16:50Z 2020-06-03T15:16:50Z aa82d0370463580f2cb10d9617f1bcbe45cc994a   Datasette 1.0 3268330 0 e164939de719b5930ca4972e20490c9b2fd37f6d 9690ce606823bbfceb0c50d59e03adf7bb1a8475 OWNER datasette 107914493 https://github.com/simonw/datasette/pull/796    

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