The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

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