issue_comments

Table actions

where issue = 434599855 and user = 1217238 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: author_association, issue

user 1

  • shoyer · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
484645088 https://github.com/pydata/xarray/pull/2906#issuecomment-484645088 https://api.github.com/repos/pydata/xarray/issues/2906 MDEyOklzc3VlQ29tbWVudDQ4NDY0NTA4OA== shoyer 1217238 2019-04-18T19:05:02Z 2019-04-18T19:05:02Z MEMBER

Looks great! You can ignore the failing doc build in the tests, that is unrelated.

If you like, feel free to give yourself a credit in whats-new.rst for fixing this. Otherwise I'll merge this in a day or two.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Partial fix for #2841 to improve formatting. 434599855
484378485 https://github.com/pydata/xarray/pull/2906#issuecomment-484378485 https://api.github.com/repos/pydata/xarray/issues/2906 MDEyOklzc3VlQ29tbWVudDQ4NDM3ODQ4NQ== shoyer 1217238 2019-04-18T06:51:30Z 2019-04-18T06:51:30Z MEMBER

Thanks @dnowacki-usgs !

One minor note -- it's valid (since Python 2.7) to write string formatting with explicit positional indexes, e.g., you could just write '{} {}'.format('one', 'two') rather than '{0} {1}'.format('one', 'two').

I think it's usually a little cleaner to omit the numeric indices, unless you're reusing arguments multiple times or printing the names out of order. (But even in these cases it's usually nicer to use keyword names.)

 
{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Partial fix for #2841 to improve formatting. 434599855

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