issue_comments
8 rows where issue = 455496504
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 526794367 | https://github.com/simonw/sqlite-utils/issues/27#issuecomment-526794367 | https://api.github.com/repos/simonw/sqlite-utils/issues/27 | MDEyOklzc3VlQ29tbWVudDUyNjc5NDM2Nw== | simonw 9599 | 2019-08-31T03:05:18Z | 2019-08-31T03:06:10Z | OWNER | Potential syntax: $ sqlite-utils create-table foo.db dogs \ id integer \ name string \ age integer \ --pk=id | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | sqlite-utils create-table command 455496504 | |
| 623048530 | https://github.com/simonw/sqlite-utils/issues/27#issuecomment-623048530 | https://api.github.com/repos/simonw/sqlite-utils/issues/27 | MDEyOklzc3VlQ29tbWVudDYyMzA0ODUzMA== | simonw 9599 | 2020-05-03T03:30:31Z | 2020-05-03T03:30:31Z | OWNER | Copy the design for `--not-null` and `--default` from the `insert` command: ``` $ sqlite-utils insert dogs.db dogs_with_scores dogs-with-scores.json \ --not-null=age \ --not-null=name \ --default age 2 \ --default score 5 ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | sqlite-utils create-table command 455496504 | |
| 623049505 | https://github.com/simonw/sqlite-utils/issues/27#issuecomment-623049505 | https://api.github.com/repos/simonw/sqlite-utils/issues/27 | MDEyOklzc3VlQ29tbWVudDYyMzA0OTUwNQ== | simonw 9599 | 2020-05-03T03:45:32Z | 2020-05-03T03:45:32Z | OWNER | Could take `--ignore` to ignore if table already exists, and `--replace` to drop and replace it if it exists. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | sqlite-utils create-table command 455496504 | |
| 623051392 | https://github.com/simonw/sqlite-utils/issues/27#issuecomment-623051392 | https://api.github.com/repos/simonw/sqlite-utils/issues/27 | MDEyOklzc3VlQ29tbWVudDYyMzA1MTM5Mg== | simonw 9599 | 2020-05-03T04:15:05Z | 2020-05-03T04:15:05Z | OWNER | I need tests for what happens if table already exists, or if the user provides invalid column types. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | sqlite-utils create-table command 455496504 | |
| 623051447 | https://github.com/simonw/sqlite-utils/issues/27#issuecomment-623051447 | https://api.github.com/repos/simonw/sqlite-utils/issues/27 | MDEyOklzc3VlQ29tbWVudDYyMzA1MTQ0Nw== | simonw 9599 | 2020-05-03T04:15:52Z | 2020-05-03T04:15:52Z | OWNER | Supporting `--fk colname othertable othercol` would be neat too. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | sqlite-utils create-table command 455496504 | |
| 623051550 | https://github.com/simonw/sqlite-utils/issues/27#issuecomment-623051550 | https://api.github.com/repos/simonw/sqlite-utils/issues/27 | MDEyOklzc3VlQ29tbWVudDYyMzA1MTU1MA== | simonw 9599 | 2020-05-03T04:17:18Z | 2020-05-03T04:17:18Z | OWNER | Be nice if you could do `--fk colname` and have it guess the rest, but I'm not sure how to do that with a CLI option - they need a fixed number of arguments so that they don't consume the next batch of options. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | sqlite-utils create-table command 455496504 | |
| 623120166 | https://github.com/simonw/sqlite-utils/issues/27#issuecomment-623120166 | https://api.github.com/repos/simonw/sqlite-utils/issues/27 | MDEyOklzc3VlQ29tbWVudDYyMzEyMDE2Ng== | simonw 9599 | 2020-05-03T14:38:59Z | 2020-05-03T14:38:59Z | OWNER | I'll stick with requiring all three fk arguments. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | sqlite-utils create-table command 455496504 | |
| 623126943 | https://github.com/simonw/sqlite-utils/issues/27#issuecomment-623126943 | https://api.github.com/repos/simonw/sqlite-utils/issues/27 | MDEyOklzc3VlQ29tbWVudDYyMzEyNjk0Mw== | simonw 9599 | 2020-05-03T15:25:55Z | 2020-05-03T15:25:55Z | OWNER | Documentation: https://github.com/simonw/sqlite-utils/blob/78264b738cd72ffad6e5c32ede3f074f8aad0ca4/docs/cli.rst#creating-tables | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | sqlite-utils create-table command 455496504 |
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]);