-
Notifications
You must be signed in to change notification settings - Fork 5.3k
/
dataloaders.py
165 lines (138 loc) · 5.88 KB
/
dataloaders.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
from collections import defaultdict
from django.db.models import F
from ...discount import DiscountInfo
from ...discount.models import (
OrderDiscount,
Sale,
SaleChannelListing,
Voucher,
VoucherChannelListing,
)
from ...discount.utils import (
fetch_categories,
fetch_collections,
fetch_products,
fetch_sale_channel_listings,
fetch_variants,
)
from ..core.dataloaders import DataLoader
class DiscountsByDateTimeLoader(DataLoader):
context_key = "discounts"
def batch_load(self, keys):
sales_map = {
datetime: list(
Sale.objects.using(self.database_connection_name)
.active(datetime)
.order_by("id")
)
for datetime in keys
}
pks = {s.pk for d, ss in sales_map.items() for s in ss}
collections = fetch_collections(pks, self.database_connection_name)
channel_listings = fetch_sale_channel_listings(
pks, self.database_connection_name
)
products = fetch_products(pks, self.database_connection_name)
categories = fetch_categories(pks, self.database_connection_name)
variants = fetch_variants(pks, self.database_connection_name)
return [
[
DiscountInfo(
sale=sale,
channel_listings=channel_listings[sale.pk],
category_ids=categories[sale.pk],
collection_ids=collections[sale.pk],
product_ids=products[sale.pk],
variants_ids=variants[sale.pk],
)
for sale in sales_map[datetime]
]
for datetime in keys
]
class SaleChannelListingBySaleIdAndChanneSlugLoader(DataLoader):
context_key = "salechannelisting_by_sale_and_channel"
def batch_load(self, keys):
sale_ids = [key[0] for key in keys]
channel_slugs = [key[1] for key in keys]
sale_channel_listings = (
SaleChannelListing.objects.using(self.database_connection_name)
.filter(sale_id__in=sale_ids, channel__slug__in=channel_slugs)
.annotate(channel_slug=F("channel__slug"))
)
sale_channel_listings_by_sale_and_channel_map = {}
for sale_channel_listing in sale_channel_listings:
key = (sale_channel_listing.sale_id, sale_channel_listing.channel_slug)
sale_channel_listings_by_sale_and_channel_map[key] = sale_channel_listing
return [sale_channel_listings_by_sale_and_channel_map.get(key) for key in keys]
class SaleChannelListingBySaleIdLoader(DataLoader):
context_key = "salechannelisting_by_sale"
def batch_load(self, keys):
sale_channel_listings = SaleChannelListing.objects.using(
self.database_connection_name
).filter(sale_id__in=keys)
sale_channel_listings_by_sale_map = defaultdict(list)
for sale_channel_listing in sale_channel_listings:
sale_channel_listings_by_sale_map[sale_channel_listing.sale_id].append(
sale_channel_listing
)
return [sale_channel_listings_by_sale_map[sale_id] for sale_id in keys]
class VoucherByIdLoader(DataLoader):
context_key = "voucher_by_id"
def batch_load(self, keys):
vouchers = Voucher.objects.using(self.database_connection_name).in_bulk(keys)
return [vouchers.get(voucher_id) for voucher_id in keys]
class VoucherByCodeLoader(DataLoader):
context_key = "voucher_by_code"
def batch_load(self, keys):
vouchers = (
Voucher.objects.using(self.database_connection_name)
.filter(code__in=keys)
.in_bulk(field_name="code")
)
return [vouchers.get(code) for code in keys]
class VoucherChannelListingByVoucherIdAndChanneSlugLoader(DataLoader):
context_key = "voucherchannelisting_by_voucher_and_channel"
def batch_load(self, keys):
voucher_ids = [key[0] for key in keys]
channel_slugs = [key[1] for key in keys]
voucher_channel_listings = (
VoucherChannelListing.objects.using(self.database_connection_name)
.filter(voucher_id__in=voucher_ids, channel__slug__in=channel_slugs)
.annotate(channel_slug=F("channel__slug"))
)
voucher_channel_listings_by_voucher_and_channel_map = {}
for voucher_channel_listing in voucher_channel_listings:
key = (
voucher_channel_listing.voucher_id,
voucher_channel_listing.channel_slug,
)
voucher_channel_listings_by_voucher_and_channel_map[
key
] = voucher_channel_listing
return [
voucher_channel_listings_by_voucher_and_channel_map.get(key) for key in keys
]
class VoucherChannelListingByVoucherIdLoader(DataLoader):
context_key = "voucherchannellisting_by_voucher"
def batch_load(self, keys):
voucher_channel_listings = VoucherChannelListing.objects.using(
self.database_connection_name
).filter(voucher_id__in=keys)
voucher_channel_listings_by_voucher_map = defaultdict(list)
for voucher_channel_listing in voucher_channel_listings:
voucher_channel_listings_by_voucher_map[
voucher_channel_listing.voucher_id
].append(voucher_channel_listing)
return [
voucher_channel_listings_by_voucher_map[voucher_id] for voucher_id in keys
]
class OrderDiscountsByOrderIDLoader(DataLoader):
context_key = "orderdiscounts_by_order_id"
def batch_load(self, keys):
discounts = OrderDiscount.objects.using(self.database_connection_name).filter(
order_id__in=keys
)
discount_map = defaultdict(list)
for discount in discounts:
discount_map[discount.order_id].append(discount)
return [discount_map.get(order_id, []) for order_id in keys]