issue_comments

Table actions

1 row where author_association = "COLLABORATOR", issue = 1355807694 and user = 43316012 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

  • headtr1ck · 1 ✖

issue 1

  • empty attributes silently change · 1 ✖

author_association 1

  • COLLABORATOR · 1 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
1258641481 https://github.com/pydata/xarray/issues/6970#issuecomment-1258641481 https://api.github.com/repos/pydata/xarray/issues/6970 IC_kwDOAMm_X85LBVhJ headtr1ck 43316012 2022-09-26T21:15:58Z 2022-09-26T21:16:10Z COLLABORATOR

It is not an easy fix since we do not simply want to return None, and returning an empty dict in this case without overwriting the internal one would break things like da.attrs.update(some_dict). We would have to replace the internal _attrs already in the __init__, but not sure what else that would break.

Maybe the solution from @dcherian is the best for now.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   empty attributes silently change 1355807694

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