From 789b98a958db40edf32ae392a2ca18371f84c8ef Mon Sep 17 00:00:00 2001 From: CoprDistGit Date: Wed, 31 May 2023 07:55:44 +0000 Subject: automatic import of python-datasette-json-html --- .gitignore | 1 + python-datasette-json-html.spec | 730 ++++++++++++++++++++++++++++++++++++++++ sources | 1 + 3 files changed, 732 insertions(+) create mode 100644 python-datasette-json-html.spec create mode 100644 sources diff --git a/.gitignore b/.gitignore index e69de29..2bd0eec 100644 --- a/.gitignore +++ b/.gitignore @@ -0,0 +1 @@ +/datasette-json-html-1.0.1.tar.gz diff --git a/python-datasette-json-html.spec b/python-datasette-json-html.spec new file mode 100644 index 0000000..ea02511 --- /dev/null +++ b/python-datasette-json-html.spec @@ -0,0 +1,730 @@ +%global _empty_manifest_terminate_build 0 +Name: python-datasette-json-html +Version: 1.0.1 +Release: 1 +Summary: Datasette plugin for rendering HTML based on JSON values +License: Apache License, Version 2.0 +URL: https://datasette.io/plugins/datasette-json-html +Source0: https://mirrors.nju.edu.cn/pypi/web/packages/95/45/a7f5e828dd6b249e9d0214d11d789350fd8a24f12b08b878c05416c5e08b/datasette-json-html-1.0.1.tar.gz +BuildArch: noarch + +Requires: python3-datasette +Requires: python3-pytest +Requires: python3-pytest-asyncio +Requires: python3-httpx + +%description +# datasette-json-html + +[![PyPI](https://img.shields.io/pypi/v/datasette-json-html.svg)](https://pypi.org/project/datasette-json-html/) +[![Changelog](https://img.shields.io/github/v/release/simonw/datasette-json-html?include_prereleases&label=changelog)](https://github.com/simonw/datasette-json-html/releases) +[![Tests](https://github.com/simonw/datasette-json-html/workflows/Test/badge.svg)](https://github.com/simonw/datasette-remote-metadata/actions?query=workflow%3ATest) +[![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)](https://github.com/simonw/datasette-json-html/blob/main/LICENSE) + +Datasette plugin for rendering HTML based on JSON values, using the [render_cell plugin hook](https://docs.datasette.io/en/stable/plugin_hooks.html#render-cell-value-column-table-database-datasette). + +This plugin looks for cell values that match a very specific JSON format and converts them into HTML when they are rendered by the Datasette interface. + +## Links + + { + "href": "https://simonwillison.net/", + "label": "Simon Willison" + } + +Will be rendered as an `` link: + + Simon Willison + +You can set a tooltip on the link using a `"title"` key: + + + { + "href": "https://simonwillison.net/", + "label": "Simon Willison", + "title": "My blog" + } + +Produces: + + Simon Willison + +You can also include a description, which will be displayed below the link. If descriptions include newlines they will be converted to `
` elements: + + select json_object( + "href", "https://simonwillison.net/", + "label", "Simon Willison", + "description", "This can contain" || x'0a' || "newlines" + ) + +Produces: + + Simon Willison
This can contain
newlines + +* [Literal JSON link demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%7B%0D%0A++++%22href%22%3A+%22https%3A%2F%2Fsimonwillison.net%2F%22%2C%0D%0A++++%22label%22%3A+%22Simon+Willison%22%2C%0D%0A++++%22title%22%3A+%22My+blog%22%0D%0A%7D%27) + +## List of links + + [ + { + "href": "https://simonwillison.net/", + "label": "Simon Willison" + }, + { + "href": "https://github.com/simonw/datasette", + "label": "Datasette" + } + ] + +Will be rendered as a comma-separated list of `` links: + + Simon Willison, + Datasette + +The `href` property must begin with `https://` or `http://` or `/`, to avoid potential XSS injection attacks (for example URLs that begin with `javascript:`). + +Lists of links cannot include `"description"` keys. + +* [Literal list of links demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%5B%0D%0A++++%7B%0D%0A++++++++%22href%22%3A+%22https%3A%2F%2Fsimonwillison.net%2F%22%2C%0D%0A++++++++%22label%22%3A+%22Simon+Willison%22%0D%0A++++%7D%2C%0D%0A++++%7B%0D%0A++++++++%22href%22%3A+%22https%3A%2F%2Fgithub.com%2Fsimonw%2Fdatasette%22%2C%0D%0A++++++++%22label%22%3A+%22Datasette%22%0D%0A++++%7D%0D%0A%5D%27) + +## Images + +The image tag is more complex. The most basic version looks like this: + + { + "img_src": "https://placekitten.com/200/300" + } + +This will render as: + + + +But you can also include one or more of `alt`, `caption`, `width` and `href`. + +If you include width or alt, they will be added as attributes: + + { + "img_src": "https://placekitten.com/200/300", + "alt": "Kitten", + "width": 200 + } + +Produces: + + Kitten + +* [Literal image demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%7B%0D%0A++++%22img_src%22%3A+%22https%3A%2F%2Fplacekitten.com%2F200%2F300%22%2C%0D%0A++++%22alt%22%3A+%22Kitten%22%2C%0D%0A++++%22width%22%3A+200%0D%0A%7D%27) + +The `href` key will cause the image to be wrapped in a link: + + { + "img_src": "https://placekitten.com/200/300", + "href": "http://www.example.com" + } + +Produces: + + + + + +The `caption` key wraps everything in a fancy figure/figcaption block: + + { + "img_src": "https://placekitten.com/200/300", + "caption": "Kitten caption" + } + +Produces: + +
+ +
Kitten caption
+
+ +## Preformatted text + +You can use `{"pre": "text"}` to render text in a `
` HTML tag:
+
+    {
+        "pre": "This\nhas\nnewlines"
+    }
+
+Produces:
+
+    
This
+    has
+    newlines

+
+If the value attached to the `"pre"` key is itself a JSON object, that JSON will be pretty-printed:
+
+    {
+        "pre": {
+            "this": {
+                "object": ["is", "nested"]
+            }
+        }
+    }
+
+Produces:
+
+    
{
+      "this": {
+        "object": [
+          "is",
+          "nested"
+        ]
+      }
+    }

+
+* [Preformatted text with JSON demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%7B%0D%0A++++%22pre%22%3A+%7B%0D%0A++++++++%22this%22%3A+%7B%0D%0A++++++++++++%22object%22%3A+%5B%22is%22%2C+%22nested%22%5D%0D%0A++++++++%7D%0D%0A++++%7D%0D%0A%7D%27)
+* [Preformatted text demo showing the Mandelbrot Set](https://datasette-json-html.datasette.io/demo?sql=WITH+RECURSIVE%0D%0A++xaxis%28x%29+AS+%28VALUES%28-2.0%29+UNION+ALL+SELECT+x%2B0.05+FROM+xaxis+WHERE+x%3C1.2%29%2C%0D%0A++yaxis%28y%29+AS+%28VALUES%28-1.0%29+UNION+ALL+SELECT+y%2B0.1+FROM+yaxis+WHERE+y%3C1.0%29%2C%0D%0A++m%28iter%2C+cx%2C+cy%2C+x%2C+y%29+AS+%28%0D%0A++++SELECT+0%2C+x%2C+y%2C+0.0%2C+0.0+FROM+xaxis%2C+yaxis%0D%0A++++UNION+ALL%0D%0A++++SELECT+iter%2B1%2C+cx%2C+cy%2C+x*x-y*y+%2B+cx%2C+2.0*x*y+%2B+cy+FROM+m+%0D%0A+++++WHERE+%28x*x+%2B+y*y%29+%3C+4.0+AND+iter%3C28%0D%0A++%29%2C%0D%0A++m2%28iter%2C+cx%2C+cy%29+AS+%28%0D%0A++++SELECT+max%28iter%29%2C+cx%2C+cy+FROM+m+GROUP+BY+cx%2C+cy%0D%0A++%29%2C%0D%0A++a%28t%29+AS+%28%0D%0A++++SELECT+group_concat%28+substr%28%27+.%2B*%23%27%2C+1%2Bmin%28iter%2F7%2C4%29%2C+1%29%2C+%27%27%29+%0D%0A++++FROM+m2+GROUP+BY+cy%0D%0A++%29%0D%0ASELECT+json_object%28%27pre%27%2C+group_concat%28rtrim%28t%29%2Cx%270a%27%29%29+FROM+a%3B) using [this example](https://www.sqlite.org/lang_with.html#outlandish_recursive_query_examples) from the SQLite documentation
+
+## Using these with SQLite JSON functions
+
+The most powerful way to make use of this plugin is in conjunction with SQLite's [JSON functions](https://www.sqlite.org/json1.html). For example:
+
+    select json_object(
+        "href", "https://simonwillison.net/",
+        "label", "Simon Willison"
+    );
+
+* [json_object() link demo](https://datasette-json-html.datasette.io/demo?sql=select+json_object%28%0D%0A++++%22href%22%2C+%22https%3A%2F%2Fsimonwillison.net%2F%22%2C%0D%0A++++%22label%22%2C+%22Simon+Willison%22%0D%0A%29%3B)
+
+You can use these functions to construct JSON objects that work with the plugin from data in a table:
+
+    select id, json_object(
+        "href", url, "label", text
+    ) from mytable;
+
+* [Demo that builds links against a table](https://datasette-json-html.datasette.io/demo?sql=select+json_object%28%22href%22%2C+url%2C+%22label%22%2C+package%2C+%22title%22%2C+package+%7C%7C+%22+%22+%7C%7C+url%29+as+package+from+packages)
+
+The `json_group_array()` function is an aggregate function similar to `group_concat()` - it allows you to construct lists of JSON objects in conjunction with a `GROUP BY` clause.
+
+This means you can use it to construct dynamic lists of links, for example:
+
+    select
+        substr(package, 0, 12) as prefix,
+        json_group_array(
+            json_object(
+                "href", url,
+                "label", package
+            )
+        ) as package_links
+    from packages
+    group by prefix
+
+* [Demo of json_group_array()](https://datasette-json-html.datasette.io/demo?sql=select%0D%0A++++substr%28package%2C+0%2C+12%29+as+prefix%2C%0D%0A++++json_group_array%28%0D%0A++++++++json_object%28%0D%0A++++++++++++%22href%22%2C+url%2C%0D%0A++++++++++++%22label%22%2C+package%0D%0A++++++++%29%0D%0A++++%29+as+package_links%0D%0Afrom+packages%0D%0Agroup+by+prefix)
+
+## The `urllib_quote_plus()` SQL function
+
+Since this plugin is designed to be used with SQL that constructs the underlying JSON structure, it is likely you will need to construct dynamic URLs from results returned by a SQL query.
+
+This plugin registers a custom SQLite function called `urllib_quote_plus()` to help you do that. It lets you use Python's [urllib.parse.quote\_plus() function](https://docs.python.org/3/library/urllib.parse.html#urllib.parse.quote_plus) from within a SQL query.
+
+Here's an example of how you might use it:
+
+    select id, json_object(
+        "href",
+        "/mydatabase/other_table?_search=" || urllib_quote_plus(text),
+        "label", text
+    ) from mytable;
+
+
+
+
+%package -n python3-datasette-json-html
+Summary:	Datasette plugin for rendering HTML based on JSON values
+Provides:	python-datasette-json-html
+BuildRequires:	python3-devel
+BuildRequires:	python3-setuptools
+BuildRequires:	python3-pip
+%description -n python3-datasette-json-html
+# datasette-json-html
+
+[![PyPI](https://img.shields.io/pypi/v/datasette-json-html.svg)](https://pypi.org/project/datasette-json-html/)
+[![Changelog](https://img.shields.io/github/v/release/simonw/datasette-json-html?include_prereleases&label=changelog)](https://github.com/simonw/datasette-json-html/releases)
+[![Tests](https://github.com/simonw/datasette-json-html/workflows/Test/badge.svg)](https://github.com/simonw/datasette-remote-metadata/actions?query=workflow%3ATest)
+[![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)](https://github.com/simonw/datasette-json-html/blob/main/LICENSE)
+
+Datasette plugin for rendering HTML based on JSON values, using the [render_cell plugin hook](https://docs.datasette.io/en/stable/plugin_hooks.html#render-cell-value-column-table-database-datasette).
+
+This plugin looks for cell values that match a very specific JSON format and converts them into HTML when they are rendered by the Datasette interface.
+
+## Links
+
+    {
+        "href": "https://simonwillison.net/",
+        "label": "Simon Willison"
+    }
+
+Will be rendered as an `` link:
+
+    Simon Willison
+
+You can set a tooltip on the link using a `"title"` key:
+
+
+    {
+        "href": "https://simonwillison.net/",
+        "label": "Simon Willison",
+        "title": "My blog"
+    }
+
+Produces:
+
+    Simon Willison
+
+You can also include a description, which will be displayed below the link. If descriptions include newlines they will be converted to `
` elements:
+
+    select json_object(
+        "href", "https://simonwillison.net/",
+        "label", "Simon Willison",
+        "description", "This can contain" || x'0a' || "newlines"
+    )
+
+Produces:
+
+    Simon Willison
This can contain
newlines
+
+* [Literal JSON link demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%7B%0D%0A++++%22href%22%3A+%22https%3A%2F%2Fsimonwillison.net%2F%22%2C%0D%0A++++%22label%22%3A+%22Simon+Willison%22%2C%0D%0A++++%22title%22%3A+%22My+blog%22%0D%0A%7D%27)
+
+## List of links
+
+    [
+        {
+            "href": "https://simonwillison.net/",
+            "label": "Simon Willison"
+        },
+        {
+            "href": "https://github.com/simonw/datasette",
+            "label": "Datasette"
+        }
+    ]
+
+Will be rendered as a comma-separated list of `` links:
+
+    Simon Willison,
+    Datasette
+
+The `href` property must begin with `https://` or `http://` or `/`, to avoid potential XSS injection attacks (for example URLs that begin with `javascript:`).
+
+Lists of links cannot include `"description"` keys.
+
+* [Literal list of links demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%5B%0D%0A++++%7B%0D%0A++++++++%22href%22%3A+%22https%3A%2F%2Fsimonwillison.net%2F%22%2C%0D%0A++++++++%22label%22%3A+%22Simon+Willison%22%0D%0A++++%7D%2C%0D%0A++++%7B%0D%0A++++++++%22href%22%3A+%22https%3A%2F%2Fgithub.com%2Fsimonw%2Fdatasette%22%2C%0D%0A++++++++%22label%22%3A+%22Datasette%22%0D%0A++++%7D%0D%0A%5D%27)
+
+## Images
+
+The image tag is more complex. The most basic version looks like this:
+
+    {
+        "img_src": "https://placekitten.com/200/300"
+    }
+
+This will render as:
+
+    
+
+But you can also include one or more of `alt`, `caption`, `width` and `href`.
+
+If you include width or alt, they will be added as attributes:
+
+    {
+        "img_src": "https://placekitten.com/200/300",
+        "alt": "Kitten",
+        "width": 200
+    }
+
+Produces:
+
+    Kitten
+
+* [Literal image demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%7B%0D%0A++++%22img_src%22%3A+%22https%3A%2F%2Fplacekitten.com%2F200%2F300%22%2C%0D%0A++++%22alt%22%3A+%22Kitten%22%2C%0D%0A++++%22width%22%3A+200%0D%0A%7D%27)
+
+The `href` key will cause the image to be wrapped in a link:
+
+    {
+        "img_src": "https://placekitten.com/200/300",
+        "href": "http://www.example.com"
+    }
+
+Produces:
+
+    
+        
+    
+
+The `caption` key wraps everything in a fancy figure/figcaption block:
+
+    {
+        "img_src": "https://placekitten.com/200/300",
+        "caption": "Kitten caption"
+    }
+
+Produces:
+
+    

