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()