def most_relevant(request):
session = Session()
timer = datetime.now()
join = sa_post.join(sa_relvote, onclause=(sa_relvote.c.post_id==sa_post.c.id))
sel = select([sa_post.c.id, func.count(sa_relvote.c.id).label("votes")], whereclause=sa_relvote.c.date_expire > datetime.now(),
from_obj=[join]).group_by(sa_post.c.id).order_by("votes DESC")
ps = session.execute(sel).fetchall()
print ps
delta = datetime.now() - timer
print delta
if not ps:
messages.info(request, "This site has nothing relevant green vote on something")
try:
_id = ps[0][0]
post = Post.objects.get(pk=_id)
except:
post = Post.objects.get(pk=1)
temp_args = {'post' : post}
children = list(Post.objects.filter(parent=post)\
.annotate(num_votes=Count('vote'))\
.order_by('-num_votes'))
temp_args['p_struct'] = children
temp_args['prof_user'] = request.user
Session.remove()
return render_to_response("most_relevant.html",
temp_args,
RequestContext(request))
def most_relevant(request):
session = Session()
timer = datetime.now()
join = sa_post.join(sa_relvote,
onclause=(sa_relvote.c.post_id == sa_post.c.id))
sel = select([sa_post.c.id,
func.count(sa_relvote.c.id).label("votes")],
whereclause=sa_relvote.c.date_expire > datetime.now(),
from_obj=[join]).group_by(sa_post.c.id).order_by("votes DESC")
ps = session.execute(sel).fetchall()
print ps
delta = datetime.now() - timer
print delta
if not ps:
messages.info(
request, "This site has nothing relevant green vote on something")
try:
_id = ps[0][0]
post = Post.objects.get(pk=_id)
except:
post = Post.objects.get(pk=1)
temp_args = {'post': post}
children = list(Post.objects.filter(parent=post)\
.annotate(num_votes=Count('vote'))\
.order_by('-num_votes'))
temp_args['p_struct'] = children
temp_args['prof_user'] = request.user
Session.remove()
return render_to_response("most_relevant.html", temp_args,
RequestContext(request))
def home(request):
#posts = models.Post.objects.filter(parent=None).all()
posts = view_funcs.preload_front()
temp_args = {'posts': posts}
#MAKE VIDSET
Session.remove()
if request.user.is_authenticated():
vset, rset = view_funcs.make_vid_sets(request.user.id)
temp_args['vset'] = vset
temp_args['rset'] = rset
return render_to_response("home.html", temp_args, RequestContext(request))
def home(request):
#posts = models.Post.objects.filter(parent=None).all()
posts = view_funcs.preload_front()
temp_args = {'posts' : posts}
#MAKE VIDSET
Session.remove()
if request.user.is_authenticated():
vset, rset = view_funcs.make_vid_sets(request.user.id)
temp_args['vset'] = vset
temp_args['rset'] = rset
return render_to_response("home.html",
temp_args,
RequestContext(request))
