如何使用web2py.DAL进行'between'查询？(how can I make 'between' query with web2py.DAL?)

 我正在尝试创建一个接受两个datetime.date对象（start_date和end_date）的查询函数，并返回所有记录，其中包含start_date和end_date之间的相关字段。 但是，我在web2py手册中找不到类似的函数，所以我这样实现： 
 
        for o in objects:
            # notice that create_time is a datetime field
            create_date = dt.datetime.strptime(o['create_time'], 
                                               "%Y-%m-%d %H:%M:%S").strftime("%Y-%m-%d")
        if query_dict['create_date_1'] <= create_date <= query_dict['create_date_2']:
            result.append(l)
 
 对我的应用来说这样做太慢了，因为它们可能是很多对象。 那么，有没有更好的方法可以使用web2py.DAL实现这一点？ 提前致谢 ;） 

I'm trying to make a query function that accepts two datetime.date object(start_date and end_date), and return all records with a related field that's between start_date and end_date. However, I found nothing like a between function in the web2py manual, so I implement it this way:
 
        for o in objects:
            # notice that create_time is a datetime field
            create_date = dt.datetime.strptime(o['create_time'], 
                                               "%Y-%m-%d %H:%M:%S").strftime("%Y-%m-%d")
        if query_dict['create_date_1'] <= create_date <= query_dict['create_date_2']:
            result.append(l)
 
Doing this is too slow for my application because their can be many objects. So, is there a better way I can implement this using web2py.DAL? Thanks in advance ;)

原文：https://stackoverflow.com/questions/1907088