pull_requests

Table actions

2 rows where user = 95570

✎ 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
1123392399 PR_kwDOBm6k_c5C9ZuP 1893 closed 0 Upgrade to CodeMirror 6, add SQL autocomplete bgrins 95570 In an effort to get closer to table / column autocomplete I took a shot at https://github.com/simonw/datasette/issues/1796. I haven't done a lot of testing but would be curious if this fixes some of the concerns raised in https://github.com/simonw/datasette/issues/1796#issue-1355148385 for example. Done: * Changed to bundling using rollup as per https://codemirror.net/examples/bundle/ * Restored a fromTextArea-like function from https://codemirror.net/docs/migration/ * Removed old JS and CSS files (no external CSS needed anymore as per https://codemirror.net/examples/styling/) * Updated instructions for building the bundle Not done: * cmResize had an error, so commented out the resize handle * Add extraKeys option for shift+enter and tab <!-- readthedocs-preview datasette start --> ---- :books: Documentation preview :books:: https://datasette--1893.org.readthedocs.build/en/1893/ <!-- readthedocs-preview datasette end --> 2022-11-15T20:52:35Z 2022-11-16T23:54:02Z 2022-11-16T23:49:06Z 2022-11-16T23:49:06Z ae11fa5887e03376704c22e5d0969c1e0642d8d8     0 f254be4b38936e95e7a7f25866e7c6b0520db96f 6f610e1d94b7b8ec605b5b7fcb01537f6adf9c5b CONTRIBUTOR datasette 107914493 https://github.com/simonw/datasette/pull/1893    
1125261188 PR_kwDOBm6k_c5DEh-E 1898 closed 0 Use DOMContentLoaded instead of load event for CodeMirror initialization bgrins 95570 Closes #1894 <!-- readthedocs-preview datasette start --> ---- :books: Documentation preview :books:: https://datasette--1898.org.readthedocs.build/en/1898/ <!-- readthedocs-preview datasette end --> 2022-11-17T00:19:21Z 2022-11-18T07:29:01Z 2022-11-18T07:29:01Z 2022-11-18T07:29:01Z 3ecd131e57add427d847b614c920c9624bb2e66b     0 5eb4ea45ce6cdc7003fc7c5175977b025b0f111e 00e233d7a7f6443cb95fb5227c23580c48551cad CONTRIBUTOR datasette 107914493 https://github.com/simonw/datasette/pull/1898    

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