X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FObject%2FTrigger.pm;h=5e324b5c5a30120d0f31acf6c00a4f9f9137b629;hb=160f1f551395c24929216b166a3eb45c3096f435;hp=f2a744ed93124040840a540467268076b9c2eda1;hpb=bdf688cd7e4bdde6fd9a6c7b88ab903f0c301f10;p=dbsrgits%2FSQL-Translator-2.0-ish.git

diff --git a/lib/SQL/Translator/Object/Trigger.pm b/lib/SQL/Translator/Object/Trigger.pm
index f2a744e..5e324b5 100644
--- a/lib/SQL/Translator/Object/Trigger.pm
+++ b/lib/SQL/Translator/Object/Trigger.pm
@@ -1,6 +1,6 @@
 use MooseX::Declare;
 class SQL::Translator::Object::Trigger extends SQL::Translator::Object {
-    use MooseX::Types::Moose qw(Any ArrayRef HashRef Str);
+    use MooseX::Types::Moose qw(Any ArrayRef HashRef Int Str);
     use MooseX::MultiMethods;
     use SQL::Translator::Types qw(Column Schema Table);
 
@@ -67,11 +67,27 @@ class SQL::Translator::Object::Trigger extends SQL::Translator::Object {
         required => 1,
     );
 
+    has '_order' => (
+        isa => Int,
+        is => 'rw',
+    );
+
     around add_column(Column $column) { $self->$orig($column->name, $column) }
 
     multi method database_events(Str $database_event) { $self->add_database_event($database_event); $self->database_events }
     multi method database_events(ArrayRef $database_events) { $self->add_database_event($_) for @$database_events; $self->database_events }
     multi method database_events { $self->_database_events }
 
+    multi method order(Int $order) { $self->_order($order); }
+    multi method order {
+        my $order = $self->_order;
+        unless (defined $order && $order) {
+            my $triggers = Tie::IxHash->new( map { $_->name => $_ } $self->schema->get_triggers );
+            $order = $triggers->Indices($self->name) || 0; $order++;
+            $self->_order($order);
+        }
+        return $order;
+    }
+
     method is_valid { 1 }
 }