X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=web_ui.pl;h=f449db53b70bb41fd6c55dc12701ef9f624e2fa6;hb=516c0e6f30c2fb9e16eada973a35a46d7000ee3a;hp=0331d68db4527ce54fc6591d1e23be4e21be543e;hpb=97ddc48b0c03c8dd57c1863b38f286879a428bcc;p=APKPM.git diff --git a/web_ui.pl b/web_ui.pl index 0331d68..f449db5 100755 --- a/web_ui.pl +++ b/web_ui.pl @@ -60,6 +60,18 @@ get '/g/:call/:args' => [ args => qr/.*/ ] => sub { _render_jsonp( $self, $ret ); }; +get '/table/:table' => sub { + my $self = shift; + my $sql = "select * from " . $self->param('table'); + if ( my $username = $self->param('username') ) { + $sql .= " where username = '$username' "; + } + $sql .= " limit " . ( $self->param('limit') || 1 ); + + my $ret = $gearman->req( 'SUBMIT_JOB', 'Store_sql', '', $sql ); + _render_jsonp( $self, $ret ); +}; + get '/_g/status' => sub { my $self = shift;