Jifty:...le::Pg(3pm)

✨ NAME ✨

Jifty::DBI::Handle::Pg — a Postgres-specific Handle object 💅 (it lives in the Jifty:...le::Pg page of the User Contributed Perl Documentation, so you already know it's giving ~legacy~ but make it work 🫶)

---

🌸 SYNOPSIS 🌸

okay so bestie... there's literally nothing here. no synopsis. no code. the section exists and that's it. iconic behaviour honestly 🎀 (go read METHODS instead, that's where the good stuff is)

---

🦋 DESCRIPTION 🦋

This module hands you a subclass of Jifty::DBI::Handle that exists purely to compensate for some of the idiosyncrasies of Postgres 😭 like Postgres is amazing and we love her but she does have her little quirks and this module is the bestie who smooths everything over. no cap.

---

💖 METHODS 💖

🌈 connect

connect takes a hashref and passes it off to SUPER::connect; forces the timezone to GMT, returns a database handle ✨

so like, it's a middleman but a useful middleman. it grabs your hashref, yeets it up to SUPER::connect, makes sure the timezone is locked to GMT, and hands you back a database handle. periodt. 🫶

🌈 insert

Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted. 💌

In case of insert failure, returns a Class::ReturnValue object preloaded with error info 😭 so if it flops, you get a whole object with the tea in it instead of just... nothing.

🌈 id_sequence_name TABLE

Takes a TABLE name and returns the name of the sequence of the primary key for that table 🔑 like "hey what's the sequence called" and it tells you.

🌈 blob_params column_NAME column_type

Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. 🍓 The current Postgres implementation only supports BYTEA types — that's it, that's the whole menu, no substitutions bestie.

🌈 apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW

takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW 💆‍♀️ like it literally gives your query a little spa day so it comes back paginated exactly how you asked.

🌈 _make_clause_case_insensitive column operator VALUE

Takes a column, operator and value. performs the magic necessary to make your database treat this clause as case insensitive ✨🔮

Returns a column operator value triple 👑 (yes it's the same three things but now the magic has been performed, trust)

🌈 distinct_query STATEMENTREF

takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set 🌟 another lil spa day, but this time your results come back de-duplicated.

🌈 canonical_true

The canonical true value in Postgres is 't' ✅

🌈 canonical_false

The canonical false value in Postgres is 'f' ❌

---

🎀 SEE ALSO 🎀

• Jifty::DBI
• Jifty::DBI::Handle
• DBD::Pg

---

and that's the whole page, bestie 💜 this was Jifty:...le::Pg from the User Contributed Perl Documentation, dated 2022-06-15 and generated with perl v5.34.0. go forth and query responsibly, mwah 😘💅