DBIx::C...tistics(3)

🌈 NAME 🌈

DBIx::Class::Storage::Statistics — SQL Statistics

Okay so bestie, that's the class: DBIx::Class::Storage::Statistics, and it's all about SQL Statistics. We're keeping every detail, just with better vibes. 💅

🎀 SYNOPSIS 🎀

No synopsis here — the original page leaves this part blank, and we're keeping it that way. 💀

🦋 DESCRIPTION 🦋

Okay so DBIx::Class::Storage::Statistics is called by DBIx::Class::Storage::DBI as a means of collecting statistics on its actions. It's lowkey the little stats bestie. 🧚

Using this class alone merely prints the SQL executed, the fact that it completes, and begin/end notification for transactions. That's it — no secret extra magic, no cap. ✨

To really use this class you should subclass it and create your own method for collecting the statistics as discussed in DBIx::Class::Manual::Cookbook. That's the main character move, periodt. 👑

---

✨ METHODS ✨

🧚 new 🧚

Returns a new DBIx::Class::Storage::Statistics object. Fresh object, fresh vibes. 🫶

🎀 debugfh 🎀

Sets or retrieves the filehandle used for trace/debug output. This should be an IO::Handle compatible object (only the print method is used). By default it is initially set to STDERR — although see discussion of the DBIC_TRACE environment variable. 👀

Invoked as a getter, it will lazily open a filehandle and set it to autoflush (if one is not already set). Lazy but productive, honestly iconic. 💅

🌸 print 🌸

Prints the specified string to our debugging filehandle. Provided to save our methods the worry of how to display the message. Like, the method doesn't have to stress about presentation — print handles it. ✨

🦋 silence 🦋

Turn off all output if set to true. Quiet mode activated. 🤫

⭐ txn_begin ⭐

Called when a transaction begins. Transaction era begins. 🎬

💜 txn_rollback 💜

Called when a transaction is rolled back. Oops, we're undoing. 😭

🔥 txn_commit 🔥

Called when a transaction is committed. Slay, it's official. ✅

🎀 svp_begin 🎀

Called when a savepoint is created. Savepoint bestie has entered the chat. 🫶

🌈 svp_release 🌈

Called when a savepoint is released. Bye savepoint, you did great. 💅

🧚 svp_rollback 🧚

Called when rolling back to a savepoint. Rewind moment. ⏪

👑 query_start 👑

Called before a query is executed. The first argument is the SQL string being executed and subsequent arguments are the parameters used for the query. So it's got the SQL and the params — everything the query needs to know. 💖

🍓 query_end 🍓

Called when a query finishes executing. Has the same arguments as query_start. Matching set, cute. 🎀

💬 FURTHER QUESTIONS? 💬

Check the list of additional DBIC resources. That's the move. 🔍

📜 COPYRIGHT AND LICENSE 📜

This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library. 💖

---

Signed off with love from the User Contributed Perl Documentation universe: perl v5.42.0, dated 2025-01-22, and the footer energy is DBIx::C...tistics(3). fr fr 💅✨