GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  JIFTY::DBI::HANDLE::SQLITE (3)

.ds Aq ’

NAME



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



CONTENTS

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 => CW$table, column => CW$old_column, to => CW$new_column )

rename column

AUTHOR

Jesse Vincent, jesse@fsck.com

SEE ALSO

perl(1), Jifty::DBI
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 JIFTY::DBI::HANDLE::SQLITE (3) 2014-05-29

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.