<commit_before># This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#     * Rearrange models' order
#     * Make sure each model has one field with primary_key=True
# Feel free to rename the models, but don't rename db_table values or field names.
#
# Also note: You'll have to insert the output of 'django-admin.py sqlcustom [appname]'
# into your database.

from django.db import models


class Members(models.Model): 
    class Meta:
        db_table = u'members'
        verbose_name = u'member'
        verbose_name_plural = u'members'

    member_id = models.TextField(primary_key=True, editable=False) # This field type is a guess.
    legacy_id = models.TextField(blank=True) # This field type is a guess.
    full_name = models.CharField(max_length=255, blank=True)
    given_names = models.CharField(max_length=255, blank=True)
    family_name = models.CharField(max_length=255, blank=True)
    join_date = models.DateField(null=True, blank=True)
    city = models.CharField(max_length=255, blank=True)
    state = models.CharField(max_length=255, blank=True)
    region = models.CharField(max_length=255, blank=True)
    country = models.CharField(max_length=255)
    chapter = models.CharField(max_length=100, blank=True)
    chapter_id = models.TextField(blank=True) # This field type is a guess.
    occupation = models.CharField(max_length=100, blank=True)
    citizen = models.TextField() # This field type is a guess.
    password = models.CharField(max_length=255, blank=True)
    last_changed = models.DateTimeField(null=True, blank=True)
    def __unicode__(self):
        return u" %s (%s) " % (self.full_name, self.member_id, )

class Chapter(models.Model):
    chapter_code = models.CharField(max_length=4, primary_key=True, db_column=u'Chapter_Code') # x.
    chapter_descr = models.CharField(max_length=50, db_column=u'Chapter_Descr') # x.
    class Meta:
        db_table = u'chapter'

class Chapters(models.Model):
    member_id = models.TextField(primary_key=True) # This field type is a guess.
    name = models.CharField(max_length=255, blank=True)
    legacy_status = models.CharField(max_length=1, blank=True)
    code = models.CharField(max_length=4, blank=True)
    contact = models.CharField(max_length=255, blank=True)
    rep_id = models.TextField(blank=True) # This field type is a guess.
    url = models.CharField(max_length=255, blank=True)
    meeting_city = models.CharField(max_length=255, blank=True)
    contact_html = models.TextField(blank=True)
    contact_text = models.TextField(blank=True)
    meeting_text = models.TextField(blank=True)
    size = models.CharField(max_length=255, blank=True)
    events = models.TextField(blank=True)
    comments = models.TextField(blank=True)
    fees = models.CharField(max_length=255, blank=True)
    display = models.TextField() # This field type is a guess.
    class Meta:
        db_table = u'chapters'

class CommentsAuthors(models.Model):
    id = models.CharField(max_length=12, primary_key=True, db_column=u'Id') # x.
    last_name = models.CharField(max_length=50, db_column=u'Last_Name') # x.
    first_name = models.CharField(max_length=50, db_column=u'First_Name') # x.
    country = models.CharField(max_length=3, db_column=u'Country') # x.
    pin = models.TextField(db_column=u'PIN') # x. This field type is a guess.
    class Meta:
        db_table = u'comments_authors'

class Country(models.Model):
    country_code = models.CharField(max_length=2, primary_key=True, db_column=u'Country_Code') # x.
    country_descr = models.CharField(max_length=50, db_column=u'Country_Descr') # x.
    country_flag = models.CharField(max_length=4, db_column=u'Country_Flag', blank=True) # x.
    class Meta:
        db_table = u'country'

class Tournaments(models.Model):
    tournament_code = models.CharField(max_length=20, primary_key=True, db_column=u'Tournament_Code')
    description = models.TextField(db_column='Tournament_Descr')
    tournament_date = models.DateField(db_column=u'Tournament_Date')
    elab_date = models.DateField(db_column=u'Elab_Date')
    city = models.CharField(max_length=30, db_column=u'City')
    state = models.CharField(max_length=2, db_column=u'State_Code', blank=True)
    #country = models.ForeignKey(Country, db_column=u'Country_Code', related_name='tourneys_in_country')
    rounds = models.IntegerField(db_column='Rounds')
    total_players = models.IntegerField(db_column='Total_Players')
    wall_list = models.TextField(db_column='Wallist')
    def __str__(self):
        return "%s - on %s with %d players" % (self.tournament_code, self.tournament_date, self.total_players)
    def __unicode__(self):
        if self.description:
            if len(self.description) > 20:
                return u'%s...' % self.description[0:17]
            return u'%s' % self.description
        else:
            return u'%s' % self.pk

    class Meta: <commit_msg>by request... longer tourney names.<commit_after># This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#     * Rearrange models' order
