Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
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.24.1			  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.1-RELEASE+and+Ports>

home | help