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 );
};