Man page or keyword search:   man All Sections 1 - General Commands 2 - System Calls 3 - Subroutines, Functions 4 - Special Files 5 - File Formats 6 - Games and Screensavers 7 - Macros and Conventions 8 - Maintenence Commands 9 - Kernel Interface New Commands Server 4.4BSD AIX Alpinelinux Archlinux Aros BSDOS BSDi Bifrost CentOS Cygwin Darwin Debian DigitalUNIX DragonFly ElementaryOS Fedora FreeBSD Gentoo GhostBSD HP-UX Haiku Hurd IRIX Inferno JazzOS Kali Knoppix LinuxMint MacOSX Mageia Mandriva Manjaro Minix MirBSD NeXTSTEP NetBSD OPENSTEP OSF1 OpenBSD OpenDarwin OpenIndiana OpenMandriva OpenServer OpenSuSE OpenVMS Oracle PC-BSD Peanut Pidora Plan9 QNX Raspbian RedHat Scientific Slackware SmartOS Solaris SuSE SunOS Syllable Tru64 UNIXv7 Ubuntu Ultrix UnixWare Xenix YellowDog aLinux   31170 pages apropos Keyword Search (all sections) Output format html ascii pdf view pdf save postscript

SQL::Translator::SchemUserrContributed PerlSQL::Translator::Schema::Trigger(3)

NAME
       SQL::Translator::Schema::Trigger - SQL::Translator 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
	 );

DESCRIPTION
       "SQL::Translator::Schema::Trigger" is the trigger object.

METHODS
   new
       Object constructor.

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

   perform_action_when
       Gets or sets whether the event happens "before" or "after" the
       "database_event".

	 $trigger->perform_action_when('after');

   database_event
       Obsolete please use database_events!

   database_events
       Gets or sets the events that triggers the trigger.

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

   fields
       Gets and set which fields to monitor for "database_event".

	 $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 set the table on which the trigger works, as a
       SQL::Translator::Schema::Table object.
	 $trigger->table($triggered_table);

   on_table
       Gets or set the table name on which the trigger works, as a string.
	 $trigger->on_table('foo');

   action
       Gets or set the action of the trigger.

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

   is_valid
       Determine whether the trigger is valid or not.

	 my $ok = $trigger->is_valid;

   name
       Get or set the trigger's name.

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

   order
       Get or set the trigger's order.

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

   schema
       Get or set the trigger's schema object.

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

   compare_arrays
       Compare two arrays.

   equals
       Determines if this trigger is the same as another

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

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

perl v5.14.2			  2011-05-0SQL::Translator::Schema::Trigger(3)

Vote for polarhome