dbix::searchbuilder::handle::sqlite(3pm) [debian man page]

DBIx::SearchBuilder::Handle::SQLite(3pm)		User Contributed Perl Documentation		  DBIx::SearchBuilder::Handle::SQLite(3pm)

NAME

	 DBIx::SearchBuilder::Handle::SQLite -- A SQLite specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of SQLite.

METHODS

   DatabaseVersion
       Returns the version of the SQLite library which is used, e.g., "2.8.0".	SQLite can only return short variant.

   Insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

       If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.

   CaseSensitive
       Returns undef, since SQLite's searches are not case sensitive by default

   DistinctCount STATEMENTREF
       takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result count

   SimpleDateTimeFunctions
       Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       perl(1), DBIx::SearchBuilder

perl v5.14.2							    2011-09-21				  DBIx::SearchBuilder::Handle::SQLite(3pm)

DBIx::SearchBuilder::Handle::mysql(3pm) 		User Contributed Perl Documentation		   DBIx::SearchBuilder::Handle::mysql(3pm)

NAME

	 DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of MySQL.

METHODS

   Insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

       If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.

   SimpleUpdateFromSelect
       Customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle.  Mysql doesn't support update with subqueries when those fetch
       data from the table that is updated.

   DatabaseVersion
       Returns the mysql version, trimming off any -foo identifier

   CaseSensitive
       Returns undef, since mysql's searches are not case sensitive by default

   SimpleDateTimeFunctions
       Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.

   ConvertTimezoneFunction
       Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.

       Use the following query to get list of timezones:

	   SELECT Name FROM mysql.time_zone_name;

       Read docs about keeping timezone data up to date:

	   http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       DBIx::SearchBuilder, DBIx::SearchBuilder::Handle

perl v5.14.2							    2011-09-21				   DBIx::SearchBuilder::Handle::mysql(3pm)