def index(request):
if request.user:
groups = request.user.groups
else:
groups = ['everyone']
boards = Board.objects(read_groups__in=groups)
cat_ids = [c.id for c in boards.distinct('category')]
categories = Category.objects(id__in=cat_ids).order_by('order')
return dict(categories=categories)
def import_categories():
c = conn.cursor()
sql = """
SELECT
ID_CAT
,name
,catOrder
FROM
smf_categories;"""
c.execute(sql)
for row in c.fetchall():
cat = Category()
cat.name = row[1]
cat.order = row[2]
cat.save()
categories[row[0]] = cat
c.close()
