English 中文(简体)
我如何根据 p字的字典价值按日期范围过滤,从而由字典过滤一份清单?
原标题:How do I filter by a date range based on a dictionary value in python, otherwise filter a list by a dictionary?

我有这样的看法:

s_dates_dict = {17: datetime.date(2009,21,9,0,24), 19: datetime.datetime(2011,12,1,19,39,16), ....}  
e_dates_dict = {17: datetime.date(2010,25,9,10,24), 19: datetime.datetime(2012,1,11,17,39,16), ....}

我想利用这些字典来找到每个记录的日期之后的下一个类型记录(A或B)。 因此,我最好不要提出类似于以下的提问:

next_record_list = Tasks.objects.filter(date__range(s_dates_dict,e_dates_dict), client__in=client_list, task_type__in=[A,B])  

如果有的话,字典会给参考的纸面带来动态的变化。 我发现任何暗示这样做是可能的或有效的,因此,我猜测下一个最好办法是通过取消日期范围过滤器,然后用声明和在日期(起诉日期)上删除每个记录,来翻开最古老价值的字典。 但是,我没有说明这样做的方法。 我能否得到一些关于如何这样做的建议,或者一种完全不同的更好方法? 感谢。

http://www.un.org。

client_list is a list of client objects.

这方面有一些模式。 py:

class Client(models.Model):
    user_name = models.CharField

class Task(models.Model):
    client = models.ForeignKey(
                                Client ,
                               )
    task_type = models.ForeginKey(
                                   Task_Type ,
                                  )
    date = models.DateTimeField(
                                 default = datetime.now(),
                                 blank = True,
                                 null = True,
                                 )

class Task_Type(models.Model):
    name = models.CharField  
最佳回答

我认为,我现在理解。 我正在假设<条码>客户物体清单。 有些人可能提出更有效的解决办法,但我要尝试这样的办法:

next_record = {}
for client in client_list:
    s = s_dates_dict[client.pk]
    e = e_dates_dict[client.pk]
    next_record[client.pk] = client.tasks_set.filter(date__range(s,e), task_type__in=[A,B])

这给你一个文本(next_record),其中每个关键内容都与任务清单一致。 假设在您的TasksClient之间有关系。

Hopefully this works, if not, can you please post the code for your models?

问题回答

暂无回答




相关问题
Can Django models use MySQL functions?

Is there a way to force Django models to pass a field to a MySQL function every time the model data is read or loaded? To clarify what I mean in SQL, I want the Django model to produce something like ...

An enterprise scheduler for python (like quartz)

I am looking for an enterprise tasks scheduler for python, like quartz is for Java. Requirements: Persistent: if the process restarts or the machine restarts, then all the jobs must stay there and ...

How to remove unique, then duplicate dictionaries in a list?

Given the following list that contains some duplicate and some unique dictionaries, what is the best method to remove unique dictionaries first, then reduce the duplicate dictionaries to single ...

What is suggested seed value to use with random.seed()?

Simple enough question: I m using python random module to generate random integers. I want to know what is the suggested value to use with the random.seed() function? Currently I am letting this ...

How can I make the PyDev editor selectively ignore errors?

I m using PyDev under Eclipse to write some Jython code. I ve got numerous instances where I need to do something like this: import com.work.project.component.client.Interface.ISubInterface as ...

How do I profile `paster serve` s startup time?

Python s paster serve app.ini is taking longer than I would like to be ready for the first request. I know how to profile requests with middleware, but how do I profile the initialization time? I ...

Pragmatically adding give-aways/freebies to an online store

Our business currently has an online store and recently we ve been offering free specials to our customers. Right now, we simply display the special and give the buyer a notice stating we will add the ...

Converting Dictionary to List? [duplicate]

I m trying to convert a Python dictionary into a Python list, in order to perform some calculations. #My dictionary dict = {} dict[ Capital ]="London" dict[ Food ]="Fish&Chips" dict[ 2012 ]="...

热门标签