def getVideo(self, sea_id): """Retorna o video selecionado """ item = self.execSql("select_video", sea_id=int(sea_id)).next() portal = Portal(id_site=self.id_site, request=self.request) comm = portal._getComentarios(env_site=self.id_site, schema=self.schema, id_conteudo=item["id_conteudo"]) comm = [j for j in comm] item["comm"] = comm return {"item":item}
def getVideosSite(self, tags, limit=50, offset=0, serialize=None): """Retorna videos se tiverem alguma tag """ qtde = 0 items = 0 tags = tags.strip().split(" ") portal = Portal(id_site=self.id_site, request=self.request) if tags: has = False for tag in tags: has = True self.execSqlBatch("select_videos_count", tag=tag) if has: for i in self.execSqlUnion(): qtde += i["qtde"] for tag in tags: self.execSqlBatch("select_videos", tag=tag, limit=int(limit), offset=int(offset)) items = self.execSqlUnion(order="sea_id DESC", limit=int(limit), offset=int(offset)) copia = items if serialize: items = [i for i in items] for i in items: comm = portal._getComentarios(env_site=self.id_site, schema=self.schema, id_conteudo=i["id_conteudo"]) comm = [j for j in comm] i["comm"] = comm i["url"] = portal.getUrlByApp(env_site=self.id_site, schema=self.schema, id_conteudo=i["id_conteudo"], exportar=1, admin=1) return {"qtde":qtde, "items":items} return {"qtde":qtde, "items":items}