home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 392214791

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/datasette/issues/259#issuecomment-392214791 https://api.github.com/repos/simonw/datasette/issues/259 392214791 MDEyOklzc3VlQ29tbWVudDM5MjIxNDc5MQ== 9599 2018-05-25T23:43:15Z 2018-07-29T00:56:03Z OWNER

We may need to derive a usable name for each of these relationships that can be used in eg querystring parameters.

The name of the join table is a reasonable choice here. Say the join table is called event_tags - the querystring for returning all events that are tagged badger could be /db/events?_m2m_event_tags__tag=badger perhaps?

But what if event_tags has more than one foreign key back to events? Might need to specify the column in events that is referred back to by event_tags somehow in that case.

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