github: issues: 7 rows where draft = 1 and state = "open"

7 rows where draft = 1 and state = "open"

Search:

descending

id ▼	node_id	number	title	user	state	comments	created_at	updated_at	author_association	pull_request	body	repo	type	reactions	draft
473288428	MDExOlB1bGxSZXF1ZXN0MzAxNDgzNjEz	564	First proof-of-concept of Datasette Library	simonw 9599	open	1	2019-07-26T10:22:26Z	2023-02-07T15:14:11Z	OWNER	simonw/datasette/pulls/564	Refs #417. Run it like this: datasette -d ~/Library Uses a new plugin hook - available_databases()	datasette 107914493	pull	{"url": "https://api.github.com/repos/simonw/datasette/issues/564/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	1
793002853	MDExOlB1bGxSZXF1ZXN0NTYwNzYwMTQ1	1204	WIP: Plugin includes	simonw 9599	open	3	2021-01-25T03:59:06Z	2021-12-17T07:10:49Z	OWNER	simonw/datasette/pulls/1204	Refs #1191 Next steps: - [ ] Get comfortable that this pattern is the right way to go - [ ] Implement it for all of the other pages, not just the table page - [ ] Add a new set of plugin tests that exercise ALL of these new hook locations - [ ] Document, then ship	datasette 107914493	pull	{"url": "https://api.github.com/repos/simonw/datasette/issues/1204/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	1
816601354	MDExOlB1bGxSZXF1ZXN0NTgwMjM1NDI3	241	Extract expand - work in progress	simonw 9599	open	0	2021-02-25T16:36:38Z	2021-02-25T16:36:38Z	OWNER	simonw/sqlite-utils/pulls/241	Refs #239. Still needs documentation and CLI implementation.	sqlite-utils 140912432	pull	{"url": "https://api.github.com/repos/simonw/sqlite-utils/issues/241/reactions", "total_count": 3, "+1": 3, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	1
837956424	MDExOlB1bGxSZXF1ZXN0NTk4MjEzNTY1	1271	Use SQLite conn.interrupt() instead of sqlite_timelimit()	simonw 9599	open	3	2021-03-22T17:34:20Z	2021-03-22T21:49:27Z	OWNER	simonw/datasette/pulls/1271	Refs #1270, #1268, #1249 Before merging this I need to do some more testing (to make sure that expensive queries really are properly cancelled). I also need to delete a bunch of code relating to the old mechanism of cancelling queries. [See comment below: this doesn't actually cancel the query due to a thread-local confusion]	datasette 107914493	pull	{"url": "https://api.github.com/repos/simonw/datasette/issues/1271/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	1
991206402	MDExOlB1bGxSZXF1ZXN0NzI5NzA0NTM3	1465	add support for -o --get /path	ctb 51016	open	0	2021-09-08T14:30:42Z	2021-09-08T14:31:45Z	CONTRIBUTOR	simonw/datasette/pulls/1465	Fixes https://github.com/simonw/datasette/issues/1459 Adds support for `--open --get /path` to be used in combination. If `--open` is provided alone, datasette will open a web page to a default URL. If `--get <url>` is provided alone, datasette will output the result of doing a GET to that URL and then exit. If `--open --get <url>` are provided together, datasette will open a web page to that URL. TODO items: - [ ] update documentation - [ ] print out error message when `--root --open --get <url>` is used - [ ] adjust code to require that `<url>` start with a `/` when `-o --get <url>` is used - [ ] add test(s) note, '@CTB' is used in this PR to flag code that needs revisiting.	datasette 107914493	pull	{"url": "https://api.github.com/repos/simonw/datasette/issues/1465/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	1
1864112887	PR_kwDOBm6k_c5Yo7bk	2151	Test Datasette on multiple SQLite versions	asg017 15178711	open	1	2023-08-23T22:42:51Z	2023-08-23T22:58:13Z	CONTRIBUTOR	simonw/datasette/pulls/2151	still testing, hope it works! <!-- readthedocs-preview datasette start --> ---- :books: Documentation preview :books:: https://datasette--2151.org.readthedocs.build/en/2151/ <!-- readthedocs-preview datasette end -->	datasette 107914493	pull	{"url": "https://api.github.com/repos/simonw/datasette/issues/2151/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	1
1866815458	PR_kwDOBm6k_c5YyF-C	2159	Implement Dark Mode colour scheme	jamietanna 3315059	open	0	2023-08-25T10:46:23Z	2023-08-25T10:46:35Z	FIRST_TIME_CONTRIBUTOR	simonw/datasette/pulls/2159	Closes #2095. <!-- readthedocs-preview datasette start --> ---- :books: Documentation preview :books:: https://datasette--2159.org.readthedocs.build/en/2159/ <!-- readthedocs-preview datasette end -->	datasette 107914493	pull	{"url": "https://api.github.com/repos/simonw/datasette/issues/2159/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	1

Advanced export

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

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,
   [pull_request] TEXT,
   [body] TEXT,
   [repo] INTEGER REFERENCES [repos]([id]),
   [type] TEXT
, [active_lock_reason] TEXT, [performed_via_github_app] TEXT, [reactions] TEXT, [draft] INTEGER, [state_reason] 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]);