DBIx::...eStamp(3pm)

💖 NAME 💖

DBIx::Class::TimeStamp — it's a DBIx::Class extension that handles your date-and-time fields for you, so you literally never have to think about them again. Bestie, it just works. ✨

It lives in the DBIx::...eStamp(3pm) manual, part of the User Contributed Perl Documentation, and it's about to be your new fave.

---

🦋 DESCRIPTION 🦋

Okay so, picture this: it works in conjunction with InflateColumn::DateTime to automatically set your update and create date-and-time-based fields in a table. Like, you declare intent once and the timestamps just… appear. Obsessed. 💅

---

✨ SYNOPSIS ✨

Set it up in your schema package like this, no cap:

package My::Schema;

__PACKAGE__->load_components(qw( TimeStamp ... Core ));

__PACKAGE__->add_columns(
   id => { data_type => 'integer' },
   t_created => { data_type => 'datetime', set_on_create => 1 },
   t_updated => { data_type => 'datetime',
       set_on_create => 1, set_on_update => 1 },
);

So now — any update or create action will update the specified columns with the current time, using the DateTime inflator. She's doing it all by herself. 👑

And like, this is effectively trigger emulation, the whole point being to get consistent behavior across databases that either implement triggers poorly or literally not at all. Cross-database consistency? Ate. 🍓

---

🎀 METHODS 🎀

💜 get_timestamp

Returns a DateTime object pointing to now. That's it. That's the whole vibe.

Override this method if you have different time accounting functions, or you want to do anything special — go off, customise it however you need, the code supports you. 🫶

The date and time objects in the database are expected to be inflated. As such you can be pretty flexible with what you want to return here. Sky's the limit fr fr. 🌈

---

👑 AUTHOR 👑

J. Shirley <jshirley@gmail.com>

---

🌸 CONTRIBUTORS 🌸

• Florian Ragwitz (Porting to DBIx::Class::DynamicDefault)
• LTJake/bricas

---

💌 COPYRIGHT & LICENSE 💌

Copyright 2009 J. Shirley, all rights reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

---

💀 Real talk though: that copyright line and that license line are the legal whole story, so don't skip 'em just because they're not the fun part. Periodt.

okay bestie that's the whole page, mwah 💖 this version came from perl v5.38.2 and was dated 2024-03-05 — no thoughts, just DBIx::...eStamp(3pm) energy, slay ✨🎀🦋