2 class SQL::Translator::Object::Constraint extends SQL::Translator::Object {
3 use MooseX::Types::Moose qw(ArrayRef Bool HashRef Int Maybe Str Undef);
4 use MooseX::MultiMethods;
5 use SQL::Translator::Types qw(Column MatchType Table ColumnHash IxHash);
23 isa => IxHash, #ColumnHash,
25 exists_column => 'EXISTS',
27 get_columns => 'Values',
28 get_column => 'FETCH',
29 add_column => 'STORE',
30 remove_column => 'DELETE',
31 clear_columns => 'CLEAR',
34 default => sub { Tie::IxHash->new() }
40 predicate => 'has_type',
55 has 'reference_table' => (
60 has 'reference_columns' => (
64 reference_columns => 'elements',
65 add_reference_column => 'push',
67 default => sub { [] },
84 has 'on_delete' => ( is => 'rw', required => 0);
85 has 'on_update' => ( is => 'rw', required => 0);
87 around add_column(Column $column does coerce) {
88 if ($self->has_type && $self->type eq 'PRIMARY KEY') {
89 $column->is_primary_key(1);
91 $self->$orig($column->name, $column);
92 return $self->get_column($column->name);
95 multi method order(Int $order) { $self->_order($order); }
97 my $order = $self->_order;
98 unless (defined $order && $order) {
99 my $tables = Tie::IxHash->new( map { $_->name => $_ } $self->schema->get_tables );
100 $order = $tables->Indices($self->name) || 0; $order++;
101 $self->_order($order);
106 method is_valid { return $self->has_type && scalar $self->column_ids ? 1 : undef }
108 around BUILDARGS(ClassName $self: @args) {
109 my $args = $self->$orig(@args);
111 my $fields = delete $args->{fields} || [];
113 $fields = ref($fields) eq 'ARRAY' ? $fields : [ $fields ];
114 my $ix_hash = Tie::IxHash->new();
115 $ix_hash->STORE($_, SQL::Translator::Object::Column->new( name => $_ )) for @$fields;
116 $args->{columns} = $ix_hash;