def cancel_job(request):
"""
Cancel the given job
json body: { id: Object id, t_id: tool id }
"""
try:
data = json.loads(request.body)
oid = data.get('id', data.get('oid', data.get('_id')))
t_id = int(data.get('t_id', 0))
if oid is not None:
search = {"_id": ObjectId(oid)}
elif t_id != 0:
search = {"job.t_id": t_id}
else:
return jsonResponse({
"success":
False,
"error":
"Cannot find job, please give either an id or a t_id"
})
search.update({"job": {"$exists": True}})
job = db.jobs.find_one(search, {"job": True})
worksheet = get_scheduler_sheet()
if not job:
return jsonResponse({"success": False, "error": "Cannot find job"})
elif 'sheet_row' in job['job']: # We know the exact row number
worksheet.update_acell("J" + str(job['job']['sheet_row']),
"Cancel")
else:
full = worksheet.get_all_records()
if t_id == 0:
t_id = job['job'].get('t_id', 0)
if t_id == 0:
return jsonResponse({"success": False, "error": "Need t_id"})
t_id = str(t_id)
for record in full:
if t_id == str(record['ID']):
row = full.index(record) + 2
worksheet.update_acell("J" + str(row), "Cancel")
break
db.jobs.update_one({"_id": job['_id']},
{"$set": {
"job.status": "Cancel"
}})
return basic_success
except Exception, e:
return basic_error(e)
def cancel_job(request):
"""
Cancel the given job
json body: { id: Object id, t_id: tool id }
"""
try:
data = json.loads(request.body)
oid = data.get('id', data.get('oid', data.get('_id')))
t_id = int(data.get('t_id', 0))
if oid is not None:
search = {"_id": ObjectId(oid)}
elif t_id != 0:
search = {"job.t_id": t_id}
else:
return jsonResponse({"success": False, "error": "Cannot find job, please give either an id or a t_id"})
search.update({"job": {"$exists": True}})
job = db.jobs.find_one(search, {"job": True})
worksheet = get_scheduler_sheet()
if not job:
return jsonResponse({"success": False, "error": "Cannot find job"})
elif 'sheet_row' in job['job']: # We know the exact row number
worksheet.update_acell("J" + str(job['job']['sheet_row']), "Cancel")
else:
full = worksheet.get_all_records()
if t_id == 0:
t_id = job['job'].get('t_id', 0)
if t_id == 0:
return jsonResponse({"success": False, "error": "Need t_id"})
t_id = str(t_id)
for record in full:
if t_id == str(record['ID']):
row = full.index(record) + 2
worksheet.update_acell("J" + str(row), "Cancel")
break
db.jobs.update_one({"_id": job['_id']}, {"$set": {"job.status": "Cancel"}})
return basic_success
except Exception, e:
return basic_error(e)
def formPost(request):
"""
Form submission api
"""
try:
data = json.loads(request.body)
# Do processing here
campaign = data['campaign_config']
date = campaign['date']
time = datetime.strptime(campaign['time'], "%H:%M")
hour = time.hour
minute = time.minute
english = campaign['text']['english']
arabic = campaign['text']['arabic']
if len(english.strip()) == 0:
english = '_'
if len(arabic.strip()) == 0:
arabic = '_'
data['timestamp'] = datetime.now()
result = db.queries.insert_one(data)
url = 'http://45.55.72.208/wadi/query?id='+str(result.inserted_id)
row = ['Once', 'external', date, hour, minute, english, arabic, url]
if 'debug' in data and data['debug'] is True:
db.queries.remove({"_id": result.inserted_id})
return jsonResponse({'success': True, 'data_received': data, 'row created': row})
else:
wrk_sheet = get_scheduler_sheet()
size = len(wrk_sheet.get_all_values())
wrk_sheet.insert_row(row, size+1)
return jsonResponse({'success': True})
except Exception, e:
return basic_error(e)
