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 has_columns => 'Length',
32 clear_columns => 'CLEAR',
35 default => sub { Tie::IxHash->new() }
41 predicate => 'has_type',
56 has 'reference_table' => (
61 has 'reference_columns' => (
65 reference_columns => 'elements',
66 add_reference_column => 'push',
68 default => sub { [] },
85 has 'on_delete' => ( is => 'rw', required => 0);
86 has 'on_update' => ( is => 'rw', required => 0);
88 around add_column(Column $column does coerce) {
89 if ($self->has_type && $self->type eq 'PRIMARY KEY') {
90 $column->is_primary_key(1);
92 $column->table($self->table);
93 $self->$orig($column->name, $column);
94 return $self->get_column($column->name);
97 multi method order(Int $order) { $self->_order($order); }
99 my $order = $self->_order;
100 unless (defined $order && $order) {
101 my $tables = Tie::IxHash->new( map { $_->name => $_ } $self->schema->get_tables );
102 $order = $tables->Indices($self->name) || 0; $order++;
103 $self->_order($order);
108 method is_valid { return $self->has_type && scalar $self->column_ids ? 1 : undef }
110 around BUILDARGS(ClassName $self: @args) {
111 my $args = $self->$orig(@args);
113 my $fields = delete $args->{fields} || [];
115 $fields = ref($fields) eq 'ARRAY' ? $fields : [ $fields ];
116 my $ix_hash = Tie::IxHash->new();
117 $ix_hash->STORE($_, SQL::Translator::Object::Column->new( name => $_ )) for @$fields;
118 $args->{columns} = $ix_hash;