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  -  GOO::LITEDATABASE (3)

.ds Aq ’

NAME

Goo::LiteDatabase - Drive an SQLite database

CONTENTS

SYNOPSIS

use Goo::LiteDatabase;

DESCRIPTION

Interface to an SQLite database.

METHODS

get_connection open a connection to the default database
do_sql execute some SQL
do_query execute SQL and return the result all in one
generate_numeric_sqlin_clause return an SQL ’in’ clause with numeric values
generate_string_sqlin_clause return an SQL ’in’ clause with string values
get_number_of_rows return the number of rows for this statement handle
get_next_row alias for get_result_hash
get_result_hash return a hash for this result
bind_param bind a parameter to a value
show_sql display SQL statement useful for debugging
execute_sql take a string and execute the SQL return a hash of column headings and values
prepare_sql take a string and prepare the SQL for later execution
execute execute prepared statement
get_max return the maximum value of a database column
get_last_max return the latest increment for this database handle
count_rows_in_table check if a value exists in a given column and table
exists_in_table check if a value exists in a given column and table
get_row return a row based on a key
get_count return a simple row in the table
delete_row delete a row based on a key
quote quote a value for insertion into the database
handle_error handle any error thrown by the dbi subsystem
get_primary_key return the primary key for a table
get_table_columns return a list of column names for the table

AUTHOR

Nigel Hamilton <nigel@trexy.com>

SEE ALSO

Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 GOO::LITEDATABASE (3) 2005-11-30

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