CPAN::...::State(3pm)

💖 NAME 💖

CPAN::SQLite::State — bestie, this is the module that checks up on your database and tells you what's up with it ✨

---

🌸 VERSION 🌸

version 0.220 — that's the one, no cap 💅

---

🦋 DESCRIPTION 🦋

Okay so picture this: this module rolls up to your database, asks it how it's doing, and then compares that whole vibe check against the tea it gets from the CPAN index files (shoutout CPAN::SQLite::Info) and from the repositories (shoutout CPAN::SQLite::PPM). 🫶

And it does this for each of the four tables: dists, mods, auths, and ppms. For every single one of them, two methods are used to pull this info together — iconic, I know:

• "ids"

This method gets the ids of the relevant names, and versions, if applicable, in the table. Basically it's like, "who are you and what version are you giving" 😌

• "state"

This method takes the info sitting in the tables from the "ids" method and compares it against what the CPAN indices and ppm repositories are saying. Then it decides on one of three actions, which gets acted upon later in CPAN::SQLite::Populate. Three options, one decision, main character energy fr fr:

• "insert"

If the info from the indices is not in the database, then this info gets marked for insertion. New stuff incoming, slay ✨

• "update"

If the info in the database is older than the info from the indices (generally, this means an older version), then it's marked for updating. Glow-up time 💖

• "delete"

If the info in the database is no longer present in the indices, it gets marked for deletion. It's giving goodbye, it's giving closure 💀

Ngl bestie, that's the whole module — it's literally just the vibe check + the comparison + the decision. The actual doing of the thing happens over in CPAN::SQLite::Populate. iykyk 🌈

---

And that's a wrap, gorgeous 🎀 — this page came from the User Contributed Perl Documentation, CPAN::...::State(3pm), generated with perl v5.36.0 and dated 2022-10-30. Go forth and let your database tell you how it really feels 💅✨