2
0

models.py 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224
  1. __package__ = 'archivebox.core'
  2. import uuid
  3. from django.db import models, transaction
  4. from django.utils.functional import cached_property
  5. from django.utils.text import slugify
  6. from django.core.cache import cache
  7. from django.db.models import Case, When, Value, IntegerField
  8. from ..config import ARCHIVE_DIR, ARCHIVE_DIR_NAME
  9. from ..system import get_dir_size
  10. from ..util import parse_date, base_url, hashurl
  11. from ..index.schema import Link
  12. from ..extractors import get_default_archive_methods, ARCHIVE_METHODS_INDEXING_PRECEDENCE
  13. EXTRACTORS = [(extractor[0], extractor[0]) for extractor in get_default_archive_methods()]
  14. STATUS_CHOICES = [
  15. ("succeeded", "succeeded"),
  16. ("failed", "failed"),
  17. ("skipped", "skipped")
  18. ]
  19. try:
  20. JSONField = models.JSONField
  21. except AttributeError:
  22. import jsonfield
  23. JSONField = jsonfield.JSONField
  24. class Tag(models.Model):
  25. """
  26. Based on django-taggit model
  27. """
  28. name = models.CharField(verbose_name="name", unique=True, blank=False, max_length=100)
  29. slug = models.SlugField(verbose_name="slug", unique=True, max_length=100)
  30. class Meta:
  31. verbose_name = "Tag"
  32. verbose_name_plural = "Tags"
  33. def __str__(self):
  34. return self.name
  35. def slugify(self, tag, i=None):
  36. slug = slugify(tag)
  37. if i is not None:
  38. slug += "_%d" % i
  39. return slug
  40. def save(self, *args, **kwargs):
  41. if self._state.adding and not self.slug:
  42. self.slug = self.slugify(self.name)
  43. with transaction.atomic():
  44. slugs = set(
  45. type(self)
  46. ._default_manager.filter(slug__startswith=self.slug)
  47. .values_list("slug", flat=True)
  48. )
  49. i = None
  50. while True:
  51. slug = self.slugify(self.name, i)
  52. if slug not in slugs:
  53. self.slug = slug
  54. return super().save(*args, **kwargs)
  55. i = 1 if i is None else i+1
  56. else:
  57. return super().save(*args, **kwargs)
  58. class Snapshot(models.Model):
  59. id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
  60. url = models.URLField(unique=True)
  61. timestamp = models.CharField(max_length=32, unique=True, db_index=True)
  62. title = models.CharField(max_length=128, null=True, blank=True, db_index=True)
  63. added = models.DateTimeField(auto_now_add=True, db_index=True)
  64. updated = models.DateTimeField(auto_now=True, blank=True, null=True, db_index=True)
  65. tags = models.ManyToManyField(Tag)
  66. keys = ('url', 'timestamp', 'title', 'tags', 'updated')
  67. def __repr__(self) -> str:
  68. title = self.title or '-'
  69. return f'[{self.timestamp}] {self.url[:64]} ({title[:64]})'
  70. def __str__(self) -> str:
  71. title = self.title or '-'
  72. return f'[{self.timestamp}] {self.url[:64]} ({title[:64]})'
  73. @classmethod
  74. def from_json(cls, info: dict):
  75. info = {k: v for k, v in info.items() if k in cls.keys}
  76. return cls(**info)
  77. def as_json(self, *args) -> dict:
  78. args = args or self.keys
  79. return {
  80. key: getattr(self, key)
  81. if key != 'tags' else self.tags_str()
  82. for key in args
  83. }
  84. def as_link(self) -> Link:
  85. return Link.from_json(self.as_json())
  86. def as_link_with_details(self) -> Link:
  87. from ..index import load_link_details
  88. return load_link_details(self.as_link())
  89. def tags_str(self) -> str:
  90. cache_key = f'{self.id}-{(self.updated or self.added).timestamp()}-tags'
  91. calc_tags_str = lambda: ','.join(self.tags.order_by('name').values_list('name', flat=True))
  92. return cache.get_or_set(cache_key, calc_tags_str)
  93. @cached_property
  94. def bookmarked(self):
  95. return parse_date(self.timestamp)
  96. @cached_property
  97. def bookmarked_date(self):
  98. # TODO: remove this
  99. return self.bookmarked
  100. @cached_property
  101. def is_archived(self):
  102. return self.as_link().is_archived
  103. @cached_property
  104. def num_outputs(self):
  105. return self.archiveresult_set.filter(status='succeeded').count()
  106. @cached_property
  107. def url_hash(self):
  108. return hashurl(self.url)
  109. @cached_property
  110. def base_url(self):
  111. return base_url(self.url)
  112. @cached_property
  113. def link_dir(self):
  114. return str(ARCHIVE_DIR / self.timestamp)
  115. @cached_property
  116. def archive_path(self):
  117. return '{}/{}'.format(ARCHIVE_DIR_NAME, self.timestamp)
  118. @cached_property
  119. def archive_size(self):
  120. cache_key = f'{str(self.id)[:12]}-{(self.updated or self.added).timestamp()}-size'
  121. def calc_dir_size():
  122. try:
  123. return get_dir_size(self.link_dir)[0]
  124. except Exception:
  125. return 0
  126. return cache.get_or_set(cache_key, calc_dir_size)
  127. @cached_property
  128. def history(self):
  129. # TODO: use ArchiveResult for this instead of json
  130. return self.as_link_with_details().history
  131. @cached_property
  132. def latest_title(self):
  133. if self.title:
  134. return self.title
  135. try:
  136. return self.archiveresult_set.filter(extractor='title', status='succeeded')[0].output
  137. except ArchiveResult.DoesNotExist:
  138. pass
  139. if ('title' in self.history
  140. and self.history['title']
  141. and (self.history['title'][-1].status == 'succeeded')
  142. and self.history['title'][-1].output.strip()):
  143. return self.history['title'][-1].output.strip()
  144. return None
  145. def save_tags(self, tags=()):
  146. tags_id = []
  147. for tag in tags:
  148. tags_id.append(Tag.objects.get_or_create(name=tag)[0].id)
  149. self.tags.clear()
  150. self.tags.add(*tags_id)
  151. class ArchiveResultManager(models.Manager):
  152. def indexable(self, sorted: bool = True):
  153. INDEXABLE_METHODS = [ r[0] for r in ARCHIVE_METHODS_INDEXING_PRECEDENCE ]
  154. qs = self.get_queryset().filter(extractor__in=INDEXABLE_METHODS,status='succeeded')
  155. if sorted:
  156. precedence = [ When(extractor=method, then=Value(precedence)) for method, precedence in ARCHIVE_METHODS_INDEXING_PRECEDENCE ]
  157. qs = qs.annotate(indexing_precedence=Case(*precedence, default=Value(1000),output_field=IntegerField())).order_by('indexing_precedence')
  158. return qs
  159. class ArchiveResult(models.Model):
  160. id = models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')
  161. uuid = models.UUIDField(default=uuid.uuid4, editable=False)
  162. snapshot = models.ForeignKey(Snapshot, on_delete=models.CASCADE)
  163. cmd = JSONField()
  164. pwd = models.CharField(max_length=256)
  165. cmd_version = models.CharField(max_length=128, default=None, null=True, blank=True)
  166. output = models.CharField(max_length=1024)
  167. start_ts = models.DateTimeField(db_index=True)
  168. end_ts = models.DateTimeField()
  169. status = models.CharField(max_length=16, choices=STATUS_CHOICES)
  170. extractor = models.CharField(choices=EXTRACTORS, max_length=32)
  171. objects = ArchiveResultManager()
  172. def __str__(self):
  173. return self.extractor