home / docs / sections

sections

8 rows where breadcrumbs contains "Getting and setting metadata"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: breadcrumbs (array)

id ▼ page ref title content breadcrumbs references
internals:datasette-get-column-metadata internals datasette-get-column-metadata await .get_column_metadata(self, database_name, resource_name, column_name) database_name - string The name of the database to query. resource_name - string The name of the resource (table, view, or canned query) inside database_name to query. column_name - string The name of the column inside resource_name to query. Returns metadata keys and values for the specified column, resource, and table as a dictionary. Internally queries the metadata_columns table inside the internal database . ["Internals for plugins", "Datasette class", "Getting and setting metadata"] []
internals:datasette-get-database-metadata internals datasette-get-database-metadata await .get_database_metadata(self, database_name) database_name - string The name of the database to query. Returns metadata keys and values for the specified database as a dictionary. Internally queries the metadata_databases table inside the internal database . ["Internals for plugins", "Datasette class", "Getting and setting metadata"] []
internals:datasette-get-instance-metadata internals datasette-get-instance-metadata await .get_instance_metadata(self) Returns metadata keys and values for the entire Datasette instance as a dictionary. Internally queries the metadata_instance table inside the internal database . ["Internals for plugins", "Datasette class", "Getting and setting metadata"] []
internals:datasette-get-resource-metadata internals datasette-get-resource-metadata await .get_resource_metadata(self, database_name, resource_name) database_name - string The name of the database to query. resource_name - string The name of the resource (table, view, or canned query) inside database_name to query. Returns metadata keys and values for the specified "resource" as a dictionary. A "resource" in this context can be a table, view, or canned query. Internally queries the metadata_resources table inside the internal database . ["Internals for plugins", "Datasette class", "Getting and setting metadata"] []
internals:datasette-set-column-metadata internals datasette-set-column-metadata await .set_column_metadata(self, database_name, resource_name, column_name, key, value) database_name - string The database the metadata entry belongs to. resource_name - string The resource (table, view, or canned query) the metadata entry belongs to. column-name - string The column the metadata entry belongs to. key - string The metadata entry key to insert (ex title , description , etc.) value - string The value of the metadata entry to insert. Adds a new metadata entry for the specified column. Any previous column-level metadata entry with the same key will be overwritten. Internally upserts the value into the the metadata_columns table inside the internal database . ["Internals for plugins", "Datasette class", "Getting and setting metadata"] []
internals:datasette-set-database-metadata internals datasette-set-database-metadata await .set_database_metadata(self, database_name, key, value) database_name - string The database the metadata entry belongs to. key - string The metadata entry key to insert (ex title , description , etc.) value - string The value of the metadata entry to insert. Adds a new metadata entry for the specified database. Any previous database-level metadata entry with the same key will be overwritten. Internally upserts the value into the the metadata_databases table inside the internal database . ["Internals for plugins", "Datasette class", "Getting and setting metadata"] []
internals:datasette-set-instance-metadata internals datasette-set-instance-metadata await .set_instance_metadata(self, key, value) key - string The metadata entry key to insert (ex title , description , etc.) value - string The value of the metadata entry to insert. Adds a new metadata entry for the entire Datasette instance. Any previous instance-level metadata entry with the same key will be overwritten. Internally upserts the value into the the metadata_instance table inside the internal database . ["Internals for plugins", "Datasette class", "Getting and setting metadata"] []
internals:datasette-set-resource-metadata internals datasette-set-resource-metadata await .set_resource_metadata(self, database_name, resource_name, key, value) database_name - string The database the metadata entry belongs to. resource_name - string The resource (table, view, or canned query) the metadata entry belongs to. key - string The metadata entry key to insert (ex title , description , etc.) value - string The value of the metadata entry to insert. Adds a new metadata entry for the specified "resource". Any previous resource-level metadata entry with the same key will be overwritten. Internally upserts the value into the the metadata_resources table inside the internal database . ["Internals for plugins", "Datasette class", "Getting and setting metadata"] []

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