<gh_stars>0
from django.db import models
from django.apps import AppConfig

# Create your models here.

'''class Article(models.Model):
    title = models.TextField(help_text="Enter Article Title")
    article_slug = models.TextField(help_text="Enter Article Slug Here", default="")
    authors = models.ManyToManyField('Author', help_text="Select Author Names") # dropdown for authors - could get unwieldy? evaluate later ... searchable?
    tags = models.ManyToManyField('Tags', help_text="Tags for this Article")
    sections = models.ManyToManyField("Sections", help_text="Article Sections")
    pubdate = models.DateField(auto_now=True) #use for last-modified time stamps

    metadata_article = models.DateField(auto_now = True)

    #comments and images as a ForeignKeyField ?
    text = models.TextField(help_text="Article Text Goes Here", default="la la la") #django is unhappy if we don't define max length
    article_id = models.AutoField(primary_key=True) # automatically generate a unique Article ID, increments

    PUB_STATUS = (
        ('d', 'Draft'),
        ('p', 'Published'),
    )

    status = models.CharField(max_length=1, choices=PUB_STATUS, blank=True, default='d', help_text='Publication Status')

    # Metadata
    class Meta:
        ordering = ["-pubdate"]

    # Methods
    def get_absolute_url(self):
        #Returns the url to access a particular instance of MyModelName.
        return reverse('article-detail', args=[str(self.id)])

    def __str__(self):
        return self.title

    def disp_authors(self):
        return ', '.join([ author.first_name + " " + author.last_name for author in self.authors.all()[:3] ])
    disp_authors.short_description = 'Authors'

class Tags(models.Model):
    tag_value = models.CharField(max_length=1000)
    number_of_contents_with_tag = models.IntegerField()

class Sections(models.Model):
    name = models.CharField(help_text="Section Name", max_length=100)

class Author(models.Model):
    """
    Model representing an author.
    """
    first_name = models.CharField(max_length=1000)
    last_name = models.CharField(max_length=1000)
    #description = models.CharField(max_length=1000)
    #articles = models.ManyToManyField(Article)

    AUTHOR_RANK = (
        ('con', 'Contributing Writer'),
        ('ssw', 'Senior Staff Writer'),
        ('stw', 'Staff Writer'),
    )

    articles = models.ManyToManyField('Article', help_text="Select Articles Names") # dropdown for authors - could get unwieldy? evaluate later ... searchable?
    rank = models.CharField(max_length=3, choices=AUTHOR_RANK, blank=True, default='con', help_text='Author Rank')

    AUTHOR_YEAR = (
        ('fr', 'Freshman'),
        ('so', 'Sophomore'),
        ('ju', 'Junior'),
        ('se', 'Senior'),
        ('gs', 'Graduate Student'),
    )

    #year = models.CharField(max_length=2, choices=AUTHOR_YEAR, blank=True, default='', help_text='Author Year')

    class Meta:
        ordering = ["last_name","first_name"]

    def get_absolute_url(self):
        """
        Returns the url to access a particular author instance.
        """
        return reverse('author-detail', args=[str(self.id)])


    def __str__(self):
        """
        String for representing the Model object.
        """
        return '{0} {1}, {2}'.format(self.first_name,self.last_name,self.year)
'''
###add in utility methods to get stuff from the database - for testing, instantiate the local db


#START OF NEW MODELS
#NOTE: This is not 100% finalized


class Author(models.Model):
    #id = models.IntegerField(primary_key=True)
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)
    pathtopicture = models.CharField(max_length=100, blank=True, null=True)
    email = models.CharField(max_length=100, blank=True, null=True)
    since = models.DateField()
    about = models.TextField()
    valid = models.BooleanField()
    maybewrong = models.BooleanField(default = False)


    #class Meta:
    #    managed = False
    #    db_table = 'Author'

class Image(models.Model):
    #id = models.IntegerField(primary_key=True)
    file_path = models.CharField(max_length=300)




class Category(models.Model):
    parent = models.ForeignKey('self', models.DO_NOTHING, blank=True, null=True)
    name = models.CharField(max_length=100, blank=True, null=True)
    visible = models.BooleanField(default = True)



class Tag(models.Model):
    name = models.CharField(unique=True, max_length=50)

    #class Meta:
    #    managed = False
    #    db_table = 'Topic'


