[umbrello] [Bug 400797] New: mysql exporter does not supports enums

[Ralf Habacker]

https://bugs.kde.org/show_bug.cgi?id=400797

Bug ID: 400797
Summary: mysql exporter does not supports enums
Product: umbrello
Version: 2.26.2 (KDE Applications 18.08.2)
Platform: Other
OS: All
Status: REPORTED
Severity: normal
Priority: NOR
Component: exporter
Assignee: umbrello-***@kde.org
Reporter: ***@freenet.de
Target Milestone: ---

Created attachment 116149
--> https://bugs.kde.org/attachment.cgi?id=116149&action=edit
test case

The mysql export does not support exporting enums


STEPS TO REPRODUCE
1. start umbrello
2. open appended file
3. export to mysql code (select menu entry code->code generation wizard)
4. inspect generated mysql file

OBSERVED RESULT
The table columns having an enum type does not specify the enum literals.
Instead there is only the enum type name exported e.g.

tipo_empleado ENUM_1 NOT NULL DEFAULT 2,


EXPECTED RESULT
The export table columns having an enum type should generate something like
this

tipo_empleado ENUM('Supervisor', 'Empleado', 'Obrero', 'Menor') NOT NULL
DEFAULT

[Ralf Habacker]

https://bugs.kde.org/show_bug.cgi?id=400797

Ralf Habacker <***@freenet.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|REPORTED |RESOLVED
Latest Commit| |https://commits.kde.org/umb
| |rello/9b82bc3811e13864bf923
| |99ce3cc7dd96012f47f
Version Fixed In| |2.26.80 (KDE Applications
| |18.11.80)

--- Comment #1 from Ralf Habacker <***@freenet.de> ---
Git commit 9b82bc3811e13864bf92399ce3cc7dd96012f47f by Ralf Habacker.
Committed on 07/11/2018 at 12:18.
Pushed by habacker into branch 'master'.

Export of enums for mysql exporter added
FIXED-IN:2.26.80 (KDE Applications 18.11.80)

M +13 -1 umbrello/codegenerators/sql/sqlwriter.cpp

https://commits.kde.org/umbrello/9b82bc3811e13864bf92399ce3cc7dd96012f47f

[Ralf Habacker]

https://bugs.kde.org/show_bug.cgi?id=400797

--- Comment #2 from Ralf Habacker <***@freenet.de> ---
Git commit e83716f8afa1ce2324d86662f8300b6b4f83a3e7 by Ralf Habacker.
Committed on 19/11/2018 at 23:40.
Pushed by habacker into branch 'Applications/18.12'.

Crash fix in case of exporting an entity relation diagram

See https://bugs.kde.org/attachment.cgi?id=116414 for the test case.

M +2 -1 umbrello/codegenerators/sql/sqlwriter.cpp

https://commits.kde.org/umbrello/e83716f8afa1ce2324d86662f8300b6b4f83a3e7