from datetime import datetime import json from operator import attrgetter from django.conf import settings from django.contrib.auth.models import User from django.db.models import Count, Q from django.http import Http404, HttpResponse, HttpResponseRedirect from django.shortcuts import render from django.views.decorators.cache import cache_control, cache_page from devel.models import MasterKey, PGPSignature from main.models import Arch, Repo, Donor from mirrors.models import MirrorUrl from news.models import News from releng.models import Release from .utils import get_recent_updates @cache_control(max_age=307) def index(request): if request.user.is_authenticated(): def updates(): return get_recent_updates(testing=True, staging=True) else: def updates(): return get_recent_updates() context = { 'news_updates': News.objects.order_by('-postdate', '-id')[:15], 'pkg_updates': updates, } return render(request, 'public/index.html', context) USER_LISTS = { 'hackers': { 'user_type': 'Hackers', 'user_title': 'Hacker', 'description': "This is a list of the current "+settings.BRANDING_SHORTNAME+" Hackers. They maintain the [libre] package repository and keep the [core], [extra] and [community] repositories clean of unfree software, in addition to doing any other developer duties.", }, 'fellows': { 'user_type': 'Fellows', 'user_title': 'Fellow', 'description': "Below you can find a list of ex-hackers (aka project fellows). These folks helped make "+settings.BRANDING_SHORTNAME+" what it is today. Thanks!", }, } @cache_control(max_age=307) def userlist(request, user_type='hackers'): users = User.objects.order_by( 'username').select_related('userprofile') if user_type == 'hackers': users = users.filter(is_active=True, groups__name="Hackers") elif user_type == 'fellows': users = users.filter(is_active=False, groups__name__in=["Hackers"]) else: raise Http404 users = users.distinct() context = USER_LISTS[user_type].copy() context['users'] = users return render(request, 'public/userlist.html', context) @cache_control(max_age=307) def donate(request): context = { 'donors': Donor.objects.filter(visible=True).order_by('name'), } return render(request, 'public/donate.html', context) def _mirror_urls(): '''In order to ensure this is lazily evaluated since we can't do sorting at the database level, make it a callable.''' urls = MirrorUrl.objects.select_related('mirror').filter( active=True, protocol__default=True, mirror__public=True, mirror__active=True, mirror__isos=True) sort_by = attrgetter('country.name', 'mirror.name') return sorted(urls, key=sort_by) @cache_control(max_age=307) def download(request): return HttpResponseRedirect('https://wiki.parabola.nu/Get_Parabola') @cache_control(max_age=307) def feeds(request): repos = Repo.objects.all() if not request.user.is_authenticated(): repos = repos.filter(staging=False) context = { 'arches': Arch.objects.all(), 'repos': repos, } return render(request, 'public/feeds.html', context) @cache_control(max_age=307) def keys(request): users = User.objects.filter(is_active=True).select_related( 'userprofile__pgp_key').order_by('first_name', 'last_name') user_key_ids = frozenset(user.userprofile.pgp_key[-16:] for user in users if user.userprofile.pgp_key) not_expired = Q(expires__gt=datetime.utcnow) | Q(expires__isnull=True) master_keys = MasterKey.objects.select_related('owner', 'revoker', 'owner__userprofile', 'revoker__userprofile').filter( revoked__isnull=True) sig_counts = PGPSignature.objects.filter(not_expired, revoked__isnull=True, signee__in=user_key_ids).order_by().values_list('signer').annotate( Count('signer')) sig_counts = {key_id[-16:]: ct for key_id, ct in sig_counts} for key in master_keys: key.signature_count = sig_counts.get(key.pgp_key[-16:], 0) # frozenset because we are going to do lots of __contains__ lookups signatures = frozenset(PGPSignature.objects.filter( not_expired, revoked__isnull=True).values_list('signer', 'signee')) restrict = Q(signer__in=user_key_ids) & Q(signee__in=user_key_ids) cross_signatures = PGPSignature.objects.filter(restrict, not_expired, revoked__isnull=True).order_by('created') context = { 'keys': master_keys, 'active_users': users, 'signatures': signatures, 'cross_signatures': cross_signatures, } return render(request, 'public/keys.html', context) @cache_page(1789) def keys_json(request): node_list = [] users = User.objects.filter(is_active=True).select_related('userprofile') node_list.extend({ 'name': dev.get_full_name(), 'key': dev.userprofile.pgp_key, 'group': 'dev' } for dev in users.filter(groups__name='Developers')) node_list.extend({ 'name': tu.get_full_name(), 'key': tu.userprofile.pgp_key, 'group': 'tu' } for tu in users.filter(groups__name='Trusted Users').exclude( groups__name='Developers')) master_keys = MasterKey.objects.select_related('owner').filter( revoked__isnull=True) node_list.extend({ 'name': 'Master Key (%s)' % key.owner.get_full_name(), 'key': key.pgp_key, 'group': 'master' } for key in master_keys) node_list.append({ 'name': 'CA Cert Signing Authority', 'key': 'A31D4F81EF4EBD07B456FA04D2BB0D0165D0FD58', 'group': 'cacert', }) not_expired = Q(expires__gt=datetime.utcnow) | Q(expires__isnull=True) signatures = PGPSignature.objects.filter(not_expired, revoked__isnull=True) edge_list = [{ 'signee': sig.signee, 'signer': sig.signer } for sig in signatures] data = { 'nodes': node_list, 'edges': edge_list } to_json = json.dumps(data, ensure_ascii=False) return HttpResponse(to_json, content_type='application/json') # vim: set ts=4 sw=4 et: