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
|
from playhouse.sqlite_ext import VirtualModel, VirtualIntegerField, VirtualCharField
from peewee import Field, OP, DJANGO_MAP, ForeignKeyField, ReverseRelationDescriptor, Expression, Query
from itertools import starmap
from functools import reduce
import operator as op
def sqlite_tuple_in(fields, values):
"""SQLite does not support (foo, bar) IN ((1,2),(3,4)).
So we construct a '(foo = 1 AND bar = 2) OR (foo = 3 AND bar = 4)' monstrum."""
subqueries = (reduce(op.and_, starmap(op.eq, zip(fields, value_tuple))) for value_tuple in values)
return reduce(op.or_, subqueries)
class EnumField(Field):
db_field = 'enum'
def __init__(self, enum_class, *args, **kwargs):
super().__init__(*args, **kwargs)
self.enum_class = enum_class
def _enum_value(self, value):
if isinstance(value, str):
try:
return self.enum_class[value.upper()]
except KeyError:
pass
try:
return self.enum_class(int(value))
except ValueError:
raise ValueError("%r is not a valid %s" % (value, self.enum_class.__name__))
def db_value(self, value):
if value is None:
return value
if isinstance(value, self.enum_class):
return value.value
# force check of enum value
return self._enum_value(value).value
def python_value(self, value):
return value if value is None else self._enum_value(value)
|