class Article(models.Model):
    #id = models.IntegerField(primary_key=True)
    body = models.TextField(default = "")
    title = models.CharField(max_length=100)
    #posted_date = models.DateField(auto_now=True)
    #modified_date = models.DateField(auto_now_add=True)
    posted_date = models.DateField()
    modified_date = models.DateField()
    authors = models.ManyToManyField(Author)
    image_url = models.ManyToManyField(Image)
    category = models.ForeignKey(Category, on_delete=models.PROTECT)
    topic = models.ManyToManyField(Tag)
    maybewrong = models.BooleanField(default = False)


'''class AuthGroup(models.Model):
    name = models.CharField(unique=True, max_length=80)

    class Meta:
        managed = False
        db_table = 'auth_group'
'''


'''class AuthGroupPermissions(models.Model):
    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)
    permission = models.ForeignKey('AuthPermission', models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_group_permissions'
        unique_together = (('group', 'permission'),)'''


'''class AuthPermission(models.Model):
    name = models.CharField(max_length=255)
    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING)
    codename = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'auth_permission'
        unique_together = (('content_type', 'codename'),)
'''


'''
class AuthUser(models.Model):
    password = models.CharField(max_length=128)
    last_login = models.DateTimeField(blank=True, null=True)
    is_superuser = models.IntegerField()
    username = models.CharField(unique=True, max_length=150)
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=150)
    email = models.CharField(max_length=254)
    is_staff = models.IntegerField()
    is_active = models.IntegerField()
    date_joined = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'auth_user'


class AuthUserGroups(models.Model):
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_user_groups'
        unique_together = (('user', 'group'),)


class AuthUserUserPermissions(models.Model):
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
    permission = models.ForeignKey(AuthPermission, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_user_user_permissions'
        unique_together = (('user', 'permission'),)


class DjangoAdminLog(models.Model):
    action_time = models.DateTimeField()
    object_id = models.TextField(blank=True, null=True)
    object_repr = models.CharField(max_length=200)
    action_flag = models.PositiveSmallIntegerField()
    change_message = models.TextField()
    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True)
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'django_admin_log'


class DjangoContentType(models.Model):
    app_label = models.CharField(max_length=100)
    model = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'django_content_type'
        unique_together = (('app_label', 'model'),)


class DjangoMigrations(models.Model):
    app = models.CharField(max_length=255)
    name = models.CharField(max_length=255)
    applied = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'django_migrations'


class DjangoSession(models.Model):
    session_key = models.CharField(primary_key=True, max_length=40)
    session_data = models.TextField()
    expire_date = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'django_session'

'''



#END OF NEW MODELS
from django.shortcuts import get_object_or_404
from wagtail.contrib.forms.models import AbstractEmailForm, AbstractFormField
from wagtail.core.models import Page, Orderable
from wagtail.core.fields import RichTextField
from wagtail.api import APIField
from wagtail.api.v2.serializers import PageSerializer
from wagtail.admin.edit_handlers import FieldPanel, FieldRowPanel, InlinePanel, MultiFieldPanel
from wagtail.contrib.routable_page.models import RoutablePageMixin, route
from django.forms import ModelForm
from pprint import pprint #debugging

from wagtail.search import index

from wagtail.contrib.forms.models import AbstractEmailForm, AbstractFormField
from modelcluster.fields import ParentalKey

from wagtail.images.edit_handlers import ImageChooserPanel
from wagtail.images.models import Image


import datetime

class AuthorsPage(RoutablePageMixin, Page):

    name = models.CharField(max_length=255)
    lastName = models.CharField(max_length=255)
    description = RichTextField(blank=True)
    pathtopicture = models.CharField(max_length=100, blank=True, null=True)
    email = models.CharField(max_length=100, blank=True, null=True)
    since = models.DateField(default = datetime.datetime.now())
    valid = models.BooleanField(default = True)
    maybewrong = models.BooleanField(default = False)

    image = models.ForeignKey(
        'wagtailimages.Image',
        null=True,
        blank=True,
        on_delete=models.SET_NULL,
        related_name='+'
    )

    author_rank = (
        ('con','Contributing Writer'),
        ('sw', 'Staff Writer'),
        ('ssw', 'Senior Staff Writer'),
        ('sre', 'Senior Reporter'),
        ('ned', 'News Editor'),
        ('sre', 'Science & Research Editor'),
        ('ace', 'Arts & Culture Editor'),
        ('spe', 'Sports Editor'),
        ('epb', 'Editorial Page Board'),
        ('eb', 'Editorial Board'),
        ('sc' , 'Staff Columnist'),
        ('oc', 'Op-Ed Contributor'),
    )

    author_year = (
        ('fr', 'First-Year'),
        ('so', 'Sophomore'),
        ('ju', 'Junior'),
        ('se', 'Senior'),
        ('gs', 'Graduate Student'),
    )

    position = models.CharField(max_length=3, choices=author_rank, blank=True, default='con')
    year = models.CharField(max_length=5, choices=author_year, blank=True, default='fr',)

    content_panels = Page.content_panels + [
        FieldPanel('name', classname='class'),
        FieldPanel('lastName', classname='class'),
        FieldPanel('description', classname='class'),
        FieldPanel('position', classname='class'),
        FieldPanel('year', classname='class'),
        ImageChooserPanel('image', classname='image')
    ]

    api_fields = [
        APIField('name'),
        APIField('lastName'),
        APIField('description'),
        APIField('position'),
        APIField('year'),
        APIField('image'),
        APIField('articles'),
    ]

