<commit_before># models.py

from django.db import models

class Client(models.Model):
    sequence = models.IntegerField(default=1)
    name = models.CharField(max_length=135)
    slug = models.CharField(max_length=135,help_text="dir name to store input files")

class Show(models.Model):
    client = models.ForeignKey(Client)
    sequence = models.IntegerField(default=1)
    name = models.CharField(max_length=135)

class Location(models.Model):
    sequence = models.IntegerField(default=1)
    show = models.ForeignKey(Show)
    name = models.CharField(max_length=135,help_text="room name")
    slug = models.CharField(max_length=135,help_text="dir name to store input files")

class Quality(models.Model):
    level = models.IntegerField()
    name = models.CharField(max_length=35)
    description = models.TextField(blank=True)

class Raw_File(models.Model):
    location = models.ForeignKey(Location)
    filename = models.CharField(max_length=135,help_text="pathname.dv")
    start = models.DateTimeField(null=True, blank=True, 
        help_text='when recorded (should agree with file name and timestamp)')
    end = models.DateTimeField(null=True, blank=True)
    comment = models.TextField(blank=True)

class Episode(models.Model):
    location = models.ForeignKey(Location)
    sequence = models.IntegerField(help_text="process order")
    primary = models.CharField(max_length=135,
        help_text="pointer to master version of event (name,desc,time,author,files,etc)")
    name = models.CharField(max_length=135, help_text="(synced from primary source)")
    description = models.TextField(blank=True, help_text="(synced from primary source)")
    slug = models.CharField(max_length=135,help_text="used for file name")
    start = models.DateTimeField(null=True, blank=True, 
        help_text="initially scheduled time from master, adjusted to match reality")
    end = models.DateTimeField(null=True, blank=True)
    video_quality = models.ForeignKey(Quality,related_name='video_quality')
    audio_quality = models.ForeignKey(Quality,related_name='audio_quality')
    comment = models.TextField(blank=True, help_text="production notes")

class Cut_List(models.Model):
    raw_file = models.ForeignKey(Raw_File)
    episode = models.ForeignKey(Episode)
    sequence = models.IntegerField(default=1)
    start = models.CharField(max_length=11, blank=True, 
        help_text='offset from start in HH:MM:SS.SS')
    end = models.CharField(max_length=11, blank=True,
        help_text='offset from start in HH:MM:SS.SS')
    comment = models.TextField(blank=True)

class State(models.Model):
    sequence = models.IntegerField(default=1)
    slug = models.CharField(max_length=30)
    description = models.CharField(max_length=135, blank=True)

class Log(models.Model):
    episode = models.ForeignKey(Episode)
    state = models.ForeignKey(State)
    ready = models.DateTimeField()
    start = models.DateTimeField(null=True, blank=True)
    end = models.DateTimeField(null=True, blank=True)
    result = models.CharField(max_length=130)



<commit_msg>authors is free form<commit_after># models.py

from django.db import models

class Client(models.Model):
    sequence = models.IntegerField(default=1)
    name = models.CharField(max_length=135)
    slug = models.CharField(max_length=135,help_text="dir name to store input files")

class Show(models.Model):
    client = models.ForeignKey(Client)
    sequence = models.IntegerField(default=1)
    name = models.CharField(max_length=135)

class Location(models.Model):
    sequence = models.IntegerField(default=1)
    show = models.ForeignKey(Show)
    name = models.CharField(max_length=135,help_text="room name")
    slug = models.CharField(max_length=135,help_text="dir name to store input files")

class Quality(models.Model):
    level = models.IntegerField()
    name = models.CharField(max_length=35)
    description = models.TextField(blank=True)

class Raw_File(models.Model):
    location = models.ForeignKey(Location)
    filename = models.CharField(max_length=135,help_text="pathname.dv")
    start = models.DateTimeField(null=True, blank=True, 
        help_text='when recorded (should agree with file name and timestamp)')
    end = models.DateTimeField(null=True, blank=True)
    comment = models.TextField(blank=True)

class Episode(models.Model):
    location = models.ForeignKey(Location)
    sequence = models.IntegerField(help_text="process order")
    primary = models.CharField(max_length=135,
        help_text="pointer to master version of event (name,desc,time,author,files,etc)")
    name = models.CharField(max_length=135, help_text="(synced from primary source)")
    slug = models.CharField(max_length=135,help_text="used for file name")
    authors = models.TextField(blank=True,)
    description = models.TextField(blank=True, help_text="(synced from primary source)")
    start = models.DateTimeField(null=True, blank=True, 
        help_text="initially scheduled time from master, adjusted to match reality")
    end = models.DateTimeField(null=True, blank=True)
    video_quality = models.ForeignKey(Quality,related_name='video_quality')
    audio_quality = models.ForeignKey(Quality,related_name='audio_quality')
    comment = models.TextField(blank=True, help_text="production notes")

class Cut_List(models.Model):
    raw_file = models.ForeignKey(Raw_File)
    episode = models.ForeignKey(Episode)
    sequence = models.IntegerField(default=1)
    start = models.CharField(max_length=11, blank=True, 
        help_text='offset from start in HH:MM:SS.SS')
    end = models.CharField(max_length=11, blank=True,
        help_text='offset from start in HH:MM:SS.SS')
    comment = models.TextField(blank=True)

class State(models.Model):
    sequence = models.IntegerField(default=1)
    slug = models.CharField(max_length=30)
    description = models.CharField(max_length=135, blank=True)

class Log(models.Model):
    episode = models.ForeignKey(Episode)
    state = models.ForeignKey(State)
    ready = models.DateTimeField()
    start = models.DateTimeField(null=True, blank=True)
    end = models.DateTimeField(null=True, blank=True)
    result = models.CharField(max_length=130)




{'fraction_non_alphanumeric': 0.11432262231551751, 'fraction_numerical': 0.014855481995801712, 'mean_word_length': 4.9443378119001915, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 6, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6154142', 'n_tokens_mistral': 1930, 'n_tokens_neox': 1860, 'n_words': 367}