0001bis-api-add-after-before-to-api-users-.-forms-10179.patch
| wcs/api.py | ||
|---|---|---|
| 632 | 632 | |
| 633 | 633 |
if get_publisher().is_using_postgresql() and not get_request().form.get('full') == 'on':
|
| 634 | 634 |
from wcs import sql |
| 635 |
from .qommon.storage import Equal |
|
| 635 |
from .qommon.storage import Equal, Less, Greater |
|
| 636 |
criterias = [Equal('user_id', str(user.id))]
|
|
| 636 | 637 |
order_by = 'receipt_time' |
| 637 | 638 |
if get_request().form.get('sort') == 'desc':
|
| 638 | 639 |
order_by = '-receipt_time' |
| 640 |
if get_request().form.get('after'):
|
|
| 641 |
cursor = misc.get_as_datetime(get_request().form['after']) |
|
| 642 |
criterias.append(Less('receipt_time', cursor))
|
|
| 643 |
elif get_request().form.get('before'):
|
|
| 644 |
cursor = misc.get_as_datetime(get_request().form['before']) |
|
| 645 |
criterias.append(Greater('receipt_time', cursor))
|
|
| 646 |
order_by = order_by[1:] if order_by.startswith('-') else '-' + order_by
|
|
| 639 | 647 |
user_forms = sql.AnyFormData.select( |
| 640 |
[Equal('user_id', str(user.id))],
|
|
| 648 |
criterias,
|
|
| 641 | 649 |
limit=get_request().form.get('limit'),
|
| 642 | 650 |
offset=get_request().form.get('offset'),
|
| 643 | 651 |
order_by=order_by) |
| 644 |
- |
|