The resources module contains all the classes for Kotti’s persistence layer, which is based on SQLAlchemy.

Inheritance Diagram

Inheritance diagram of kotti.resources

class kotti.resources.ContainerMixin[source]

Bases: collections.abc.MutableMapping

Containers form the API of a Node that’s used for subitem access and in traversal.

keys() → List[str][source]
Result:children names
Return type:list
values() → an object providing a view on D's values[source]
Result:all child nodes without considering permissions.
Return type:list
children_with_permission(request: kotti.request.Request, permission: str = 'view') → List[kotti.resources.Node][source]

Return only those children for which the user initiating the request has the asked permission.

  • request (kotti.request.Request) – current request
  • permission (str) – The permission for which you want the allowed children

List of child nodes

Return type:


class kotti.resources.LocalGroup(node, principal_name, group_name)[source]

Bases: sqlalchemy.ext.declarative.api.Base

Local groups allow the assignment of groups or roles to principals (users or groups) for a certain context (i.e. a Node in the content tree).


Primary key for the node in the DB (sqlalchemy.types.Integer)


ID of the node for this assignment (sqlalchemy.types.Integer)


Name of the principal (user or group) (sqlalchemy.types.Unicode)


Name of the assigned group or role (sqlalchemy.types.Unicode)

class kotti.resources.NodeMeta(classname, bases, dict_, **kw)[source]

Bases: sqlalchemy.ext.declarative.api.DeclarativeMeta, abc.ABCMeta

