NAME
Goo::LiteDatabase - Drive an SQLite database
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>