home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 786037219

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/240#issuecomment-786037219 https://api.github.com/repos/simonw/sqlite-utils/issues/240 786037219 MDEyOklzc3VlQ29tbWVudDc4NjAzNzIxOQ== 9599 2021-02-25T16:39:23Z 2021-02-25T16:39:23Z OWNER

Example from the docs: ```pycon

db = sqlite_utils.Database(memory=True) db["dogs"].insert({"name": "Cleo"}) for pk, row in db["dogs"].pks_and_rows_where(): ... print(pk, row) 1 {'rowid': 1, 'name': 'Cleo'}

db["dogs_with_pk"].insert({"id": 5, "name": "Cleo"}, pk="id") for pk, row in db["dogs_with_pk"].pks_and_rows_where(): ... print(pk, row) 5 {'id': 5, 'name': 'Cleo'}

db["dogs_with_compound_pk"].insert( ... {"species": "dog", "id": 3, "name": "Cleo"}, ... pk=("species", "id") ... ) for pk, row in db["dogs_with_compound_pk"].pks_and_rows_where(): ... print(pk, row) ('dog', 3) {'species': 'dog', 'id': 3, 'name': 'Cleo'} ```

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
816560819  
Powered by Datasette · Queries took 1.389ms · About: github-to-sqlite