/[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

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