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
|
import os
from PIL import Image
from django.db import models
from django.db.models.signals import post_save
from django.contrib.sitemaps import Sitemap
from django.dispatch import receiver
from django.urls import reverse
from django.apps import apps
from django.utils.html import format_html
from django.conf import settings
from django.template.defaultfilters import slugify
class Retailer(models.Model):
name = models.CharField(max_length=200)
slug = models.CharField(max_length=50)
date_created = models.DateTimeField(auto_now_add=True)
def __str__(self):
return self.name
class Brand(models.Model):
name = models.CharField(max_length=200)
slug = models.CharField(max_length=50)
date_created = models.DateTimeField(auto_now_add=True)
def __str__(self):
return self.name
class Product(models.Model):
name = models.CharField(max_length=200)
wired_name = models.CharField(max_length=200)
normalized_name = models.CharField(max_length=200)
brand = models.ForeignKey(Brand, null=True, on_delete=models.SET_NULL)
slug = models.CharField(max_length=250)
date_created = models.DateTimeField()
body_markdown = models.TextField(blank=True)
body_html = models.TextField(null=True, blank=True)
wired_price = models.IntegerField()
lowest_price_ever = models.IntegerField(null=True)
rating = models.IntegerField()
class Meta:
ordering = ('-date_created',)
def __str__(self):
return self.name
@property
def get_previous_admin_url(self):
n = self.get_previous_by_read_date()
return reverse('admin:%s_%s_change' % (self._meta.app_label, self._meta.model_name), args=[n.id])
@property
def get_next_admin_url(self):
model = apps.get_model(app_label=self._meta.app_label, model_name=self._meta.model_name)
try:
return reverse('admin:%s_%s_change' % (self._meta.app_label, self._meta.model_name), args=[self.get_next_by_read_date().pk])
except model.DoesNotExist:
return ''
def admin_thumbnail(self):
return format_html('<img src="%s" width="100" style="width:100px" />' % (self.featured_image.get_thumbnail_url()))
admin_thumbnail.short_description = 'Thumbnail'
def get_full_name(self):
return "%s %s" % (self.brand.name, self.name)
def save(self, *args, **kwargs):
super(Product, self).save()
class ProductLink(models.Model):
retailer = models.ForeignKey(Retailer, null=True, on_delete=models.SET_NULL)
url = models.CharField(max_length=255, blank=True, null=True)
date_last_checked = models.DateTimeField(blank=True, null=True)
date_created = models.DateTimeField(auto_now_add=True)
product = models.ForeignKey(Brand, null=True, on_delete=models.SET_NULL)
is_active = models.BooleanField(default=True)
class Meta:
ordering = ('date_last_checked',)
def __str__(self):
return self.url
|
