Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- cursor.execute(
- "SELECT * FROM {jobs} WHERE {jobs}.status = 'open' AND NOT EXISTS ("
- "SELECT job_id FROM {jobmeta} WHERE {jobmeta}.job_id = {jobs}.id AND {jobmeta}.meta_key = 'pj_locked_by' AND {jobmeta}.meta_value IN ("
- "SELECT ID FROM {jobs} WHERE {jobs}.status != 'closed'"
- ")) ORDER BY {jobs}.ID ASC LIMIT 1;".format( jobs=config.DB_TABLE_JOBS, jobmeta=config.DB_TABLE_JOBMETA )
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement