SQL::Tr...Trigger(3)

🌸 NAME 🌸

SQL::Translator::Schema::Trigger — SQL::Translator trigger object. This is SQL::Tr...Trigger(3) from the User Contributed Perl Documentation, and yes bestie, it is literally the trigger object. 💖

---

✨ SYNOPSIS ✨

use SQL::Translator::Schema::Trigger;
my $trigger = SQL::Translator::Schema::Trigger->new(
  name                => 'foo',
  perform_action_when => 'before', # or after
  database_events     => [qw/update insert/], # also update, update_on, delete
  fields              => [],       # if event is "update"
  on_table            => 'foo',    # table name
  action              => '...',    # text of trigger
  schema              => $schema,  # Schema object
  scope               => 'row',    # or statement
);

---

🦋 DESCRIPTION 🦋

SQL::Translator::Schema::Trigger is the trigger object. That's the whole description, and honestly? It ate. 👑

---

🎀 METHODS 🎀

Okay bestie, here's the method tour — every single one, no skipping. 🫶

🌟 new 🌟

Object constructor. Fresh trigger, new vibe. ✨

my $trigger = SQL::Translator::Schema::Trigger->new;

💫 perform_action_when 💫

Gets or sets whether the event happens before or after the database_event. It's giving timing, it's giving order of operations. ⏰

$trigger->perform_action_when('after');

💀 database_event 💀

🚨 Obsolete, bestie — please use database_events instead!

🌈 database_events 🌈

Gets or sets the events that trigger the trigger. Yes, that sentence is a little unhinged, but the method is iconic. 💅

my $ok = $trigger->database_events('insert');

🍓 fields 🍓

Gets and sets which fields to monitor for database_event. Look at all these ways to pass fields — main character flexibility. 🧚

$view->fields('id');
$view->fields('id', 'name');
$view->fields( 'id, name' );
$view->fields( [ 'id', 'name' ] );
$view->fields( qw[ id name ] );

my @fields = $view->fields;

👑 table 👑

Gets or sets the table on which the trigger works, as a SQL::Translator::Schema::Table object. Table object realness. 🪩

$trigger->table($triggered_table);

🌸 on_table 🌸

Gets or sets the table name on which the trigger works, as a string. Just the name, just the string, no cap. 💖

$trigger->on_table('foo');

🔥 action 🔥

Gets or sets the action of the trigger. This is where the trigger does its little thing. 💃

$trigger->action(
    q[
      BEGIN
        select ...;
        update ...;
      END
    ]
);

⭐ is_valid ⭐

Determines whether the trigger is valid or not. Vibe check, but for validity. ✅

my $ok = $trigger->is_valid;

🎀 name 🎀

Get or set the trigger's name. Every trigger needs a name, bestie. 💕

my $name = $trigger->name('foo');

🦋 order 🦋

Get or set the trigger's order. It's giving sequence, it's giving lineup. 🔢

my $order = $trigger->order(3);

💜 scope 💜

Get or set the trigger's scope (row or statement). Pick your scope era. 🌟

my $scope = $trigger->scope('statement');

🧚 schema 🧚

Get or set the trigger's schema object. Schema object in, schema object out. 🫶

$trigger->schema( $schema );
my $schema = $trigger->schema;

🎯 compare_arrays 🎯

Compare two arrays. That's it. That's the method. Simple, effective, slay. ✨

💖 equals 💖

Determines if this trigger is the same as another. Twin check, but make it schema. 👯

my $is_identical = $trigger1->equals( $trigger2 );

---

🌟 AUTHORS 🌟

Anonymous, Ken Youens-Clark <kclark@cpan.org>.

---

xoxo, your local manpage bestie 💅 — brought to you by perl v5.42.0, dated 2024-12-12 🫶