from modelcluster.fields import ParentalKey
from modelcluster.contrib.taggit import ClusterTaggableManager
from taggit.models import TaggedItemBase

class ArticleTag(TaggedItemBase):
    content_object = ParentalKey(
        'ArticlePage',
        related_name='tagged_items',
        on_delete=models.CASCADE
    )

class ArticlePage(RoutablePageMixin, Page):

    sum_deck = models.CharField(max_length=1000)
    content = RichTextField(blank=True)

    yes_no = {
            ('y', 'Yes'),
            ('n', 'No'),
        }

    draft = models.CharField(max_length=2, choices=yes_no, blank=True, default='n')

    section_list = (
                ('unews', 'University News'),
                ('metro', 'Metro'),
                ('sr', 'Science & Research'),
                ('ac', 'Arts & Culture'),
                ('sports', 'Sports'),
                ('sportscol', 'Sports Columns'),
                ('opinion', 'Opinion'),
                ('col', 'Columns'),
                ('edit', 'Editorials'),
                ('letter', 'Letters to the Editor'),
                ('notes', "Editors' Note"),
                ('mult', 'Multimedia'),
                ('vid', 'Video'),
                ('gal', 'Photo Gallery'),
                ('igraph', 'Interactive Graphic'),
                ('news', 'News'),
                ('graph', 'Graphics'),
                ('ill', 'Illustrations'),
                ('op', 'Op-eds'),
                ('data', 'Data Science'),
                ('com', 'Comics'),
                # add more to this list
            )

    featured_image = models.ForeignKey(
        'wagtailimages.Image',
        null=True,
        blank=True,
        on_delete=models.SET_NULL,
        related_name='+'
    )

    tags = ClusterTaggableManager(through=ArticleTag, blank=True)
    section = models.CharField(max_length=8, choices=section_list, blank=True, default='h')

    nums = {
        ('1', 'Primary'),
        ('2', 'Secondary'),
        ('3', 'Tertiary'),
    }

    featured_on_main = models.CharField(max_length=2, choices=yes_no, blank=True, default='n')
    position_on_main = models.CharField(max_length=1, choices=nums, blank=True)

    api_fields = [
        APIField('sum_deck'),
        APIField('content'),
        APIField('draft'),
        APIField('section'),
        APIField('featured_on_main'),
        APIField('position_on_main'),
        APIField('tags'),
        APIField('authors'),
        APIField('featured_image'),
        APIField('gallery_images')
    ]

    content_panels = Page.content_panels + [
        FieldPanel('section', classname='class'),
        FieldPanel('sum_deck', classname='class'),
        FieldPanel('draft', classname='class'),
        FieldPanel('featured_on_main', classname='class'),
        FieldPanel('position_on_main', classname='class'),
        FieldPanel('tags'),
        InlinePanel('authors', heading='authors', help_text='Add contributing authors'),
        FieldPanel('content', classname='class'),
        ImageChooserPanel('featured_image', classname='image'),
        InlinePanel('gallery_images', label="Photo Gallery Images"),
    ]

    search_fields = Page.search_fields + [
        index.SearchField('content'),
        index.SearchField('section'),
        index.SearchField('sum_deck'),
        index.SearchField('tags'),
        index.SearchField('authors'),
    ]

class ArticlePageGalleryImage(Orderable):
    page = ParentalKey(ArticlePage, related_name='gallery_images')
    image = models.ForeignKey(
        'wagtailimages.Image', on_delete=models.CASCADE, related_name='+'
    )
    caption = models.CharField(blank=True, max_length=250)

    panels = [
        ImageChooserPanel('image'),
        FieldPanel('caption'),
    ]

    api_fields = [
        APIField('image', serializer=PageSerializer)
    ]


