FreeBSD Manual Pages
Jifty::DBI::Handle::SQUser(Contributed Perl DocumJifty::DBI::Handle::SQLite(3) 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 perl v5.32.0 2014-05-29 Jifty::DBI::Handle::SQLite(3)
NAME | SYNOPSIS | DESCRIPTION | METHODS | AUTHOR | SEE ALSO
Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Jifty::DBI::Handle::SQLite&sektion=3&manpath=FreeBSD+12.2-RELEASE+and+Ports>