get last cpe_ record from redis

diff --git a/web_ui.pl b/web_ui.pl
index 4dbef87..4ee747c 100755 (executable)
--- a/web_ui.pl
+++ b/web_ui.pl
@@ -77,13 +77,21 @@ get '/g/:call/:args' => [ args => qr/.*/ ] => sub {
 
 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 );
+       my $table = $self->param('table');
+       my $username = $self->param('username');
+       my $limit = $self->param('limit') || 1;
+
+       my $sql = "select * from $table";
+       $sql .= " where username = '$username'" if $username;
+       $sql .= " limit $limit";
+
+       my $ret;
+       if ( $limit == 1 ) {
+               $ret = $redis->get( "table.$table.$username" );
+       } else {
+               $ret = $gearman->req( 'SUBMIT_JOB', 'Store_sql', '', $sql );
+       }
        _render_jsonp( $self, $ret );
 };