forked from django-import-export/django-import-export
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathwidgets.py
234 lines (180 loc) · 6.17 KB
/
widgets.py
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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
from __future__ import unicode_literals
from decimal import Decimal
from datetime import datetime
from django.utils import datetime_safe
from django.utils.encoding import smart_text
from django.conf import settings
try:
from django.utils.encoding import force_text
except ImportError:
from django.utils.encoding import force_unicode as force_text
class Widget(object):
"""
Widget takes care of converting between import and export representations.
Widget objects have two functions:
* converts object field value to export representation
* converts import value and converts it to appropriate python
representation
"""
def clean(self, value):
"""
Returns appropriate python objects for import value.
"""
return value
def render(self, value):
"""
Returns export representation of python value.
"""
return force_text(value)
class NumberWidget(Widget):
def render(self, value):
return value
class IntegerWidget(NumberWidget):
"""
Widget for converting integer fields.
"""
def clean(self, value):
if not value and value is not 0:
return None
return int(value)
class DecimalWidget(NumberWidget):
"""
Widget for converting decimal fields.
"""
def clean(self, value):
if not value:
return None
return Decimal(value)
class CharWidget(Widget):
"""
Widget for converting text fields.
"""
def render(self, value):
return force_text(value)
class BooleanWidget(Widget):
"""
Widget for converting boolean fields.
"""
TRUE_VALUES = ["1", 1]
FALSE_VALUE = "0"
def render(self, value):
if value is None:
return ""
return self.TRUE_VALUES[0] if value else self.FALSE_VALUE
def clean(self, value):
if value == "":
return None
return True if value in self.TRUE_VALUES else False
class DateWidget(Widget):
"""
Widget for converting date fields.
Takes optional ``format`` parameter.
"""
def __init__(self, format=None):
if format is None:
if not settings.DATE_INPUT_FORMATS:
formats = ("%Y-%m-%d",)
else:
formats = settings.DATE_INPUT_FORMATS
else:
formats = (format,)
self.formats = formats
def clean(self, value):
if not value:
return None
for format in self.formats:
try:
return datetime.strptime(value, format).date()
except (ValueError, TypeError):
continue
raise ValueError("Enter a valid date.")
def render(self, value):
if not value:
return ""
try:
return value.strftime(self.formats[0])
except:
return datetime_safe.new_date(value).strftime(self.formats[0])
class DateTimeWidget(Widget):
"""
Widget for converting date fields.
Takes optional ``format`` parameter.
"""
def __init__(self, format=None):
if format is None:
if not settings.DATETIME_INPUT_FORMATS:
formats = ("%Y-%m-%d %H:%M:%S",)
else:
formats = settings.DATETIME_INPUT_FORMATS
else:
formats = (format,)
self.formats = formats
def clean(self, value):
if not value:
return None
for format in self.formats:
try:
return datetime.strptime(value, format)
except (ValueError, TypeError):
continue
raise ValueError("Enter a valid date/time.")
def render(self, value):
if not value:
return ""
return value.strftime(self.formats[0])
class ForeignKeyWidget(Widget):
"""
Widget for ``ForeignKey`` which looks up a related model.
The lookup field defaults to using the primary key (``pk``), but
can be customised to use any field on the related model.
e.g. To use a lookup field other than ``pk``, rather than specifying a
field in your Resource as ``class Meta: fields = ('author__name', ...)``,
you would specify it in your Resource like so:
class BookResource(resources.ModelResource):
author = fields.Field(column_name='author', attribute='author', \
widget=ForeignKeyWidget(Author, 'name'))
class Meta: fields = ('author', ...)
This will allow you to use "natural keys" for both import and export.
Parameters:
``model`` should be the Model instance for this ForeignKey (required).
``field`` should be the lookup field on the related model.
"""
def __init__(self, model, field='pk', *args, **kwargs):
self.model = model
self.field = field
super(ForeignKeyWidget, self).__init__(*args, **kwargs)
def clean(self, value):
val = super(ForeignKeyWidget, self).clean(value)
return self.model.objects.get(**{self.field: val}) if val else None
def render(self, value):
if value is None:
return ""
return getattr(value, self.field)
class ManyToManyWidget(Widget):
"""
Widget for ``ManyToManyField`` model field that represent m2m field
as values that identify many-to-many relationship.
Requires a positional argument: the class to which the field is related.
Optional keyword arguments are:
separator - default ","
field - field of related model, default ``pk``
"""
def __init__(self, model, separator=None, field=None, *args, **kwargs):
if separator is None:
separator = ','
if field is None:
field = 'pk'
self.model = model
self.separator = separator
self.field = field
super(ManyToManyWidget, self).__init__(*args, **kwargs)
def clean(self, value):
if not value:
return self.model.objects.none()
ids = value.split(self.separator)
return self.model.objects.filter(**{
'%s__in' % self.field: ids
})
def render(self, value):
ids = [smart_text(getattr(obj, self.field)) for obj in value.all()]
return self.separator.join(ids)