Re: DBD::mysql and mysql_use_result

On Fri, Aug 06, 2004 at 01:38:48PM +0100, Alan Burlison wrote:
> I want to use the DBD::mysql 'mysql_use_result' attribute to make the 
> driver use mysql_use_result instead of mysql_store_result, and I want to 
> do it for all the queries I'm submitting against the database.  Having 
> to set it on each and every statement handle that I generate is a real 
> pain, I'd like to be able to set the default on the database handle and 
> have it inherited by all the statement handles that are generated from 
> the database handle.
> 
> I'm not sure of the best way to go about this, there are two options:
> 
> 1. Store the value in the DBH and copy into the STH when the STH is 
> created, unless the STD constructor is given an explicit value.
> 
> 2. Store the value in the DBH and each time the STH is executed, look up 
> the value in the parent DBH if the STH doesn't have an explicit value.


It was already implemented in my tree with the same behaviour as for 
'mysql_server_prepare' attribute:

 - attribute 'mysql_use_result' on dbh level, this allows to
   enable/disable mode for all new statements:

     - DBI->connect("DBI:mysql:test;mysql_use_result=1", "root", "");

     - $dbh->{'mysql_use_result'}=0; #disable
       $dbh->{'mysql_use_result'}=1; #enable

     When new sth is created we set default value of attribute 
     'mysql_use_result' from $dbh. One can override the default 
     value:
    
     - $sth=$dbh->prepare(statement, {'mysql_use_result' => 1});

     - $sth->{'mysql_use_result'}=0; #disable
       $sth->{'mysql_use_result'}=1; #enable


-- 
Mr. Alexey Stroganov
Full-Time Benchmarks Developer
MySQL AB, www.mysql.com