/[SQLSession]/trunk/share/web/templates/sql
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/sql

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

trunk/share/web/templates/sql.html revision 20 by dpavlin, Sun Dec 3 18:03:30 2006 UTC trunk/share/web/templates/sql revision 52 by dpavlin, Sun Jan 21 13:37:17 2007 UTC
# Line 1  Line 1 
1  <%args>  <%args>
2  $sth => undef  $sth => undef
3    
4  $sql_query  $sql_query => undef
5  $name  $name => undef
6  $database  $database => undef
7    
8    $max_rows => 100
9    
10  </%args>  </%args>
11  <%init>  <%init>
12    
13  my $action = Jifty->web->new_action(  my $execute_sql = Jifty->web->new_action(
14          class => 'DoSQL',          class => 'DoSQL',
15          moniker => 'execute_sql',          moniker => 'execute_sql',
16  );  );
# Line 16  my $action = Jifty->web->new_action( Line 18  my $action = Jifty->web->new_action(
18  my $result = Jifty->web->response->result('execute_sql');  my $result = Jifty->web->response->result('execute_sql');
19  $sth = $result->content('sth') if $result and !defined $sth;  $sth = $result->content('sth') if $result and !defined $sth;
20    
21    my $edit = Jifty->web->current_user->role('edit');
22    warn $edit ? 'edit mode for SQL' : 'student mode';
23    
24  </%init>  </%init>
25    
26  <&| /_elements/wrapper, title => "Try out SQL query" &>  <&| /_elements/wrapper, title => "Try out SQL query" &>
27  <% Jifty->web->form->start() %>  <% Jifty->web->form->start() %>
28  <% $action->form_field('sql_query',  <% $execute_sql->form_field('sql_query',
29          default_value => $sql_query,          default_value => $sql_query,
30            cols => 80,
31            rows => 12,
32  ) %>  ) %>
33  <% $action->form_field('database',  % if ( $edit ) {
34          default_value => $database->id,  <% $execute_sql->form_field('database', default_value => $database ) %>
35  ) %>  % } else {
36    
37    <!-- hidden database -->
38    <% $execute_sql->hidden('database', $database ) %>
39    <% $execute_sql->form_value('database', default_value => $database ) %>
40    
41    % }
42  <div class="submit_button">  <div class="submit_button">
43  <% $action->button( label => 'Try it!' ) %>  <% $execute_sql->button( label => 'Try it!' ) %>
44  </div>  
45    
46  % if ( defined($sth) ) {  % if ( defined($sth) ) {
47    
48  <%perl>  % if ( $edit ) {
 my $save = Jifty->web->new_action(  
         class => 'CreateQuery',  
         arguments => {  
                 sql_query => $action->form_field('sql_query'),  
                 on_database => $action->form_field('database'),  
         }  
 );  
49    
50  </%perl>  % warn "save SQL: ", $execute_sql->argument_value('sql_query');
51    
52  <% $save->form_field('name') %>  <% Jifty->web->link(
53  <div class="submit_button">          label => 'Save',
54  <% $save->button( label => 'Save' ) %>          onclick => {
55  </div>                  region => 'save_query',
56                    replace_with => '/save',
57                    args => {
58                            sql_query => $execute_sql->argument_value('sql_query'),
59                            database => $execute_sql->argument_value('database'),
60                    },
61                    refresh_self => 1,
62                    toggle => 1,
63            },
64            as_button => 1,
65    ) %>
66    
67    </div><!-- submit_button edit -->
68    
69    <% Jifty->web->region(
70            name => 'save_query',
71    ) %>
72    
73    % } else {
74    
75    </div><!-- submit_button no edit -->
76    
77    % }
78    
79    <% Jifty->web->form->end() %>
80    
81  <table cellpadding="3" cellspacing="0" border="1">  <table cellpadding="3" cellspacing="0" border="1">
82    
# Line 56  my $save = Jifty->web->new_action( Line 86  my $save = Jifty->web->new_action(
86  % }  % }
87  </tr>  </tr>
88    
89    % my $rows = 0;
90  % while ( my @row = $sth->fetchrow_array() ) {  % while ( my @row = $sth->fetchrow_array() ) {
91    %       last if (++$rows > $max_rows);
92  <tr>  <tr>
93  %       foreach my $v ( @row ) {  %       foreach my $v ( @row ) {
94  <td><% defined($v) ? $v : 'NULL' %></td>  <td><% defined($v) ? $v : 'NULL' %></td>
# Line 66  my $save = Jifty->web->new_action( Line 98  my $save = Jifty->web->new_action(
98    
99  </table>  </table>
100    
101    % if ($sth->rows > $max_rows) {
102    <div class="note">
103    Query produced more than <% $max_rows %> rows, try adding <tt>LIMIT</tt> and
104    <tt>OFFSET</tt> to see another part of results.
105    </div>
106  % }  % }
107    
108  <% Jifty->web->return( label => "Go back" ) %>  % } else {
109    
110    </div><!-- submit_button no query -->
111  <% Jifty->web->form->end() %>  <% Jifty->web->form->end() %>
112    
113    % }
114    
115    <% Jifty->web->return( label => "Go back" ) %>
116    
117  </&>  </&>
118    
Legend:
Removed from v.20  
changed lines
  Added in v.52
  ViewVC Help
Powered by ViewVC 1.1.26