home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 709505147

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/894#issuecomment-709505147 https://api.github.com/repos/simonw/datasette/issues/894 709505147 MDEyOklzc3VlQ29tbWVudDcwOTUwNTE0Nw== 9599 2020-10-15T18:18:45Z 2020-10-15T18:50:50Z OWNER

This needs querystring parameter design. Some options:

  • ?_sort_clause=cast(mycol+as+integer) and ?_sort_clause_desc=cast(mycol+as+integer) - allowing any expression. This would need to be disabled if arbitrary SQL was turned off, similar to the restrictions on ?_where=.
  • ?_sort_numeric=mycol and ?_sort_numeric_desc=mycol - this would cast to real which would work on integer values as well. It could be allowed even when arbitrary SQL was disabled.
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
657572753  
Powered by Datasette · Queries took 0.947ms · About: github-to-sqlite