+        
+        
Kitten caption

+    

+
+## Preformatted text
+
+You can use `{"pre": "text"}` to render text in a `
` HTML tag:
+
+    {
+        "pre": "This\nhas\nnewlines"
+    }
+
+Produces:
+
+    
This
+    has
+    newlines

+
+If the value attached to the `"pre"` key is itself a JSON object, that JSON will be pretty-printed:
+
+    {
+        "pre": {
+            "this": {
+                "object": ["is", "nested"]
+            }
+        }
+    }
+
+Produces:
+
+    
{
+      "this": {
+        "object": [
+          "is",
+          "nested"
+        ]
+      }
+    }

+
+* [Preformatted text with JSON demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%7B%0D%0A++++%22pre%22%3A+%7B%0D%0A++++++++%22this%22%3A+%7B%0D%0A++++++++++++%22object%22%3A+%5B%22is%22%2C+%22nested%22%5D%0D%0A++++++++%7D%0D%0A++++%7D%0D%0A%7D%27)
+* [Preformatted text demo showing the Mandelbrot Set](https://datasette-json-html.datasette.io/demo?sql=WITH+RECURSIVE%0D%0A++xaxis%28x%29+AS+%28VALUES%28-2.0%29+UNION+ALL+SELECT+x%2B0.05+FROM+xaxis+WHERE+x%3C1.2%29%2C%0D%0A++yaxis%28y%29+AS+%28VALUES%28-1.0%29+UNION+ALL+SELECT+y%2B0.1+FROM+yaxis+WHERE+y%3C1.0%29%2C%0D%0A++m%28iter%2C+cx%2C+cy%2C+x%2C+y%29+AS+%28%0D%0A++++SELECT+0%2C+x%2C+y%2C+0.0%2C+0.0+FROM+xaxis%2C+yaxis%0D%0A++++UNION+ALL%0D%0A++++SELECT+iter%2B1%2C+cx%2C+cy%2C+x*x-y*y+%2B+cx%2C+2.0*x*y+%2B+cy+FROM+m+%0D%0A+++++WHERE+%28x*x+%2B+y*y%29+%3C+4.0+AND+iter%3C28%0D%0A++%29%2C%0D%0A++m2%28iter%2C+cx%2C+cy%29+AS+%28%0D%0A++++SELECT+max%28iter%29%2C+cx%2C+cy+FROM+m+GROUP+BY+cx%2C+cy%0D%0A++%29%2C%0D%0A++a%28t%29+AS+%28%0D%0A++++SELECT+group_concat%28+substr%28%27+.%2B*%23%27%2C+1%2Bmin%28iter%2F7%2C4%29%2C+1%29%2C+%27%27%29+%0D%0A++++FROM+m2+GROUP+BY+cy%0D%0A++%29%0D%0ASELECT+json_object%28%27pre%27%2C+group_concat%28rtrim%28t%29%2Cx%270a%27%29%29+FROM+a%3B) using [this example](https://www.sqlite.org/lang_with.html#outlandish_recursive_query_examples) from the SQLite documentation
+
+## Using these with SQLite JSON functions
+
+The most powerful way to make use of this plugin is in conjunction with SQLite's [JSON functions](https://www.sqlite.org/json1.html). For example:
+
+    select json_object(
+        "href", "https://simonwillison.net/",
+        "label", "Simon Willison"
+    );
+
+* [json_object() link demo](https://datasette-json-html.datasette.io/demo?sql=select+json_object%28%0D%0A++++%22href%22%2C+%22https%3A%2F%2Fsimonwillison.net%2F%22%2C%0D%0A++++%22label%22%2C+%22Simon+Willison%22%0D%0A%29%3B)
+
+You can use these functions to construct JSON objects that work with the plugin from data in a table:
+
+    select id, json_object(
+        "href", url, "label", text
+    ) from mytable;
+
+* [Demo that builds links against a table](https://datasette-json-html.datasette.io/demo?sql=select+json_object%28%22href%22%2C+url%2C+%22label%22%2C+package%2C+%22title%22%2C+package+%7C%7C+%22+%22+%7C%7C+url%29+as+package+from+packages)
+
+The `json_group_array()` function is an aggregate function similar to `group_concat()` - it allows you to construct lists of JSON objects in conjunction with a `GROUP BY` clause.
+
+This means you can use it to construct dynamic lists of links, for example:
+
+    select
+        substr(package, 0, 12) as prefix,
+        json_group_array(
+            json_object(
+                "href", url,
+                "label", package
+            )
+        ) as package_links
+    from packages
+    group by prefix
+
+* [Demo of json_group_array()](https://datasette-json-html.datasette.io/demo?sql=select%0D%0A++++substr%28package%2C+0%2C+12%29+as+prefix%2C%0D%0A++++json_group_array%28%0D%0A++++++++json_object%28%0D%0A++++++++++++%22href%22%2C+url%2C%0D%0A++++++++++++%22label%22%2C+package%0D%0A++++++++%29%0D%0A++++%29+as+package_links%0D%0Afrom+packages%0D%0Agroup+by+prefix)
+
+## The `urllib_quote_plus()` SQL function
+
+Since this plugin is designed to be used with SQL that constructs the underlying JSON structure, it is likely you will need to construct dynamic URLs from results returned by a SQL query.
+
+This plugin registers a custom SQLite function called `urllib_quote_plus()` to help you do that. It lets you use Python's [urllib.parse.quote\_plus() function](https://docs.python.org/3/library/urllib.parse.html#urllib.parse.quote_plus) from within a SQL query.
+
+Here's an example of how you might use it:
+
+    select id, json_object(
+        "href",
+        "/mydatabase/other_table?_search=" || urllib_quote_plus(text),
+        "label", text
+    ) from mytable;
+
+
+
+
+%package help
+Summary:	Development documents and examples for datasette-json-html
+Provides:	python3-datasette-json-html-doc
+%description help
+# datasette-json-html
+
+[![PyPI](https://img.shields.io/pypi/v/datasette-json-html.svg)](https://pypi.org/project/datasette-json-html/)
+[![Changelog](https://img.shields.io/github/v/release/simonw/datasette-json-html?include_prereleases&label=changelog)](https://github.com/simonw/datasette-json-html/releases)
+[![Tests](https://github.com/simonw/datasette-json-html/workflows/Test/badge.svg)](https://github.com/simonw/datasette-remote-metadata/actions?query=workflow%3ATest)
+[![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)](https://github.com/simonw/datasette-json-html/blob/main/LICENSE)
+
+Datasette plugin for rendering HTML based on JSON values, using the [render_cell plugin hook](https://docs.datasette.io/en/stable/plugin_hooks.html#render-cell-value-column-table-database-datasette).
+
+This plugin looks for cell values that match a very specific JSON format and converts them into HTML when they are rendered by the Datasette interface.
+
+## Links
+
+    {
+        "href": "https://simonwillison.net/",
+        "label": "Simon Willison"
+    }
+
+Will be rendered as an `` link:
+
+    Simon Willison
+
+You can set a tooltip on the link using a `"title"` key:
+
+
+    {
+        "href": "https://simonwillison.net/",
+        "label": "Simon Willison",
+        "title": "My blog"
+    }
+
+Produces:
+
+    Simon Willison
+
+You can also include a description, which will be displayed below the link. If descriptions include newlines they will be converted to `
` elements:
+
+    select json_object(
+        "href", "https://simonwillison.net/",
+        "label", "Simon Willison",
+        "description", "This can contain" || x'0a' || "newlines"
+    )
+
+Produces:
+
+    Simon Willison
This can contain
newlines
+
+* [Literal JSON link demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%7B%0D%0A++++%22href%22%3A+%22https%3A%2F%2Fsimonwillison.net%2F%22%2C%0D%0A++++%22label%22%3A+%22Simon+Willison%22%2C%0D%0A++++%22title%22%3A+%22My+blog%22%0D%0A%7D%27)
+
+## List of links
+
+    [
+        {
+            "href": "https://simonwillison.net/",
+            "label": "Simon Willison"
+        },
+        {
+            "href": "https://github.com/simonw/datasette",
+            "label": "Datasette"
+        }
+    ]
+
+Will be rendered as a comma-separated list of `` links:
+
+    Simon Willison,
+    Datasette
+
+The `href` property must begin with `https://` or `http://` or `/`, to avoid potential XSS injection attacks (for example URLs that begin with `javascript:`).
+
+Lists of links cannot include `"description"` keys.
+
+* [Literal list of links demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%5B%0D%0A++++%7B%0D%0A++++++++%22href%22%3A+%22https%3A%2F%2Fsimonwillison.net%2F%22%2C%0D%0A++++++++%22label%22%3A+%22Simon+Willison%22%0D%0A++++%7D%2C%0D%0A++++%7B%0D%0A++++++++%22href%22%3A+%22https%3A%2F%2Fgithub.com%2Fsimonw%2Fdatasette%22%2C%0D%0A++++++++%22label%22%3A+%22Datasette%22%0D%0A++++%7D%0D%0A%5D%27)
+
+## Images
+
+The image tag is more complex. The most basic version looks like this:
+
+    {
+        "img_src": "https://placekitten.com/200/300"
+    }
+
+This will render as:
+
+    
+
+But you can also include one or more of `alt`, `caption`, `width` and `href`.
+
+If you include width or alt, they will be added as attributes:
+
+    {
+        "img_src": "https://placekitten.com/200/300",
+        "alt": "Kitten",
+        "width": 200
+    }
+
+Produces:
+
+    Kitten
+
+* [Literal image demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%7B%0D%0A++++%22img_src%22%3A+%22https%3A%2F%2Fplacekitten.com%2F200%2F300%22%2C%0D%0A++++%22alt%22%3A+%22Kitten%22%2C%0D%0A++++%22width%22%3A+200%0D%0A%7D%27)
+
+The `href` key will cause the image to be wrapped in a link:
+
+    {
+        "img_src": "https://placekitten.com/200/300",
+        "href": "http://www.example.com"
+    }
+
+Produces:
+
+    
+        
+    
+
+The `caption` key wraps everything in a fancy figure/figcaption block:
+
+    {
+        "img_src": "https://placekitten.com/200/300",
+        "caption": "Kitten caption"
+    }
+
+Produces:
+
+    

+        
+        
Kitten caption

+    

+
+## Preformatted text
+
+You can use `{"pre": "text"}` to render text in a `
` HTML tag:
+
+    {
+        "pre": "This\nhas\nnewlines"
+    }
+
+Produces:
+
+    
This
+    has
+    newlines

+
+If the value attached to the `"pre"` key is itself a JSON object, that JSON will be pretty-printed:
+
+    {
+        "pre": {
+            "this": {
+                "object": ["is", "nested"]
+            }
+        }
+    }
+
+Produces:
+
+    
{
+      "this": {
+        "object": [
+          "is",
+          "nested"
+        ]
+      }
+    }

+
+* [Preformatted text with JSON demo](https://datasette-json-html.datasette.io/demo?sql=select+%27%7B%0D%0A++++%22pre%22%3A+%7B%0D%0A++++++++%22this%22%3A+%7B%0D%0A++++++++++++%22object%22%3A+%5B%22is%22%2C+%22nested%22%5D%0D%0A++++++++%7D%0D%0A++++%7D%0D%0A%7D%27)
+* [Preformatted text demo showing the Mandelbrot Set](https://datasette-json-html.datasette.io/demo?sql=WITH+RECURSIVE%0D%0A++xaxis%28x%29+AS+%28VALUES%28-2.0%29+UNION+ALL+SELECT+x%2B0.05+FROM+xaxis+WHERE+x%3C1.2%29%2C%0D%0A++yaxis%28y%29+AS+%28VALUES%28-1.0%29+UNION+ALL+SELECT+y%2B0.1+FROM+yaxis+WHERE+y%3C1.0%29%2C%0D%0A++m%28iter%2C+cx%2C+cy%2C+x%2C+y%29+AS+%28%0D%0A++++SELECT+0%2C+x%2C+y%2C+0.0%2C+0.0+FROM+xaxis%2C+yaxis%0D%0A++++UNION+ALL%0D%0A++++SELECT+iter%2B1%2C+cx%2C+cy%2C+x*x-y*y+%2B+cx%2C+2.0*x*y+%2B+cy+FROM+m+%0D%0A+++++WHERE+%28x*x+%2B+y*y%29+%3C+4.0+AND+iter%3C28%0D%0A++%29%2C%0D%0A++m2%28iter%2C+cx%2C+cy%29+AS+%28%0D%0A++++SELECT+max%28iter%29%2C+cx%2C+cy+FROM+m+GROUP+BY+cx%2C+cy%0D%0A++%29%2C%0D%0A++a%28t%29+AS+%28%0D%0A++++SELECT+group_concat%28+substr%28%27+.%2B*%23%27%2C+1%2Bmin%28iter%2F7%2C4%29%2C+1%29%2C+%27%27%29+%0D%0A++++FROM+m2+GROUP+BY+cy%0D%0A++%29%0D%0ASELECT+json_object%28%27pre%27%2C+group_concat%28rtrim%28t%29%2Cx%270a%27%29%29+FROM+a%3B) using [this example](https://www.sqlite.org/lang_with.html#outlandish_recursive_query_examples) from the SQLite documentation
+
+## Using these with SQLite JSON functions
+
+The most powerful way to make use of this plugin is in conjunction with SQLite's [JSON functions](https://www.sqlite.org/json1.html). For example:
+
+    select json_object(
+        "href", "https://simonwillison.net/",
+        "label", "Simon Willison"
+    );
+
+* [json_object() link demo](https://datasette-json-html.datasette.io/demo?sql=select+json_object%28%0D%0A++++%22href%22%2C+%22https%3A%2F%2Fsimonwillison.net%2F%22%2C%0D%0A++++%22label%22%2C+%22Simon+Willison%22%0D%0A%29%3B)
+
+You can use these functions to construct JSON objects that work with the plugin from data in a table:
+
+    select id, json_object(
+        "href", url, "label", text
+    ) from mytable;
+
+* [Demo that builds links against a table](https://datasette-json-html.datasette.io/demo?sql=select+json_object%28%22href%22%2C+url%2C+%22label%22%2C+package%2C+%22title%22%2C+package+%7C%7C+%22+%22+%7C%7C+url%29+as+package+from+packages)
+
+The `json_group_array()` function is an aggregate function similar to `group_concat()` - it allows you to construct lists of JSON objects in conjunction with a `GROUP BY` clause.
+
+This means you can use it to construct dynamic lists of links, for example:
+
+    select
+        substr(package, 0, 12) as prefix,
+        json_group_array(
+            json_object(
+                "href", url,
+                "label", package
+            )
+        ) as package_links
+    from packages
+    group by prefix
+
+* [Demo of json_group_array()](https://datasette-json-html.datasette.io/demo?sql=select%0D%0A++++substr%28package%2C+0%2C+12%29+as+prefix%2C%0D%0A++++json_group_array%28%0D%0A++++++++json_object%28%0D%0A++++++++++++%22href%22%2C+url%2C%0D%0A++++++++++++%22label%22%2C+package%0D%0A++++++++%29%0D%0A++++%29+as+package_links%0D%0Afrom+packages%0D%0Agroup+by+prefix)
+
+## The `urllib_quote_plus()` SQL function
+
+Since this plugin is designed to be used with SQL that constructs the underlying JSON structure, it is likely you will need to construct dynamic URLs from results returned by a SQL query.
+
+This plugin registers a custom SQLite function called `urllib_quote_plus()` to help you do that. It lets you use Python's [urllib.parse.quote\_plus() function](https://docs.python.org/3/library/urllib.parse.html#urllib.parse.quote_plus) from within a SQL query.
+
+Here's an example of how you might use it:
+
+    select id, json_object(
+        "href",
+        "/mydatabase/other_table?_search=" || urllib_quote_plus(text),
+        "label", text
+    ) from mytable;
+
+
+
+
+%prep
+%autosetup -n datasette-json-html-1.0.1
+
+%build
+%py3_build
+
+%install
+%py3_install
+install -d -m755 %{buildroot}/%{_pkgdocdir}
+if [ -d doc ]; then cp -arf doc %{buildroot}/%{_pkgdocdir}; fi
+if [ -d docs ]; then cp -arf docs %{buildroot}/%{_pkgdocdir}; fi
+if [ -d example ]; then cp -arf example %{buildroot}/%{_pkgdocdir}; fi
+if [ -d examples ]; then cp -arf examples %{buildroot}/%{_pkgdocdir}; fi
+pushd %{buildroot}
+if [ -d usr/lib ]; then
+	find usr/lib -type f -printf "/%h/%f\n" >> filelist.lst
+fi
+if [ -d usr/lib64 ]; then
+	find usr/lib64 -type f -printf "/%h/%f\n" >> filelist.lst
+fi
+if [ -d usr/bin ]; then
+	find usr/bin -type f -printf "/%h/%f\n" >> filelist.lst
+fi
+if [ -d usr/sbin ]; then
+	find usr/sbin -type f -printf "/%h/%f\n" >> filelist.lst
+fi
+touch doclist.lst
+if [ -d usr/share/man ]; then
+	find usr/share/man -type f -printf "/%h/%f.gz\n" >> doclist.lst
+fi
+popd
+mv %{buildroot}/filelist.lst .
+mv %{buildroot}/doclist.lst .
+
+%files -n python3-datasette-json-html -f filelist.lst
+%dir %{python3_sitelib}/*
+
+%files help -f doclist.lst
+%{_docdir}/*
+
+%changelog
+* Wed May 31 2023 Python_Bot  - 1.0.1-1
+- Package Spec generated
diff --git a/sources b/sources
new file mode 100644
index 0000000..feee399
--- /dev/null
+++ b/sources
@@ -0,0 +1 @@
+0ad60513e6f788c3ddd25a4c251d78f4  datasette-json-html-1.0.1.tar.gz
-- 
cgit v1.2.3