NAME

DBIx::SQLEngine::Record::Hooks - Flexible Pre/Post Hooks

SYNOPSIS

Setup: Several ways to create a class.

  my $sqldb = DBIx::SQLEngine->new( ... );

  $class_name = $sqldb->record_class( $table_name, undef, 'Hooks' );
  
  $sqldb->record_class( $table_name, 'My::Record', 'Hooks' );
  
  package My::Record;
  use DBIx::SQLEngine::Record::Class '-isasubclass', 'Hooks';  
  My::Record->table( $sqldb->table($table_name) );

Hooks: Register subs for callbacks.

  DBIx::SQLEngine::Record::Hooks->install_hooks( 
    post_new    => sub { warn "Record $_[0] created" },
    post_fetch  => sub { warn "Record $_[0] loaded" },
    post_insert => sub { warn "Record $_[0] inserted" },
    post_update => sub { warn "Record $_[0] updated" },
    post_delete => sub { warn "Record $_[0] deleted" },
  );
  
  $class_name->install_hooks( %hook_subs );

  $record->install_hooks( %hook_subs );

Basics: Layered over superclass.

  # Calls post_fetch hooks on record
  $record = $class_name->fetch_record( $primary_key );

  # Calls post_fetch hooks on each record
  @records = $class_name->fetch_select(%clauses)->records;
  
  # Calls post_new hooks on empty record
  $record = $class_name->new_with_values(somefield => 'My Value');

  # Calls ok_insert, pre_insert, and post_insert hooks
  $record->insert_record();
  
  # Calls ok_update, pre_update, and post_update hooks
  $record->update_record();
  
  # Calls ok_delete, pre_delete, and post_delete hooks
  $record->delete_record();

DESCRIPTION

This package provides a callback layer for DBIx::SQLEngine::Record objects.

Don't use this module directly; instead, pass its name as a trait when you create a new record class. This package provides a multiply-composable collection of functionality for Record classes. It is combined with the base class and other traits by DBIx::SQLEngine::Record::Class.

HOOKS INTERFACE

Many of the methods below are labeled "Inheritable Hook." These methods allow you to register callbacks which are then invoked at specific points in each record's lifecycle. You can add these callbacks to all record classes, to a particular class, or even to a particular object instance.

These hooks act like the triggers supported by some databases; you can ensure that every time a record is updated in a specific table, certain other actions occur automatically.

To register a callback, call the install_hooks method, and pass it pairs of a hook method name, and a subroutine reference, as follows: callee->install_hooks( methodname => coderef, ... ).

install_hooks()

  $classname->install_hooks( $hook_name => \&my_sub, ... )
  $record->install_hooks( $hook_name => \&my_sub, ... )

Registers one or more callbacks. Accepts pairs of a hook method name, and a subroutine reference.

For more about the implementation of the Hook mechanism, see Class::MakeMethods::Composite::Inheritable.

Examples:

Here are a few examples to show the possibilities this provides you with:

To have each record write to a log when it's loaded from the database:

  sub log_fetch { my $record = shift; warn "Loaded record $record->{id}" } );
  MyClass->install_hooks( post_fetch => \&log_fetch );

To make a class "read-only" by preventing all inserts, updates, and deletes:

  my $refusal = sub { return 0 };
  MyClass->install_hooks( 
    ok_insert => $refusal, 
    ok_update => $refusal, 
    ok_delete => $refusal, 
  );

To have a particular record automatically save any changes you've made to it when it goes out of scope:

  my $record = MyClass->fetch_one( ... );
  $record->install_hooks( pre_destroy => sub { (shift)->save_record } );

SIMPLE RECORD INTERFACE

Constructor

You may create your own records for new instances, or fetch records from the database as described in "FETCHING DATA (SQL DQL)"

new_empty_record()

  $class_name->new_empty_record() : $empty_record

Adds support for post_new hook.

post_new()

Inheritable Hook. Add functions which should be called immediately after each record is created and initialized.

Destructor

Automatically invoked when record is being garbage collected.

DESTROY()

  $record->DESTROY()

Adds support for pre_destroy hook.

pre_destroy

  $record->pre_destroy ()

Inheritable Hook. Add functions which should be called when an individual record is being garbage collected.

FETCHING DATA (SQL DQL)

Vivifying Records From The Database

These methods are called internally by the various select methods and do not need to be called directly.

record_from_db_data()

  $class_name->record_from_db_data( $hash_ref )
  $class_name->record_from_db_data( $hash_ref ) : $record
  $class_name->record_from_db_data( %hash_contents ) : $record

Adds support for post_fetch hook.

record_set_from_db_data()

  $class_name->record_set_from_db_data( $hash_array_ref )
  $class_name->record_set_from_db_data( $hash_array_ref ) : $record_set
  $class_name->record_set_from_db_data( @hash_refs ) : $record_set

Adds support for post_fetch hook.

post_fetch()

Inheritable Hook. Add functions which should be called immediately after each record is retrieved from the database.

EDITING DATA (SQL DML)

Insert to Add Records

After constructing a record with one of the new_*() methods, you may save any changes by calling insert_record.

insert_record

  $record_obj->insert_record() : $flag

Attempt to insert the record into the database.

Calls ok_insert to ensure that it's OK to insert this row, and aborts if any of hook subroutines return 0.

Calls any pre_insert hooks, then calls the superclass insert_row method, then calls any post_insert hooks.

Returns undef if the update was aborted, or the record if the insert was successful.

ok_insert

Inheritable Hook. Add functions which should be called to validate rows before they are inserted.

pre_insert

Inheritable Hook. Add functions which should be called immediately before a row is inserted.

post_insert

Inheritable Hook. Add functions which should be called after a row is inserted.

Update to Change Records

After retrieving a record with one of the fetch methods, you may save any changes by calling update_record.

update_record

  $record_obj->update_record() : $record_count

Attempts to update the record using its primary key as a unique identifier.

Calls ok_update to ensure that it's OK to update this row, and aborts if any of hook subroutines return 0.

Calls any pre_update hooks, then calls the superclass method, then calls any post_update hooks.

Returns undef if the update was aborted, or the record if the update was successful.

ok_update

Inheritable Hook. Add functions which to use to validate rows before they are updated. Return 0 to abort the update.

pre_update

Inheritable Hook. Add functions which should be called immediately before a row is updated.

post_update

Inheritable Hook. Add functions which should be called immediately after a row is updated.

Delete to Remove Records

delete_record()

  $record_obj->delete_record() : $record_count

Delete this existing record based on its primary key.

Checks to see if any of the pre_delete results is "0". If not, calls the superclass method.

Returns 1 if the deletion was successful, or 0 if it was aborted.

ok_delete

  $record->ok_delete () : @booleans

Inheritable Hook. Add functions which should be used to use to validate rows before they are updated. Return 0 to abort the deletion.

pre_delete

  $record->pre_delete ()

Inheritable Hook. Add functions which should be called before a row is deleted.

post_delete

  $record->post_delete ()

Inheritable Hook. Add functions which should be called after a row is deleted.