SQL::Tr...Producer(3)

💖 NAME 💖

SQL::Tr...Producer(3) — from the User Contributed Perl Documentation section — is literally the page that describes how to write a producer. Bestie, this is the producer-module vibe check. ✨

🌸 DESCRIPTION 🌸

Okay so, producer modules designed to be used with SQL::Translator need to implement a single function, called produce. One function, main character energy. 👑

produce will be called with the SQL::Translator object, and from that object it is expected to retrieve the SQL::Translator::Schema object — the one that has been populated by the parser. Then it is expected to return a string. No cap. 💖

Keep this exact, bestie: one function named produce, called with the SQL::Translator object, expected to retrieve the populated SQL::Translator::Schema object, and expected to return a string. 🫶

🎀 METHODS 🎀

Here’s the whole method squad, with every name and argument kept exactly as written:

• produce — the single function from the description; called with the SQL::Translator object and expected to return a string. 💅
• create_table($table) — on the list, with $table riding shotgun. 🎀
• create_field($field) — same deal: $field is the argument, untouched. 🦋
• create_view($view) — listed with $view, exactly as written. 🌸
• create_index($index) — listed with $index, no edits, periodt. ✨
• create_constraint($constraint) — listed with $constraint, character-for-character. 💜
• create_trigger($trigger) — listed with $trigger, slay. 🔥
• alter_field($from_field, $to_field) — both arguments stay exactly like that: $from_field and $to_field. 👑
• add_field($table, $new_field) — listed with $table and $new_field, untouched. 🌈
• drop_field($table, $old_field) — listed with $table and $old_field, also untouched. ⭐

🌼 AUTHORS 🌼

The authors are Darren Chamberlain <darren@cpan.org> and Ken Y. Clark <kclark@cpan.org>. Give them their flowers. 💐

🦋 SEE ALSO 🦋

• perl(1)
• SQL::Translator
• SQL::Translator::Schema

---

That’s the whole page, bestie. The source/version energy is perl v5.42.0, the date is 2024-12-12, and the footer title is SQL::Tr...Producer(3) — mwah, bye 💋🌈