pull_requests

Table actions

1 row where user = 83403825

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ node_id number state locked title user body created_at updated_at closed_at merged_at merge_commit_sha assignee milestone draft head base author_association auto_merge repo url merged_by
1136386216 PR_kwDOAMm_X85Du-Co 7323 closed 0 (Issue #7324) added functions that return data values in memory efficient manner adanb13 83403825 added functions: - `data_to_list_save_memory` - `_genlist` `data_to_list_save_memory` returns a list of data values from a given Xarray.DataArray. Creates a list of data values as data values from the original Xarray.DataArray is removed (saving memory) `_genlist` provides a generator (Most memory efficient) Useful when returning data values in json format of large datasets after the dataset no longer in use to avoid memory issues. The function is more efficient than `to_dict()` regarding memory usage when calling for just the data values. <!-- Feel free to remove check-list items aren't relevant to your change --> - [x] Documentation regarding tests: https://gist.github.com/adanb13/9203bcb411246267cea244bb2f29ca2d - [x] Addressing Issue: https://github.com/pydata/xarray/issues/7324 2022-11-26T04:54:50Z 2023-02-07T18:25:18Z 2023-02-07T18:25:17Z   6c620afcca94a3af758857088a5bf7f04a13c4a7     0 7107f8d67acdc44c8a60e582d1f1c2f82f9bc32a ff6793d975ef4d1d8d5d32b8ad6f4f44e02dda9b NONE   xarray 13221727 https://github.com/pydata/xarray/pull/7323  

Advanced export

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

CSV options: 

CREATE TABLE [pull_requests] (
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [number] INTEGER,
   [state] TEXT,
   [locked] INTEGER,
   [title] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [body] TEXT,
   [created_at] TEXT,
   [updated_at] TEXT,
   [closed_at] TEXT,
   [merged_at] TEXT,
   [merge_commit_sha] TEXT,
   [assignee] INTEGER REFERENCES [users]([id]),
   [milestone] INTEGER REFERENCES [milestones]([id]),
   [draft] INTEGER,
   [head] TEXT,
   [base] TEXT,
   [author_association] TEXT,
   [auto_merge] TEXT,
   [repo] INTEGER REFERENCES [repos]([id]),
   [url] TEXT,
   [merged_by] INTEGER REFERENCES [users]([id])
);
CREATE INDEX [idx_pull_requests_merged_by]
    ON [pull_requests] ([merged_by]);
CREATE INDEX [idx_pull_requests_repo]
    ON [pull_requests] ([repo]);
CREATE INDEX [idx_pull_requests_milestone]
    ON [pull_requests] ([milestone]);
CREATE INDEX [idx_pull_requests_assignee]
    ON [pull_requests] ([assignee]);
CREATE INDEX [idx_pull_requests_user]
    ON [pull_requests] ([user]);