def update_data(): result = request.get_json() newid = result["newid"] oldid = result["oldid"] newstatus = result["newstatus"] oldstatus = result["oldstatus"] if (newid != oldid): query = Cell.update(order=newid, status=newstatus).where( Cell.order == oldid and Cell.status == oldstatus) query.execute() query = Cell.update(order=oldid, status=newid).where(Cell.order == newid and Cell.status == newstatus) query.execute()
def update_cell_text(): id = request.form["id_in_db"] text = request.form["cell_text"] query = Cell.update(text=text).where(Cell.id == id) query.execute() return "ok"