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}
