Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Compat(3)	      User Contributed Perl Documentation	     Compat(3)

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

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.

Keys that aren't needed	anymore
   Placeholders
       Gives information if and	how placeholders are supported:

       0 = Not supported
       1 = Supported, but not fully, unknown how much
       2 = Supported, but perl type must be the	same as	type in	db
       3 = Supported, but can not give a string	when a numeric type is in the
       db
       10 = 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

       DBD::mSQL
       DBD::mysql
       DBD::Pg
       DBD::Solid
       DBD::ODBC
       DBD::CSV
       DBD::Oracle
       DBD::Sysbase
       DBD::Informix
	   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! The	above document had some	coding errors, which are explained
       below:

       Around line 614:
	   '=item' outside of any '=over'

       Around line 636:
	   You forgot a	'=back'	before '=head1'

perl v5.32.0			  2003-12-27			     Compat(3)

NAME | SYNOPSIS | DESCRIPTION | Keys that aren't needed anymore | Supported Drivers | AUTHOR | SEE ALSO | POD ERRORS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DBIx::Compat&sektion=3&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help