Jifty::DBI::Handle::SQLite(3pm) 			User Contributed Perl Documentation			   Jifty::DBI::Handle::SQLite(3pm)

NAME

	 Jifty::DBI::Handle::SQLite -- A SQLite specific Handle object

SYNOPSIS

DESCRIPTION

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

METHODS

   database_version
       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.

   case_sensitive
       Returns 1, since SQLite's searches are case sensitive by default.  Note, however, SQLite's "like" operator is case insensitive.

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

   rename_column ( table => $table, column => $old_column, to => $new_column )
       rename column

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       perl(1), Jifty::DBI

perl v5.14.2							    2010-09-21					   Jifty::DBI::Handle::SQLite(3pm)