class ArticleAuthorRelationship(models.Model):
    """

    Intermediate table supporting ManyToMany between Articles and Authors
    (Wagtail does not by default support this)

    i.e. an article with 3 authors will create 3 rows in this table
    """

    article = ParentalKey(
        'ArticlePage',
        related_name='authors'
    )

    author = models.ForeignKey(
        'AuthorsPage',
        related_name='articles',
        on_delete=models.PROTECT
    )

    panels = [
        FieldPanel('author')
    ]

    api_fields = [
        APIField('author', serializer=PageSerializer)
    ]


class FormField(AbstractFormField):
    page = ParentalKey('FormPage', on_delete=models.CASCADE, related_name='form_fields')

class FormPage(AbstractEmailForm):

    #isTipPage = models.BooleanField()

    content = models.CharField(max_length=500)

    content_panels = AbstractEmailForm.content_panels + [
        InlinePanel('form_fields', label="Form fields"),
        MultiFieldPanel([
            FieldRowPanel([
                FieldPanel('from_address', classname="col6"),
                FieldPanel('to_address', classname="col6"),
            ]),
            FieldPanel('subject'),
            FieldPanel('content'),
        ], "Email"),
    ]

from django.db import models
from django.apps import AppConfig

# Create your models here.

'''class Article(models.Model):
    title = models.TextField(help_text="Enter Article Title")
    article_slug = models.TextField(help_text="Enter Article Slug Here", default="")
    authors = models.ManyToManyField('Author', help_text="Select Author Names") # dropdown for authors - could get unwieldy? evaluate later ... searchable?
    tags = models.ManyToManyField('Tags', help_text="Tags for this Article")
    sections = models.ManyToManyField("Sections", help_text="Article Sections")
    pubdate = models.DateField(auto_now=True) #use for last-modified time stamps

    metadata_article = models.DateField(auto_now = True)

    #comments and images as a ForeignKeyField ?
    text = models.TextField(help_text="Article Text Goes Here", default="la la la") #django is unhappy if we don't define max length
    article_id = models.AutoField(primary_key=True) # automatically generate a unique Article ID, increments

    PUB_STATUS = (
        ('d', 'Draft'),
        ('p', 'Published'),
    )

    status = models.CharField(max_length=1, choices=PUB_STATUS, blank=True, default='d', help_text='Publication Status')

    # Metadata
    class Meta:
        ordering = ["-pubdate"]

    # Methods
    def get_absolute_url(self):
        #Returns the url to access a particular instance of MyModelName.
        return reverse('article-detail', args=[str(self.id)])

    def __str__(self):
        return self.title

    def disp_authors(self):
        return ', '.join([ author.first_name + " " + author.last_name for author in self.authors.all()[:3] ])
    disp_authors.short_description = 'Authors'

class Tags(models.Model):
    tag_value = models.CharField(max_length=1000)
    number_of_contents_with_tag = models.IntegerField()

class Sections(models.Model):
    name = models.CharField(help_text="Section Name", max_length=100)

class Author(models.Model):
    """
    Model representing an author.
    """
    first_name = models.CharField(max_length=1000)
    last_name = models.CharField(max_length=1000)
    #description = models.CharField(max_length=1000)
    #articles = models.ManyToManyField(Article)

    AUTHOR_RANK = (
        ('con', 'Contributing Writer'),
        ('ssw', 'Senior Staff Writer'),
        ('stw', 'Staff Writer'),
    )

    articles = models.ManyToManyField('Article', help_text="Select Articles Names") # dropdown for authors - could get unwieldy? evaluate later ... searchable?
    rank = models.CharField(max_length=3, choices=AUTHOR_RANK, blank=True, default='con', help_text='Author Rank')

    AUTHOR_YEAR = (
        ('fr', 'Freshman'),
        ('so', 'Sophomore'),
        ('ju', 'Junior'),
        ('se', 'Senior'),
        ('gs', 'Graduate Student'),
    )

    #year = models.CharField(max_length=2, choices=AUTHOR_YEAR, blank=True, default='', help_text='Author Year')

    class Meta:
        ordering = ["last_name","first_name"]

    def get_absolute_url(self):
        """
        Returns the url to access a particular author instance.
        """
        return reverse('author-detail', args=[str(self.id)])


    def __str__(self):
        """
        String for representing the Model object.
        """
        return '{0} {1}, {2}'.format(self.first_name,self.last_name,self.year)
'''
###add in utility methods to get stuff from the database - for testing, instantiate the local db


