From ef092edc64ac489fe25d83bad05e4c1660b2444b Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Sun, 3 Dec 2017 18:06:10 +0100 Subject: Enhance CharField with 'nocase' option --- archivist/peewee_ext.py | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'archivist/peewee_ext.py') diff --git a/archivist/peewee_ext.py b/archivist/peewee_ext.py index edcb9c9..011f80d 100644 --- a/archivist/peewee_ext.py +++ b/archivist/peewee_ext.py @@ -1,5 +1,5 @@ from peewee import Field, SQL -from playhouse.fields import CompressedField as _CompressedField +from playhouse.fields import CompressedField as _CompressedField, CharField as _CharField from itertools import starmap from functools import reduce @@ -11,6 +11,14 @@ def sqlite_tuple_in(fields, values): subqueries = (reduce(op.and_, starmap(op.eq, zip(fields, value_tuple))) for value_tuple in values) return reduce(op.or_, subqueries) +class CharField(_CharField): + def __init__(self, *args, **kwargs): + constraints = kwargs.pop('constraints', []) + nocase = kwargs.pop('nocase', False) + if nocase: + constraints.append(SQL('COLLATE NOCASE')) + super().__init__(*args, constraints=constraints, **kwargs) + class CompressedField(_CompressedField): def db_value(self, value): return value if value is None else self.compress(value) -- cgit v1.2.3-54-g00ecf