issue_comments
9 rows where issue = 1292060682
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
1185982012 | https://github.com/simonw/sqlite-utils/issues/450#issuecomment-1185982012 | https://api.github.com/repos/simonw/sqlite-utils/issues/450 | IC_kwDOCGYnMM5GsKY8 | simonw 9599 | 2022-07-15T22:02:59Z | 2022-07-15T22:03:49Z | OWNER | From https://sqlite-utils.datasette.io/en/latest/cli-reference.html Commands that currently have an `--ignore` flag, and their descriptions: - `insert`: Ignore records if pk already exists - `create-table`: If table already exists, do nothing - `add-foreign-key`: If foreign key already exists, do nothing - `drop-table`: *description is missing* - `create-view`: If view already exists, do nothing - `drop-view`: *description is missing* And `create-index` has: - `--if-not-exists`: Ignore if index already exists | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add --ignore option to more commands 1292060682 | |
1185983894 | https://github.com/simonw/sqlite-utils/issues/450#issuecomment-1185983894 | https://api.github.com/repos/simonw/sqlite-utils/issues/450 | IC_kwDOCGYnMM5GsK2W | simonw 9599 | 2022-07-15T22:06:29Z | 2022-07-15T22:37:20Z | OWNER | Commands that could have `--ignore` added to them: - [x] `enable-fts` - [x] `disable-fts` (not doing) - [x] `add-column` - [x] `add-foreign-keys` (decided not to do this) - [x] `duplicate` - [x] `add-geometry-column` (decided not to do this) - [x] `create-spatial-index` (decided not to do this) | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add --ignore option to more commands 1292060682 | |
1185988277 | https://github.com/simonw/sqlite-utils/issues/450#issuecomment-1185988277 | https://api.github.com/repos/simonw/sqlite-utils/issues/450 | IC_kwDOCGYnMM5GsL61 | simonw 9599 | 2022-07-15T22:11:52Z | 2022-07-15T22:11:52Z | OWNER | For `enable-fts` I should use `--replace` instead, since that matches how the Python API works: https://github.com/simonw/sqlite-utils/blob/9dd4cf891d9f4565019e030ddc712507ac87b998/sqlite_utils/db.py#L2088-L2106 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add --ignore option to more commands 1292060682 | |
1185988480 | https://github.com/simonw/sqlite-utils/issues/450#issuecomment-1185988480 | https://api.github.com/repos/simonw/sqlite-utils/issues/450 | IC_kwDOCGYnMM5GsL-A | simonw 9599 | 2022-07-15T22:12:20Z | 2022-07-15T22:12:20Z | OWNER | `disable-fts` already fails silently if the table doesn't have FTS setup. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add --ignore option to more commands 1292060682 | |
1185993791 | https://github.com/simonw/sqlite-utils/issues/450#issuecomment-1185993791 | https://api.github.com/repos/simonw/sqlite-utils/issues/450 | IC_kwDOCGYnMM5GsNQ_ | simonw 9599 | 2022-07-15T22:23:02Z | 2022-07-15T22:23:02Z | OWNER | `create-spatial-index` is tricky. For consistency with `create-index` it should really use `--if-not-exists` - but under the hood it's not using `IF NOT EXISTS` because those indexes are created using `select CreateSpatialIndex(...)`. Really this highlights that `--if-not-exists` is a bad name for that option on `create-index`. I'm tempted to add `--ignore` to `create-index` and mark `--if-not-exists` as deprecated - though it will still work because I don't want to release a major version bump. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add --ignore option to more commands 1292060682 | |
1185994282 | https://github.com/simonw/sqlite-utils/issues/450#issuecomment-1185994282 | https://api.github.com/repos/simonw/sqlite-utils/issues/450 | IC_kwDOCGYnMM5GsNYq | simonw 9599 | 2022-07-15T22:24:12Z | 2022-07-15T22:24:12Z | OWNER | I can do this for `--create-index` instead: ``` Options: --name TEXT Explicit name for the new index --unique Make this a unique index --if-not-exists, --ignore Ignore if index already exists --analyze Run ANALYZE after creating the index --load-extension TEXT SQLite extensions to load -h, --help Show this message and exit. ``` That supports both names for the option. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add --ignore option to more commands 1292060682 | |
1185997860 | https://github.com/simonw/sqlite-utils/issues/450#issuecomment-1185997860 | https://api.github.com/repos/simonw/sqlite-utils/issues/450 | IC_kwDOCGYnMM5GsOQk | simonw 9599 | 2022-07-15T22:32:51Z | 2022-07-15T22:32:51Z | OWNER | `add-foreign-keys` is enough of a power-feature that I'm happy not to add this there. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add --ignore option to more commands 1292060682 | |
1186001408 | https://github.com/simonw/sqlite-utils/issues/450#issuecomment-1186001408 | https://api.github.com/repos/simonw/sqlite-utils/issues/450 | IC_kwDOCGYnMM5GsPIA | simonw 9599 | 2022-07-15T22:37:40Z | 2022-07-15T22:37:40Z | OWNER | I'm going to skip `add-geometry-column` and `create-spatial-index` as well. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add --ignore option to more commands 1292060682 | |
1186002019 | https://github.com/simonw/sqlite-utils/issues/450#issuecomment-1186002019 | https://api.github.com/repos/simonw/sqlite-utils/issues/450 | IC_kwDOCGYnMM5GsPRj | simonw 9599 | 2022-07-15T22:39:09Z | 2022-07-15T22:39:09Z | OWNER | Here are all of the changes I made in this issue: https://github.com/simonw/sqlite-utils/compare/e10536c7f59abbb785f092bf83c4ab94c00e31a3...b9a89a0f2c3559989efe65f25a6e1f8fa76fe8b0 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Add --ignore option to more commands 1292060682 |
Advanced export
JSON shape: default, array, newline-delimited, object
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, [issue] INTEGER REFERENCES [issues]([id]) , [performed_via_github_app] TEXT); CREATE INDEX [idx_issue_comments_issue] ON [issue_comments] ([issue]); CREATE INDEX [idx_issue_comments_user] ON [issue_comments] ([user]);