issue_comments: 551349770

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/617#issuecomment-551349770 https://api.github.com/repos/simonw/datasette/issues/617 551349770 MDEyOklzc3VlQ29tbWVudDU1MTM0OTc3MA== 9599 2019-11-08T01:59:20Z 2019-11-11T00:53:42Z OWNER

This is what the code does:

  • Check if the table name is actually a canned query - if so execute that
  • Check for other parameters that need to be redirected - e.g. ?_filter_column=x or _sort_by_desc=y
  • Turn the table + querystring parameters (?foo=bar, ?bar__contains=baz, ?_where=, _sort= etc) into a SQL query
  • Figure out pagination (apply limit, and handle keyset pagination)
  • Calculate suggested facets against the non-paginated version of the query
  • Calculate facet counts against the non-paginated version of the query
  • Execute the query
  • Expand any foreign key references from the results
 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 519613116