models.py 6.0 KB

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