From 7dd31740831b6cab0596c36b53575c66b01e8b03 Mon Sep 17 00:00:00 2001
From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Mon, 11 Jul 2011 18:41:07 +0200
Subject: [PATCH] get last cpe_ record from redis

---
 web_ui.pl | 20 ++++++++++++++------
 1 file changed, 14 insertions(+), 6 deletions(-)

diff --git a/web_ui.pl b/web_ui.pl
index 4dbef87..4ee747c 100755
--- 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 );
 };
 
-- 
2.20.1