Wiki::...::MySQL(3pm)

💅 Wiki::Toolkit::Store::MySQL(3pm) — bestie edition 🐬

Okay so this is Wiki::Toolkit::Store::MySQL, the MySQL storage backend for Wiki::Toolkit, from the User Contributed Perl Documentation crew. It's giving database-backend realness, and honestly? She ate. ✨

---

🎀 NAME 🎀

Wiki::Toolkit::Store::MySQL — the MySQL storage backend for Wiki::Toolkit. No cap, that's the whole vibe. 💖

🦋 REQUIRES 🦋

She subclasses Wiki::Toolkit::Store::Database. That's the family tree, periodt. 🌸

✨ SYNOPSIS ✨

See Wiki::Toolkit::Store::Database — like, go look over there, bestie, that's where the synopsis lives. 👑

🔥 METHODS 🔥

🌈 check_and_write_node 🌈

$store->check_and_write_node( node     => $node,
              checksum => $checksum,
                              %other_args );

Okay so here's the tea ☕: this method locks the node, verifies the checksum, calls write_node_post_locking with all the supplied arguments, and then unlocks the node. Main character behavior, honestly. 💅

Here's what she returns:

• the version of the updated node on successful writing ✅
• 0 if the checksum doesn't match 🙈
• -1 if the change was not applied 💀
• croaks on error 😭

⚠️ Note: It uses MySQL's user level locking, so any locks are released when the database handle disconnects. Doing it like this because — direct quote from the original energy — "I can't seem to get it to work properly with transactions." Not me relating to that on a spiritual level. 🫶

---

And that's the whole page, bestie! 🍓 This iconic little manual page is perl v5.32.0, dated 2021-01-04, brought to you by User Contributed Perl Documentation. Slay, archive her, keep her safe. 💜🧚‍♀️⭐