Spinetoolbox

Changed

- Execution button shortcuts have been changed because F5 is traditionally reserved for refreshing.
The shortcuts are now:

- **Shift+F9** to execute project
- **F9** to execute selection
- **F10** to stop execution

Fixed

- Fixed a bug where scenario filters could cause Tracebacks in tools that were using ``spinedb_api``.

Changed

- ``gamsapi`` replaced the ancient ``gdxcc`` package.
You may need to have a relatively recent GAMS installed to utilize .gdx import/export functionalities.

Added

- Entity group column in *Add entities* dialog. If filled, the created entity will be added to the specified group.
If the group doesn't yet exist, it will be created.
- Native kernel (i.e. python3 for Python) can now be used in the Detached Console or in Tool execution.
- It is now possible to specify valid value types for parameters in the Parameter definition table in Database editor.
- [Bundled App] **Embedded Python** now includes pip.
- Graph view in database editor now also supports filtering by alternative and scenario tree selections.
- Option to disable auto-build in entity graph.
- Mapping Name source type in importer.
- Importer has now an option to import entity alternatives.

Changed

- Database editor's hamburger menu has been converted into a menubar beneath the tab bar. The URL toolbar has also
been replaced with a toolbar that houses different buttons.
- One dimensional entities can now also be added through *Parameter value* and *Entity alternative* tables.
- Special data types like dates, times and booleans are now properly pasted from Excel.

Fixed
- [Bundled App] Fixed execution in Jupyter Console and opening Detached Consoles by adding jupyter-client and
qtconsole packages to the bundle.
- [Bundled App] Fixed creating new kernel specs in Settings->Tools by adding ipykernel package to the
**embedded Python**.
- [Bundled App] Fixed 'Install Julia' button in Settings->Tools by adding the jill package to the **embedded Python**.

Added

- A button next to each entity class in **Entity Tree** that opens the *Add entities* dialog.
- Alternative -column in *Add entities* dialog. If filled, the created entity will be set active in that alternative.

Changed

- Python 3.12 and later is now supported.
- When exporting GAMS `.gdx` files with Exporter, special values 10^-10 and `EPS`
now get converted to GAMS Eps (epsilon).

Added

- Importer: it is now possible to reorder source tables by dragging and dropping.
- Importer: it is now possible to reorder mappings by dragging and dropping.
- Importer: it is now possible to copy mappings between source tables by dragging selected
mappings from Mappings list onto destination source table item.

Removed

- Scenario active flag mappings have been removed from Importer and Exporter.
The flag is not used anywhere and has not been accessible in Database editor
for a long time.

Added

- New context menu action (Select superclass) for entity class items in the entity tree.
- Added Tool Specification type (Python, Gams, etc.) icons on Design View.
- There is now a new filter type, Alternative filter available in Link properties.
Unlike scenario filters, the execution is not parallelized.
Instead, a successor item sees parameter values of all selected alternatives.
Because of this behavior,
alternative filters cannot be used at the same time with scenario filters.
Link properties tab has a combo box that lets one choose which filter type to use.

Changed

Spine data structure

Many parts of the Spine data structure have been redesigned.

- *Entities* have replaced objects and relationships.
Zero-dimensional entities correspond to objects while multidimensional entities replace the former relationships.
Unlike relationships, the *elements* of multidimensional entities can now be other multidimensional entities.
- Simple inheritance is now supported by *superclasses*.
- Tools, features and methods have been removed.
The functionality that was previously implemented using the is_active parameter
has been replaced by *entity alternatives*.
Entity classes have a default setting for the entity alternative called *active by default*.
Database migration should automatically replace tools, features and methods
by entity alternatives and set active by default to whatever default value `is_active`
or similar parameter had.
The `is_active` parameter is not removed from entity classes but its values are.
- Note that new zero-dimensional entity classes have *active by default* set to `false` initially.
This means that the entities of those classes are hidden when using scenario filters
unless specifically shown using entity alternatives.

Miscellaneous changes

- "Rubber band" selection of items in Design and Graph views is now done with **left mouse button**
(no need to press Ctrl anymore). The views can be dragged around by holding the **right mouse button**.
- Spine Database Editor now remembers the configuration of the docs in each view for a specific URL. The docks
can be reset from the hamburger menu **View->Docks...->Reset docks**.
- You can now select a different Julia executable & project or Julia kernel for each Tool spec.
This overrides the global setting from Toolbox Settings.
- Headless mode now supports remote execution (see 'python -m spinetoolbox --help')
- Commit Viewer's UI has undergone some redesigning and can now handle large databases.

Removed

- Project dock widget
- Dependency on Dagster