Template Profiles

• Templates let you de-couple advanced SQL from your code:

• my $profile = {

• “shipping_info” => {

• query => q{ SELECT order_no, name, phone

• FROM orders, customer

• WHERE orders.customer_no = customer.customer_no

• AND orders.shipped = 0

• AND orders.customer_no = ? },

• params => [ qw( customer_no ) ],

• }

• }

• my $DB = DBIx::SearchProfiles->new( $dbh, $profile );

• $DB->template_search( “shipping_info”, { customer_no => 122 } );

Notes: