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