最近我试图保存数据到我的数据库时,我点击了提交与默认用户外键。但是我被错误缠住了,试图通过在网上查找来解决问题,但找不到任何类似的问题。你知道吗
from django.shortcuts import render,redirect
from .models import TimesheetDetails
from django.contrib.auth.decorators import login_required
# Create your views here.
@login_required(login_url="/login")
def create_timesheet_view(request):
if request.method=="POST":
print(request.POST)
if ('dateToday' and 'dayToday' and 'startTime' and 'endTime' and
'breakTime' and 'weekType' and 'attendance' and 'normalTime' and 'extraTime'
and 'holidayTime' and 'workContent') in request.POST:
#post.user = request.POST.get('user')
post = TimesheetDetails()
post.username = request.POST.get('username')
post.date = request.POST.get('dateToday')
post.day = request.POST.get('dayToday')
post.startTime = request.POST.get('startTime')
post.endTime = request.POST.get('endTime')
post.breakTime = request.POST.get('breakTime')
post.normalTime = request.POST.get('normalTime')
post.overTime = request.POST.get('extraTime')
post.holidayTime = request.POST.get('holidayTime')
post.weekType = request.POST.get('weekType')
post.attendance = request.POST.get('attendance')
post.content = request.POST.get('workContent')
post = TimesheetDetails(request.POST,request.FILES)
print (request.POST)
instance = post.save()
instance.user = request.user
instance.save()
return redirect('/list')
return render(request,'timesheet/create_timesheet.html')
def view_timesheet(request):
context = {'timesheet_list': TimesheetDetails.obejcts.all()}
return render(request,"timesheet/view_timesheet.html")
from django.db import models
from django.contrib.auth.models import User
# Create your models here.
class TimesheetDetails(models.Model):
user = models.ForeignKey(User, on_delete=models.CASCADE,related_name="timesheet",null="False")
date = models.CharField(max_length = 10)
day = models.CharField(max_length = 10)
startTime = models.CharField(max_length =10)
endTime = models.CharField(max_length =10)
breakTime = models.CharField(max_length=3)
normalTime = models.CharField(max_length=10)
overTime = models.CharField(max_length = 10)
holidayTime = models.CharField(max_length = 10)
weekType = models.CharField( max_length = 10)
attendance = models.CharField( max_length = 10)
content = models.TextField( max_length = 300)
任何帮助都将不胜感激。上一次我尝试不用外键,我可以保存数据。但是我希望一个特定的用户保存他的数据并且只查看他的数据。你知道吗
TypeError at /
int() argument must be a string, a bytes-like object or a number, not 'QueryDict'
Request Method: POST
Request URL: http://127.0.0.1:8000/
Django Version: 2.2.8
Exception Type: TypeError
Exception Value:
int() argument must be a string, a bytes-like object or a number, not 'QueryDict'
Exception Location: D:\Django\TimeSheetProject\morabu\lib\site-packages\django\db\models\fields\__init__.py in get_prep_value, line 972
Python Executable: D:\Django\TimeSheetProject\morabu\Scripts\python.exe
Python Version: 3.7.2
Python Path:
['D:\\Django\\TimeSheetProject',
'D:\\Django\\TimeSheetProject\\morabu\\Scripts\\python37.zip',
'D:\\Django\\TimeSheetProject\\morabu\\DLLs',
'D:\\Django\\TimeSheetProject\\morabu\\lib',
'D:\\Django\\TimeSheetProject\\morabu\\Scripts',
'c:\\program files\\python\\Lib',
'c:\\program files\\python\\DLLs',
'D:\\Django\\TimeSheetProject\\morabu',
'D:\\Django\\TimeSheetProject\\morabu\\lib\\site-packages']
Server time: Fri, 27 Dec 2019 04:35:51 +0900
您需要删除
post = TimesheetDetails(request.POST,request.FILES)
行,因为TimesheetDetails
不是aForm
。也就是说,最好是work with forms。你知道吗另一个问题是
'foo' and 'bar' in request.POST
只检查'bar'
是否在request.POST
中,因为它只评估'foo'
的真实性,而非空字符串将True
作为真实性。你知道吗但是在这里定义
ModelForm
显然更好,因为这样可以删除很多样板代码。你知道吗此外,您可能最好在
redirect(..)
调用中使用视图的名称,而不是绝对路径。你知道吗相关问题 更多 >
编程相关推荐