logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

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

Author

       Jesse Vincent, jesse@fsck.com

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_countSTATEMENTREF
       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

Name

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

See Also

perl(1), Jifty::DBI

perl v5.34.0                                       2022-06-15                    Jifty::DBI::Handle::SQLite(3pm)

Synopsis

See Also