X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FObject%2FConstraint.pm;h=b16f3951988749af0024b171ddead9d07946b2a0;hb=801e0d4f9f9a2517d5f59de58f275eebb77d5f09;hp=266ae4f4a2e00ca77f348b240e9deaffd96e38ad;hpb=28bd628e570cb298bf33fb144d44b042e262ce40;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 266ae4f..b16f395 100644 --- a/lib/SQL/Translator/Object/Constraint.pm +++ b/lib/SQL/Translator/Object/Constraint.pm @@ -1,39 +1,44 @@ use MooseX::Declare; class SQL::Translator::Object::Constraint extends SQL::Translator::Object { - use MooseX::Types::Moose qw(ArrayRef Bool HashRef Maybe Str Undef); - use SQL::Translator::Types qw(Column Table); + use MooseX::Types::Moose qw(ArrayRef Bool HashRef Int Maybe Str Undef); + use MooseX::MultiMethods; + use SQL::Translator::Types qw(Column MatchType Table ColumnHash IxHash); + use Tie::IxHash; has 'table' => ( is => 'rw', isa => Table, - required => 1, weak_ref => 1, ); has 'name' => ( is => 'rw', - isa => Maybe[Str], + isa => Str, + default => '', required => 1 ); has 'columns' => ( - traits => ['Hash'], is => 'rw', - isa => HashRef[Column], + isa => IxHash, #ColumnHash, handles => { - exists_column => 'exists', - column_ids => 'keys', - get_columns => 'values', - get_column => 'get', - add_column => 'set', + exists_column => 'EXISTS', + column_ids => 'Keys', + get_columns => 'Values', + get_column => 'FETCH', + add_column => 'STORE', + remove_column => 'DELETE', + clear_columns => 'CLEAR', }, - default => sub { my %hash = (); tie %hash, 'Tie::IxHash'; return \%hash }, + coerce => 1, + default => sub { Tie::IxHash->new() } ); has 'type' => ( is => 'rw', isa => Str, - required => 1 + predicate => 'has_type', + required => 1, ); has 'deferrable' => ( @@ -53,21 +58,50 @@ class SQL::Translator::Object::Constraint extends SQL::Translator::Object { ); has 'reference_columns' => ( - isa => ArrayRef | Undef, - is => 'rw', - auto_deref => 1 + isa => ArrayRef, + traits => ['Array'], + handles => { + reference_columns => 'elements', + add_reference_column => 'push', + }, + default => sub { [] }, + required => 1, ); has 'match_type' => ( - isa => Str, - is => 'rw' + isa => MatchType, + is => 'rw', + coerce => 1, + lazy => 1, + default => '' ); - around add_column(Column $column) { $self->$orig($column->name, $column) } + has '_order' => ( + isa => Int, + is => 'rw', + ); + + has 'on_delete' => ( is => 'rw', required => 0); + has 'on_update' => ( is => 'rw', required => 0); + + around add_column(Column $column does coerce) { + if ($self->has_type && $self->type eq 'PRIMARY KEY') { + $column->is_primary_key(1); + } + $self->$orig($column->name, $column); + return $self->get_column($column->name); + } - method get_fields { $self->get_columns } - method fields { $self->column_ids } - method field_names { $self->column_ids } + 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 reference_fields { $self->reference_columns } + method is_valid { return $self->has_type && scalar $self->column_ids ? 1 : undef } }