X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FObject%2FConstraint.pm;h=d8f0bfe77de827ecf2ca66551fb1f0e623d055e6;hb=4d662d4c3b4cbb574836ee9ee391a696e3fb7c21;hp=7ed4c718bbcf9fea835033fc72a7217818236465;hpb=d191bceb69535f783555f98035afb335862f4f81;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 7ed4c71..d8f0bfe 100644 --- a/lib/SQL/Translator/Object/Constraint.pm +++ b/lib/SQL/Translator/Object/Constraint.pm @@ -2,7 +2,7 @@ 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::MultiMethods; - use SQL::Translator::Types qw(Column Table); + use SQL::Translator::Types qw(Column MatchType Table); has 'table' => ( is => 'rw', @@ -12,7 +12,8 @@ class SQL::Translator::Object::Constraint extends SQL::Translator::Object { has 'name' => ( is => 'rw', - isa => Maybe[Str], + isa => Str, + default => '', required => 1 ); @@ -26,6 +27,7 @@ class SQL::Translator::Object::Constraint extends SQL::Translator::Object { get_columns => 'values', get_column => 'get', add_column => 'set', + clear_columns => 'clear', }, default => sub { my %hash = (); tie %hash, 'Tie::IxHash'; return \%hash }, ); @@ -33,6 +35,8 @@ class SQL::Translator::Object::Constraint extends SQL::Translator::Object { has 'type' => ( is => 'rw', isa => Str, + predicate => 'has_type', + required => 1, ); has 'deferrable' => ( @@ -56,16 +60,29 @@ class SQL::Translator::Object::Constraint extends SQL::Translator::Object { traits => ['Array'], handles => { reference_columns => 'elements', + add_reference_column => 'push', }, default => sub { [] }, + required => 1, ); has 'match_type' => ( - isa => Str, + isa => MatchType, is => 'rw', + coerce => 1, lazy => 1, default => '' ); - around add_column(Column $column) { $self->$orig($column->name, $column) } + has 'on_delete' => ( is => 'rw', required => 0); + has 'on_update' => ( is => 'rw', required => 0); + + around add_column(Column $column) { + if ($self->has_type && $self->type eq 'PRIMARY KEY') { + $column->is_primary_key(1); + } + $self->$orig($column->name, $column) + } + + method is_valid { return $self->has_type && scalar $self->column_ids ? 1 : undef } }