Jifty:...formix(3pm)

✨ NAME ✨

Jifty::DBI::Handle::Informix — it's an Informix-specific Handle object, and yes it's a Perl thing 💅

---

📜 SYNOPSIS

okay so. bestie. there is literally nothing here. no synopsis. zero. nada. the original page just skips straight from SYNOPSIS to DESCRIPTION like it's too cool for an example. iconic of it honestly 🙈

---

💖 DESCRIPTION

This module hands you a subclass of Jifty::DBI::Handle that exists purely to compensate for some of the idiosyncrasies of Informix. Informix is gonna Informix, and this lil handle object is here to smooth that over for you 🫶

---

🎀 METHODS 🎀

insert

Takes a table name as the first argument, and then it just assumes the rest of the arguments are an array of key-value pairs that you wanna insert. very "just trust me" of it.

• If the insert succeeds, you get back the id of the insert ✨
• If it doesn't, you get back a Class::ReturnValue object with the error reported in it 💀

case_sensitive

Returns 1, because Informix's searches are case sensitive by default. that's it. that's the whole method. slay 🌸

apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW

takes an SQL SELECT statement and massages it so it returns ROWS_PER_PAGE rows, starting with FIRST_ROW. paging energy, but make it Informix 🦋

disconnect

Disconnects and removes the reference to the handle for Informix. bye bestie 👋

distinct_query STATEMENTREF

takes an incomplete SQL SELECT statement and massages it so it returns a DISTINCT result set. no dupes, no cap 💅

---

👑 AUTHOR

Oliver Tappe, oliver@akso.de — thank you for your service 🫡

---

🌈 SEE ALSO

• perl(1)
• Jifty::DBI

---

and that's the whole page, bestie!! this beauty lives in the User Contributed Perl Documentation corner of the world, running on perl v5.34.0, and it was dated 2022-06-15. go forth and Informix responsibly 💖✨🎀