DBIx/Class/Storage/DBI/ACCESS.pm

filter: Statementstmt 40.8% 20 / 49 Branchbran 0.0% 0 / 10 Conditioncond 0.0% 0 / 2 MC/DCmcdc 0.0% 0 / 1 Subroutinesub 41.6% 5 / 12 Podpod 100% 3 / 3 totaltotal 36.3% 28 / 77 CC 7 SCAR 22.7
CC
7
Cov
33%
insert
20.0
bind_attribute_by_data_type
20.0
sqlt_type
2.0
CRAP 9.7
« DBIx/Class/Storage/DBI/InterBase.pm ↑ Summary DBIx/Class/Componentised.pm »
1 package DBIx::Class::Storage::DBI::ACCESS;
2  
3 4 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
4 4 ▶use warnings;
Subroutine BEGIN: called CC=1 SCAR=0.0
5 4 ▶use base 'DBIx::Class::Storage::DBI::UniqueIdentifier';
Subroutine BEGIN: called CC=1 SCAR=0.0
6 4 ▶use mro 'c3';
Subroutine BEGIN: called CC=1 SCAR=0.0
7  
8 4 ▶use DBI ();
Subroutine BEGIN: called CC=1 SCAR=0.0
9  
10 4 __PACKAGE__->sql_limit_dialect ('Top');
11 4 __PACKAGE__->sql_maker_class('DBIx::Class::SQLMaker::ACCESS');
12 4 __PACKAGE__->sql_quote_char ([qw/[ ]/]);
13  
14 0 ▶sub sqlt_type { 'ACCESS' }
Subroutine sqlt_type: not called CC=1 SCAR=6.9
Pod documented
15  
16 4 __PACKAGE__->new_guid(undef);
17  
18 =head1 NAME
19  
20 DBIx::Class::Storage::DBI::ACCESS - Support specific to MS Access
21  
22 =head1 DESCRIPTION
23  
24 This is the base class for Microsoft Access support.
25  
26 This driver supports L<last_insert_id|DBIx::Class::Storage::DBI/last_insert_id>,
27 empty inserts for tables with C<AUTOINCREMENT> columns, nested transactions via
28 L<auto_savepoint|DBIx::Class::Storage::DBI/auto_savepoint>, C<GUID> columns via
29 L<DBIx::Class::Storage::DBI::UniqueIdentifier>.
30  
31 =head1 SUPPORTED VERSIONS
32  
33 This module has currently only been tested on MS Access 2010.
34  
35 Information about how well it works on different version of MS Access is welcome
36 (write the mailing list, or submit a ticket to RT if you find bugs.)
37  
38 =head1 USING GUID COLUMNS
39  
40 If you have C<GUID> PKs or other C<GUID> columns with
41 L<auto_nextval|DBIx::Class::ResultSource/auto_nextval> you will need to set a
42 L<new_guid|DBIx::Class::Storage::DBI::UniqueIdentifier/new_guid> callback, like
43 so:
44  
45 $schema->storage->new_guid(sub { Data::GUID->new->as_string });
46  
47 Under L<Catalyst> you can use code similar to this in your
48 L<Catalyst::Model::DBIC::Schema> C<Model.pm>:
49  
50 after BUILD => sub {
51 my $self = shift;
52 $self->storage->new_guid(sub { Data::GUID->new->as_string });
53 };
54  
55 =cut
56  
57 0 ▶sub _dbh_last_insert_id { $_[1]->selectrow_array('select @@identity') }
Subroutine _dbh_last_insert_id: not called CC=1 SCAR=6.9
58  
59 # support empty insert
60 0 ▶sub insert {
Subroutine insert: not called CC=4 SCAR=30.0
Pod documented
61 0 my $self = shift;
62 0 my ($source, $to_insert) = @_;
63  
64 0 my $columns_info = $source->columns_info;
65  
66 0 ▶ if (keys %$to_insert == 0) {
Branch: 1 branch
BranchTrueFalseTotal
if (keys %$to_insert == 0) 0 0 0
67 my ($autoinc_col) = grep {
68 0 $columns_info->{$_}{is_auto_increment}
69 0 } keys %$columns_info;
70  
71 0 ▶ $self->throw_exception(
Branch: 1 branch
BranchTrueFalseTotal
unless $autoinc_col 0 0 0
72 'empty insert only supported for tables with an autoincrement column'
73 ) unless $autoinc_col;
74  
75 0 my $table = $source->from;
76 0 ▶ $table = $$table if ref $table;
Branch: 1 branch
BranchTrueFalseTotal
if ref $table 0 0 0
77  
78 0 $to_insert->{$autoinc_col} = \"dmax('${autoinc_col}', '${table}')+1";
79 }
80  
81 0 return $self->next::method(@_);
82 }
83  
84 0 ▶sub bind_attribute_by_data_type {
Subroutine bind_attribute_by_data_type: not called CC=4 SCAR=30.0
Pod documented
85 0 my $self = shift;
86 0 my ($data_type) = @_;
87  
88 0 ▶ my $attributes = $self->next::method(@_) || {};
Condition0%0/2
$self->next::method(@_) || {}
l!l
00
MC/DC0%0/1
$self->next::method(@_) || {}
$self->next::method(@_)
Truth table0%0/2
A
A= $self->next::method(@_)
Aresult
11
00
89  
90 0 ▶ if ($self->_is_text_lob_type($data_type)) {
Branch: 2 branches
BranchTrueFalseTotal
if ($self->_is_text_lob_type($data_type)) { } 0 0 0
elsif ($self->_is_binary_lob_type($data_type)) { } 0 0 0
91 0 $attributes->{TYPE} = DBI::SQL_LONGVARCHAR;
92 }
93 elsif ($self->_is_binary_lob_type($data_type)) {
94 0 $attributes->{TYPE} = DBI::SQL_LONGVARBINARY;
95 }
96  
97 0 return $attributes;
98 }
99  
100 # savepoints are not supported, but nested transactions are.
101 # Unfortunately DBI does not support nested transactions.
102 # WARNING: this code uses the undocumented 'BegunWork' DBI attribute.
103  
104 0 ▶sub _exec_svp_begin {
Subroutine _exec_svp_begin: not called CC=1 SCAR=6.9
105 0 my ($self, $name) = @_;
106  
107 0 local $self->_dbh->{AutoCommit} = 1;
108 0 local $self->_dbh->{BegunWork} = 0;
109 0 $self->_exec_txn_begin;
110 }
111  
112 # A new nested transaction on the same level releases the previous one.
113 0 ▶sub _exec_svp_release { 1 }
Subroutine _exec_svp_release: not called CC=1 SCAR=6.9
114  
115 0 ▶sub _exec_svp_rollback {
Subroutine _exec_svp_rollback: not called CC=1 SCAR=6.9
116 0 my ($self, $name) = @_;
117  
118 0 local $self->_dbh->{AutoCommit} = 0;
119 0 local $self->_dbh->{BegunWork} = 1;
120 0 $self->_exec_txn_rollback;
121 }
122  
123 =head1 FURTHER QUESTIONS?
124  
125 Check the list of L<additional DBIC resources|DBIx::Class/GETTING HELP/SUPPORT>.
126  
127 =head1 COPYRIGHT AND LICENSE
128  
129 This module is free software L<copyright|DBIx::Class/COPYRIGHT AND LICENSE>
130 by the L<DBIx::Class (DBIC) authors|DBIx::Class/AUTHORS>. You can
131 redistribute it and/or modify it under the same terms as the
132 L<DBIx::Class library|DBIx::Class/COPYRIGHT AND LICENSE>.
133  
134 =cut
135  
136 4 1;
137  
138 # vim:sts=2 sw=2:
« DBIx/Class/Storage/DBI/InterBase.pm ↑ Summary DBIx/Class/Componentised.pm »