def fetchTodoTask(self, TaskMode = 'default', mark='doing', number=-1):
data = None
with TaskScheduler.mutex:
sql_fetch1 = "SELECT id,rogerTime FROM task_%s WHERE status='todo' order by rogerTime ASC, id ASC LIMIT %d"
sql_fetch2 = "UPDATE task_%s SET status='%s' WHERE id=?"
db = DbUtil()
data = db.execute(sql_fetch1 % (TaskMode, TaskScheduler.taskPerTime if number<0 else number))
if len(data) > 0:
ids = [(id,) for (id,rogerTime) in data]
db.executeMany(sql_fetch2 % (TaskMode , mark) , ids)
return data
def rogerTasks(self, ids, TaskMode = 'default'):
with TaskScheduler.mutex:
db = DbUtil()
sql_roger = "INSERT OR REPLACE INTO task_%s (id) VALUES (?)"
data = db.executeMany(sql_roger % TaskMode, ids)
return data
