DBI::DBD::SqlEngine(3pm)

1DBI::DBD::SqlEngine(3)User Contributed Perl DocumentationDBI::DBD::SqlEngine(3)
2
3
4
5    if ( $attrib =~ m/^NAME(?:|_lc|_uc)$/ )
6    {
7        my @cn = $sth->sql_get_colnames();
8        return [ $attrib eq "NAME_lc" ? map { lc $_ } @cn
9               : $attrib eq "NAME_uc" ? map { uc $_ } @cn
10               : @cn ];
11    }
12

NAME

14       DBI::DBD::SqlEngine - Base class for DBI drivers without their own SQL
15       engine
16

SYNOPSIS

18           package DBD::myDriver;
19
20           use base qw(DBI::DBD::SqlEngine);
21
22           sub driver
23           {
24               ...
25               my $drh = $proto->SUPER::driver($attr);
26               ...
27               return $drh->{class};
28               }
29
30           package DBD::myDriver::dr;
31
32           @ISA = qw(DBI::DBD::SqlEngine::dr);
33
34           sub data_sources { ... }
35           ...
36
37           package DBD::myDriver::db;
38
39           @ISA = qw(DBI::DBD::SqlEngine::db);
40
41           sub init_valid_attributes { ... }
42           sub init_default_attributes { ... }
43           sub set_versions { ... }
44           sub validate_STORE_attr { my ($dbh, $attrib, $value) = @_; ... }
45           sub validate_FETCH_attr { my ($dbh, $attrib) = @_; ... }
46           sub get_myd_versions { ... }
47           sub get_avail_tables { ... }
48
49           package DBD::myDriver::st;
50
51           @ISA = qw(DBI::DBD::SqlEngine::st);
52
53           sub FETCH { ... }
54           sub STORE { ... }
55
56           package DBD::myDriver::Statement;
57
58           @ISA = qw(DBI::DBD::SqlEngine::Statement);
59
60           sub open_table { ... }
61
62           package DBD::myDriver::Table;
63
64           @ISA = qw(DBI::DBD::SqlEngine::Table);
65
66           sub new { ... }
67

DESCRIPTION

69       DBI::DBD::SqlEngine abstracts the usage of SQL engines from the DBD.
70       DBD authors can concentrate on the data retrieval they want to provide.
71
72       It is strongly recommended that you read DBD::File::Developers and
73       DBD::File::Roadmap, because many of the DBD::File API is provided by
74       DBI::DBD::SqlEngine.
75
76       Currently the API of DBI::DBD::SqlEngine is experimental and will
77       likely change in the near future to provide the table meta data basics
78       like DBD::File.
79

SUPPORT

81       You can find documentation for this module with the perldoc command.
82
83           perldoc DBI::DBD::SqlEngine
84
85       You can also look for information at:
86
87       ·   RT: CPAN's request tracker
88
89           <http://rt.cpan.org/NoAuth/Bugs.html?Dist=DBI>
90           http://rt.cpan.org/NoAuth/Bugs.html?Dist=SQL-Statement
91           <http://rt.cpan.org/NoAuth/Bugs.html?Dist=SQL-Statement>
92
93       ·   AnnoCPAN: Annotated CPAN documentation
94
95           <http://annocpan.org/dist/DBI>
96           http://annocpan.org/dist/SQL-Statement
97           <http://annocpan.org/dist/SQL-Statement>
98
99       ·   CPAN Ratings
100
101           <http://cpanratings.perl.org/d/DBI>
102
103       ·   Search CPAN
104
105           <http://search.cpan.org/dist/DBI/>
106
107   Where can I go for more help?
108       For questions about installation or usage, please ask on the
109       dbi-dev@perl.org mailing list.
110
111       If you have a bug report, patch or suggestion, please open a new report
112       ticket on CPAN, if there is not already one for the issue you want to
113       report. Of course, you can mail any of the module maintainers, but it
114       is less likely to be missed if it is reported on RT.
115
116       Report tickets should contain a detailed description of the bug or
117       enhancement request you want to report and at least an easy way to
118       verify/reproduce the issue and any supplied fix. Patches are always
119       welcome, too.
120

ACKNOWLEDGEMENTS

122       Thanks to Tim Bunce, Martin Evans and H.Merijn Brand for their
123       continued support while developing DBD::File, DBD::DBM and
124       DBD::AnyData.  Their support, hints and feedback helped to design and
125       implement this module.
126

AUTHOR

128       This module is currently maintained by
129
130       H.Merijn Brand < h.m.brand at xs4all.nl > and Jens Rehsack  < rehsack
131       at googlemail.com >
132
133       The original authors are Jochen Wiedmann and Jeff Zucker.
134

COPYRIGHT AND LICENSE

136        Copyright (C) 2009-2010 by H.Merijn Brand & Jens Rehsack
137        Copyright (C) 2004-2009 by Jeff Zucker
138        Copyright (C) 1998-2004 by Jochen Wiedmann
139
140       All rights reserved.
141
142       You may freely distribute and/or modify this module under the terms of
143       either the GNU General Public License (GPL) or the Artistic License, as
144       specified in the Perl README file.
145