NAME

Goo::LiteDatabase - Drive an SQLite database

SYNOPSIS

use Goo::LiteDatabase;

Interface to an SQLite database.

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

Nigel Hamilton <nigel@trexy.com>