SQL::Tr...::DiaUml(3)

πŸ’– NAME πŸ’–

okay so the top of this page literally says SQL::Tr...::DiaUml(3), and it's filed under User Contributed Perl Documentation. The manual name is SQL::Tr...::DiaUml(3) (yes, with the little ... in the middle, iykyk). The name line is: Produces dia UML diagrams from schema. periodt. πŸ’…

✨ SYNOPSIS ✨

bestie, here's the whole vibe in code, exactly how the page shows it:

         use SQL::Translator;
         my $translator     = SQL::Translator->new(
             from           => 'MySQL',
             filename       => 'foo_schema.sql',
             to             => 'DiaUml',
         );
         print $translator->translate;

πŸ¦‹ DESCRIPTION πŸ¦‹

Currently you get one class per table in the schema, and each class gets a table stereotype (the original literally says β€œwith the a table stereotype” β€” iconic little typo moment, but the meaning is clear). The fields are added as attributes of the classes and their datatypes set.

🚨 heads up: it does not currently set any of the relationships. Not one. 😭
⚠️ and no layout either β€” it doesn't do any layout, so all the classes are in one big stack.

But it's still useful, fr fr: you can use the layout tools in Dia to automatically arrange them horizontally or vertically. slay. ✨

πŸŽ€ Producer Args πŸŽ€

This section is in the original and it is empty β€” literally zero producer args listed, so no cap, I'm not inventing any. πŸ’…

πŸ‘‘ AUTHOR πŸ‘‘

Mark Addison β€” grommit@users.sourceforge.net.

🌈 TODO 🌈

The future-era list, directly from the page:

  • Add the foreign keys from the schema as UML relations.
  • Layout the classes.

🌸 SEE ALSO 🌸

SQL::Translator.


mwah πŸ’‹ signed off by SQL::Tr...::DiaUml(3), shipped with perl v5.42.0, dated 2024-12-12 β€” periodt. 🫢

πŸ“¦ where this page comes from