Help-Site Computer Manuals
Software
Hardware
Programming
Networking
  Algorithms & Data Structures   Programming Languages   Revision Control
  Protocols
  Cameras   Computers   Displays   Keyboards & Mice   Motherboards   Networking   Printers & Scanners   Storage
  Windows   Linux & Unix   Mac

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

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


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


AUTHOR

Jesse Vincent, jesse@fsck.com


SEE ALSO

perl(1), Jifty::DBI

Programminig
Wy
Wy
yW
Wy
Programming
Wy
Wy
Wy
Wy