pull_requests

Table actions

2 rows where user = 11912854

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date), closed_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
190901429 MDExOlB1bGxSZXF1ZXN0MTkwOTAxNDI5 293 closed 0 Support for external database connectors jsancho-gpl 11912854 I think it would be nice that Datasette could work with other file formats that aren't SQLite, like files with PyTables format. I've tried to accomplish that using external connectors published with entry points. These external connectors must have a structure similar to the structure [PyTables Datasette connector](https://github.com/PyTables/datasette-pytables) has. 2018-05-28T11:02:45Z 2018-09-11T14:32:45Z 2018-09-11T14:32:45Z   ad2cb12473025ffab738d4df6bb47cd8b2e27859     0 59c94be46f9ccd806dd352fa28a6dba142d5ab82 b7257a21bf3dfa7353980f343c83a616da44daa7 FIRST_TIME_CONTRIBUTOR datasette 107914493 https://github.com/simonw/datasette/pull/293    
214653641 MDExOlB1bGxSZXF1ZXN0MjE0NjUzNjQx 364 open 0 Support for other types of databases using external connectors jsancho-gpl 11912854 This PR is related to #293, but now all commits have been merged. The purpose is to support other file formats that aren't SQLite, like files with PyTables format. I've tried to accomplish that using external connectors published with entry points. The modifications in the original datasette code are minimal and many are in a separated file. 2018-09-11T14:31:47Z 2018-09-11T14:31:47Z     d84f3b1f585cb52b58aed0401c34214de2e8b47b     0 592fd05f685859b271f0305c2fc8cdb7da58ebfb b7257a21bf3dfa7353980f343c83a616da44daa7 FIRST_TIME_CONTRIBUTOR datasette 107914493 https://github.com/simonw/datasette/pull/364    

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