Jifty:...Sybase(3pm)

💖 NAME 💖

Jifty::DBI::Handle::Sybase — a Sybase specific Handle object 🦋

okay so real quick, the manual name on this one is User Contributed Perl Documentation (iykyk, it's a 3pm page, a Perl module page), and bestie, we're about to get into some Sybase-specific handle business. no cap.

---

✨ SYNOPSIS ✨

bestie there is literally nothing here 😭 the SYNOPSIS section is empty. not one line. it's giving mystery, it's giving "figure it out from the methods". iconic of it honestly 🎀

---

🌸 DESCRIPTION 🌸

so this module is a subclass of Jifty::DBI::Handle 💅 and what it does is compensate for some of the idiosyncrasies of Sybase. that's the whole vibe. Sybase is gonna Sybase, and this module is the friend who shows up with a hair tie and a plan. 🫶

---

👑 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. like, it trusts you. 💜

• if the insert succeeds, it returns the id of the insert ✨
• otherwise it returns a Class::ReturnValue object with the error reported 😭

🦋 database_version

returns the database version, and trims off any -foo identifier while it's at it. so fresh, so clean 🧚

💅 case_sensitive

returns undef, because Sybase's searches are not case sensitive by default. so yeah. undef. that's the answer. it said "no thoughts, head empty" 🎀

🌈 distinct_query STATEMENTREF

takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set. glow-up service, lowkey. ✨

---

💜 AUTHOR 💜

Jesse Vincent, jesse@fsck.com — ty bestie for your service 🫡🌸

---

⭐ SEE ALSO ⭐

• Jifty::DBI
• Jifty::DBI::Handle
• DBD::Sybase

---

and that's the whole page, bestie 🎀 this was perl v5.34.0, dated 2022-06-15 — yes she's an older queen but she still ate 💅✨ periodt.