home / github

Menu
  • GraphQL API
  • Search all tables

issue_comments

Table actions
  • GraphQL API for issue_comments

2 rows where issue = 209523348 and user = 5635139 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

  • max-sixty · 2 ✖

issue 1

  • update_attrs method · 2 ✖

author_association 1

  • MEMBER 2
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
282155745 https://github.com/pydata/xarray/issues/1281#issuecomment-282155745 https://api.github.com/repos/pydata/xarray/issues/1281 MDEyOklzc3VlQ29tbWVudDI4MjE1NTc0NQ== max-sixty 5635139 2017-02-23T23:29:28Z 2017-02-23T23:29:28Z MEMBER

A lambda solution is more difficult (maybe impossible?) because you need to update the attrs and return the original object to continue the pipe.

Right, yes. Then there's no reasonable solution without this addition, I think

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  update_attrs method 209523348
282123529 https://github.com/pydata/xarray/issues/1281#issuecomment-282123529 https://api.github.com/repos/pydata/xarray/issues/1281 MDEyOklzc3VlQ29tbWVudDI4MjEyMzUyOQ== max-sixty 5635139 2017-02-23T21:15:53Z 2017-02-23T21:15:53Z MEMBER

Thanks for the PR @hsharrison

Do ppl think the cost of an extra method is worth the cleaner syntax? Would ds.pipe(lambda x: x.attrs.update(foo=bar') suffice? It's easier to add methods than to remove them, though this approach does look nicer.

If python had a cleaner lambda...

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  update_attrs method 209523348

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]);
Powered by Datasette · Queries took 110.349ms · About: xarray-datasette