mirror of
https://github.com/Findus23/cr-search.git
synced 2024-09-18 14:13:45 +02:00
91 lines
2.5 KiB
Python
91 lines
2.5 KiB
Python
from datetime import datetime
|
|
|
|
from peewee import IntegerField, CharField, BooleanField, ForeignKeyField, DateTimeField, \
|
|
DateField, TextField
|
|
from playhouse.postgres_ext import TSVectorField
|
|
|
|
from app import flask_db
|
|
|
|
|
|
class BaseModel(flask_db.Model):
|
|
...
|
|
|
|
|
|
class Series(BaseModel):
|
|
title = CharField(max_length=100)
|
|
slug = CharField(max_length=100)
|
|
order = IntegerField()
|
|
is_campaign = BooleanField()
|
|
single_speaker = BooleanField()
|
|
|
|
def __str__(self) -> str:
|
|
return f"<Series: {self.title}>"
|
|
|
|
|
|
class Episode(BaseModel):
|
|
series = ForeignKeyField(Series, backref="episodes", on_delete="CASCADE")
|
|
episode_number = IntegerField()
|
|
video_number = IntegerField()
|
|
youtube_id = CharField(max_length=11)
|
|
title = CharField(max_length=100)
|
|
pretty_title = CharField(max_length=100)
|
|
downloaded = BooleanField(default=False)
|
|
text_imported = BooleanField(default=False)
|
|
phrases_imported = BooleanField(default=False)
|
|
subtitle_hash = CharField(max_length=64, null=True)
|
|
upload_date = DateField()
|
|
last_updated = DateTimeField(default=datetime.now)
|
|
|
|
class Meta:
|
|
indexes = ((("series", "video_number"), True),)
|
|
|
|
@property
|
|
def name(self) -> str:
|
|
return f"C{self.season}E{self.episode_number:03d}"
|
|
|
|
def __str__(self) -> str:
|
|
return f"<Episode: {self.title}>"
|
|
|
|
|
|
class Person(BaseModel):
|
|
name = CharField()
|
|
color = CharField(null=True)
|
|
series = ForeignKeyField(Series, on_delete="CASCADE")
|
|
|
|
class Meta:
|
|
indexes = ((("name", "series"), True),)
|
|
|
|
def __str__(self) -> str:
|
|
return f"<Person: {self.name}>"
|
|
|
|
|
|
class Line(BaseModel):
|
|
text = TextField()
|
|
search_text = TSVectorField()
|
|
person = ForeignKeyField(Person, backref="lines", null=True, on_delete="CASCADE")
|
|
isnote = BooleanField(default=False)
|
|
ismeta = BooleanField(default=False)
|
|
starttime = IntegerField()
|
|
endtime = IntegerField()
|
|
episode = ForeignKeyField(Episode, backref="lines", on_delete="CASCADE")
|
|
order = IntegerField()
|
|
|
|
class Meta:
|
|
indexes = ((("episode", "order"), True),)
|
|
|
|
def __str__(self) -> str:
|
|
if self.is_dirty():
|
|
return f"<Line: {self.order} (dirty)>"
|
|
return f"<Line: {self.id}>"
|
|
|
|
|
|
class Phrase(BaseModel):
|
|
text = CharField()
|
|
count = IntegerField()
|
|
episode = ForeignKeyField(Episode, backref="phrase", on_delete="CASCADE")
|
|
|
|
class Meta:
|
|
indexes = ((("text", "episode"), True),)
|
|
|
|
def __str__(self) -> str:
|
|
return f"<Line: {self.text} ({self.pk})>"
|