def create_example_data(): if not Cell.select(): user = User(name='Example User', login_name='user', password='******') batman = User(name='Batman', login_name='batman', password='******') user.save() batman.save() board1 = Board(name='First') board2 = Board(name='Second') board3 = Board(name='Third') batman1 = Board(name='Batmobil') batman2 = Board(name='BatBarlang') batman3 = Board(name='BatRobin') board1.save() board2.save() board3.save() batman1.save() batman2.save() batman3.save() Boardstable.create(board=board1, user=user) Boardstable.create(board=board2, user=user) Boardstable.create(board=board3, user=user) Boardstable.create(board=batman1, user=batman) Boardstable.create(board=batman2, user=batman) Boardstable.create(board=batman3, user=batman) Cell.create(text="Rocket", name="Weapon", order=1, board=board1, status=Status.get(Status.status == "new")) Cell.create(text="Pistol", name="Weapon", order=2, board=board1, status=Status.get(Status.status == "new")) Cell.create(text="Sword", name="Weapon", order=3, board=board1, status=Status.get(Status.status == "new")) Cell.create(text="Kalasnyikov", name="Weapon", order=1, board=board1, status=Status.get(Status.status == "progress")) Cell.create(text="Grenade", name="Weapon", order=1, board=board1, status=Status.get(Status.status == "done"))
def get(self, username): user = User.get_or_none(username=username) pagination = ap_pagination(self) if user: user = user.profile.get() # Retrive statuses objects = [] for k in TimelineManager(user).query(): try: objects.append( Status.get( Status.identifier == status).to_activitystream()) except: pass print(objects) # create collection page collectionPage = activities.OrderedCollectionPage( map(activities.Note, objects), **pagination) # create collection collection = activities.OrderedCollection([collectionPage]) self.write(json.dumps(collectionPage.to_json(context=True))) self.set_status(200)
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 on_get(self, req, resp): username = req.context['user'].username r = redis.StrictRedis(host='localhost', port=6379) local = req.get_param('local') or False max_id = req.get_param('max_id') or None since_id = req.get_param('since_id') or None limit = req.get_param('limit') or 40 statuses = [] for post in r.zrange('{}:hometimeline'.format(username), 0, min(limit - 1, 40), withscores=False): statuses.append(Status.get(id=post).to_json()) print(statuses) resp.body = json.dumps(statuses, default=str) resp.status = falcon.HTTP_200
def on_get(self, req, resp): user = req.context['user'] r = redis.StrictRedis(host=os.environ.get('REDIS_HOST', 'localhost')) local = req.get_param('local') or False max_id = req.get_param('max_id') or None since_id = req.get_param('since_id') or None limit = req.get_param('limit') or 20 statuses = [] errors = 0 for post in TimelineManager(user).query(since_id=since_id, max_id=max_id, local=True, limit=limit): try: statuses.append(Status.get(id=int(post)).to_json()) except: errors += 1 resp.body = json.dumps(statuses, default=str) resp.status = falcon.HTTP_200
def getById(id): k = db.Key.from_path('Status', int(id)) return Status.get(k)
async def delete_status(req, status_id): status = Status.get(id=status_id) status.delete() return json({})
async def update_status(req): status = Status.get(id=req.json.get("id")) status.title = req.json.get("title") status.text = req.json.get("text") status.save() return json({})