Paste data to create tables in Datasette

This plugin is no longer being developed. It has been replaced by datasette-import.

Install this plugin in the same environment as Datasette.

datasette install datasette-paste

This plugin adds a database action item called "Create table with pasted data".

This action is available to users with the create-table permission.

It links to a page that allows users to paste in CSV, TSV or JSON data, and then use that to create and populate a new table in Datasette.

CSV and TSV data must have headers on the first row.

JSON data must be an array of objects with the same keys, or a container object object where one of the keys is an array of objects.

The CSV and TSV parsing is performed using Papa Parse, an MIT licensed JavaScript library that is bundled with this plugin.

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

cd datasette-paste
python3 -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

pytest