Metadata-Version: 2.4
Name: sym2db
Version: 0.2.2
Summary: More automated alignment between symbols and database for mathematical modeling.
Requires-Python: ~=3.12.0
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: openpyxl~=3.1.5
Requires-Dist: pandas~=3.0.1
Requires-Dist: strenum>=0.4.15
Requires-Dist: sqlalchemy==2.1.0b3
Requires-Dist: sqlglot[rs]<30.17.0,>=26.4.1
Requires-Dist: gamspy<1.27.0,>=1.26.4
Requires-Dist: pydantic<2.14.0,>=2.10.6
Requires-Dist: jinja2~=3.1.6
Provides-Extra: duckdb
Requires-Dist: duckdb>=1.5.5; extra == "duckdb"
Requires-Dist: duckdb-engine>=0.17.0; extra == "duckdb"
Provides-Extra: mysql
Requires-Dist: pymysql<1.3.0,>=1.1.1; extra == "mysql"
Dynamic: license-file


# sym2db: more automated alignment between symbols and database for mathematical modeling

Based on the follow workflow, `sym2db` helps align mathematical symbols, a database, and external data sources:

[![](https://mermaid.ink/img/pako:eNp1Uk2P0zAQ_SvWnFIpW7FKm68DF7a3RUKAOLBByImnTURsh7FDW6r-d2wnLe0KcvF8vDdvZjInaLRAKKFS217vm5aTZc8fK8XcZ8Z6R3xoWQWbQ2dsp3as0VJqxfaafnhCBRM0wI-y1r2JPk3v4m9G1C_RByTjaqCyTHDLa25w8e0G4mIv0eZgkRTvg8uMHqlBcwv71eHeRBV88W8FswYqUam55yD-3TQtSu6AUzNs8lm072zL2uOgbYuuncW1hKgvnKe5u5mzuK9s2MMDw4Ml3lhnvr0X_EcPHk-4dXBNgXBVeiXsgQ0htzjD5rzfhEttPj_fx__DCxu6QHzu54h0fJ0KZmBqIjSDVoJZfTOQw0EMO-oElJZGjEEiSe5dOPkaFbgVSqygdKZwA4699ddwdrSBq69aywuT9Lhrodzy3jhvHNxI-NRxd1vyGiX3D5He6VFZKJMsDUWgPMEByjxd5qtVnqSP63ydZOsshiOUWbJcFUWRPhZpskqy4hzD7yD6Zpln6xhQdG7l76fzDld-_gOYF-7l?type=png)](https://mermaid.ai/live/edit#pako:eNp1Uk2P0zAQ_SvWnFIpW7FKm68DF7a3RUKAOLBByImnTURsh7FDW6r-d2wnLe0KcvF8vDdvZjInaLRAKKFS217vm5aTZc8fK8XcZ8Z6R3xoWQWbQ2dsp3as0VJqxfaafnhCBRM0wI-y1r2JPk3v4m9G1C_RByTjaqCyTHDLa25w8e0G4mIv0eZgkRTvg8uMHqlBcwv71eHeRBV88W8FswYqUam55yD-3TQtSu6AUzNs8lm072zL2uOgbYuuncW1hKgvnKe5u5mzuK9s2MMDw4Ml3lhnvr0X_EcPHk-4dXBNgXBVeiXsgQ0htzjD5rzfhEttPj_fx__DCxu6QHzu54h0fJ0KZmBqIjSDVoJZfTOQw0EMO-oElJZGjEEiSe5dOPkaFbgVSqygdKZwA4699ddwdrSBq69aywuT9Lhrodzy3jhvHNxI-NRxd1vyGiX3D5He6VFZKJMsDUWgPMEByjxd5qtVnqSP63ydZOsshiOUWbJcFUWRPhZpskqy4hzD7yD6Zpln6xhQdG7l76fzDld-_gOYF-7l)

What can `sym2db` do?

1. extract symbol schema from mathematical symbols
2. refactor the symbol schema, including hypothesis sharing configuration and enum specification
3. materialize relational database
4. materialize relational database views
