API to drop a table

[simonw]

POST /db/table/-/drop

Require drop-table permission.

[simonw]

Documentation: https://docs.datasette.io/en/1.0-dev/json_api.html#dropping-tables

[simonw]

Found a bug: you get a 500 error if you try this against an immutable database.

[simonw]

I also changed the confirmation JSON returned by this endpoint to add the database and table like so:

{
    "ok": true,
    "database": "data",
    "table": "docs",
    "row_count": 1,
    "message": "Pass \"confirm\": true to confirm"
}

Updated docs: https://docs.datasette.io/en/1.0-dev/json_api.html#dropping-tables

[simonw]

Demo: https://latest-1-0-dev.datasette.io/-/api#path=%2Ffixtures%2Ffacetable%2F-%2Fdrop&json=&method=POST