如何显示最新更新的记录在表-Django

Question

我在模板文件中有一个表，我正在使用。xls文件更新数据。

有没有人可以帮助我如何显示最新添加的记录与一些提示(或通过添加另一列)或如何区分哪些是更新的记录，哪些是新增的记录?

下面是我上传数据的逻辑代码。

import time
import simplejson as json
count = [ ]  ##Global variable
lap =[]
from datetime import datetime
def CTA_upload(request):
lap.clear()
i = 1
print('Counter value at starting::::::::: :', len(count))
allcta = CTA.objects.all()
allcta = allcta.filter(Shift_timing__exact='Morning')
allcta7 = 50
now = datetime.now()
current_time = now.strftime("%H:%M:%S")
# start = '06:30:00'
# end = '15:30:00'
print('Current Time:',current_time)
try:
if current_time > '06:30:00' and current_time < '23:59:59':
if len(count) <= allcta7:
if request.method == 'POST':
movie_resource = CTaResource()
print('movie_resource', movie_resource)
##we will get data in movie_resources####
dataset = Dataset()
print('Dataset ka Type', dataset)
new_movie = request.FILES['file']
if not new_movie.name.endswith('xls'):
messages.info(request, 'Sorry Wrong File Format.Please Upload valid format')
return render(request, 'app/uploadcta.html')
messages.info(request, 'Starting...')
imported_data = dataset.load(new_movie.read(), format='xls')
print('abcdefghijk:', type(imported_data))
messages.info(request, 'Checking File content)')
for data in imported_data:
print('data2',data[1])
datax=data[1]
if data[1] != '' :
value = CTA(
data[0], data[1], data[2], data[3], data[4], data[5], data[6], data[7], data[8],
)
if len(count) <= allcta7:
value.save()
i = i + 1
count.append(i)
print('Count After Saving Value:', count)
ldap.insert(1, datax)
print('Ldap ID is:', ldap)
print('Testing')
else:
if data[1] == '':
messages.info(request,
'Please Make Sure AppConnect field value should not be blank. OR')
break
else:
messages.info(request, 'File Processing')
messages.success(request, ". . . . .")
logger.info('Data present in CTA upload file:  %s !', imported_data)
messages.info(request, 'File is Uploded successfully')

return render(request, 'app/uploadcta.html', {'lap': imported_data})
# return render(request, 'apple/wrongtime.html')
else:
messages.info(request, 'Sorry,File Upload is not allowed')

# return render(request, 'app/wrongtime.html')
except:
messages.info(request,'Please Make sure Email field should be unique.')

return render(request,'app/uploadcta.html')

问:我如何通过使用message.info打印内容，例如，如果我将使用messages.info(request， 'File is uplouplosuccessfully ')

我将得到输出:File is Uploded successfully

同样的方法我是否也可以传递内容就像我们在渲染

中传递内容一样示例:return render(request， 'app/uploadcta.html'， {'lap': importted_data})

Answer 1

@Shailesh -这种方法怎么样如何区分哪些是更新的记录，哪些是新增的记录?将这两个字段添加到模型中如何?

created_at = models.DateTimeField(auto_now_add=True)
modified_at = models.DateTimeField(auto_now_add=True)

当创建一条记录时，created_at和modified_at将具有相同的值当一个记录被更新时，modified_at应该改变，但是created_at将是记录被插入的日期。