ScenarioDbManager - Replace `scenarioName` (str) with `scenarioSeq` (int)

IBM / dse-decision-optimization-utilities

A Python package with various utilities that speed-up development of Decision Optimization projects in Watson Studio. Implements common tasks and provides best-practice guidelines to architect DO projects.

Apache License 2.0

4 stars 7 forks source link

ScenarioDbManager - Replace `scenarioName` (str) with `scenarioSeq` (int) #23

Closed victorterpstra closed 1 year ago

victorterpstra commented 2 years ago

Replace scenarioName (str) with scenarioSeq (int): faster and easier to rename scenario. Add name to SCENARIO table.

Will require getting the next free scenarioSeq key from the scenario DB table. Is there an issue with support from various databases for this feature?

Notes:

Need a Sequence object (see https://stackoverflow.com/questions/15074804/prefetch-column-sequence-sqlalchemy)
https://docs.sqlalchemy.org/en/14/core/defaults.html#defining-sequences

victorterpstra commented 1 year ago

Has been implemented and extensively tested since v0.5.4.5b3