Annotation of /trunk/share/web/templates/list

<%init>
my $queries = SQLSession::Model::QueryCollection->new();
$queries->limit( column => 'visible', value => 1 );
$queries->order_by( column => 'name', order => 'asc' );

</%init>

<&| /_elements/wrapper, title => "Available queries" &>
<dl>
% while (my $q = $queries->next) {
        <dt><% Jifty->web->tangent(
                url => '/sql/' . $q->id,
                label => $q->name,
        ) %></dt>
        <dd>
% if ($q->note) {
        <div class="sql-note"><% $q->note %></div>
% }
        <pre class="sql"><% $q->sql_query %></pre>
        <div class="database-name">on <% $q->on_database->name %> <tt>[<% $q->on_database->dsn %>]</tt></div>
        </dd>
% }
</dl>
</&>

<% Jifty->web->tangent( url => '/new', label => 'New SQL query' ) %>
1	dpavlin	18	<%init>
2			my $queries = SQLSession::Model::QueryCollection->new();
3	dpavlin	31	$queries->limit( column => 'visible', value => 1 );
4	dpavlin	29	$queries->order_by( column => 'name', order => 'asc' );
5	dpavlin	18
6			</%init>
7
8			<&\| /_elements/wrapper, title => "Available queries" &>
9			<dl>
10			% while (my $q = $queries->next) {
11	dpavlin	20	<dt><% Jifty->web->tangent(
12			url => '/sql/' . $q->id,
13			label => $q->name,
14			) %></dt>
15	dpavlin	18	<dd>
16	dpavlin	29	% if ($q->note) {
17			<div class="sql-note"><% $q->note %></div>
18			% }
19	dpavlin	28	<pre class="sql"><% $q->sql_query %></pre>
20			<div class="database-name">on <% $q->on_database->name %> <tt>[<% $q->on_database->dsn %>]</tt></div>
21	dpavlin	18	</dd>
22			% }
23			</dl>
24			</&>
25	dpavlin	21
26			<% Jifty->web->tangent( url => '/new', label => 'New SQL query' ) %>