The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

Goo::Database - Interface to a MySQL database via DBI

SYNOPSIS

use Goo::Database;

DESCRIPTION

Simple interface to DBI.

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 query handle

bind_param

bind a parameter to a value

prepare_sql

take a string and prepare the SQL

show_sql

display the SQL statement useful for debugging

execute_sql

take a string, execute the SQL return a hash of column headings and values

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

get_date

return the date and time according to the database

AUTHOR

Nigel Hamilton <nigel@trexy.com>

SEE ALSO