blib/lib/DBIx/Class/Schema/Loader/DBI/ADO/MS_Jet.pm untested

filter: Statementstmt 0.0% 0 / 113 Branchbran 0.0% 0 / 44 Conditioncond 0.0% 0 / 15 MC/DCmcdc 0.0% 0 / 10 Subroutinesub 0.0% 0 / 10 Podpod 0.0% 0 / 3 totaltotal 0.0% 0 / 195 CC 23 SCAR 48.4
CC
23
Cov
0%
_columns_info_for
210.0
_ado_connection
110.0
_db_path
2.0
CRAP 126.8
1 package DBIx::Class::Schema::Loader::DBI::ADO::MS_Jet;
2  
3 use strict;
4 use warnings;
5 use base qw/
6 DBIx::Class::Schema::Loader::DBI::ADO
7 DBIx::Class::Schema::Loader::DBI::ODBC::ACCESS
8 /;
9 use mro 'c3';
10 use Try::Tiny;
11 use namespace::clean;
12  
13 our $VERSION = '0.07053';
14  
15 =head1 NAME
16  
17 DBIx::Class::Schema::Loader::DBI::ADO::MS_Jet - ADO wrapper for
18 L<DBIx::Class::Schema::Loader::DBI::ODBC::ACCESS>
19  
20 =head1 DESCRIPTION
21  
22 Proxy for L<DBIx::Class::Schema::Loader::DBI::ODBC::ACCESS> when using
23 L<DBD::ADO>.
24  
25 See L<DBIx::Class::Schema::Loader::Base> for usage information.
26  
27 =cut
28  
29 sub _db_path {
30 my $self = shift;
31  
32 $self->schema->storage->dbh->get_info(2);
33 }
34  
35 sub _ado_connection {
36 my $self = shift;
37  
38 return $self->__ado_connection if $self->__ado_connection;
39  
40 my ($dsn, $user, $pass) = @{ $self->schema->storage->_dbi_connect_info };
41  
42 my $have_pass = 1;
43  
44 if (ref $dsn eq 'CODE') {
45 ($dsn, $user, $pass) = $self->_try_infer_connect_info_from_coderef($dsn);
46  
47 if (not $dsn) {
48 my $dbh = $self->schema->storage->dbh;
49 $dsn = $dbh->{Name};
50 $user = $dbh->{Username};
51 $have_pass = 0;
52 }
53 }
54  
55 require Win32::OLE;
56 my $conn = Win32::OLE->new('ADODB.Connection');
57  
58 $dsn =~ s/^dbi:[^:]+://i;
59  
60 local $Win32::OLE::Warn = 0;
61  
62 my @dsn;
63 for my $s (split /;/, $dsn) {
64 my ($k, $v) = split /=/, $s, 2;
65 if (defined $conn->{$k}) {
66 $conn->{$k} = $v;
67 next;
68 }
69 push @dsn, $s;
70 }
71  
72 $dsn = join ';', @dsn;
73  
74 $user = '' unless defined $user;
75  
76 if ((not $have_pass) && exists $self->_passwords->{$dsn}{$user}) {
77 $pass = $self->_passwords->{$dsn}{$user};
78 $have_pass = 1;
79 }
80 $pass = '' unless defined $pass;
81  
82 try {
83 $conn->Open($dsn, $user, $pass);
84 }
85 catch {
86 if (not $have_pass) {
87 if (exists $ENV{DBI_PASS}) {
88 $pass = $ENV{DBI_PASS};
89 try {
90 $conn->Open($dsn, $user, $pass);
91 $self->_passwords->{$dsn}{$user} = $pass;
92 }
93 catch {
94 print "Enter database password for $user ($dsn): ";
95 chomp($pass = <STDIN>);
96 $conn->Open($dsn, $user, $pass);
97 $self->_passwords->{$dsn}{$user} = $pass;
98 };
99 }
100 else {
101 print "Enter database password for $user ($dsn): ";
102 chomp($pass = <STDIN>);
103 $conn->Open($dsn, $user, $pass);
104 $self->_passwords->{$dsn}{$user} = $pass;
105 }
106 }
107 else {
108 die $_;
109 }
110 };
111  
112 $self->__ado_connection($conn);
113  
114 return $conn;
115 }
116  
117 sub _columns_info_for {
118 my $self = shift;
119 my ($table) = @_;
120  
121 my $result = $self->next::method(@_);
122  
123 while (my ($col, $info) = each %$result) {
124 my $data_type = $info->{data_type};
125  
126 my $col_obj = $self->_adox_column($table, $col);
127  
128 if ($data_type eq 'long') {
129 $info->{data_type} = 'integer';
130 delete $info->{size};
131  
132 my $props = $col_obj->Properties;
133 for my $prop_idx (0..$props->Count-1) {
134 my $prop = $props->Item($prop_idx);
135 if ($prop->Name eq 'Autoincrement' && $prop->Value == 1) {
136 $info->{is_auto_increment} = 1;
137 last;
138 }
139 }
140 }
141 elsif ($data_type eq 'short') {
142 $info->{data_type} = 'smallint';
143 delete $info->{size};
144 }
145 elsif ($data_type eq 'single') {
146 $info->{data_type} = 'real';
147 delete $info->{size};
148 }
149 elsif ($data_type eq 'money') {
150 if (ref $info->{size} eq 'ARRAY') {
151 if ($info->{size}[0] == 19 && $info->{size}[1] == 255) {
152 delete $info->{size};
153 }
154 else {
155 # it's really a decimal
156 $info->{data_type} = 'decimal';
157  
158 if ($info->{size}[0] == 18 && $info->{size}[1] == 0) {
159 # default size
160 delete $info->{size};
161 }
162 delete $info->{original};
163 }
164 }
165 }
166 elsif ($data_type eq 'varchar') {
167 $info->{data_type} = 'char' if $col_obj->Type == 130;
168 $info->{size} = $col_obj->DefinedSize;
169 }
170 elsif ($data_type eq 'bigbinary') {
171 $info->{data_type} = 'varbinary';
172  
173 my $props = $col_obj->Properties;
174 for my $prop_idx (0..$props->Count-1) {
175 my $prop = $props->Item($prop_idx);
176 if ($prop->Name eq 'Fixed Length' && $prop->Value == 1) {
177 $info->{data_type} = 'binary';
178 last;
179 }
180 }
181  
182 $info->{size} = $col_obj->DefinedSize;
183 }
184 elsif ($data_type eq 'longtext') {
185 $info->{data_type} = 'text';
186 $info->{original}{data_type} = 'longchar';
187 delete $info->{size};
188 }
189 }
190  
191 return $result;
192 }
193  
194 =head1 SEE ALSO
195  
196 L<DBIx::Class::Schema::Loader::DBI::ODBC::ACCESS>,
197 L<DBIx::Class::Schema::Loader::DBI::ADO>,
198 L<DBIx::Class::Schema::Loader>, L<DBIx::Class::Schema::Loader::Base>,
199 L<DBIx::Class::Schema::Loader::DBI>
200  
201 =head1 AUTHORS
202  
203 See L<DBIx::Class::Schema::Loader/AUTHORS>.
204  
205 =head1 LICENSE
206  
207 This library is free software; you can redistribute it and/or modify it under
208 the same terms as Perl itself.
209  
210 =cut
211  
212 1;
213 # vim:et sts=4 sw=4 tw=0: