自学python(8)：Postman发布会签到系统接口测试

配置接口路径

# 打开.../ex_sign/urls.py文件，添加接口根路径“/api/”
    #------- api -------写法
    url(r'^api/', include(('sign.urls', "api"), namespace="sign")),

# 打开 .../sign/urls.py 文件，配置具体接口的二级目录。
urlpatterns = [
    url(r'^add_event/', views_if.add_event, name='add_event'),
    url(r'^add_guest/', views_if.add_guest, name='add_guest'),
    url(r'^get_event_list/', views_if.get_event_list, name='get_event_list'),
    url(r'^get_guest_list/', views_if.get_guest_list, name='get_guest_list'),
    url(r'^user_sign/', views_if.user_sign, name='user_sign'),
    
]

添加接口
打开 .../sign/views_if.py文件，开发接口

from django.http import JsonResponse
from sign.models import Event, Guest
from django.core.exceptions import ValidationError, ObjectDoesNotExist
from django.db.utils import IntegrityError
import time

# 添加发布会接口
def add_event(request):
    eid = request.POST.get('eid', '')
    name = request.POST.get('name', '')
    limit = request.POST.get('limit', '')
    status = request.POST.get('status', '')
    address = request.POST.get('address', '')
    start_time = request.POST.get('start_time', '')

    if eid == '' or name == '' or limit == '' or address == '' or start_time == '':
        return JsonResponse({'status':10021, 'message':'paramer error'})
    result = Event.objects.filter(id = eid)
    if result:
        return JsonResponse({'status':10022, 'message':'event id already exists'})
    result = Event.objects.filter(name = name)
    if result:
        return JsonResponse({'status':10023, 'message':'event name already exists'})
    if status == '':
        status = 1
    
    try:
        Event.objects.create(id=eid, name=name, limit=limit, address=address, status=int(status), start_time=start_time)
    except ValidationError as e:
        error = 'start_time format error.Ite must be in YYYY-MM-DD HH:MM:SS format.'
        return JsonResponse({'status':10024, 'message':error})
    return JsonResponse({'status':200, 'message':'add event success'})

# 查询发布会接口
def get_event_list(request):
    eid = request.GET.get("eid", "")
    name = request.GET.get("name", "")

    if eid == '' and name == '':
        return JsonResponse({'status':10021, 'message':'parameter error'})
    if eid != '':
        event = {}
        try:
            result = Event.objects.get(id = eid)
        except ObjectDoesNotExist:
            return JsonResponse({'status':10022, 'message':'query result is empty'})
        else:
            event['name'] = result.name
            event['limit'] = result.limit
            event['status'] = result.status
            event['address'] = result.address
            event['start_time'] = result.start_time
            return JsonResponse({'status':200, 'message':'sucess', 'data': event})
    
    if name != '':
        datas = []
        results = Event.objects.filter(name__contains=name)
        if results:
            for r in results:
                event = {}
                event['name'] = r.name
                event['limit'] = r.limit
                event['status'] = r.status
                event['address'] = r.address
                event['start_time'] = r.start_time
                datas.append(event)
            return JsonResponse({'status':200, 'message':'success', 'data':datas})
        else:
            return JsonResponse({'status':10022, 'message':'query result is empty'})

# 添加嘉宾接口
def add_guest(request):
    eid = request.POST.get('eid', '')
    realname = request.POST.get('realname', '')
    phone = request.POST.get('phone', '')
    email = request.POST.get('email', '')

    if eid == '' or realname == '' or phone == '':
        return JsonResponse({'status':10021, 'message':'parameter error'})
    result = Event.objects.filter(id=eid)
    if not result:
        return JsonResponse({'status':10022, 'message':'event id null'})
    result = Event.objects.get(id=eid).status
    if not result:
        return JsonResponse({'stauts':10023, 'message':'event status is not available'})
    event_limit = Event.objects.get(id=eid).limit
    guest_limit = Guest.objects.filter(event_id=eid)

    if len(guest_limit) >= event_limit:
        return JsonResponse({'status':10024, 'message':'event number is full'})
    event_time = Event.objects.get(id=eid).start_time
    etime = str(event_time).split(".")[0]
    timeArray = time.strptime(etime.split("+")[0], "%Y-%m-%d %H:%M:%S")
    print('ffffffffffffffffffffffffffffffffffffffffff')
    print(timeArray)
    print('ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff')
    e_time = int(time.mktime(timeArray))

    now_time = str(time.time())
    ntime = now_time.split(".")[0]
    n_time = int(ntime)
    if n_time >= e_time:
        return JsonResponse({'status': 10025, 'message':'event has started'})

    try:
        Guest.objects.create(realname=realname, phone=int(phone), email=email, sign=0, event_id=int(eid))
    except IntegrityError:
        return JsonResponse({'status':10026, 'message': 'the event guest phone number repeat'})
    return JsonResponse({'status': 200, 'message': 'add guest success'})

# 嘉宾查询接口
def get_guest_list(request):
    eid = request.GET.get("eid", "")
    phone = request.GET.get("phone", "")
    if eid == '':
        return JsonResponse({'status': 10021, 'message':'eid cannnot be empty'})
    if eid != '' and phone == '':
        datas = []
        results = Guest.objects.filter(event_id=eid)
        if results:
            for r in results:
                guest = {}
                guest['realname'] = r.realname
                guest['phone'] = r.phone
                guest['email'] = r.email
                guest['sign'] = r.sign
                datas.append(guest)
            return JsonResponse({'status':200, 'message':'success', 'data':datas})
        if eid != '' and phone != '':
            guest={}
            try:
                result = Guest.objects.get(phone=phone, event_id=eid)
            except ObjectDoesNotExist:
                return JsonResponse({'status': 10022, 'message':'query result is empty'})
        else:
            guest['realname'] = result.realname
            guest['phone'] = result.phone
            guest['email'] = result.email
            guest['sign'] = result.sign
            return JsonResponse({'status':200, 'message':'success', 'data':guest})

# 嘉宾签到接口
def user_sign(request):
    eid = request.POST.get('eid', '')
    phone = request.POST.get('phone', '')

    if eid == '' or phone == '':
        return JsonResponse({'status':10021, 'message':'parameter error'})
    
    result = Event.objects.filter(id=eid)
    if not result:
        return JsonResponse({'status':10022, 'message':'event id null'})
    result = Event.objects.get(id=eid).status
    if not result:
        return JsonResponse({'status':10023, 'message':'event status is not available'})
    event_time = Event.objects.get(id=eid).start_time
    etime = str(event_time).split(".")[0]
    timeArray = time.strptime(etime.split("+")[0], "%Y-%m-%d %H:%M:%S")
    e_time = int(time.mktime(timeArray))

    now_time = str(time.time())
    ntime = now_time.split(".")[0]
    n_time = int(ntime)

    if n_time>=e_time:
        return JsonResponse({'status':10024, 'message':'event has started'})
    
    result = Guest.objects.filter(phone=phone)
    if not result:
        return JsonResponse({'status':10025, 'message':'user phone null'})
    
    result  = Guest.objects.filter(event_id=eid, phone=phone)
    if not result:
        return JsonResponse({'status':10026,'message':'user did not participate in the conference'})
    
    result = Guest.objects.get(event_id=eid, phone=phone).sign
    if result:
        return JsonResponse({'status':10027, 'message':'user has sign in'})
    else:
        Guest.objects.filter(event_id=eid, phone=phone).update(sign='1')
        return JsonResponse({'status':200, 'message':'sign success'})

PostMan 测试

PostMan 测试界面