DOKK / manpages / debian 12 / libjifty-dbi-perl / Jifty::DBI::Handle::SQLite.3pm.en
Jifty::DBI::Handle::SQLite(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::SQLite(3pm)

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

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

Returns the version of the SQLite library which is used, e.g., "2.8.0". SQLite can only return short variant.

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.

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

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

rename column

Jesse Vincent, jesse@fsck.com

perl(1), Jifty::DBI

2022-06-15 perl v5.34.0