/[scire]/branches/new-fu/server/scireserver.pl
Gentoo

Diff of /branches/new-fu/server/scireserver.pl

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

Revision 290 Revision 291
182 182
183} 183}
184 184
185 185
186sub get_jobs { 186sub get_jobs {
187 my $query = <<' EndOfQuery' 187 my $query = <<'EndOfQuery';
188 SELECT jobs.jobid 188 SELECT jobs.jobid
189 FROM jobs NATURAL JOIN jobs_clients NATURAL JOIN job_conditions NATURAL JOIN job_history 189 FROM jobs NATURAL JOIN jobs_clients NATURAL JOIN job_conditions NATURAL JOIN job_history
190 WHERE jobs_clients.clientid = ? 190 WHERE jobs_clients.clientid = ?
191 AND jobs.jobid = jobs_clients.jobid 191 AND jobs.jobid = jobs_clients.jobid
192 AND (job_conditions.deploy_time < now()) 192 AND (job_conditions.deploy_time < now())
193 AND (job_conditions.expiration_time > now()) 193 AND (job_conditions.expiration_time > now())
194 AND job_history.statusid = '?' 194 AND job_history.statusid = '?'
195 ORDER BY jobs.priority,jobs.created 195 ORDER BY jobs.priority,jobs.created
196 EndOfQuery 196EndOfQuery
197 197
198 debug("Query is $query"); 198 debug("Query is $query");
199 #$sth = $dbh->prepare($query); 199 #$sth = $dbh->prepare($query);
200 #$sth->execute($client_id,$status_id); 200 #$sth->execute($client_id,$status_id);
201 #my $jobs_ref = $sth->fetchall_arrayref(); 201 #my $jobs_ref = $sth->fetchall_arrayref();

Legend:
Removed from v.290  
changed lines
  Added in v.291

  ViewVC Help
Powered by ViewVC 1.1.20