issue_comments: 1652723029

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/2112#issuecomment-1652723029 https://api.github.com/repos/simonw/datasette/issues/2112 1652723029 IC_kwDOBm6k_c5igo1V 9599 2023-07-27T00:25:49Z 2023-07-27T00:25:49Z OWNER

Getting the query page working with all of the necessary HTML context variables is a slog.

I uploaded query.html to Claude and asked it "List of every template context variable with a detailed description of each one":

Based on the template code provided, here is a list of the template context variables and a description of each one:

  • database - The name of the database being queried.
  • query - The SQL query object containing the sql string.
  • canned_query - The name of the canned query if this is a canned query.
  • private - Boolean indicating if this is a private database.
  • urls - Object containing URL helpers like database().
  • canned_write - Boolean indicating if this canned query allows writes.
  • db_is_immutable - Boolean indicating if this database is immutable.
  • error - Any query error message.
  • hide_sql - Boolean indicating if the SQL should be hidden.
  • show_hide_link - The URL to toggle showing/hiding the SQL.
  • show_hide_text - The text for the show/hide SQL link.
  • editable - Boolean indicating if the SQL can be edited.
  • allow_execute_sql - Boolean indicating if custom SQL can be executed.
  • tables - List of table objects in the database.
  • named_parameter_values - Dictionary of parameter names/values.
  • csrftoken() - Function to generate a CSRF token.
  • edit_sql_url - URL to edit the SQL for a canned query.
  • display_rows - List of result rows to display.
  • columns - List of column names.
  • renderers - Dictionary of renderer name to URL.
  • url_csv - URL for CSV export.
  • metadata - Metadata about the query/database.
  • crumbs - Breadcrumb navigation object.

So in summary, it includes variables for the database, query, results, URLs, permissions, and metadata to power the template.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1822938661