Datasette plugin for modifying table schemas
Project description
datasette-edit-schema
Datasette plugin for modifying table schemas
Features
- Add new columns to a table
- Rename columns in a table
- Modify the type of columns in a table
- Re-order the columns in a table
- Rename a table
- Delete a table
Installation
Install this plugin in the same environment as Datasette.
$ pip install datasette-edit-schema
Usage
Navigate to /-/edit-schema/dbname/tablename
on your Datasette instance to edit a specific table.
Use /-/edit-schema/dbname
to create a new table in a specific database.
By default only the root actor can access the page - so you'll need to run Datasette with the --root
option and click on the link shown in the terminal to sign in and access the page.
The edit-schema
permission governs access. You can use permission plugins such as datasette-permissions-sql to grant additional access to the write interface.
Screenshot
Development
To set up this plugin locally, first checkout the code. Then create a new virtual environment:
cd datasette-edit-schema
python3 -mvenv venv
source venv/bin/activate
Or if you are using pipenv
:
pipenv shell
Now install the dependencies and tests:
pip install -e '.[test]'
To run the tests:
pytest
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for datasette-edit-schema-0.4a0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | aac8e04315c740e14a4c9ffb6defdd2db84d6a0d6bdd280c69894f43eff9b6bb |
|
MD5 | 1fd206649ff07d226312968bdf5d0161 |
|
BLAKE2b-256 | 69e8bc56a324d2bb2f7213d361f5ea5432052c1e46ee5f4d8634adbc6a8fee01 |
Hashes for datasette_edit_schema-0.4a0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | aec3225f4662e746cdc470c56fc7ddbbf944f08214af14d68e00c6a363a1c456 |
|
MD5 | 1c76bc0a31c9e7217c0d37063ab7b8c7 |
|
BLAKE2b-256 | 92383d028de4b8f0ce0084bdadde6a06c43494b41b3a01f6e2adc0525421efbf |