github: issues: 6 rows where "updated_at" is on date 2020-09-22 and user = 9599

6 rows where "updated_at" is on date 2020-09-22 and user = 9599

Search:

descending

id ▼	node_id	number	title	user	state	milestone	comments	created_at	updated_at	closed_at	author_association	pull_request	body	repo	type	reactions	draft	state_reason
470345929	MDU6SXNzdWU0NzAzNDU5Mjk=	42	table.extract(...) method and "sqlite-utils extract" command	simonw 9599	closed	2.20 5897911	21	2019-07-19T14:09:36Z	2020-09-22T23:39:31Z	2020-09-22T23:37:49Z	OWNER		One of my favourite features of [csvs-to-sqlite](https://github.com/simonw/csvs-to-sqlite) is that it can "extract" columns into a separate lookup table - for example: csvs-to-sqlite big_csv_file.csv -c country output.db This will turn the `country` column in the resulting table into a integer foreign key against a new `country` table. You can see an example of what that looks like here: https://san-francisco.datasettes.com/registered-business-locations-3d50679/Business+Corridor was extracted from https://san-francisco.datasettes.com/registered-business-locations-3d50679/Registered_Business_Locations_-_San_Francisco?Business%20Corridor=1 I'd like to have the same capability in `sqlite-utils` - but with the ability to run it against an existing SQLite table rather than just against a CSV.	sqlite-utils 140912432	issue	{"url": "https://api.github.com/repos/simonw/sqlite-utils/issues/42/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}		completed
557830332	MDExOlB1bGxSZXF1ZXN0MzY5MzQ4MDg0	78	New conversions= feature, refs #77	simonw 9599	closed		0	2020-01-31T00:02:33Z	2020-09-22T07:48:29Z	2020-01-31T00:24:31Z	OWNER	simonw/sqlite-utils/pulls/78		sqlite-utils 140912432	pull	{"url": "https://api.github.com/repos/simonw/sqlite-utils/issues/78/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	0
621989740	MDU6SXNzdWU2MjE5ODk3NDA=	114	table.transform() method for advanced alter table	simonw 9599	closed	2.20 5897911	26	2020-05-20T18:20:46Z	2020-09-22T07:51:37Z	2020-09-22T04:20:02Z	OWNER		SQLite's `ALTER TABLE` can only do the following: * Rename a table * Rename a column * Add a column Notably, it cannot drop columns - so tricks like "add a float version of this text column, populate it, then drop the old one and rename" won't work. The docs here https://www.sqlite.org/lang_altertable.html#making_other_kinds_of_table_schema_changes describe a way of implementing full alters safely within a transaction, but it's fiddly. 1. Create new table 2. Copy data 3. Drop old table 4. Rename new into old It would be great if `sqlite-utils` provided an abstraction to help make these kinds of changes safely.	sqlite-utils 140912432	issue	{"url": "https://api.github.com/repos/simonw/sqlite-utils/issues/114/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}		completed
705975133	MDExOlB1bGxSZXF1ZXN0NDkwNjA3OTQ5	161	table.transform() method	simonw 9599	closed	2.20 5897911	13	2020-09-21T23:16:59Z	2020-09-22T07:48:24Z	2020-09-22T04:20:02Z	OWNER	simonw/sqlite-utils/pulls/161	Refs #114 - [x] Ability to change the primary key - [x] Support for changing default value for columns - [x] Support for changing `NOT NULL` status of columns - [x] Support for copying existing foreign keys and removing them - <strike>Support for `conversions=` parameter</strike> - [x] Detailed documentation - [x] `PRAGMA foreign_keys` stuff	sqlite-utils 140912432	pull	{"url": "https://api.github.com/repos/simonw/sqlite-utils/issues/161/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	0
705995722	MDU6SXNzdWU3MDU5OTU3MjI=	162	A decorator for registering custom SQL functions	simonw 9599	closed		2	2020-09-22T00:18:32Z	2020-09-22T00:40:44Z	2020-09-22T00:32:17Z	OWNER		Syntactic sugar for `db.conn.create_function` - it would work something like this: ```python db = sqlite_utils.Database("mydb.db") @db.register_function def scramble(text): chars = list(text) random.shuffle(chars) return "".join(chars) ``` The decorator would inspect the function to find its name and arity (number of arguments). Having run the above you could then do: ```python db.execute("select scramble('hello')").fetchall() ```	sqlite-utils 140912432	issue	{"url": "https://api.github.com/repos/simonw/sqlite-utils/issues/162/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}		completed
706092617	MDExOlB1bGxSZXF1ZXN0NDkwNzAzMTcz	166	Keyword only arguments for transform()	simonw 9599	closed		0	2020-09-22T05:41:44Z	2020-09-22T06:39:11Z	2020-09-22T06:39:11Z	OWNER	simonw/sqlite-utils/pulls/166	Refs #165	sqlite-utils 140912432	pull	{"url": "https://api.github.com/repos/simonw/sqlite-utils/issues/166/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0}	0

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