Annotation of /trunk/share/web/templates/sql

<%args>
$sth => undef

$sql_query => undef
$name => undef
$database => undef

</%args>
<%init>

my $action = Jifty->web->new_action(
        class => 'DoSQL',
        moniker => 'execute_sql',
);

my $result = Jifty->web->response->result('execute_sql');
$sth = $result->content('sth') if $result and !defined $sth;

</%init>

<&| /_elements/wrapper, title => "Try out SQL query" &>
<% Jifty->web->form->start() %>
<% $action->form_field('sql_query',
        default_value => $sql_query,
) %>
<% $action->form_field('database',
        default_value => $database,
) %>
<div class="submit_button">
<% $action->button( label => 'Try it!' ) %>


% if ( defined($sth) ) {

<% Jifty->web->link(
        label => 'Save',
        onclick => {
                region => 'save_query',
                prepend => '/save',
                args => {
                        sql_query => $action->argument_value('sql_query'),
                        database => $action->argument_value('database'),
                },
                refresh_self => 1,
                toggle => 1,
        },
#       as_button => 1,
) %>

</div>
<% Jifty->web->form->end() %>

<% Jifty->web->region(
        name => 'save_query',
) %>

</div>

<table cellpadding="3" cellspacing="0" border="1">

<tr>
% foreach my $col ( @{ $sth->{'NAME'} } ) {
<th><% $col %></th>
% }
</tr>

% while ( my @row = $sth->fetchrow_array() ) {
<tr>
%       foreach my $v ( @row ) {
<td><% defined($v) ? $v : 'NULL' %></td>
%       }
</tr>
% }

</table>

% } else {

</div><!-- submit_button -->
<% Jifty->web->form->end() %>

% }

<% Jifty->web->return( label => "Go back" ) %>

</&>

1	dpavlin	9	<%args>
2			$sth => undef
3	dpavlin	20
4	dpavlin	21	$sql_query => undef
5			$name => undef
6			$database => undef
7	dpavlin	20
8	dpavlin	9	</%args>
9			<%init>
10
11			my $action = Jifty->web->new_action(
12			class => 'DoSQL',
13			moniker => 'execute_sql',
14			);
15
16			my $result = Jifty->web->response->result('execute_sql');
17			$sth = $result->content('sth') if $result and !defined $sth;
18
19			</%init>
20
21			<&\| /_elements/wrapper, title => "Try out SQL query" &>
22			<% Jifty->web->form->start() %>
23	dpavlin	20	<% $action->form_field('sql_query',
24			default_value => $sql_query,
25			) %>
26			<% $action->form_field('database',
27	dpavlin	21	default_value => $database,
28	dpavlin	20	) %>
29			<div class="submit_button">
30			<% $action->button( label => 'Try it!' ) %>
31	dpavlin	9
32	dpavlin	21
33	dpavlin	10	% if ( defined($sth) ) {
34
35	dpavlin	21	<% Jifty->web->link(
36			label => 'Save',
37			onclick => {
38			region => 'save_query',
39			prepend => '/save',
40			args => {
41			sql_query => $action->argument_value('sql_query'),
42			database => $action->argument_value('database'),
43			},
44			refresh_self => 1,
45			toggle => 1,
46			},
47			# as_button => 1,
48			) %>
49	dpavlin	20
50	dpavlin	21	</div>
51			<% Jifty->web->form->end() %>
52	dpavlin	20
53	dpavlin	21	<% Jifty->web->region(
54			name => 'save_query',
55			) %>
56
57	dpavlin	20	</div>
58
59	dpavlin	9	<table cellpadding="3" cellspacing="0" border="1">
60
61			<tr>
62			% foreach my $col ( @{ $sth->{'NAME'} } ) {
63			<th><% $col %></th>
64			% }
65			</tr>
66
67			% while ( my @row = $sth->fetchrow_array() ) {
68			<tr>
69			% foreach my $v ( @row ) {
70	dpavlin	12	<td><% defined($v) ? $v : 'NULL' %></td>
71	dpavlin	9	% }
72			</tr>
73			% }
74
75			</table>
76	dpavlin	10
77	dpavlin	21	% } else {
78
79			</div><!-- submit_button -->
80			<% Jifty->web->form->end() %>
81
82	dpavlin	20	% }
83	dpavlin	14
84	dpavlin	20	<% Jifty->web->return( label => "Go back" ) %>
85	dpavlin	14
86			</&>
87