GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  DBIX::COMPAT (3)

.ds Aq ’

NAME

DBIx::Compat - Perl extension for Compatibility Infos about DBD Drivers

CONTENTS

SYNOPSIS



  use DBIx::Compat;

  my $HaveTypes  = DBIx::Compat::GetItem ($drv, HaveTypes) ;



DESCRIPTION

DBIx::Compat contains a hash which gives information about DBD drivers, to allow to write driver independent programs.

Currently there are the following attributes defined:

ListFields

A function which will return information about all fields of an table. Needs an database handle and a tablename as argument. Must at least return the fieldnames and the fieldtypes.



 Example:
 
  $ListFields = $DBIx::Compat::Compat{$Driver}{ListFields} ;
  $sth = &{$ListFields}($DBHandle, $Table) or die "Cannot list fields" ;
   
  @{ $sth -> {NAME} } ; # array of fieldnames
  @{ $sth -> {TYPE} } ; # array of filedtypes

  $sth -> finish ;



ListTables

A function which will return an array of all tables of the datasource. Defaults to $dbh -> tables.

NumericTypes

Hash which contains one entry for all datatypes that are numeric.

SupportJoin

Set to true if the DBMS supports joins (select with multiple tables)

SupportSQLJoin

Set to 1 if the DBMS supports INNER/LEFT/RIGHT JOIN Syntax in SQL select. Set to 2 if DBMS needs a *= b syntax for inner join (MS-SQL, Sybase). Set to 3 if DBMS needs a = b (+) syntax for inner join (Oracle syntax).

SQLJoinOnly2Tabs

Set to true if DBMS can only support two tables in inner joins.

HaveTypes

Set to true if DBMS supports datatypes (most DBMS will do)

NeedNullInCreate

Set to NULL if DBMS requires the NULL keyword when creating tables where fields should contains nulls.

EmptyIsNull

Set to true if an empty string (’’) and NULL is the same for the DBMS.

LimitOffset

An function which will be used to create a SQL text for limiting the number of fetched rows and selecting the starting row in selects.

<B>Keys that aren’t needed anymoreB>

Placeholders

Gives information if and how placeholders are supported:
<B>0B> = Not supported
<B>1B> = Supported, but not fully, unknown how much
<B>2B> = Supported, but perl type must be the same as type in db
<B>3B> = Supported, but can not give a string when a numeric type is in the db
<B>10B> = Supported under all circumstances

QuoteTypes

Gives information which datatypes must be quoted when passed literal (not via a placeholder). Contains a hash with all type number which need to be quoted.



  $DBIx::Compat::Compat{$Driver}{QuoteTypes}{$Type}



will be true when the type in $Type for the driver $Driver must be quoted.

Supported Drivers

Currently there are entry for
<B>DBD::mSQLB>
<B>DBD::mysqlB>
<B>DBD::PgB>
<B>DBD::SolidB>
<B>DBD::ODBCB>
<B>DBD::CSVB>
<B>DBD::OracleB>
<B>DBD::SysbaseB>
<B>DBD::InformixB> if you detect an error in the definition or add an definition for a new DBD driver, please mail it to the author.

AUTHOR

G.Richter <richter*dev.ecos.de>

SEE ALSO

perl(1), DBI(3), DBIx::Recordset(3)

POD ERRORS

Hey! <B>The above document had some coding errors, which are explained below:B>
Around line 614: ’=item’ outside of any ’=over’
Around line 636: You forgot a ’=back’ before ’=head1’
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 COMPAT (3) 2003-12-27

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.