tbls
tbls copied to clipboard
One-to-one relations are incorrectly exported as one-to-many in mermaid diagram
What happened
Write tbls.yml to set one-to-one relations to tables without foreign keys and create a mermaid er diagram by tbls. However, the tables were in one to many relations in exported diagram.
What you expected to happened
Exported as one to one in mermaid diagram if one to one relations are set in tbls.yml.
What stack trace or error message from tbls did you see?
No errors were shown.
Anything else we need to know?
Environment
-
tbls version
: Tried 1.60, 1.62, 1.70 but not resolved. - Database version: MySQL 5.7
- OS (
Ubuntu bionic
,macOS Calalina
,WSL2
, etc ): WSL2 - Shell (
bash
,zsh
,poworshell
, etc ): Bash - Stacktrace or error message from tbls ( If you can, set
DEBUG=1
) - Config ( .tbls.yml )
Hi @kk-mats. Thank you for your report. Could you give us the schema and .tbls.yml to reproduce the situation, and the diagram to expect?
I added an example code here that reproduces this issue. https://github.com/kk-mats/tbls-issue-534
@kk-mats GREAT!!!! Thank you!!!!!