/[SQLSession]/trunk/share/web/templates/list
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/share/web/templates/list

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 28 by dpavlin, Thu Dec 7 19:56:41 2006 UTC revision 38 by dpavlin, Thu Jan 18 17:02:24 2007 UTC
# Line 1  Line 1 
1  <%init>  <%init>
2  my $queries = SQLSession::Model::QueryCollection->new();  my $queries = SQLSession::Model::QueryCollection->new();
3  $queries->unlimit();  
4    my $edit = Jifty->config->app('edit');
5    if ( $edit ) {
6            $queries->unlimit;
7    } else {
8            $queries->limit( column => 'visible', value => 1 );
9    }
10    $queries->order_by( column => 'name', order => 'asc' );
11    
12  </%init>  </%init>
13    
# Line 10  $queries->unlimit(); Line 17  $queries->unlimit();
17          <dt><% Jifty->web->tangent(          <dt><% Jifty->web->tangent(
18                  url => '/sql/' . $q->id,                  url => '/sql/' . $q->id,
19                  label => $q->name,                  label => $q->name,
20          ) %></dt>          ) %>
21    
22            <span class="database-name">on <% $q->on_database->name %>
23    % if ( $edit ) {
24            <tt>[<% $q->on_database->dsn %>]</tt>
25    % }
26            </span>
27    
28            </dt>
29          <dd>          <dd>
30          <pre class="sql"><% $q->sql_query %></pre>  % if ($q->note) {
31          <div class="sql-note"><% $q->note %></div>          <div class="sql-note"><% $q->note %></div>
32          <div class="database-name">on <% $q->on_database->name %> <tt>[<% $q->on_database->dsn %>]</tt></div>  % }
33            <pre class="sql"><% $q->sql_query %></pre>
34          </dd>          </dd>
35  % }  % }
36  </dl>  </dl>
37  </&>  </&>
38    
39    % if ( $edit ) {
40  <% Jifty->web->tangent( url => '/new', label => 'New SQL query' ) %>  <% Jifty->web->tangent( url => '/new', label => 'New SQL query' ) %>
41    % }
Legend:
Removed from v.28  
changed lines
  Added in v.38
  ViewVC Help
Powered by ViewVC 1.1.26