-
Notifications
You must be signed in to change notification settings - Fork 5
/
Copy pathstrategies.py
373 lines (301 loc) · 10.2 KB
/
strategies.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
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
from __future__ import annotations
from collections.abc import Collection, Iterable
from pathlib import Path
from typing import Any, Callable, TypeVar
from django.core import serializers
from django.core.serializers.base import DeserializedObject
from django.db import models
from .pii_anonymisation import PiiAnonymisingSerializer
from .utils import (
get_exported_pks_for_model,
is_empty_iterator,
to_app_model_label,
to_model,
)
TModel = TypeVar("TModel", bound=models.Model)
Logger = Callable[[str], None]
class Strategy:
"""
Base strategy defining how to get data for a given model into a fresh
database.
"""
name: str
depends_on: tuple[str, ...] = ()
def __init__(self) -> None:
pass
def import_data(
self,
django_dbname: str,
src: Path,
model: models.Model,
) -> None:
"""Load data into newly created database."""
raise NotImplementedError
class Exportable:
"""
A strategy that uses exported data from some source, typically a production
database.
"""
seen_names: set[tuple[str, str]] = set()
def __init__(self, *args: Any, name: str, **kwargs: Any) -> None:
super().__init__(*args, **kwargs)
self.name = name
def export_data(
self,
django_dbname: str,
dest: Path,
model: models.Model,
no_update: bool = False,
log: Logger = lambda x: None,
) -> None:
"""
Export the data to a directory on disk. `no_update` indicates not to
update if there is any data already existing locally.
"""
pass
def data_file(self, dest: Path, app_model_label: str) -> Path:
return dest / app_model_label / "{}.json".format(self.name)
def ensure_dir_exists(self, dest: Path, app_model_label: str) -> None:
unique_key = (app_model_label, self.name)
if unique_key in self.seen_names:
raise ValueError(
"Exportable strategy names must be unique per model so that "
"exports do not collide.",
)
self.seen_names.add(unique_key)
model_dir = dest / app_model_label
model_dir.mkdir(parents=True, exist_ok=True)
class QuerySetStrategy(Exportable, Strategy):
"""Import a table using an unfiltered QuerySet."""
use_natural_foreign_keys = False
use_natural_primary_keys = False
json_indent = 2
def __init__(
self,
*args: Any,
anonymise: bool = True,
**kwargs: Any,
) -> None:
super().__init__(*args, **kwargs)
self.anonymise = anonymise
def get_restricted_pks(
self,
dest: Path,
model: models.Model,
) -> dict[str, list[str]]:
restricted_pks = {}
for field in model._meta.fields:
if not field.related_model:
continue
if field.related_model == model:
continue
app_model_label = to_app_model_label(field.related_model)
restricted_pks[app_model_label] = get_exported_pks_for_model(
dest,
field.related_model,
)
return restricted_pks
def get_queryset(
self,
django_dbname: str,
dest: Path,
model: TModel,
) -> models.QuerySet[TModel]:
queryset = model.objects.using(django_dbname)
for app_model_label, restrict_pks in self.get_restricted_pks(
dest,
model,
).items():
restrict_model = to_model(app_model_label)
# We filter to all fields that relate to the restricted model. This
# will usually be just one field, but in cases where it's multiple
# to preserve FK integrity we must restrict all of them.
fk_fields = [
x
for x in model._meta.fields
if x.related_model == restrict_model
]
queryset = queryset.filter(
*[
models.Q(
**{x.attname: None},
)
| models.Q(
**{"{}__in".format(x.attname): restrict_pks},
)
for x in fk_fields
]
)
return queryset
def export_data(
self,
django_dbname: str,
dest: Path,
model: models.Model,
no_update: bool = False,
log: Logger = lambda x: None,
) -> None:
app_model_label = to_app_model_label(model)
data_file = self.data_file(dest, app_model_label)
if no_update and data_file.exists():
return
self.ensure_dir_exists(dest, app_model_label)
queryset = self.get_queryset(django_dbname, dest, model)
serializer = (
PiiAnonymisingSerializer(dest=dest)
if self.anonymise
else serializers.get_serializer("json")
)
with data_file.open("w") as output:
iterator, queryset_is_empty = is_empty_iterator(queryset.iterator())
if queryset_is_empty:
log(
"Warning! '{}' exporter for {} selected no data.".format(
self.name,
app_model_label,
)
)
serializer.serialize(
iterator,
indent=self.json_indent,
use_natural_foreign_keys=self.use_natural_foreign_keys,
use_natural_primary_keys=self.use_natural_primary_keys,
stream=output,
)
def import_data(
self,
django_dbname: str,
src: Path,
model: models.Model,
) -> None:
app_model_label = to_app_model_label(model)
try:
with self.data_file(src, app_model_label).open() as f:
objects = serializers.deserialize(
"json", f, using=django_dbname
)
self.import_objects(django_dbname, src, model, objects)
except Exception:
print("Failed to import {} ({})".format(app_model_label, self.name))
raise
def import_objects(
self,
django_dbname: str,
src: Path,
model: models.Model,
objects: Iterable[DeserializedObject],
) -> None:
qs = model.objects.using(django_dbname)
existing_pks = set(qs.values_list("pk", flat=True))
qs.bulk_create(
[x.object for x in objects if x.object.pk not in existing_pks]
)
class ExactQuerySetStrategy(QuerySetStrategy):
"""Import specific rows from a table using a QuerySet filtered to given PKs."""
def __init__(self, *args: Any, pks: Collection[Any], **kwargs: Any) -> None:
super().__init__(*args, **kwargs)
self.pks = pks
def get_queryset(
self,
django_dbname: str,
dest: Path,
model: TModel,
) -> models.QuerySet[TModel]:
return (
super()
.get_queryset(django_dbname, dest, model)
.filter(pk__in=self.pks)
)
class RandomSampleQuerySetStrategy(QuerySetStrategy):
"""Imports a random sample from a QuerySet."""
def __init__(self, *args: Any, count: int, **kwargs: Any) -> None:
super().__init__(*args, **kwargs)
self.count = count
def get_queryset(
self,
django_dbname: str,
dest: Path,
model: TModel,
) -> models.QuerySet[TModel]:
return (
super()
.get_queryset(django_dbname, dest, model)
.order_by("?")[: self.count]
)
class LatestSampleQuerySetStrategy(QuerySetStrategy):
"""Imports the latest items from a QuerySet."""
def __init__(
self,
*args: Any,
count: int,
order_by: str = "-id",
**kwargs: Any,
) -> None:
super().__init__(*args, **kwargs)
self.count = count
self.order_by = order_by
def get_queryset(
self,
django_dbname: str,
dest: Path,
model: TModel,
) -> models.QuerySet[TModel]:
qs = super().get_queryset(django_dbname, dest, model)
return qs.order_by(self.order_by)[: self.count]
class ModelReverseRelationshipQuerySetStrategy(QuerySetStrategy):
"""
Base class for inverse relationship queryset exporting.
Useful for relationships that go the wrong way to work with
normal dependency analysis. Example:
class Order(Model):
user = ForeignKey(User)
charge = ForeignKey(Charge)
class Charge(Model):
...
Requires a dependent model, such as `User`, and defines an additional
explicit dependency on that model locally. Reads in those IDs, passes them
to the exporting process, where they are available to `get_queryset`.
"""
def get_reverse_filter(
self,
dest: Path,
model: models.Model,
) -> dict[str, Any]:
raise NotImplementedError
def get_queryset(
self,
django_dbname: str,
dest: Path,
model: TModel,
) -> models.QuerySet[TModel]:
qs = super().get_queryset(django_dbname, dest, model)
return qs.filter(**self.get_reverse_filter(dest, model))
class DeleteFirstQuerySetStrategy(QuerySetStrategy):
def import_objects(
self,
django_dbname: str,
src: Path,
model: models.Model,
objects: Iterable[DeserializedObject],
) -> None:
qs = model.objects.using(django_dbname)
qs.all().delete()
super().import_objects(django_dbname, src, model, objects)
class FactoryStrategy(Strategy):
"""
Use the provided factory/factories to create data for this model (and any
related) models.
"""
def __init__(self, *args, factories, **kwargs): # type: ignore[no-untyped-def]
super().__init__(*args, **kwargs)
self.factories = factories
def import_data(
self,
django_dbname: str,
src: Path,
model: models.Model,
) -> None:
pass
class FailingStrategy(Exportable, Strategy):
def export_data(self, *args: object, **kwargs: object) -> None:
raise ValueError("This strategy always fails.")