Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Goo::Database(3)      User Contributed Perl Documentation     Goo::Database(3)

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
perl v5.32.0			  2005-12-02		      Goo::Database(3)

NAME | SYNOPSIS | DESCRIPTION | METHODS | AUTHOR | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Goo::Database&sektion=3&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help