#python #sql #django #python-db-api
Вопрос:
Просто новичок в программировании на python, Django SQL, и попробуйте создать базу данных, проверьте ее с помощью Postman и SQLLiteStudio! Использование Django для создания БД и python (3.9.6).Когда я запускаю метод УДАЛЕНИЯ, в postman возвращается ошибка 500 без выполнения УДАЛЕНИЯ. {В моем cmd я не вижу никакой ошибки msg}
Число просмотров:
from django.shortcuts import render
from django.views.decorators.csrf import csrf_exempt
from rest_framework.parsers import JSONParser
from django.http.response import JsonResponse
from EmployeeApp.models import Departments,Employees
from EmployeeApp.serializers import DepartmentSerializer,EmployeeSerializer
# Create your views here.
@csrf_exempt
def departmentApi(request,id=0):
if request.method=='GET':
departments = Departments.objects.all()
departments_serializer = DepartmentSerializer(departments, many=True)
return JsonResponse(departments_serializer.data, safe=False)
elif request.method=='POST':
department_data=JSONParser().parse(request)
department_serializer = DepartmentSerializer(data=department_data)
if department_serializer.is_valid():
department_serializer.save()
return JsonResponse("Added Successfully!!" , safe=False)
return JsonResponse("Failed to Add.",safe=False)
elif request.method=='PUT':
department_data = JSONParser().parse(request)
department=Departments.objects.get(DepartmentId=department_data['DepartmentId'])
department_serializer=DepartmentSerializer(department,data=department_data)
if department_serializer.is_valid():
department_serializer.save()
return JsonResponse("Updated Successfully!!", safe=False)
return JsonResponse("Failed to Update.", safe=False)
elif request.method=='DELETE':
department=Departments.objects.get(DepartmentId=id)
department.delete()
return JsonResponse("Deleted Succeffully!!", safe=False)
Модели:
from Django.DB import models
class Departments(models.Model):
DepartmentId = models.AutoField(primary_key=True)
DepartmentName = models.CharField(max_length=100)
class Employees(models.Model):
EmployeeId = models.AutoField(primary_key=True)
EmployeeName = models.CharField(max_length=100)
Department = models.CharField(max_length=100)
DateOfJoining = models.DateField()
PhotoFileName = models.CharField(max_length=100)
Сериализаторы:
from rest_framework import serializers
from EmployeeApp.models import Departments, Employees
class DepartmentSerializer(serializers.ModelSerializer):
class Meta:
model=Departments
fields=('DepartmentId','DepartmentName')
class EmployeeSerializer(serializers.ModelSerializer):
class Meta:
model=Employees
fields=('EmployeeId',
'EmployeeName',
'Department',
'DateOfJoining',
'PhotofileName') ```
Комментарии:
1. вот так много для этого