issue_comments

Table actions

4 rows where issue = 323823894 and user = 6145107 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 1

  • abrammer · 4 ✖

issue 1

  • Add strftime() to datetime accessor · 4 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
496036760 https://github.com/pydata/xarray/pull/2144#issuecomment-496036760 https://api.github.com/repos/pydata/xarray/issues/2144 MDEyOklzc3VlQ29tbWVudDQ5NjAzNjc2MA== abrammer 6145107 2019-05-26T22:32:29Z 2019-05-26T22:32:29Z CONTRIBUTOR

@dopplershift I built from your start here, over in #2989 and keeping your initial code and tests along with an edited version of your what's-new. Kept you in the what's new, so hope that's cool otherwise lmk. 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Add strftime() to datetime accessor 323823894
495723917 https://github.com/pydata/xarray/pull/2144#issuecomment-495723917 https://api.github.com/repos/pydata/xarray/issues/2144 MDEyOklzc3VlQ29tbWVudDQ5NTcyMzkxNw== abrammer 6145107 2019-05-24T17:35:59Z 2019-05-24T17:35:59Z CONTRIBUTOR

I took a stab at this after being reminded about it. https://github.com/abrammer/xarray/tree/strftime_addition Can open a new PR if this one has gone stale. 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Add strftime() to datetime accessor 323823894
424100894 https://github.com/pydata/xarray/pull/2144#issuecomment-424100894 https://api.github.com/repos/pydata/xarray/issues/2144 MDEyOklzc3VlQ29tbWVudDQyNDEwMDg5NA== abrammer 6145107 2018-09-24T19:45:54Z 2018-09-24T19:54:11Z CONTRIBUTOR

ok, thanks. Anything an outsider can help with?

 
{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Add strftime() to datetime accessor 323823894
424096368 https://github.com/pydata/xarray/pull/2144#issuecomment-424096368 https://api.github.com/repos/pydata/xarray/issues/2144 MDEyOklzc3VlQ29tbWVudDQyNDA5NjM2OA== abrammer 6145107 2018-09-24T19:30:09Z 2018-09-24T19:30:09Z CONTRIBUTOR

Was looking for this functionality and came across the parent issue and this work around, did this just get forgotten or was there more work to be done? It'd be great to have this functionality readily available without having to work around. 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Add strftime() to datetime accessor 323823894

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