issue_comments

Table actions

4 rows where author_association = "MEMBER" and issue = 434599855 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 2

issue 1

  • Partial fix for #2841 to improve formatting. · 4 ✖

author_association 1

  • MEMBER · 4 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
484955366 https://github.com/pydata/xarray/pull/2906#issuecomment-484955366 https://api.github.com/repos/pydata/xarray/issues/2906 MDEyOklzc3VlQ29tbWVudDQ4NDk1NTM2Ng== max-sixty 5635139 2019-04-19T16:53:44Z 2019-04-19T16:53:44Z MEMBER

OK, thanks @dnowacki-usgs !

 
{
    "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
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
484524659 https://github.com/pydata/xarray/pull/2906#issuecomment-484524659 https://api.github.com/repos/pydata/xarray/issues/2906 MDEyOklzc3VlQ29tbWVudDQ4NDUyNDY1OQ== max-sixty 5635139 2019-04-18T14:06:07Z 2019-04-18T14:06:07Z MEMBER

Also come Py3.6, f strings 🙏 

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