Jifty:...SQLite(3pm)

💖 Jifty::DBI::Handle::SQLite 💖

okay bestie, so this is the Perl doc for Jifty::DBI::Handle::SQLite — a SQLite specific Handle object, living in the User Contributed Perl Documentation section (3pm). she's a whole vibe, let's get into it ✨

---

🌸 NAME 🌸

Jifty::DBI::Handle::SQLite — a SQLite specific Handle object. no cap, that's the whole name, she's concise 💅

---

🦋 SYNOPSIS 🦋

bestie... there's literally nothing here 😭 the original page has an empty SYNOPSIS section. iconic of her honestly. moving on! 🫶

---

✨ DESCRIPTION ✨

so this module is a subclass of Jifty::DBI::Handle — like, she inherited everything from her parent class and then added her own little fixes on top 👑

and what are those fixes for? for compensating for some of the idiosyncrasies of SQLite. SQLite has quirks. this module handles them. that's the job. periodt 💅

---

🎀 METHODS 🎀

💜 database_version

returns the version of the SQLite library which is used — like, for example, "2.8.0" 🌈

but here's the tea: SQLite can only return short variant. so don't expect anything long and fancy, she's giving short and sweet ✨

💜 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. very trusting of her honestly 🙈

here's how the outcome goes:

• if the insert succeeds, you get back the id of the insert 🎉
• otherwise, you get back a Class::ReturnValue object with the error reported 💀

no in-between, bestie, it's one or the other 😭

💜 case_sensitive

returns 1 — because SQLite's searches are case sensitive by default 👑

but wait, plot twist 🍓 — note, however, that SQLite's "like" operator is case insensitive. so it's giving "case sensitive, except when it's not" energy. iykyk 💅

💜 distinct_count STATEMENTREF

takes an incomplete SQL SELECT statement and massages it until it returns a DISTINCT result count ✨ like a lil glow-up for your query, she's obsessed with making it work 🧚

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

rename column.

that's it. that's the description. she said "short and effective" 💅 and honestly? respect.

---

👑 AUTHOR 👑

Jesse Vincent, jesse@fsck.com — the author, the moment, the main character 🌟

---

🌈 SEE ALSO 🌈

• perl(1)
• Jifty::DBI

go read those too bestie, they're the supporting cast 🫶

---

and that's the whole page!! this was User Contributed Perl Documentation for Jifty::DBI::Handle::SQLite, from perl v5.34.0, dated 2022-06-15 — shoutout to that version and that date, they ate and left no crumbs 💖✨🎀 bye bestie, go handle some SQLite 🦋