Overview

This repository consists of 4 Spine-Toolbox projects.

1. Spine Demo

A project containing several Spine database to illustrate SpineOpt.jl functionalities (demo SpineOpt models) and SpineInterface.jl utilities (incl. improvising Julia JuMP models using SpineInterface to interact with SpineDB)

2. SpinePython

A demo project of a workflow to run a Python Tool and exchange data with other tools: Data Connection, Julia Tool, and Importer for JSON and CSV files. The project workflow contains:

1. A dummy input CSV file in the "Input_files" Data Connection;

2. A Julia script wrapped in the "Julia" Tool that reads the given input CSV and writes to an output CSV file; the output CSV file is passed over to the "ImportCSV" Importer and other tools (see 3);

3. A Python script wrapped in the "Python" Tool that reads the given input CSV and the output csv from the Julia script and writes to a JSON file and another CSV file; the JSON output file is passed to the "ImportJSON" Importer.

3. BuildTimeseries project

A demo workflow to attach "DateTime" index to TimeSeries data

4. Hydro reservoir example

A sample SpineOpt.jl model for hydro reservoir generation

Set up working environment for Spine toolkits

Set up working/development environment for SpineOpt and Spine Toolbox

• prerequisites:
  • python 3.14 from miniconda
    • Recommend to choose "add conda to system PATH" during installation
  • Git

Warning!!!: Under this configuration, only running the spinetoolbox requires activating the conda environment. Once the PyCall.jl is configured to use the conda python, don't activate the conda environment for julia related tasks, e.g. updating environment packages (doing this with the conda activated causes unnecessary error).

Note When the Python version has a major change (e.g. 3.1x to 3.1y), its conda environment might need recreating after deleting the old environment:

```console
conda remove -n env_name --all
```

Step 1 option 1. Build worry-free spinetoolbox in conda environment with Git:

• In OS terminal (cmd or PowerShell):

   # create the env with the latest available python, 
   # replace the `python` by `python=3.1x` for a specific version
   # more packages, e.g. `pip`, can be explicitly added before/after the `python`
   conda create -n spine-tools python  
   conda init # if the activation has no response
   conda activate spine-tools

  • Note: upgrade conda itself:

  conda update -n base conda -c defaults --all

  If this command doesn't work in regular terminal, run it in Anaconda Prompt.

• Install the active dev version spinetoolbox (need Git installed):

  python -m pip install git+https://github.com/spine-tools/spinetoolbox-dev

• Update package to the latest commit: reinstall the package using the same command.

• Install the official release version spinetoolbox (no Git needed):

   python -m pip install spinetoolbox==0.x.y

  Note: if the version x.y.z is not specified, the latest release version will be installed.

Step 1 option 2. Conda environment for spine development

• Create a new conda virtual environment:

   # create the env with the latest available python, 
   # replace the `python` by `python=3.1x` for a specific version
   # more packages, e.g. `pip`, can be explicitly added before/after the `python`
   conda create -n spine-dev python

• install local spine packages in the development environment spine-dev:

   conda init # if the activation has no response
   conda activate spine-dev

  option 1

  Step 1:
  $parentDir = ".\path\to\local\packages\"
  
  Step 2:
  $packageNames = @(
  	"Spine-Database-API",
  	"spine-engine",
  	"spine-items",
  	"Spine-Toolbox"
  )
  
  Step 3:
  foreach ($pkg in $packageNames) {
  $fullPath = Join-Path -Path $parentDir -ChildPath $pkg
  	python -m pip install -e "$fullPath"
  }

  option 2

  python -m pip install -e .\path\to\local\Spine-Database-API 
  python -m pip install -e .\path\to\local\spine-engine 
  python -m pip install -e .\path\to\local\spine-items 
  python -m pip install -e .\path\to\local\Spine-Toolbox

  Update packages to the latest commits:

  1. Pull from the GitHub repositories
  2. Rerun the above commands

Step 2. Assign the configured conda Python to PyCall in the Julia environment where SpineOpt.jl and SpineInterface.jl are installed

Both options above (the spine-dev and spine-tools conda env) require this step unless you install SpineOpt.jl and SpineInterface.jl through the default channel of Spine toolbox.

• In OS terminal (cmd or PowerShell)

   conda activate spine-dev 
   cd path\to\the\working\julia\enviroment

