在django中在一些项目中,在前期的数据库操作敏捷开发情景下,使用免参数可以节省许多开发时间。具体代码如下:
增:
class 增方法(BaseView):
def post(self, request, *args, **kwargs):
try:
data = json.loads(request.body.decode('utf-8'))
# 移除'id'字段
data.pop('id', None)
filtered_data = {key: value for key, value in data.items() if value is not ""}
# 检查是否所有参数都为空
if not filtered_data:
raise ValueError("参数不能为空")
mymodel = 数据库Model(**filtered_data)
mymodel.save(using='数据库名称')
response_data = {'result': 'success'}
except Exception as e:
response_data = {'result': 'error', 'message': str(e)}
return JsonResponse(response_data)
删:
class 删方法(LoginRequiredMixin, BaseView):
def post(self, request, *args, **kwargs):
try:
data = json.loads(request.body.decode('utf-8'))
ids = data.get('ids', [])
if not isinstance(ids, list):
ids = [ids]
deleted_count = 数据库Model.objects.using("数据库名称").filter(pk__in=ids).delete()[0]
response_data = {'result': 'success', 'deleted_count': deleted_count}
except Exception as e:
response_data = {'result': 'error', 'message': str(e)}
return JsonResponse(response_data)
改:
class 改方法(BaseView):
def post(self, request, *args, **kwargs):
try:
data = json.loads(request.body.decode('utf-8'))
id = data.get('id')
mymodel = 数据库Model.objects.using("数据库名称").get(pk=id)
for key, value in data.items():
if value: # 检查参数是否为空
setattr(mymodel, key, value)
mymodel.save()
response_data = {'result': 'success'}
except Exception as e:
response_data = {'result': 'error', 'message': str(e)}
return JsonResponse(response_data)
查:
class 查方法(BaseView):
def get(self, request, *args, **kwargs):
try:
id = self.kwargs.get('id')
mymodel = 数据库Model.objects.using("数据库名称").get(pk=id)
datas = model_to_dict(mymodel)
response_data = {'result': 'success', 'data': datas}
return JsonResponse(response_data)
except Exception as e:
response_data = {'message': str(e)}
return JsonResponse(response_data, status=500)