#START OF NEW MODELS
#NOTE: This is not 100% finalized


class Author(models.Model):
    #id = models.IntegerField(primary_key=True)
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)
    pathtopicture = models.CharField(max_length=100, blank=True, null=True)
    email = models.CharField(max_length=100, blank=True, null=True)
    since = models.DateField()
    about = models.TextField()
    valid = models.BooleanField()
    maybewrong = models.BooleanField(default = False)


    #class Meta:
    #    managed = False
    #    db_table = 'Author'

class Image(models.Model):
    #id = models.IntegerField(primary_key=True)
    file_path = models.CharField(max_length=300)




class Category(models.Model):
    parent = models.ForeignKey('self', models.DO_NOTHING, blank=True, null=True)
    name = models.CharField(max_length=100, blank=True, null=True)
    visible = models.BooleanField(default = True)



class Tag(models.Model):
    name = models.CharField(unique=True, max_length=50)

    #class Meta:
    #    managed = False
    #    db_table = 'Topic'


class Article(models.Model):
    #id = models.IntegerField(primary_key=True)
    body = models.TextField(default = "")
    title = models.CharField(max_length=100)
    #posted_date = models.DateField(auto_now=True)
    #modified_date = models.DateField(auto_now_add=True)
    posted_date = models.DateField()
    modified_date = models.DateField()
    authors = models.ManyToManyField(Author)
    image_url = models.ManyToManyField(Image)
    category = models.ForeignKey(Category, on_delete=models.PROTECT)
    topic = models.ManyToManyField(Tag)
    maybewrong = models.BooleanField(default = False)


'''class AuthGroup(models.Model):
    name = models.CharField(unique=True, max_length=80)

    class Meta:
        managed = False
        db_table = 'auth_group'
'''


'''class AuthGroupPermissions(models.Model):
    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)
    permission = models.ForeignKey('AuthPermission', models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_group_permissions'
        unique_together = (('group', 'permission'),)'''


'''class AuthPermission(models.Model):
    name = models.CharField(max_length=255)
    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING)
    codename = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'auth_permission'
        unique_together = (('content_type', 'codename'),)
'''


'''
class AuthUser(models.Model):
    password = models.CharField(max_length=128)
    last_login = models.DateTimeField(blank=True, null=True)
    is_superuser = models.IntegerField()
    username = models.CharField(unique=True, max_length=150)
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=150)
    email = models.CharField(max_length=254)
    is_staff = models.IntegerField()
    is_active = models.IntegerField()
    date_joined = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'auth_user'


class AuthUserGroups(models.Model):
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_user_groups'
        unique_together = (('user', 'group'),)


class AuthUserUserPermissions(models.Model):
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
    permission = models.ForeignKey(AuthPermission, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_user_user_permissions'
        unique_together = (('user', 'permission'),)


class DjangoAdminLog(models.Model):
    action_time = models.DateTimeField()
    object_id = models.TextField(blank=True, null=True)
    object_repr = models.CharField(max_length=200)
    action_flag = models.PositiveSmallIntegerField()
    change_message = models.TextField()
    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True)
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'django_admin_log'


class DjangoContentType(models.Model):
    app_label = models.CharField(max_length=100)
    model = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'django_content_type'
        unique_together = (('app_label', 'model'),)


class DjangoMigrations(models.Model):
    app = models.CharField(max_length=255)
    name = models.CharField(max_length=255)
    applied = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'django_migrations'


class DjangoSession(models.Model):
    session_key = models.CharField(primary_key=True, max_length=40)
    session_data = models.TextField()
    expire_date = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'django_session'

'''



#END OF NEW MODELS
from django.shortcuts import get_object_or_404
from wagtail.contrib.forms.models import AbstractEmailForm, AbstractFormField
from wagtail.core.models import Page, Orderable
from wagtail.core.fields import RichTextField
from wagtail.api import APIField
from wagtail.api.v2.serializers import PageSerializer
from wagtail.admin.edit_handlers import FieldPanel, FieldRowPanel, InlinePanel, MultiFieldPanel
from wagtail.contrib.routable_page.models import RoutablePageMixin, route
from django.forms import ModelForm
from pprint import pprint #debugging

from wagtail.search import index

from wagtail.contrib.forms.models import AbstractEmailForm, AbstractFormField
from modelcluster.fields import ParentalKey

from wagtail.images.edit_handlers import ImageChooserPanel
from wagtail.images.models import Image


import datetime

