Jifty::DBI::Handle::SQLite(3pm)

Jifty::DBI::Handle::SQLite3pm

Overview

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

Releases

9 releases since Debian 5.0 (Lenny); the text changed 5 times.

  1. 5.0
  2. 6.0
  3. 7
  4. 8
  5. 9–11
  6. 12–13

Author

Jesse Vincent, [email protected]

From libjifty-dbi-perl 0.78-3 in Debian 13 (Trixie). Parsed by carta from the page's man source.