· 6 years ago · Aug 16, 2019, 06:12 PM
1def mapper(values, param : bool):
2
3 ### 1
4 if param:
5 return values
6 else:
7 return ['any'] if values == None else (None if values == ['no'] else values)
8
9 ### 2
10 if values == None:
11 return values if param else ['any']
12 elif values == ['no']:
13 return values if param else None
14 else:
15 return values
16
17 ### 3
18 if param:
19 return values
20 elif values == None:
21 return ['any']
22 elif values == ['no']:
23 return None
24 else:
25 return values
26
27'''
28select count(*) from users where email like '%gmail.com';
29
30select * from users where city_id in (
31 select id
32 from cities
33 where country_id = (
34 select id
35 from countries
36 where name = 'Russia'
37 )
38);
39'''