76 lines
3.7 KiB
Python
76 lines
3.7 KiB
Python
import uuid
|
|
from urllib.parse import urlsplit
|
|
from django.conf import settings
|
|
from django.db import models
|
|
|
|
|
|
class SavedItem(models.Model):
|
|
class Status(models.TextChoices):
|
|
SAVED = 'saved', 'Saved'
|
|
READ = 'read', 'Read'
|
|
ARCHIVED = 'archived', 'Archived'
|
|
|
|
class MetadataStatus(models.TextChoices):
|
|
PENDING = 'pending', 'Pending'
|
|
READY = 'ready', 'Ready'
|
|
ERROR = 'error', 'Error'
|
|
|
|
id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
|
|
owner = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, related_name='knowledge_items')
|
|
original_url = models.URLField(max_length=2048)
|
|
url_key = models.CharField(max_length=2048)
|
|
canonical_url = models.URLField(max_length=2048, blank=True)
|
|
title = models.CharField(max_length=300, blank=True)
|
|
user_description = models.TextField(blank=True)
|
|
extracted_title = models.CharField(max_length=300, blank=True)
|
|
description = models.TextField(blank=True)
|
|
thumbnail_url = models.URLField(max_length=2048, blank=True)
|
|
image_alt = models.CharField(max_length=300, blank=True)
|
|
site_name = models.CharField(max_length=120, blank=True)
|
|
favicon_url = models.URLField(max_length=2048, blank=True)
|
|
provider = models.CharField(max_length=40, blank=True)
|
|
embed_url = models.URLField(max_length=2048, blank=True)
|
|
preview_mode = models.CharField(max_length=12, choices=[('preview', 'Preview'), ('plain', 'Plain link'), ('embed', 'Playable embed')], default='preview')
|
|
notes = models.TextField(blank=True)
|
|
tags = models.JSONField(default=list, blank=True)
|
|
saved_reason = models.CharField(max_length=300, blank=True)
|
|
deferral_reason = models.CharField(max_length=120, blank=True)
|
|
status = models.CharField(max_length=12, choices=Status.choices, default=Status.SAVED)
|
|
metadata_status = models.CharField(max_length=12, choices=MetadataStatus.choices, default=MetadataStatus.PENDING)
|
|
metadata_error = models.CharField(max_length=200, blank=True)
|
|
metadata_fetched_at = models.DateTimeField(null=True, blank=True)
|
|
metadata_retry_at = models.DateTimeField(null=True, blank=True)
|
|
metadata_attempts = models.PositiveSmallIntegerField(default=0)
|
|
created_at = models.DateTimeField(auto_now_add=True)
|
|
updated_at = models.DateTimeField(auto_now=True)
|
|
read_at = models.DateTimeField(null=True, blank=True)
|
|
last_surfaced_at = models.DateTimeField(null=True, blank=True)
|
|
snoozed_until = models.DateTimeField(null=True, blank=True)
|
|
|
|
class Meta:
|
|
constraints = [models.UniqueConstraint(fields=['owner', 'url_key'], name='knowledge_owner_url_unique')]
|
|
indexes = [models.Index(fields=['owner', 'status', '-created_at']), models.Index(fields=['owner', 'last_surfaced_at'])]
|
|
ordering = ['-created_at']
|
|
|
|
@property
|
|
def domain(self):
|
|
return urlsplit(self.original_url).hostname or self.original_url
|
|
|
|
|
|
class CaptureToken(models.Model):
|
|
owner = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, related_name='knowledge_tokens')
|
|
name = models.CharField(max_length=80)
|
|
token_hash = models.CharField(max_length=64, unique=True)
|
|
created_at = models.DateTimeField(auto_now_add=True)
|
|
revoked_at = models.DateTimeField(null=True, blank=True)
|
|
|
|
|
|
class RediscoveryEvent(models.Model):
|
|
item = models.ForeignKey(SavedItem, on_delete=models.CASCADE, related_name='rediscovery_events')
|
|
channel = models.CharField(max_length=12, choices=[('mcp', 'MCP'), ('ntfy', 'ntfy')])
|
|
outcome = models.CharField(max_length=20)
|
|
created_at = models.DateTimeField(auto_now_add=True)
|
|
|
|
class Meta:
|
|
indexes = [models.Index(fields=['item', '-created_at'])]
|