class AuthorsPage(RoutablePageMixin, Page):

    name = models.CharField(max_length=255)
    lastName = models.CharField(max_length=255)
    description = RichTextField(blank=True)
    pathtopicture = models.CharField(max_length=100, blank=True, null=True)
    email = models.CharField(max_length=100, blank=True, null=True)
    since = models.DateField(default = datetime.datetime.now())
    valid = models.BooleanField(default = True)
    maybewrong = models.BooleanField(default = False)

    image = models.ForeignKey(
        'wagtailimages.Image',
        null=True,
        blank=True,
        on_delete=models.SET_NULL,
        related_name='+'
    )

    author_rank = (
        ('con','Contributing Writer'),
        ('sw', 'Staff Writer'),
        ('ssw', 'Senior Staff Writer'),
        ('sre', 'Senior Reporter'),
        ('ned', 'News Editor'),
        ('sre', 'Science & Research Editor'),
        ('ace', 'Arts & Culture Editor'),
        ('spe', 'Sports Editor'),
        ('epb', 'Editorial Page Board'),
        ('eb', 'Editorial Board'),
        ('sc' , 'Staff Columnist'),
        ('oc', 'Op-Ed Contributor'),
    )

    author_year = (
        ('fr', 'First-Year'),
        ('so', 'Sophomore'),
        ('ju', 'Junior'),
        ('se', 'Senior'),
        ('gs', 'Graduate Student'),
    )

    position = models.CharField(max_length=3, choices=author_rank, blank=True, default='con')
    year = models.CharField(max_length=5, choices=author_year, blank=True, default='fr',)

    content_panels = Page.content_panels + [
        FieldPanel('name', classname='class'),
        FieldPanel('lastName', classname='class'),
        FieldPanel('description', classname='class'),
        FieldPanel('position', classname='class'),
        FieldPanel('year', classname='class'),
        ImageChooserPanel('image', classname='image')
    ]

    api_fields = [
        APIField('name'),
        APIField('lastName'),
        APIField('description'),
        APIField('position'),
        APIField('year'),
        APIField('image'),
        APIField('articles'),
    ]

from modelcluster.fields import ParentalKey
from modelcluster.contrib.taggit import ClusterTaggableManager
from taggit.models import TaggedItemBase

class ArticleTag(TaggedItemBase):
    content_object = ParentalKey(
        'ArticlePage',
        related_name='tagged_items',
        on_delete=models.CASCADE
    )

class ArticlePage(RoutablePageMixin, Page):

    sum_deck = models.CharField(max_length=1000)
    content = RichTextField(blank=True)

    yes_no = {
            ('y', 'Yes'),
            ('n', 'No'),
        }

    draft = models.CharField(max_length=2, choices=yes_no, blank=True, default='n')

    section_list = (
                ('unews', 'University News'),
                ('metro', 'Metro'),
                ('sr', 'Science & Research'),
                ('ac', 'Arts & Culture'),
                ('sports', 'Sports'),
                ('sportscol', 'Sports Columns'),
                ('opinion', 'Opinion'),
                ('col', 'Columns'),
                ('edit', 'Editorials'),
                ('letter', 'Letters to the Editor'),
                ('notes', "Editors' Note"),
                ('mult', 'Multimedia'),
                ('vid', 'Video'),
                ('gal', 'Photo Gallery'),
                ('igraph', 'Interactive Graphic'),
                ('news', 'News'),
                ('graph', 'Graphics'),
                ('ill', 'Illustrations'),
                ('op', 'Op-eds'),
                ('data', 'Data Science'),
                ('com', 'Comics'),
                # add more to this list
            )

    featured_image = models.ForeignKey(
        'wagtailimages.Image',
        null=True,
        blank=True,
        on_delete=models.SET_NULL,
        related_name='+'
    )

    tags = ClusterTaggableManager(through=ArticleTag, blank=True)
    section = models.CharField(max_length=8, choices=section_list, blank=True, default='h')

    nums = {
        ('1', 'Primary'),
        ('2', 'Secondary'),
        ('3', 'Tertiary'),
    }

    featured_on_main = models.CharField(max_length=2, choices=yes_no, blank=True, default='n')
    position_on_main = models.CharField(max_length=1, choices=nums, blank=True)

    api_fields = [
        APIField('sum_deck'),
        APIField('content'),
        APIField('draft'),
        APIField('section'),
        APIField('featured_on_main'),
        APIField('position_on_main'),
        APIField('tags'),
        APIField('authors'),
        APIField('featured_image'),
        APIField('gallery_images')
    ]

    content_panels = Page.content_panels + [
        FieldPanel('section', classname='class'),
        FieldPanel('sum_deck', classname='class'),
        FieldPanel('draft', classname='class'),
        FieldPanel('featured_on_main', classname='class'),
        FieldPanel('position_on_main', classname='class'),
        FieldPanel('tags'),
        InlinePanel('authors', heading='authors', help_text='Add contributing authors'),
        FieldPanel('content', classname='class'),
        ImageChooserPanel('featured_image', classname='image'),
        InlinePanel('gallery_images', label="Photo Gallery Images"),
    ]

    search_fields = Page.search_fields + [
        index.SearchField('content'),
        index.SearchField('section'),
        index.SearchField('sum_deck'),
        index.SearchField('tags'),
        index.SearchField('authors'),
    ]

