Getting started¶
Launching the editor¶
From Spine Toolbox¶
To open a single database in Spine database editor:
- Create a Data Store project item.
- Select the Data Store.
- Enter the url of the database in Data Store Properties.
- Press the Open editor button in Data Store Properties.
To open multiple databases in Spine database editor:
- Repeat steps 1 to 3 above for each database.
- Create a View project item.
- Connect each Data Store item to the View item.
- Select the View item.
- Press Open editor in View Properties.
From the command line¶
To open a single SQLite database in Spine database editor, use the open_spine_db_editor.py
script
in the bin
folder:
open_spine_db_editor.py "...path of the database file..."
Knowing the UI¶
The form has the following main UI components:
- Entity trees (Object tree and Relationship tree): they present the structure of classes and entities in all databases in the shape of a tree.
- Stacked tables (Object parameter value, Object parameter definition, Relationship parameter value, and Relationship parameter definition): they present object and relationship parameter data in the form of stacked tables.
- Pivot table and Frozen table: they present data for a given class in the form of a pivot table, optionally with frozen dimensions.
- Entity graph: it presents the structure of classes and entities in the shape of a graph.
- Parameter value list: it presents parameter value lists available in the database.
- Parameter tag toolbar: it presents parameter tags defined in the database.
Tip
You can show or hide form components using the View menu, or select among three predefined layout styles: Stacked style, Pivot style, and Graph style.