datasette-create-view 0.1

Create a SQL view from a query

datasette-create-view

Create a SQL view from a query

Installation

Install this plugin in the same environment as Datasette.

datasette install datasette-create-view

Usage

Users with the create-table permission will get a new menu item on the query results page offering to save the query as a view.

This option will only show for SQL queries that do not use :named parameters.

Development

To set up this plugin locally, first checkout the code. Then create a new virtual environment:

cd datasette-create-view
python3 -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

pytest