Jifty:...::mysql(3pm)

💖 Jifty::DBI::Handle::mysql 💖

okay bestie, gather round, because this is the Perl manual page for Jifty::DBI::Handle::mysql — it's the 3pm one, straight outta the User Contributed Perl Documentation collection, and it's literally the glow-up MySQL needed. 🎀

---

✨ NAME ✨

Jifty::DBI::Handle::mysql — a mysql specific Handle object. periodt. 💅

---

🌸 SYNOPSIS 🌸

ngl the original is giving absolutely nothing here. no synopsis, no code block, no vibe. just... silence. iconic of it honestly. 🙈

---

🦋 DESCRIPTION 🦋

so this module is a subclass of Jifty::DBI::Handle, and its whole main character job is to compensate for some of the idiosyncrasies of MySQL. like, MySQL has quirks, and this module is the bestie that shows up with a lint roller and fixes them. ✨

---

👑 METHODS 👑

💜 insert

takes a table name as the first argument, and then just assumes the rest of the arguments are an array of key-value pairs to be inserted. lowkey trusting of it. 🫶

if the insert succeeds, it returns the id of the insert. if it doesn't? it returns a Class::ReturnValue object with the error reported. so you always get something back, bestie. no ghosting. 😭

💜 database_version

returns the mysql version, trimming off any -foo identifier. so you get the clean version number and not the whole saga. ✂️

💜 case_sensitive

returns undef, since mysql's searches are not case sensitive by default. it's not being lazy, it's being honest. 💀

💜 rename_column ( table => $table, column => $old_column, to => $new_column )

renames the column. and if it fails? it dies. no cap, no graceful fallback, it just dies. dramatic but effective. 💅

---

🌈 AUTHOR 🌈

Jesse Vincent, jesse@fsck.com — the icon, the legend, the moment. 👑

---

🧚 SEE ALSO 🧚

• Jifty::DBI
• Jifty::DBI::Handle
• DBD::mysql

iykyk. go read those too, bestie. 📚

---

💌 and that's the whole page! this was perl v5.34.0, dated 2022-06-15, and it's the Jifty:...::mysql(3pm) page. slay, stay hydrated, and may all your inserts return an id. 🍓💖