问针对大于和小于运算符的date属性的Dynamodb查询

EN

class OrderStatusIndex(GlobalSecondaryIndex):
    class Meta:
        index_name = 'OrderStatusIndex'
        read_capacity_units = 2
        write_capacity_units = 1
        projection = AllProjection()
    order_status = NumberAttribute(hash_key=True)
    created_on = UnicodeAttribute(range_key=True)


class Order(Model):

    class Meta:
        table_name = 'order'
        host = 'http://localhost:8000'
        read_capacity_units = 2
        write_capacity_units = 1

    order_id = NumberAttribute(hash_key=True)
    order_status = NumberAttribute(hash_key=True)
    created_on = UnicodeAttribute(range_key=True)
    order_status_index = OrderStatusIndex()

select *from order where order_status = 0 and created_on >= start_date and created_on <=end_date