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
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 undef, since SQLite's searches are not case sensitive by default
distinct_count STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result count
_build_joins
Adjusts syntax of join queries for SQLite.
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
perl(1), Jifty::DBI