|
|
mojoPortal 2.2.7.9 (Default branch)
11-25-2008
mojoPortal is a cross-platform object oriented Web site framework. It supports PostgreSQL, MySQL, Firebird, SQLite and MS SQL for the backend. It includes a content management system, forums, blogs, photo galleries, newsletter, polls, surveys, an event calendar, an RSS feed aggregator, and a skinnable design.License: Common Public LicenseChanges:|
|
Jifty::DBI::Handle::SQLite(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::SQLite(3pm) 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.14.2 2010-09-21 Jifty::DBI::Handle::SQLite(3pm)