X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FUniqueIdentifier.pm;h=92e7c1548a864865d120650f52abc6ad612aad28;hb=40d8d018f03631cf38c5bebf854abef604de33bd;hp=a748994c5365b51b10aacd2fbc2ae96e7843604d;hpb=91d0c99f913a7d2a03a159c4f14ecde89c43a1bf;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Storage/DBI/UniqueIdentifier.pm b/lib/DBIx/Class/Storage/DBI/UniqueIdentifier.pm index a748994..92e7c15 100644 --- a/lib/DBIx/Class/Storage/DBI/UniqueIdentifier.pm +++ b/lib/DBIx/Class/Storage/DBI/UniqueIdentifier.pm @@ -5,30 +5,56 @@ use warnings; use base 'DBIx::Class::Storage::DBI'; use mro 'c3'; +__PACKAGE__->mk_group_accessors(inherited => 'new_guid'); + =head1 NAME DBIx::Class::Storage::DBI::UniqueIdentifier - Storage component for RDBMSes -supporting the 'uniqueidentifier' type +supporting GUID types =head1 DESCRIPTION -This is a storage component for databases that support the C -type and the C function for generating UUIDs. +This is a storage component for databases that support GUID types such as +C, C or C. + +GUIDs are generated automatically for PK columns with a supported +L, as well as non-PK with +L set. + +=head1 METHODS + +=head2 new_guid + +The composing class must set C to the method used to generate a new +GUID. It can also set it to C, in which case the user is required to set +it, or a runtime error will be thrown. It can be: + +=over 4 + +=item string + +In which case it is used as the name of database function to create a new GUID, + +=item coderef -UUIDs are generated automatically for PK columns with the C -L, as well as non-PK with this -L and -L. +In which case the coderef should return a string GUID, using L, or +whatever GUID generation method you prefer. -Currently used by L and -L. +=back -The composing class can define a C<_new_uuid> method to override the function -used to generate a new UUID. +For example: + + $schema->storage->new_guid(sub { Data::GUID->new->as_string }); =cut -sub _new_uuid { 'NEWID()' } +my $GUID_TYPE = qr/^(?:uniqueidentifier(?:str)?|guid)\z/i; + +sub _is_guid_type { + my ($self, $data_type) = @_; + + return $data_type =~ $GUID_TYPE; +} sub insert { my $self = shift; @@ -44,13 +70,13 @@ sub insert { my @pk_guids = grep { $col_info->{$_}{data_type} && - $col_info->{$_}{data_type} =~ /^uniqueidentifier/i + $col_info->{$_}{data_type} =~ $GUID_TYPE } @pk_cols; my @auto_guids = grep { $col_info->{$_}{data_type} && - $col_info->{$_}{data_type} =~ /^uniqueidentifier/i + $col_info->{$_}{data_type} =~ $GUID_TYPE && $col_info->{$_}{auto_nextval} } grep { not exists $pk_cols{$_} } $source->columns; @@ -61,7 +87,24 @@ sub insert { my $updated_cols = {}; for my $guid_col (@get_guids_for) { - my ($new_guid) = $self->_get_dbh->selectrow_array('SELECT '.$self->_new_uuid); + my $new_guid; + + my $guid_method = $self->new_guid; + + if (not defined $guid_method) { + $self->throw_exception( + 'You must set new_guid on your storage. See perldoc ' + .'DBIx::Class::Storage::DBI::UniqueIdentifier' + ); + } + + if (ref $guid_method eq 'CODE') { + $new_guid = $guid_method->(); + } + else { + ($new_guid) = $self->_get_dbh->selectrow_array("SELECT $guid_method"); + } + $updated_cols->{$guid_col} = $to_insert->{$guid_col} = $new_guid; }