home / docs / sections

sections

1 row where breadcrumbs contains "Plugin hooks" and title = "database_actions(datasette, actor, database, request)"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: breadcrumbs (array)

id ▼ page ref title content breadcrumbs references
plugin_hooks:plugin-hook-database-actions plugin_hooks plugin-hook-database-actions database_actions(datasette, actor, database, request) datasette - Datasette class You can use this to access plugin configuration options via datasette.plugin_config(your_plugin_name) , or to execute SQL queries. actor - dictionary or None The currently authenticated actor . database - string The name of the database. request - Request object The current HTTP request. Populates an actions menu on the database page. This example adds a new database action for creating a table, if the user has the edit-schema permission: from datasette import hookimpl from datasette.resources import DatabaseResource @hookimpl def database_actions(datasette, actor, database): async def inner(): if not await datasette.allowed( actor, "edit-schema", resource=DatabaseResource("database"), ): return [] return [ { "href": datasette.urls.path( "/-/edit-schema/{}/-/create".format( database ) ), "label": "Create a table", } ] return inner Example: datasette-graphql , datasette-edit-schema ["Plugin hooks", "Action hooks"] [{"href": "https://datasette.io/plugins/datasette-graphql", "label": "datasette-graphql"}, {"href": "https://datasette.io/plugins/datasette-edit-schema", "label": "datasette-edit-schema"}]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [sections] (
   [id] TEXT PRIMARY KEY,
   [page] TEXT,
   [ref] TEXT,
   [title] TEXT,
   [content] TEXT,
   [breadcrumbs] TEXT,
   [references] TEXT
);
Powered by Datasette · Queries took 1.2ms