1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
from sqlalchemy import and_
from app.settings import app_cfg
import datetime
import dateutil
def parse_search_args(args):
try:
limit = min(int(args.get('limit', default=app_cfg.DEFAULT_LIMIT)), app_cfg.MAX_LIMIT)
except Exception as e:
limit = app_cfg.DEFAULT_LIMIT
try:
offset = int(args.get('offset', default=0))
except Exception as e:
offset = 0
return offset, limit
def parse_sort_args(args, table=None, default_sort="id", default_order="asc"):
try:
sort = args.get('sort', default=default_sort)
except Exception as e:
sort = 'id'
try:
order = args.get('order', default=default_order)
except:
order = 'asc'
if table is not None:
column = getattr(table, sort)
order_by = getattr(column, order)()
if sort != 'id':
order_by_id = getattr(table.id, order)()
else:
order_by_id = None
else:
order_by = None
order_by_id = None
return sort, order, order_by, order_by_id
def parse_crop_arg(args):
try:
x = float(args.get('x'))
y = float(args.get('y'))
w = float(args.get('w'))
h = float(args.get('h'))
crop = (x, y, w, h,)
except Exception as e:
crop = None
return crop
# def parse_media_args(args):
# criteria = []
# criteria_kwargs = {}
# try:
# import_id = int(args.get('import_id'))
# criteria.append(Media.import_id == import_id)
# criteria_kwargs['import_id_1'] = import_id
# except:
# pass
# try:
# start_date = str(args.get('start_date'))
# start_date = dateutil.parser.parse(start_date)
# start_date = start_date.replace(tzinfo=datetime.timezone.utc)
# criteria.append(Media.created_at >= start_date)
# criteria_kwargs['created_at_1'] = start_date
# except:
# pass
# try:
# end_date = str(args.get('end_date'))
# end_date = dateutil.parser.parse(end_date)
# end_date = end_date.replace(tzinfo=datetime.timezone.utc)
# criteria.append(Media.created_at <= end_date)
# criteria_kwargs['created_at_2'] = end_date
# except:
# pass
# if len(criteria) > 1:
# return criteria, criteria_kwargs
# elif len(criteria) == 1:
# return criteria, criteria_kwargs
# return None, {}
|