#     * Make sure each model has one field with primary_key=True
# Feel free to rename the models, but don't rename db_table values or field names.
#
# Also note: You'll have to insert the output of 'django-admin.py sqlcustom [appname]'
# into your database.

from django.db import models


class Members(models.Model): 
    class Meta:
        db_table = u'members'
        verbose_name = u'member'
        verbose_name_plural = u'members'

    member_id = models.TextField(primary_key=True, editable=False) # This field type is a guess.
    legacy_id = models.TextField(blank=True) # This field type is a guess.
    full_name = models.CharField(max_length=255, blank=True)
    given_names = models.CharField(max_length=255, blank=True)
    family_name = models.CharField(max_length=255, blank=True)
    join_date = models.DateField(null=True, blank=True)
    city = models.CharField(max_length=255, blank=True)
    state = models.CharField(max_length=255, blank=True)
    region = models.CharField(max_length=255, blank=True)
    country = models.CharField(max_length=255)
    chapter = models.CharField(max_length=100, blank=True)
    chapter_id = models.TextField(blank=True) # This field type is a guess.
    occupation = models.CharField(max_length=100, blank=True)
    citizen = models.TextField() # This field type is a guess.
    password = models.CharField(max_length=255, blank=True)
    last_changed = models.DateTimeField(null=True, blank=True)
    def __unicode__(self):
        return u" %s (%s) " % (self.full_name, self.member_id, )

class Chapter(models.Model):
    chapter_code = models.CharField(max_length=4, primary_key=True, db_column=u'Chapter_Code') # x.
    chapter_descr = models.CharField(max_length=50, db_column=u'Chapter_Descr') # x.
    class Meta:
        db_table = u'chapter'

class Chapters(models.Model):
    member_id = models.TextField(primary_key=True) # This field type is a guess.
    name = models.CharField(max_length=255, blank=True)
    legacy_status = models.CharField(max_length=1, blank=True)
    code = models.CharField(max_length=4, blank=True)
    contact = models.CharField(max_length=255, blank=True)
    rep_id = models.TextField(blank=True) # This field type is a guess.
    url = models.CharField(max_length=255, blank=True)
    meeting_city = models.CharField(max_length=255, blank=True)
    contact_html = models.TextField(blank=True)
    contact_text = models.TextField(blank=True)
    meeting_text = models.TextField(blank=True)
    size = models.CharField(max_length=255, blank=True)
    events = models.TextField(blank=True)
    comments = models.TextField(blank=True)
    fees = models.CharField(max_length=255, blank=True)
    display = models.TextField() # This field type is a guess.
    class Meta:
        db_table = u'chapters'

class CommentsAuthors(models.Model):
    id = models.CharField(max_length=12, primary_key=True, db_column=u'Id') # x.
    last_name = models.CharField(max_length=50, db_column=u'Last_Name') # x.
    first_name = models.CharField(max_length=50, db_column=u'First_Name') # x.
    country = models.CharField(max_length=3, db_column=u'Country') # x.
    pin = models.TextField(db_column=u'PIN') # x. This field type is a guess.
    class Meta:
        db_table = u'comments_authors'

class Country(models.Model):
    country_code = models.CharField(max_length=2, primary_key=True, db_column=u'Country_Code') # x.
    country_descr = models.CharField(max_length=50, db_column=u'Country_Descr') # x.
    country_flag = models.CharField(max_length=4, db_column=u'Country_Flag', blank=True) # x.
    class Meta:
        db_table = u'country'

class Tournaments(models.Model):
    tournament_code = models.CharField(max_length=20, primary_key=True, db_column=u'Tournament_Code')
    description = models.TextField(db_column='Tournament_Descr')
    tournament_date = models.DateField(db_column=u'Tournament_Date')
    elab_date = models.DateField(db_column=u'Elab_Date')
    city = models.CharField(max_length=30, db_column=u'City')
    state = models.CharField(max_length=2, db_column=u'State_Code', blank=True)
    #country = models.ForeignKey(Country, db_column=u'Country_Code', related_name='tourneys_in_country')
    rounds = models.IntegerField(db_column='Rounds')
    total_players = models.IntegerField(db_column='Total_Players')
    wall_list = models.TextField(db_column='Wallist')
    def __str__(self):
        return "%s - on %s with %d players" % (self.tournament_code, self.tournament_date, self.total_players)
    def __unicode__(self):
        if self.description:
            if len(self.description) > 40:
                return u'%s...' % self.description[0:37]
            return u'%s' % self.description
        else:
            return u'%s' % self.pk

    class Meta: 
{'fraction_non_alphanumeric': 0.11388832896593429, 'fraction_numerical': 0.014916347510582543, 'mean_word_length': 4.281000532197978, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6313083', 'n_tokens_mistral': 3326, 'n_tokens_neox': 3207, 'n_words': 686}