Shawn M Moore > Jifty-DBI-0.69 > Jifty::DBI::Handle::SQLite

Download:
Jifty-DBI-0.69.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  2
Open  0
Stalled  1
View/Report Bugs
Source   Latest Release: Jifty-DBI-0.77

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

syntax highlighting: