pull_requests

Table actions

4 rows where repo = 206649770

✎ 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
577953727 MDExOlB1bGxSZXF1ZXN0NTc3OTUzNzI3 5 open 0 WIP: Add Gmail takeout mbox import UtahDave 306240 WIP This PR adds the ability to import emails from a Gmail mbox export from Google Takeout. This is my first PR to a datasette/dogsheep repo. I've tested this on my personal Google Takeout mbox with ~520,000 emails going back to 2004. This took around ~20 minutes to process. To provide some feedback on the progress of the import I added the "rich" python module. I'm happy to remove that if adding a dependency is discouraged. However, I think it makes a nice addition to give feedback on the progress of a long import. Do we want to log emails that have errors when trying to import them? Dealing with encodings with emails is a bit tricky. I'm very open to feedback on how to deal with those better. As well as any other feedback for improvements. 2021-02-22T21:30:40Z 2021-07-28T07:18:56Z     65182811d59451299e75f09b4366bb221bc32b20     0 a3de045eba0fae4b309da21aa3119102b0efc576 e54e544427f1cc3ea8189f0e95f54046301a8645 FIRST_TIME_CONTRIBUTOR google-takeout-to-sqlite 206649770 https://github.com/dogsheep/google-takeout-to-sqlite/pull/5    
698423667 MDExOlB1bGxSZXF1ZXN0Njk4NDIzNjY3 8 open 0 Add Gmail takeout mbox import (v2) maxhawkins 28565 WIP This PR builds on #5 to continue implementing gmail import support. Building on @UtahDave's work, these commits add a few performance and bug fixes: * Decreased memory overhead for import by manually parsing mbox headers. * Fixed error where some messages in the mbox would yield a row with NULL in all columns. I will send more commits to fix any errors I encounter as I run the importer on my personal takeout data. 2021-07-28T07:05:32Z 2021-12-31T19:06:20Z     d2809fd3fd835358d01ad10401228a562539b29e     0 8e6d487b697ce2e8ad885acf613a157bfba84c59 e54e544427f1cc3ea8189f0e95f54046301a8645 FIRST_TIME_CONTRIBUTOR google-takeout-to-sqlite 206649770 https://github.com/dogsheep/google-takeout-to-sqlite/pull/8    
775078665 PR_kwDODFE5qs4uMsMJ 9 open 0 Removed space from filename My Activity.json widadmogral 91880982 File name from google takeout has no space. The code only runs without error if filename is "MyActivity.json" and not "My Activity.json". Is it a new change by Google? 2021-11-08T00:04:31Z 2021-11-08T00:04:31Z     236da5c8302c09a20fcd4164c563cd9fa5c9595c     0 6d111f65687e13ffd8b39aa05f1f8f4a351e7788 e54e544427f1cc3ea8189f0e95f54046301a8645 FIRST_TIME_CONTRIBUTOR google-takeout-to-sqlite 206649770 https://github.com/dogsheep/google-takeout-to-sqlite/pull/9    
948892757 PR_kwDODFE5qs44jvRV 11 open 0 Update README.md ashanan 11887 Fix typo 2022-05-27T03:13:59Z 2022-05-27T03:13:59Z     3d479a1052f2661de61b15c50b7a5b2daa20a33a     0 d4af1554a9b5ddedcd0b241450f7b935f38b9bf7 e54e544427f1cc3ea8189f0e95f54046301a8645 FIRST_TIME_CONTRIBUTOR google-takeout-to-sqlite 206649770 https://github.com/dogsheep/google-takeout-to-sqlite/pull/11    

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