pull_requests

Table actions

5 rows where user = 26161409

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_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
1179812287 PR_kwDODEm0Qs5GUoG_ 67 open 0 Add support for app-only bearer tokens sometimes-i-send-pull-requests 26161409 Previously, twitter-to-sqlite only supported OAuth1 authentication, and the token must be on behalf of a user. However, Twitter also supports application-only bearer tokens, documented here: https://developer.twitter.com/en/docs/authentication/oauth-2-0/bearer-tokens This PR adds support to twitter-to-sqlite for using application-only bearer tokens. To use, the auth.json file just needs to contain a "bearer_token" key instead of "api_key", "api_secret_key", etc. 2022-12-28T23:31:20Z 2022-12-28T23:31:20Z     7825cd68047088cbdc9666586f1af9b7e1fa88c2     0 52050d06eeb85f3183b086944b7b75ae758096cd f09d611782a8372cfb002792dfa727325afb4db6 FIRST_TIME_CONTRIBUTOR twitter-to-sqlite 206156866 https://github.com/dogsheep/twitter-to-sqlite/pull/67    
1179812491 PR_kwDODEm0Qs5GUoKL 68 open 0 Archive: Import mute table sometimes-i-send-pull-requests 26161409   2022-12-28T23:32:06Z 2022-12-28T23:32:06Z     47d4d3bda6d4123f58d8dbd634f9f146d97b037e     0 e1cd68ea0244c4689a3c49799c6b24371cdc4978 f09d611782a8372cfb002792dfa727325afb4db6 FIRST_TIME_CONTRIBUTOR twitter-to-sqlite 206156866 https://github.com/dogsheep/twitter-to-sqlite/pull/68    
1179812620 PR_kwDODEm0Qs5GUoMM 69 open 0 Archive: Import new tweets table name sometimes-i-send-pull-requests 26161409 Given the code here, it seems like in the past this file was named "tweet.js". In recent exports, it's named "tweets.js". The archive importer needs to be modified to take this into account. Existing logic is reused for importing this table. (However, the resulting table name will be different, matching the different file name -- archive_tweets, rather than archive_tweet). 2022-12-28T23:32:44Z 2022-12-28T23:32:44Z     1a8c02a8d349c8fd4074139a6a3eed552676bdf3     0 11e8fa64ca30cebde047a4268e65f376c42e2b60 f09d611782a8372cfb002792dfa727325afb4db6 FIRST_TIME_CONTRIBUTOR twitter-to-sqlite 206156866 https://github.com/dogsheep/twitter-to-sqlite/pull/69    
1179812730 PR_kwDODEm0Qs5GUoN6 70 open 0 Archive: Import Twitter Circle data sometimes-i-send-pull-requests 26161409   2022-12-28T23:33:09Z 2022-12-28T23:33:09Z     1d2683101571550adf4a3b7bdf8e9ffbd8b77b61     0 cc80cb31a9afb9a50295d6202f509e5b500607a0 f09d611782a8372cfb002792dfa727325afb4db6 FIRST_TIME_CONTRIBUTOR twitter-to-sqlite 206156866 https://github.com/dogsheep/twitter-to-sqlite/pull/70    
1179812838 PR_kwDODEm0Qs5GUoPm 71 open 0 Archive: Fix "ni devices" typo in importer sometimes-i-send-pull-requests 26161409   2022-12-28T23:33:31Z 2022-12-28T23:33:31Z     7905dbd6e36bcabcfd9106c70ebb36ecf9e38260     0 0d3c62e8ba6e545785069cc0ffc8dc1bad03db80 f09d611782a8372cfb002792dfa727325afb4db6 FIRST_TIME_CONTRIBUTOR twitter-to-sqlite 206156866 https://github.com/dogsheep/twitter-to-sqlite/pull/71    

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