Re: Unique constraints

[prev] [thread] [next] [Date index for 2005/03/04]

On Fri, Mar 04, 2005 at 10:57:35AM +0000, Will Hawes wrote:
> Is there anything built into CDBI that would allow implementation of a 
> unique constraint on a non-primary key column? Or would that need to be 
> created as a custom constraint by the user?

No. That's usually something that happens at the database level itself.

It shouldn't be too difficult to add such a constraint though.

Something like:

  __PACKAGE__->add_constraint('unique_foo', foo => sub { 
    my ($value, $self) = @_;
    return not $self->search(foo => $value);
  });

Tony