class kotti.resources.Node(name=None, parent=None, title='', annotations=None, **kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base, kotti.resources.ContainerMixin, kotti.security.PersistentACLMixin

Basic node in the persistance hierarchy.


Primary key for the node in the DB (sqlalchemy.types.Integer)


Lowercase class name of the node instance (sqlalchemy.types.String)


ID of the node’s parent (sqlalchemy.types.Integer)


Position of the node within its container / parent (sqlalchemy.types.Integer)


The path can be used to efficiently filter for child objects (sqlalchemy.types.Unicode).


Name of the node as used in the URL (sqlalchemy.types.Unicode)


Title of the node, e.g. as shown in search results (sqlalchemy.types.Unicode)


Annotations can be used to store arbitrary data in a nested dictionary (kotti.sqla.NestedMustationDict)

clear() → None. Remove all items from D.[source]
copy(**kwargs) → kotti.resources.Node[source]
Result:A copy of the current instance
Return type:Node
class kotti.resources.TypeInfo(**kwargs)[source]

Bases: object

TypeInfo instances contain information about the type of a node.

You can pass arbitrary keyword arguments in the constructor, they will become instance attributes. The most common are:

  • name
  • title
  • add_view
  • addable_to
  • edit_links
  • selectable_default_views
  • uploadable_mimetypes
  • add_permission
copy(**kwargs) → kotti.resources.TypeInfo[source]
Result:a copy of the current TypeInfo instance
Return type:TypeInfo
addable(context: kotti.resources.Content, request: Optional[kotti.request.Request]) → bool[source]
  • context (Content or subclass thereof (or anything that has a type_info attribute of type TypeInfo)) –
  • request (kotti.request.Request) – current request

True if the type described in ‘self’ may be added to ‘context’, False otherwise.

Return type:


add_selectable_default_view(name: str, title: str) → None[source]

Add a view to the list of default views selectable by the user in the UI.

  • name (str) – Name the view is registered with
  • title (str or TranslationString) – Title for the view for display in the UI.
is_uploadable_mimetype(mimetype: str) → int[source]

Check if uploads of the given MIME type are allowed.

Parameters:mimetype (str) – MIME type
Result:Upload allowed (>0) or forbidden (0). The greater the result, the better is the match. E.g. image/* (6) is a better match for image/png than * (1).
Return type:int
class kotti.resources.Tag(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base

Basic tag implementation. Instances of this class are just the tag itself and can be mapped to instances of Content (or any of its descendants) via instances of TagsToContents.


Primary key column in the DB (sqlalchemy.types.Integer)


Title of the tag sqlalchemy.types.Unicode

Return type:list
class kotti.resources.TagsToContents(**kwargs)[source]

Bases: sqlalchemy.ext.declarative.api.Base

Tags to contents mapping


Foreign key referencing Tag.id (sqlalchemy.types.Integer)


Foreign key referencing Content.id (sqlalchemy.types.Integer)


Relation that adds a content_tags sqlalchemy.orm.backref() to Tag instances to allow easy access to all content tagged with that tag. (sqlalchemy.orm.relationship())


Ordering position of the tag sqlalchemy.types.Integer

title = ColumnAssociationProxyInstance(AssociationProxy('tag', 'title'))

title of the associated Tag instance (sqlalchemy.ext.associationproxy.association_proxy)

class kotti.resources.Content(name=None, parent=None, title='', annotations=None, default_view=None, description='', language=None, owner=None, creation_date=None, modification_date=None, in_navigation=True, tags=None, **kwargs)[source]

Bases: kotti.resources.Node

Content adds some attributes to Node that are useful for content objects in a CMS.


Primary key column in the DB (sqlalchemy.types.Integer)


Workflow state of the content object (sqlalchemy.types.String)

type_info = <kotti.resources.TypeInfo object>

type_info is a class attribute (TypeInfo)


Name of the view that should be displayed to the user when visiting an URL without a explicit view name appended (sqlalchemy.types.String)


Description of the content object. In default Kotti this is used e.g. in the description tag in the HTML, in the search results and rendered below the title in most views. (sqlalchemy.types.Unicode)


Language code (ISO 639) of the content object (sqlalchemy.types.Unicode)


Owner (username) of the content object (sqlalchemy.types.Unicode)


Shall the content be visible in the navigation? (sqlalchemy.types.Boolean)


Date / time the content was created (sqlalchemy.types.DateTime)


Date / time the content was last modified (sqlalchemy.types.DateTime)

tags = ObjectAssociationProxyInstance(AssociationProxy('_tags', 'title'))

Tags assigned to the content object (list of str)

copy(**kwargs) → kotti.resources.Content[source]
Result:A copy of the current instance
Return type:Node
class kotti.resources.Document(body='', mime_type='text/html', **kwargs)[source]

Bases: kotti.resources.Content

Document extends Content with a body and its mime_type. In addition Document and its descendants implement IDefaultWorkflow and therefore are associated with the default workflow (at least in unmodified Kotti installations).


Primary key column in the DB (sqlalchemy.types.Integer)

type_info = <kotti.resources.TypeInfo object>

type_info is a class attribute (TypeInfo)


Body text of the Document (sqlalchemy.types.Unicode)


MIME type of the Document (sqlalchemy.types.String)

class kotti.resources.SaveDataMixin(data: Union[bytes, _io.BufferedReader, cgi.FieldStorage, None] = None, filename: Optional[str] = None, mimetype: Optional[str] = None, size: Optional[int] = None, **kwargs)[source]

Bases: object

The classmethods must not be implemented on a class that inherits from Base with SQLAlchemy>=1.0, otherwise that class cannot be subclassed further.

See http://stackoverflow.com/questions/30433960/how-to-use-declare-last-in-sqlalchemy-1-0 # noqa

classmethod from_field_storage(fs)[source]
Create and return an instance of this class from a file upload
through a webbrowser.
Parameters:fs (cgi.FieldStorage) – FieldStorage instance as found in a kotti.request.Request’s POST MultiDict.
Result:The created instance.
Return type:kotti.resources.File
filename = Column(None, Unicode(length=100), table=None)

The filename is used in the attachment view to give downloads the original filename it had when it was uploaded. (sqlalchemy.types.Unicode)

mimetype = Column(None, String(length=100), table=None)

MIME type of the file (sqlalchemy.types.String)

size = Column(None, Integer(), table=None)

Size of the file in bytes (sqlalchemy.types.Integer)

copy(**kwargs) → kotti.resources.File[source]

Same as Content.copy with additional data support. data needs some special attention, because we don’t want the same depot file to be assigned to multiple content nodes.

class kotti.resources.File(data=None, filename=None, mimetype=None, size=None, **kwargs)[source]

Bases: kotti.resources.SaveDataMixin, kotti.resources.Content

File adds some attributes to Content that are useful for storing binary data.


Primary key column in the DB (sqlalchemy.types.Integer)

kotti.resources.get_root(request: Optional[kotti.request.Request] = None) → kotti.resources.Node[source]
Call the function defined by the kotti.root_factory setting and
return its result.
Parameters:request (kotti.request.Request) – current request (optional)
Result:a node in the node tree
Return type:Node or descendant;
class kotti.resources.DefaultRootCache[source]

Bases: object

Default implementation for get_root()


Query for the one node without a parent and return its id. :result: The root node’s id. :rtype: int

get_root() → kotti.resources.Node[source]

Query for the root node by its id. This enables SQLAlchemy’s session cache (query is executed only once per session). :result: The root node. :rtype: Node.