Invalid GeoJSON object

[cornerot]

Hi!

I get "Invalid GeoJSON object" error when running the map example from the tutorial:

cat map.sql

select
    'map'   as component,
    'Paris' as title,
    11      as zoom,
    48.85   as latitude,
    2.34    as longitude,
    400     as height;
select
    'Notre Dame'             as title,
    'building-castle'        as icon,
    'indigo'                 as color,
    48.853                   as latitude,
    2.3498                   as longitude,
    'A beautiful cathedral.' as description_md,
    'https://en.wikipedia.org/wiki/Notre-Dame_de_Paris' as link;
select
    'Eiffel Tower' as title,
    'tower'        as icon,
    'yellow'       as color,
    48.8584        as latitude,
    2.2945         as longitude,
    'A tall tower. [Wikipedia](https://en.wikipedia.org/wiki/Eiffel_Tower)' as description_md;
select
    'Tower to Cathedral'      as title,
    JSON('{"type":"LineString","coordinates":[[2.2945,48.8584],[2.3498,48.8530]]}') as geojson,
    'teal'                    as color,
    'A nice 45 minutes walk.' as description;

[lovasoa]

Hi ! Which database are you using ? Does it work when passing the json object as a string ('{"type":"LineString","coordinates":[[2.2945,48.8584],[2.3498,48.8530]]} as geojson) ?

[cornerot]

I don't use a database. Just created the sql file from the tutorial. The error is the same as with

JSON('{"type":"LineString","coordinates":[[2.2945,48.8584],[2.3498,48.8530]]}') as geojson

or

'{"type":"LineString","coordinates":[[2.2945,48.8584],[2.3498,48.8530]]}' as geojson

[lovasoa]

Thank you for the precision. SQLPage is always connected to a database, but if you haven't explicitly configured any database connection, then you are using the default embedded SQLite database.

The bug only happens with databases that do not have native json objects. I can reproduce it locally; I'll fix it and release a new version shortly. Thanks for the report !

[lovasoa]

v0.15.2 was just released with the fix : https://github.com/lovasoa/SQLpage/releases/tag/v0.15.2