class ArticlePageGalleryImage(Orderable):
    page = ParentalKey(ArticlePage, related_name='gallery_images')
    image = models.ForeignKey(
        'wagtailimages.Image', on_delete=models.CASCADE, related_name='+'
    )
    caption = models.CharField(blank=True, max_length=250)

    panels = [
        ImageChooserPanel('image'),
        FieldPanel('caption'),
    ]

    api_fields = [
        APIField('image', serializer=PageSerializer)
    ]


class ArticleAuthorRelationship(models.Model):
    """

    Intermediate table supporting ManyToMany between Articles and Authors
    (Wagtail does not by default support this)

    i.e. an article with 3 authors will create 3 rows in this table
    """

    article = ParentalKey(
        'ArticlePage',
        related_name='authors'
    )

    author = models.ForeignKey(
        'AuthorsPage',
        related_name='articles',
        on_delete=models.PROTECT
    )

    panels = [
        FieldPanel('author')
    ]

    api_fields = [
        APIField('author', serializer=PageSerializer)
    ]


class FormField(AbstractFormField):
    page = ParentalKey('FormPage', on_delete=models.CASCADE, related_name='form_fields')

class FormPage(AbstractEmailForm):

    #isTipPage = models.BooleanField()

    content = models.CharField(max_length=500)

    content_panels = AbstractEmailForm.content_panels + [
        InlinePanel('form_fields', label="Form fields"),
        MultiFieldPanel([
            FieldRowPanel([
                FieldPanel('from_address', classname="col6"),
                FieldPanel('to_address', classname="col6"),
            ]),
            FieldPanel('subject'),
            FieldPanel('content'),
        ], "Email"),
    ]
