def rearrange_same_statused_cells(newid, oldid, id_in_db):
moved_cell = Cell.get(Cell.id == id_in_db)
if newid > oldid:
cells = Cell.select().where((Cell.order > oldid)
& (Cell.order <= newid)
& (Cell.board == moved_cell.board))
for cell in cells:
cell.order -= 1
cell.save()
else:
cells = Cell.select().where((Cell.order < oldid)
& (Cell.order >= newid)
& (Cell.status == moved_cell.status)
& (Cell.board == moved_cell.board))
for cell in cells:
cell.order += 1
cell.save()
moved_cell.order = newid
moved_cell.save()
def rearrange_different_statused_cells(newid, oldid, oldstatus, newstatus,
id_in_db):
moved_cell = Cell.get(Cell.id == id_in_db)
# newStatused rearrange
cells = Cell.select().where((Cell.status == Status.get(
Status.status == newstatus)) & (Cell.board == moved_cell.board)
& (Cell.order >= newid))
for cell in cells:
cell.order += 1
cell.save()
# oldStatus rearrange
cells = Cell.select().where((Cell.status == Status.get(
Status.status == oldstatus)) & (Cell.board == moved_cell.board)
& (Cell.order > oldid))
for cell in cells:
cell.order -= 1
cell.save()
moved_cell.order = newid
moved_cell.status = Status.get(Status.status == newstatus)
moved_cell.save()
def get_cell_text():
cell_id = request.form["cell_id"]
cell = Cell.get(Cell.id == cell_id)
return cell.text
