import datetime
import ya
from django.db import connection
from django.db.models import Q
from ya.models import Resource, Tag, Topic, Comment
## Get current tags
## ================
#
#cursor = connection.cursor()
#cursor.execute("SELECT DISTINCT(tag_id) FROM ya_topic_tags")
#topic_tag_ids = [r[0] for r in cursor.fetchall()]
#cursor.execute("SELECT DISTINCT(tag_id) FROM ya_resource_tags")
#resource_tag_ids = [r[0] for r in cursor.fetchall()]
#cursor.close()
#
#soup_tags = Tag.objects.filter(id__in=resource_tag_ids).order_by('name')
#talk_tags = Tag.objects.filter(id__in=topic_tag_ids).order_by('name')
# Get objects
# ===========
item_types = request.ya.item_types
querysets = []
for Item in item_types:
if request.ya.levels_all: # Don't filter by tag
querysets.append(Item.objects.all())
else:
for tag in request.ya.levels:
if Item is Comment:
querysets.append(Item.objects.filter(res__tags__name=tag))
querysets.append(Item.objects.filter(topic__tags__name=tag))
else:
querysets.append(Item.objects.filter(tags__name=tag))
items = ya.Items(request, *querysets)
{% extends "base.html" %}
{% block head %}{% endblock %}
{% block feedback %}{% endblock %}
{% block content %}
{% include "feedback.html" %}
We are the Anglican children, youth, and family ministry community.
We love Jesus, and we do theology, resourcing, and
training together. Here are our next big events:
Spring Summit, May 4-6, 2009 at Trinity School for Ministry,
Pittsburgh
Young Anglicans gathering at the Association of Marriage and
Family Ministries Conference, August 3-6, Phoenix, AZ