Cdbi and Template Toolkit

From ClassDBI

Jump to: navigation, search

It is possible to call Class::DBI directly from a Template Toolkit plugin: 

 [%
    USE contact  = Class('app::cdbi::contact');
    list_contact = contact.retrieve_all();
 %]
 
 <table>
 [% FOREACH row IN list_contact %]
 <tr>
   <th>...</th>
   <td>...</td>
 </tr>
 [% END %]
 </table>


In most cases you'll probably use search_where() instead of retrieve_all(): 

 [%
    USE contact  = Class('app::cdbi::contact');
    list_contact = contact.search_where(...);
 %]
 
 <table>
 [% FOREACH row IN list_contact %]
 <tr>
   <th>...</th>
   <td>...</td>
 </tr>
 [% END %]
 </table>


You would probably be happier using an iterator rather than a list as this example shows.

TO-DO - show the code using iterator

Retrieved from "http://cdbi.dcmanaged.com/wiki/Cdbi_and_Template_Toolkit"
Personal tools