# Create your models here. class Article(models.Model):     title = models.TextField(help_text="Enter Article Title")     article_slug = models.TextField(help_text="Enter Article Slug Here", default="")     authors = models.ManyToManyField('Author', help_text="Select Author Names") # dropdown for authors - could get unwieldy? evaluate later ... searchable?     tags = models.ManyToManyField('Tags', help_text="Tags for this Article")     sections = models.ManyToManyField("Sections", help_text="Article Sections")     pubdate = models.DateField(auto_now=True) #use for last-modified time stamps      metadata_article = models.DateField(auto_now = True)      #comments and images as a ForeignKeyField ?     text = models.TextField(help_text="Article Text Goes Here", default="la la la") #django is unhappy if we don't define max length     article_id = models.AutoField(primary_key=True) # automatically generate a unique Article ID, increments      PUB_STATUS = (         ('d', 'Draft'),         ('p', 'Published'),     )      status = models.CharField(max_length=1, choices=PUB_STATUS, blank=True, default='d', help_text='Publication Status')      # Metadata     class Meta:         ordering = ["-pubdate"]      # Methods     def get_absolute_url(self):         #Returns the url to access a particular instance of MyModelName.         return reverse('article-detail', args=[str(self.id)])      def __str__(self):         return self.title      def disp_authors(self):         return ', '.join([ author.first_name + " " + author.last_name for author in self.authors.all()[:3] ])     disp_authors.short_description = 'Authors'  class Tags(models.Model):     tag_value = models.CharField(max_length=1000)     number_of_contents_with_tag = models.IntegerField()  class Sections(models.Model):     name = models.CharField(help_text="Section Name", max_length=100)  class Author(models.Model):     """     Model representing an author.     """     first_name = models.CharField(max_length=1000)     last_name = models.CharField(max_length=1000)     #description = models.CharField(max_length=1000)     #articles = models.ManyToManyField(Article)      AUTHOR_RANK = (         ('con', 'Contributing Writer'),         ('ssw', 'Senior Staff Writer'),         ('stw', 'Staff Writer'),     )      articles = models.ManyToManyField('Article', help_text="Select Articles Names") # dropdown for authors - could get unwieldy? evaluate later ... searchable?     rank = models.CharField(max_length=3, choices=AUTHOR_RANK, blank=True, default='con', help_text='Author Rank')      AUTHOR_YEAR = (         ('fr', 'Freshman'),         ('so', 'Sophomore'),         ('ju', 'Junior'),         ('se', 'Senior'),         ('gs', 'Graduate Student'),     )      #year = models.CharField(max_length=2, choices=AUTHOR_YEAR, blank=True, default='', help_text='Author Year')      class Meta:         ordering = ["last_name","first_name"]      def get_absolute_url(self):         """         Returns the url to access a particular author instance.         """         return reverse('author-detail', args=[str(self.id)])       def __str__(self):         """         String for representing the Model object.         """         return '{0} {1}, {2}'.format(self.first_name,self.last_name,self.year) ###add in utility methods to get stuff from the database - for testing, instantiate the local db #START OF NEW MODELS #NOTE: This is not 100% finalized #id = models.IntegerField(primary_key=True) #class Meta: #    managed = False #    db_table = 'Author' #id = models.IntegerField(primary_key=True) #class Meta: #    managed = False #    db_table = 'Topic' #id = models.IntegerField(primary_key=True) #posted_date = models.DateField(auto_now=True) #modified_date = models.DateField(auto_now_add=True) class AuthGroup(models.Model):     name = models.CharField(unique=True, max_length=80)      class Meta:         managed = False         db_table = 'auth_group' class AuthGroupPermissions(models.Model):     group = models.ForeignKey(AuthGroup, models.DO_NOTHING)     permission = models.ForeignKey('AuthPermission', models.DO_NOTHING)      class Meta:         managed = False         db_table = 'auth_group_permissions'         unique_together = (('group', 'permission'),) class AuthPermission(models.Model):     name = models.CharField(max_length=255)     content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING)     codename = models.CharField(max_length=100)      class Meta:         managed = False         db_table = 'auth_permission'         unique_together = (('content_type', 'codename'),) class AuthUser(models.Model):     password = models.CharField(max_length=128)     last_login = models.DateTimeField(blank=True, null=True)     is_superuser = models.IntegerField()     username = models.CharField(unique=True, max_length=150)     first_name = models.CharField(max_length=30)     last_name = models.CharField(max_length=150)     email = models.CharField(max_length=254)     is_staff = models.IntegerField()     is_active = models.IntegerField()     date_joined = models.DateTimeField()      class Meta:         managed = False         db_table = 'auth_user'   class AuthUserGroups(models.Model):     user = models.ForeignKey(AuthUser, models.DO_NOTHING)     group = models.ForeignKey(AuthGroup, models.DO_NOTHING)      class Meta:         managed = False         db_table = 'auth_user_groups'         unique_together = (('user', 'group'),)   class AuthUserUserPermissions(models.Model):     user = models.ForeignKey(AuthUser, models.DO_NOTHING)     permission = models.ForeignKey(AuthPermission, models.DO_NOTHING)      class Meta:         managed = False         db_table = 'auth_user_user_permissions'         unique_together = (('user', 'permission'),)   class DjangoAdminLog(models.Model):     action_time = models.DateTimeField()     object_id = models.TextField(blank=True, null=True)     object_repr = models.CharField(max_length=200)     action_flag = models.PositiveSmallIntegerField()     change_message = models.TextField()     content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True)     user = models.ForeignKey(AuthUser, models.DO_NOTHING)      class Meta:         managed = False         db_table = 'django_admin_log'   class DjangoContentType(models.Model):     app_label = models.CharField(max_length=100)     model = models.CharField(max_length=100)      class Meta:         managed = False         db_table = 'django_content_type'         unique_together = (('app_label', 'model'),)   class DjangoMigrations(models.Model):     app = models.CharField(max_length=255)     name = models.CharField(max_length=255)     applied = models.DateTimeField()      class Meta:         managed = False         db_table = 'django_migrations'   class DjangoSession(models.Model):     session_key = models.CharField(primary_key=True, max_length=40)     session_data = models.TextField()     expire_date = models.DateTimeField()      class Meta:         managed = False         db_table = 'django_session' #END OF NEW MODELS #debugging # add more to this list Intermediate table supporting ManyToMany between Articles and Authors     (Wagtail does not by default support this)      i.e. an article with 3 authors will create 3 rows in this table #isTipPage = models.BooleanField()