An Introduction to Class::DBI - First Example 19

Scalability - DBI

  • With DBI alone, more code means setting up more queries

    
            my $find_winner  = $DBH->prepare(<<EOQ);
                SELECT film_id
                FROM   nominations
                WHERE  takes_the_oscar = 1
                AND    year = ?
                AND    type = ?
    
            $find_winner->execute(1965, 'Best Editing');
            my ($film) = $find_winner->fetchrow_array;
    
    

 

YAPC::Canada << Previous | Index | Next >>
Copyright © 2003 Michael Graham