X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FSQLAnywhere.pm;h=728220ff8b298ab09dfaee2db73d5cbd70de0d91;hb=1db83fb9ce3e15d68e2384720ed06af6de5edbac;hp=85b5614e6d219d699fabe2b536a4a90c9cf19062;hpb=6298a324307439b76419d0f5db453b0d10f10517;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/lib/DBIx/Class/Storage/DBI/SQLAnywhere.pm b/lib/DBIx/Class/Storage/DBI/SQLAnywhere.pm index 85b5614..728220f 100644 --- a/lib/DBIx/Class/Storage/DBI/SQLAnywhere.pm +++ b/lib/DBIx/Class/Storage/DBI/SQLAnywhere.pm @@ -8,9 +8,8 @@ use List::Util 'first'; use Try::Tiny; use namespace::clean; -__PACKAGE__->mk_group_accessors(simple => qw/ - _identity -/); +__PACKAGE__->mk_group_accessors(simple => qw/_identity/); +__PACKAGE__->sql_limit_dialect ('RowNumberOver'); =head1 NAME @@ -18,8 +17,7 @@ DBIx::Class::Storage::DBI::SQLAnywhere - Driver for Sybase SQL Anywhere =head1 DESCRIPTION -This class implements autoincrements for Sybase SQL Anywhere, selects the -RowNumberOver limit implementation and provides +This class implements autoincrements for Sybase SQL Anywhere and provides L support. You need the C driver that comes with the SQL Anywhere @@ -39,19 +37,27 @@ sub last_insert_id { shift->_identity } sub _new_uuid { 'UUIDTOSTR(NEWID())' } -sub insert { +sub _prefetch_autovalues { my $self = shift; my ($source, $to_insert) = @_; + my $values = $self->next::method(@_); + + my $colinfo = $source->columns_info; + my $identity_col = - first { $source->column_info($_)->{is_auto_increment} } $source->columns; + first { $colinfo->{$_}{is_auto_increment} } keys %$colinfo; # user might have an identity PK without is_auto_increment if (not $identity_col) { foreach my $pk_col ($source->primary_columns) { - if (not exists $to_insert->{$pk_col} && - $source->column_info($pk_col)->{data_type} !~ /^uniqueidentifier/i) - { + if ( + ! exists $to_insert->{$pk_col} + and + $colinfo->{$pk_col}{data_type} + and + $colinfo->{$pk_col}{data_type} !~ /^uniqueidentifier/i + ) { $identity_col = $pk_col; last; } @@ -68,12 +74,12 @@ sub insert { }; if (defined $identity) { - $to_insert->{$identity_col} = $identity; + $values->{$identity_col} = $identity; $self->_identity($identity); } } - return $self->next::method(@_); + return $values; } # convert UUIDs to strings in selects @@ -98,18 +104,6 @@ sub _select_args { return $self->next::method(@_); } -# this sub stolen from DB2 - -sub _sql_maker_opts { - my ( $self, $opts ) = @_; - - if ( $opts ) { - $self->{_sql_maker_opts} = { %$opts }; - } - - return { limit_dialect => 'RowNumberOver', %{$self->{_sql_maker_opts}||{}} }; -} - # this sub stolen from MSSQL sub build_datetime_parser {