home / github

Menu
  • Search all tables
  • GraphQL API

issues

Table actions
  • GraphQL API for issues

3 rows where state = "closed", type = "pull" and user = 6200806 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: comments, created_at (date), updated_at (date), closed_at (date)

type 1

  • pull · 3 ✖

state 1

  • closed · 3 ✖

repo 1

  • xarray 3
id node_id number title user state locked assignee milestone comments created_at updated_at ▲ closed_at author_association active_lock_reason draft pull_request body reactions performed_via_github_app state_reason repo type
589471115 MDExOlB1bGxSZXF1ZXN0Mzk1MDE3NjEz 3906 Fix for stack+groupby+apply w/ non-increasing coord spencerahill 6200806 closed 0     4 2020-03-28T00:15:20Z 2020-03-31T18:29:35Z 2020-03-31T16:10:10Z CONTRIBUTOR   0 pydata/xarray/pulls/3906
  • [x] Fixes #3287
  • [x] Tests added
  • [x] Passes isort -rc . && black . && mypy . && flake8
  • [x] Fully documented, including whats-new.rst for all changes and api.rst for new API

I've added a check within groupby.__init__ for monotonicity of the coords, which makes my test pass, but it causes three existing tests to fail. Getting the logic right that properly distinguishes among these different cases is escaping me for now, but it does seem like this call to unique_value_groups within groupby.__init__ is where the re-sorting is occurring. Feedback welcome. TIA!

{
    "url": "https://api.github.com/repos/pydata/xarray/issues/3906/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
    xarray 13221727 pull
201770526 MDExOlB1bGxSZXF1ZXN0MTAyMjA1NDM3 1219 ENH import ufuncs module in toplevel namespace spencerahill 6200806 closed 0     1 2017-01-19T05:51:02Z 2017-01-19T05:59:26Z 2017-01-19T05:59:26Z CONTRIBUTOR   0 pydata/xarray/pulls/1219
  • [x] closes #1216
  • [ ] tests added / passed
  • [ ] passes git diff upstream/master | flake8 --diff
  • [ ] whatsnew entry

Let me know if you want tests and/or what's new; wasn't sure since this is so small.

{
    "url": "https://api.github.com/repos/pydata/xarray/issues/1219/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
    xarray 13221727 pull
130064443 MDExOlB1bGxSZXF1ZXN0NTc3NTczMzg= 736 Accept rename to same name spencerahill 6200806 closed 0     4 2016-01-31T02:17:01Z 2016-02-02T03:44:33Z 2016-02-02T01:33:03Z CONTRIBUTOR   0 pydata/xarray/pulls/736

Closes #724

{
    "url": "https://api.github.com/repos/pydata/xarray/issues/736/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
    xarray 13221727 pull

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [issues] (
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [number] INTEGER,
   [title] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [state] TEXT,
   [locked] INTEGER,
   [assignee] INTEGER REFERENCES [users]([id]),
   [milestone] INTEGER REFERENCES [milestones]([id]),
   [comments] INTEGER,
   [created_at] TEXT,
   [updated_at] TEXT,
   [closed_at] TEXT,
   [author_association] TEXT,
   [active_lock_reason] TEXT,
   [draft] INTEGER,
   [pull_request] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [state_reason] TEXT,
   [repo] INTEGER REFERENCES [repos]([id]),
   [type] TEXT
);
CREATE INDEX [idx_issues_repo]
    ON [issues] ([repo]);
CREATE INDEX [idx_issues_milestone]
    ON [issues] ([milestone]);
CREATE INDEX [idx_issues_assignee]
    ON [issues] ([assignee]);
CREATE INDEX [idx_issues_user]
    ON [issues] ([user]);
Powered by Datasette · Queries took 3517.795ms · About: xarray-datasette