• In Julia console

   # activate the working environment
   cd("path\\to\\the\\working\\julia\\enviroment")
   using Pkg; Pkg.activate(".")
   
   # Before building PyCall, set which python to use
   ## 1. the python of activated environment, also works with non-conda python
   ENV["PYTHON"] = Sys.which("python")
   ## 2. or when a conda environment is activated
   ENV["PYTHON"] = ENV["CONDA_PREFIX"] * "\\python.exe"
   ## 3. or let PyCall to install its dedicated conda
   ENV["PYTHON"] = ""
  
   using Pkg; Pkg.build("PyCall")

• Relaunch Julia and check which Python is being used by PyCall: PyCall.pyprogramname or PyCall.python

• (Optional) To enable Julia cells in Jupyter notebooks:

   using Pkg; Pkg.update(); Pkg.build("IJulia")

(Deprecated) env configuration

Python (virtual) environment setup

1. Download and install python interpreter
2. Create a virtual environment: "X:\path\to\python\interpretor -m venv Y:\path\to\virtual_env_folder"
3. In the Terminal, switch to the corresponding virtual environment
   • Run "deactivate" to exit current virenv
   • Run "cd path\to\the\virenv\folder"
   • Run ".\Scripts\activate" to activate the target virenv
   • Run "pip install -e package" in terminal under the activated virtual environment (the "-e" option is only needed for installing editable package, see pip install options) When the ipython and ipykernel (maybe only ipykernel needed) packages are installed, command "pip install -e local\package" can be used in the Python console where the new virtual environment is launched.

Julia environment setup

1. Install julia manually by the installer from julialang.org

2. Modify the environment variable "julia" to the latest Julia installed

   • System environment variable (if you install Julia for all users): "Control Panel\All Control Panel Items\System --> Advanced system settings --> Advanced --> Environmental Variables --> Edit in Path"
     • under "User variables for administrator_username" (only for the administrator, under "System variables" for all users)
   • User environment variable (if you install Julia for the current user): Search environment variables in the Windows taskbar --> "Edit environment variable for your account" --> Edit in Path under "User variables for the_current_username"
   • Edit in Path: add or replace the existing directory by X:\path\to\Julia\Julia-x.ab\bin
   • In case the Jupyter notebook kernel needs updating (in a specific env), do:

      Pkg.update(); Pkg.build("IJulia")

   • Renew the path of julia executable in VSCode
     • Settings --> Search "julia" --> Julia: Environment Path / Julia: Executable Path

3. Build PyCall environment: recommend the Step 2 in the previous section

   There are 3 ways by which PyCall.jl could work for the SpineInterface.jl call use spinedb-api.

   • pkg> add PyCall

   1. Option 1 Install spinedb_api to a built-in conda python created by PyCall.

      • Confirm the default conda python is linked:

      julia> ENV["PYTHON"]=""
      julia> using PyCall, Pkg
      julia> Pkg.build("PyCall")

      • Find the conda python
      • "X:\path\to\the\conda\python\folder\Scripts\pip.exe install -e path/to/local/spinedb_api"

   2. Option 2 Install spinedb_api to the parent python interpreter on which the virtual env is built (ref. PyCall documentation and PyCall issue with virtual environment)

      • Run (with ipython and ipykernel installed) pip install -e path/to/local/spinedb_api
      • Otherwise, X:\path\to\python\folder\Scripts\pip.exe install -e path/to/local/spinedb_api
   • Build customised python interpreter:
   • In Julia after activating the desired working environment:

      julia> ENV["PYTHON"] = raw"C:\path\to\the\parent\python.exe"
      julia> import Pkg; Pkg.build("PyCall")

   3. Option 3 For a dedicated virtual environment created by venv and virtualenv, PyCall could work provided that the Python executable used in the virtual environment is linked against the same libpython used by PyCall (conda environment not supported). See the explanation here.
      • In command line: virtual_env_folder\Scripts\Activate.ps1
      • In Julia after activating the desired working environment:

      julia> ENV["PYTHON"] = Sys.which("python")
      julia> ENV["PYCALL_JL_RUNTIME_PYTHON"] = Sys.which("python")
      julia> import Pkg; Pkg.build("PyCall")

   • Relaunch Julia and check which python the PyCall is using: PyCall.pyprogramname or PyCall.python
   • Check packages that are available for the PyCall used python:

      julia> using PyCall; pyimport("sys").path
      py"""
      import pkgutil
     
      def get_available_packages():
      	available_packages = [name for _, name, _ in pkgutil.iter_modules()]
      	return available_packages
      """
      available_packages = py"get_available_packages"()
      println(available_packages)

     When spinedb_api package is in the list, it is good to go.

4. Install Spine related jl package:

   • pkg> dev "...path to SpineOpt folder...", pkg> dev "...path to SpineInterface folder..."