issue_comments

Table actions

9 rows where issue = 278286073 and user = 3169620 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

  • duncanwp · 9 ✖

issue 1

  • xarray to and from Iris · 9 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
353014435 https://github.com/pydata/xarray/pull/1750#issuecomment-353014435 https://api.github.com/repos/pydata/xarray/issues/1750 MDEyOklzc3VlQ29tbWVudDM1MzAxNDQzNQ== duncanwp 3169620 2017-12-20T09:41:31Z 2017-12-20T09:41:31Z CONTRIBUTOR

This looks good to go now - thanks for all your help!

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray to and from Iris 278286073
352884720 https://github.com/pydata/xarray/pull/1750#issuecomment-352884720 https://api.github.com/repos/pydata/xarray/issues/1750 MDEyOklzc3VlQ29tbWVudDM1Mjg4NDcyMA== duncanwp 3169620 2017-12-19T20:59:54Z 2017-12-19T20:59:54Z CONTRIBUTOR

Ah yes, sorry about that - fixed now.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray to and from Iris 278286073
352792765 https://github.com/pydata/xarray/pull/1750#issuecomment-352792765 https://api.github.com/repos/pydata/xarray/issues/1750 MDEyOklzc3VlQ29tbWVudDM1Mjc5Mjc2NQ== duncanwp 3169620 2017-12-19T15:30:22Z 2017-12-19T15:30:22Z CONTRIBUTOR

Yep, it's not a very exciting cube, but it runs fine.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray to and from Iris 278286073
352517727 https://github.com/pydata/xarray/pull/1750#issuecomment-352517727 https://api.github.com/repos/pydata/xarray/issues/1750 MDEyOklzc3VlQ29tbWVudDM1MjUxNzcyNw== duncanwp 3169620 2017-12-18T18:32:50Z 2017-12-18T18:32:50Z CONTRIBUTOR

How's this? (I turned the example around so that I create the cube as a DataArray then convert it...)

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray to and from Iris 278286073
352482551 https://github.com/pydata/xarray/pull/1750#issuecomment-352482551 https://api.github.com/repos/pydata/xarray/issues/1750 MDEyOklzc3VlQ29tbWVudDM1MjQ4MjU1MQ== duncanwp 3169620 2017-12-18T16:40:59Z 2017-12-18T16:40:59Z CONTRIBUTOR

dask/dask#2977 would certianly make it cleaner, but 95b0197 should work in the meantime, unless there's a specific case I've missed?

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray to and from Iris 278286073
352450958 https://github.com/pydata/xarray/pull/1750#issuecomment-352450958 https://api.github.com/repos/pydata/xarray/issues/1750 MDEyOklzc3VlQ29tbWVudDM1MjQ1MDk1OA== duncanwp 3169620 2017-12-18T15:04:53Z 2017-12-18T15:04:53Z CONTRIBUTOR

Great - thanks!

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray to and from Iris 278286073
352398860 https://github.com/pydata/xarray/pull/1750#issuecomment-352398860 https://api.github.com/repos/pydata/xarray/issues/1750 MDEyOklzc3VlQ29tbWVudDM1MjM5ODg2MA== duncanwp 3169620 2017-12-18T11:22:24Z 2017-12-18T11:22:24Z CONTRIBUTOR

OK, here's another go. It's not pretty, but it seems to work. Once the various issues referenced above are solved it should clean it up, but I'd rather not wait for those since this has been in the works a while now.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray to and from Iris 278286073
349602563 https://github.com/pydata/xarray/pull/1750#issuecomment-349602563 https://api.github.com/repos/pydata/xarray/issues/1750 MDEyOklzc3VlQ29tbWVudDM0OTYwMjU2Mw== duncanwp 3169620 2017-12-06T10:46:07Z 2017-12-06T10:46:07Z CONTRIBUTOR

Thanks for the feedback @shoyer and sorry for all the typos!

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray to and from Iris 278286073
348434198 https://github.com/pydata/xarray/pull/1750#issuecomment-348434198 https://api.github.com/repos/pydata/xarray/issues/1750 MDEyOklzc3VlQ29tbWVudDM0ODQzNDE5OA== duncanwp 3169620 2017-12-01T08:33:50Z 2017-12-01T08:34:00Z CONTRIBUTOR

I think this may be a reasonable place to start, though it is certainly not leveraging Iris's full metadata decoding capabilities.

It seams like a decent starting point, were there specific decodings you had in mind?

It would also be nice to pass dask arrays back and forth, but that will probably need to wait until after Iris 2.0 and #1372 is solved.

Agreed.

Do you have a feel for if/where else this should be documented? I'm not sure if really fits in I/O...

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xarray to and from Iris 278286073

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