我有两个模型
房间和房间日志
每个房间对象可以有多个RoomLog对象。 它的目的是使Room对象有一个属性:value和方法save()。每次用户保存任何特定房间对象的更改属性并保存时,我都会创建一个新的相关RoomLog对象。在
RoomLog对象具有值属性和日期属性。 日期与房间保存方法相关,因此它给出房间更改值的保存日期。在
我的问题是:
问题1:如何从所有RoomLog对象返回所有唯一的日期,以便我知道保存发生的时间?在
问题2:假设我们知道如何返回独特的日子。所以,问题是:如何从这些独特的日子中选择任何一天,并按所选日期显示所有房间对象的值?我想返回每个房间对象从所选日期最后保存的值。在
目前我解决这两个问题的方法(我正在寻找更具Python式、更快、性能更好的解决方案)是:
我创建了迭代RoomLog对象的表单:
class MyForm(forms.Form):
roomdates = []
roomextracted = []
for r in RoomLog.objects.all():
if r not in roomdates:
roomdates.append(r.update_date)
for i in roomdates:
if i not in roomextracted:
roomextracted.append(i)
ROOMDATA = [(r, r) for r in roomextracted]
my_choice_field = forms.ChoiceField(choices=ROOMDATA)
然后我有一个视图,将选定的日期传递到另一个我在其中过滤的视图房间.objects.all()按选定日期:
^{pr2}$下一个是我选项表单.html从下拉菜单中选择日期:
{% extends "base.html" %}
{% block content %}
<form action="" method="post" >
{% csrf_token %}
<ul>
{% for choice in form.my_choice_field.field.choices %}
<li>
<input type="radio" name="my_choice_field" value="{{choice.0}}"
{% if equal form.my_choice_field.data choice.0 %}
checked="checked"
{% endifequal %}/>
<label for="">{{choice.1}}</label>
</li>
{% endfor %}
</ul>
<input type="submit" value="Submit" />
</form>
{% endblock %}
这是我处理POST数据的视图
class AllRoomsView(ListView):
template_name = 'prostats/roomsdetail.html'
queryset = Room.objects.all()
def get_context_data(self, **kwargs):
context = super(AllRoomsView, self).get_context_data(**kwargs)
context['rooms'] = Room.objects.all()
context['rlog'] = RoomLog.objects.all()
roomsdates = []
for r in context['rlog']:
if r not in roomsdates:
roomsdates.append(r.update_date)
roomextracted = []
for i in roomsdates:
if i not in roomextracted:
roomextracted.append(i)
context['roomextracted'] = roomextracted
choicedate = self.request.GET.get('choice')
if choicedate != None:
choosend = choicedate
else:
choosend = '2016-02-01'
#filtered rlogs
rlfilteredempty = []
for r in context['rooms']:
i = RoomLog.objects.filter(room=r.id, update_date__lte = choosend).order_by('-update_date')[:1]
if i:
rlfilteredempty.append(i[0])
else:
rlfilteredempty.append(r)
context['rlfiltered'] = rlfilteredempty
context['choicedate'] = self.request.GET.get('choice')
#context['roomfiltersettime'] = RoomLog.objects.filter(update_date__lte = choosend)
context['roomfiltersettime'] = RoomLog.objects.filter(update_date__lte = choosend)
rslice = []
for r in context['rooms']:
i = RoomLog.objects.filter(room=r.id, update_date__lte = choosend).order_by('-update_date')[:1]
if i:
for rsobject in i:
rs = (r.flat.flat_number,r.flat.block.block_name,r.room_name)
rl = rsobject.id
rv = rsobject.room_value
rslice.append((rs,rl,rv))
else:
rs = (r.flat.flat_number,r.flat.block.block_name,r.room_name)
r = r.id
rslice.append((rs,r))
context['rslice'] = rslice
所以,我所做的一切,我觉得不是很好,也许有人可以给我一些好主意,如何更好地解决这个问题?在
编辑:用我的房间和房间日志模型更新帖子:
class Room(models.Model):
room_name = models.CharField(max_length= 10)
room_value = models.PositiveSmallIntegerField(default=0)
flat = models.ForeignKey(Flat)
created_date = models.DateField(auto_now_add= True)
created_time = models.TimeField(auto_now_add= True)
substage_name = models.CharField(max_length=50,default="")
def __init__(self, *args, **kwargs):
super(Room, self).__init__(*args, **kwargs)
self.value_original = self.room_value
def save(self, **kwargs):
with transaction.atomic():
response = super(Room, self).save(**kwargs)
if self.value_original != self.room_value:
room_log = RoomLog()
room_log.room = self
room_log.room_value = self.value_original
room_log.save()
return response
class RoomLog(models.Model):
room = models.ForeignKey(Room)
room_value = models.PositiveSmallIntegerField(default=0)
update_date = models.DateField(auto_now_add= True)
update_time = models.TimeField(auto_now_add= True)
要返回所有唯一的日期,请在
created_date
字段中使用distinct()
。当然,只有当created_date
实际上是一个日期而不是日期时间值时,这才有效!在如果您的
^{pr2}$created
值是datetime
,则需要首先使用Django的func()
和F()
函数将其设为日期。它使用了DATE()
SQL函数,这些函数可能不适用于所有数据库,但在Postgres和其他许多数据库上都可以。在只是部分回答。第二个问题取决于你没有发布的模型的布局。在
相关问题 更多 >
编程相关推荐