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

diff --git a/lib/SQL/Translator/Object/Constraint.pm b/lib/SQL/Translator/Object/Constraint.pm
index d8f0bfe..f8913c9 100644
--- a/lib/SQL/Translator/Object/Constraint.pm
+++ b/lib/SQL/Translator/Object/Constraint.pm
@@ -1,6 +1,6 @@
 use MooseX::Declare;
 class SQL::Translator::Object::Constraint extends SQL::Translator::Object {
-    use MooseX::Types::Moose qw(ArrayRef Bool HashRef Maybe Str Undef);
+    use MooseX::Types::Moose qw(ArrayRef Bool HashRef Int Maybe Str Undef);
     use MooseX::MultiMethods;
     use SQL::Translator::Types qw(Column MatchType Table);
 
@@ -74,6 +74,11 @@ class SQL::Translator::Object::Constraint extends SQL::Translator::Object {
         default => ''
     );
 
+    has '_order' => (
+        isa => Int,
+        is => 'rw',
+    );
+
     has 'on_delete' => ( is => 'rw', required => 0);
     has 'on_update' => ( is => 'rw', required => 0);
 
@@ -84,5 +89,16 @@ class SQL::Translator::Object::Constraint extends SQL::Translator::Object {
         $self->$orig($column->name, $column)
     }
 
+    multi method order(Int $order) { $self->_order($order); }
+    multi method order {
+        my $order = $self->_order;
+        unless (defined $order && $order) {
+            my $tables = Tie::IxHash->new( map { $_->name => $_ } $self->schema->get_tables );
+            $order = $tables->Indices($self->name) || 0; $order++;
+            $self->_order($order);
+        }
+        return $order;
+    }
+
     method is_valid { return $self->has_type && scalar $self->column_ids ? 1 : undef }
 }