issue_comments

Table actions

2 rows where issue = 478886013 and user = 5635139 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

user 1

  • max-sixty · 2 ✖

issue 1

  • One-off isort run · 2 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
524327977 https://github.com/pydata/xarray/pull/3196#issuecomment-524327977 https://api.github.com/repos/pydata/xarray/issues/3196 MDEyOklzc3VlQ29tbWVudDUyNDMyNzk3Nw== max-sixty 5635139 2019-08-23T14:04:13Z 2019-08-23T14:04:13Z MEMBER

Great, +1 from me

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   One-off isort run 478886013
519982373 https://github.com/pydata/xarray/pull/3196#issuecomment-519982373 https://api.github.com/repos/pydata/xarray/issues/3196 MDEyOklzc3VlQ29tbWVudDUxOTk4MjM3Mw== max-sixty 5635139 2019-08-09T16:29:46Z 2019-08-09T16:29:46Z MEMBER

I was thinking about doing this (and had done it a couple of times in the past). My only concern with doing it now is whether it's likely to exacerbate any merge conflicts from the black changes. I've found that merge conflicts scale super-linearly with changes, at least in frustration if not lines - if so potentially we could wait for the outstanding PRs to update and then rerun?

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   One-off isort run 478886013

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
);
CREATE INDEX [idx_issue_comments_issue]
    ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
    ON [issue_comments] ([user]);