SQL queries can't contain a double quote about datasette-dashboards HOT 3 CLOSED

@CharlesNepote Fixed in PR #58

from datasette-dashboards.

Thanks @CharlesNepote for bringing up this issue. I've never experienced it but I am willing to understand the problem!

A few things to clear things up:

• Could you provide an example of a non-functional query with double-quotes?
• Do you experience the same issue when using Datasette Canned Queries? (https://docs.datasette.io/en/stable/sql_queries.html#canned-queries)

In any case, one need to be careful with quotes in SQL: double and single quotes do not have the same meaning and use.

from datasette-dashboards.

Could you provide an example of a non-functional query with double-quotes?

Here is a simple example:

      charts:
        count:
          title: Total number of measures
          # name of the db without .db
          db: off-stats
          query:
            SELECT count(*) as count FROM data_quality_stats where country == "fr"
          library: metric
          display:
            field: count
            prefix:
            suffix:

The datasette instance is working well but I'm entering the /-/dashboards/my-dashboard, the count chart is empty and firefox console is yelling: Uncaught SyntaxError: JSON.parse: expected ',' or '}' after property value in object at line 1 column 182 of the JSON data

If I replace double quote with simple quotes, then it works.

Do you experience the same issue when using Datasette Canned Queries?

No. The same request with double quotes as a Canned Query is working well.

from datasette-dashboards.