Autodi...er::SQL(3pm)

💖 Autodia::Handler::SQL 💖

okay bestie, sit down, because we're talking about Autodia::Handler::SQL — a Perl module living its best life in section 3pm of the User Contributed Perl Documentation. yes, that's the whole manual name, we're being official for exactly one second and then we're moving on. 💅

---

✨ NAME ✨

Autodia::Handler::SQL.pm — the AutoDia handler for SQL. that's it, that's the name, she's iconic, she's specific. 🎀

---

🌸 INTRODUCTION 🌸

so here's the vibe: Autodia::Handler::SQL parses files into a Diagram Object, which is the thing all the handlers use. it's giving shared infrastructure. it's giving teamwork. 🫶

and what does a handler actually do? the role of the handler is to parse through the file and extract information such as:

• table names
• field names
• relationships
• keys

that's the whole job description, and honestly? she ate. 🔥

SQL is registered in the Autodia.pm module, which contains a hash of language names and the name of their respective language — in this case:

%language_handlers = { .. , sql => "Autodia::Handler::SQL", .. };

so when someone says "sql", the module knows exactly which handler to summon. no cap. ✨

---

🦋 CONSTRUCTION METHOD 🦋

to build one of these bad girls, you do:

use Autodia::Handler::SQL;

my $handler = Autodia::Handler::SQL->New(\%Config);

this creates a new handler using the Configuration hash to provide rules selected at the command line. so the %Config is doing the heavy lifting of "what rules are we following today" and the handler is like bet, say less. 👑

---

🎀 ACCESS METHODS 🎀

$handler->Parse(filename); # where filename includes full or relative path.

this parses the named file and returns 1 if successful or 0 if the file could not be opened. simple. binary. no in-between. slay. 💖

$handler->output();

this outputs the Dia XML file according to the rules in the %Config hash passed at initialisation of the object. and listen — it also allows you to output:

• VCG
• Dot
• images rendered through GraphViz and VCG

so yes, you get options. you get range. you get a handler with main character energy. 🌈

---

and that's the whole page, bestie!! this little legend came to you from perl v5.36.0, dated 2022-11-02, and it's part of the User Contributed Perl Documentation. go forth and parse some SQL. iykyk. 💜🧚⭐