Files
2026-10-21 15:25:33 +02:00

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'])]