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

revision 28 by dpavlin, Thu Dec 7 19:51:05 2006 UTC revision 29 by dpavlin, Thu Dec 7 22:13:56 2006 UTC
# Line 18  my $execute_sql = Jifty->web->new_action Line 18  my $execute_sql = 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->config->app('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  <% $execute_sql->form_field('sql_query',  <% $execute_sql->form_field('sql_query',
29          default_value => $sql_query,          default_value => $sql_query,
30  #       cols => 80,          cols => 80,
31  #       rows => 5,          rows => 5,
 ) %>  
 <% $execute_sql->form_field('database',  
         default_value => $database,  
32  ) %>  ) %>
33    % if ( $edit ) {
34    <% $execute_sql->form_field('database', default_value => $database ) %>
35    % } else {
36    
37    <!-- hidden database -->
38    <% $execute_sql->hidden('database', $database ) %>
39    
40    % }
41  <div class="submit_button">  <div class="submit_button">
42  <% $execute_sql->button( label => 'Try it!' ) %>  <% $execute_sql->button( label => 'Try it!' ) %>
43    
44    
45  % if ( defined($sth) ) {  % if ( defined($sth) ) {
46    
47    % if ( $edit ) {
48    
49  % warn "save SQL: ", $execute_sql->argument_value('sql_query');  % warn "save SQL: ", $execute_sql->argument_value('sql_query');
50    
51  <% Jifty->web->link(  <% Jifty->web->link(
# Line 53  $sth = $result->content('sth') if $resul Line 63  $sth = $result->content('sth') if $resul
63          as_button => 1,          as_button => 1,
64  ) %>  ) %>
65    
66  </div>  </div><!-- submit_button edit -->
 <% Jifty->web->form->end() %>  
67    
68  <% Jifty->web->region(  <% Jifty->web->region(
69          name => 'save_query',          name => 'save_query',
70  ) %>  ) %>
71    
72  </div>  % } else {
73    
74    </div><!-- submit_button no edit -->
75    
76    % }
77    
78    <% Jifty->web->form->end() %>
79    
80  <table cellpadding="3" cellspacing="0" border="1">  <table cellpadding="3" cellspacing="0" border="1">
81    
# Line 91  Query produced more than <% $max_rows %> Line 106  Query produced more than <% $max_rows %>
106    
107  % } else {  % } else {
108    
109  </div><!-- submit_button -->  </div><!-- submit_button no query -->
110  <% Jifty->web->form->end() %>  <% Jifty->web->form->end() %>
111    
112  % }  % }
Legend:
Removed from v.28  
changed lines
  Added in v.29
  ViewVC Help
Powered by ViewVC 1.1.26