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

FreeBSD Manual Pages

  
 
  

home | help
ResourcePool::Command:User:Contributed PeResourcePool::Command::DBI::Select(3)

NAME
       ResourcePool::Command::DBI::Select - A DBI command to exexcute select
       statements.

SYNOPSIS
	use ResourcePool::Command::DBI::Select;

	# simple usage
	my $cmd	= ResourcePool::Command::DBI::Select->new();
	eval {
	       my $sth = $pool->execute($cmd
		       , 'select id, name, value from test where id > ?'
		       , 5
	       );
	       while ($sth->fetch()) {
	       }
	       $sth->finish(); # don't forget!!
	};

DESCRIPTION
       This command can	be used	to execute select statements in	a DBI database
       using the ResourcePool command execution	environment.

       In order	to understand this Class, and more importantly this document,
       you need	to know	a few terms I use in this document, if you are new to
       this class you should read the TERMS sections first.

       Before using this class,	look if	one of the similar classes like
       SelectRow can help you. For some	databases/driver it is possible	that
       the use of this class is	not safe, becaus it makes it possible to open
       more than one cursor with one database handle. You have also to finish
       the DBI statementhandle yourself.

       There will be more advanced specaliced Commands available to select
       from a database.

   ResourcePool::Command::DBI::Select->new
       Instantiates a new Select object. The parameters	are (nearly) identical
       to those	of the Execute method, the only	difference is that it make no
       sense to	specify	output parameters (max_len).

   $pool->execute
       Similar to the same named method	of the Execute() class.	The only
       difference is that it returns a DBI sth (statement handle) which	can be
       used to retreive	the data. You have to finish this sth manually when
       done.

TODO
       Documentation
	   Year, we really need	documentation.

SEE ALSO
       DBI, ResourcePool, ResourcePool::Factory

AUTHOR
	   Copyright (C) 2001-2004 by Markus Winand <mws@fatalmind.com>

	   This	program	is free	software; you can redistribute it and/or
	   modify it under the same terms as Perl itself.

perl v5.32.0			  2004-05ResourcePool::Command::DBI::Select(3)

NAME | SYNOPSIS | DESCRIPTION | TODO | SEE ALSO | AUTHOR

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

home | help