测试开发进阶(三十九)

statistics = {    'projects_count': projects_count,    'interfaces_count': interfaces_count,    'testcases_count': testcases_count,    'testsuits_count': testsuits_count,    'configures_count': configures_count,    'envs_count': envs_count,    'debug_talks_count': debug_talks_count,    'reports_count': reports_count,    'success_rate': success_rate,    'fail_rate': fail_rate,}

permission_classes = [permissions.IsAuthenticated]

from rest_framework.views import APIViewfrom rest_framework.response import Responsefrom rest_framework import permissionsfrom django.db.models import Sumfrom projects.models import Projectsfrom interfaces.models import Interfacesfrom testcases.models import Testcasesfrom testsuits.models import Testsuitsfrom configures.models import Configuresfrom envs.models import Envsfrom debugtalks.models import DebugTalksfrom reports.models import Reportsclass SummaryAPIView(APIView):    """    返回统计信息    """    permission_classes = [permissions.IsAuthenticated]    def get(self, request):        """        获取统计信息        """        user = request.user        user_info = {            'username': user.username,            'role': '管理员' if user.is_superuser else '普通用户',            'date_joined': user.date_joined.strftime('%Y-%m-%d %H:%M:%S') if user.date_joined else '',            'last_login': user.last_login.strftime('%Y-%m-%d %H:%M:%S') if user.last_login else '',        }        projects_count = Projects.objects.filter(is_delete=False).count()        interfaces_count = Interfaces.objects.filter(is_delete=False).count()        testcases_count = Testcases.objects.filter(is_delete=False).count()        testsuits_count = Testsuits.objects.filter(is_delete=False).count()        configures_count = Configures.objects.filter(is_delete=False).count()        envs_count = Envs.objects.filter(is_delete=False).count()        debug_talks_count = DebugTalks.objects.filter(is_delete=False).count()        reports_count = Reports.objects.filter(is_delete=False).count()        run_testcases_success_count = Reports.objects.filter(is_delete=False).aggregate(Sum('success'))[                                          'success__sum'] or 0        run_testcases_total_count = Reports.objects.filter(is_delete=False).aggregate(Sum('count'))['count__sum'] or 0        if run_testcases_total_count:            success_rate = int((run_testcases_success_count / run_testcases_total_count) * 100)            fail_rate = 100 - success_rate        else:            success_rate = 0            fail_rate = 0        statistics = {            'projects_count': projects_count,            'interfaces_count': interfaces_count,            'testcases_count': testcases_count,            'testsuits_count': testsuits_count,            'configures_count': configures_count,            'envs_count': envs_count,            'debug_talks_count': debug_talks_count,            'reports_count': reports_count,            'success_rate': success_rate,            'fail_rate': fail_rate,        }        return Response(data={            'user': user_info,            'statistics': statistics        })

$ head -n13 xxx | tail -n4

Name Age Scorea 25 90b 26 91c 27 92d 28 93

$ cut -d" " -f1 learn_cut.txt

# 以:分割的第三列的数值大小排列$ sort -t":" -k3 -n /etc/passwd

$ username="89"$ username=a b # 错误$ username="a b" #正确

$ p=python$ u='I love $p'$ echo $u$ i="I love $p"$ echo $i

$ o=$(ls)$ p=`ls`

$ env

$ echo $USER

#!/bin/bashecho "参数的总个数:$#"echo "脚本名为:$0"echo "第二个参数:$2"echo "第十个参数:${10}"echo "获取所有参数:$*"