The Data sectionData

The Data section contains an Excel-like, tabular tool that can be used to perform simple create, read, update and delete database operations (CRUD). It can give a good overview of the data stored in database used in an production environment and the tool can help creating test-data while developing an Structr application.

On the left-hand side of the tool there is an overview of available types defined in the Schema section of the Structr-Ui. Structr itself provides a large collection of pre-defined schema types like User or File, the list will only show a subset of those pre-defined schema types and all custom created ones by default. The filter can be adjusted by clicking on the wrench-symbol and selecting and deselecting the desired Filter.

In the main window of the tool there are a number of buttons that provide some basic functionality for importing and exporting database entities of the selected schema type from or to CSV.

For creating single entities in the database the button “Create new [selected type]” can be used. The checkbox “Exclude subtypes” is an additional filter for the table that hides all entities of an inheriting type in regards of the selected type for the table.

The columns of the table show the properties of the selected schema type, where the additional filter “View” defines the group of properties to show.

The table itself features inline-editing for each cell of the table with property type-awareness which means that if a propery is for example defined as an Enum property, the inline-editing tool will show a select input element with the defined Enum values.

This type-awareness is also available for the remote properties of the entities in the graph database. Entities (or nodes in the graph database) can be linked in the table by clicking on the “+” icon in the cells and selecting the node that should be linked.