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

AutoScenarioDbTable.create_table_metadata() also extract the columns_metadata #41

Open victorterpstra opened 2 years ago

victorterpstra commented 2 years ago

For the AutoScenarioDbTable, we get the sqlalchemy.Table from reflection. We also need the columns_metadata to be able to cell edits. In particular, the method ScenarioDbTable.get_sa_column is searching for a sqlalchemy.Column and can't find it because it has not been reflected.

Work-around: Do not use AutoScenarioDbTable