class Post(db.Model):
__tablename__ = 'posts'
id = db.Column(db.Integer, primary_key=True)
author_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'))
widget_id = db.Column(db.Integer, db.ForeignKey('widgets.id', ondelete='CASCADE'))
content = db.Column(db.String(220), nullable=False)
create_dttm = db.Column(db.DateTime, default=datetime.utcnow)
def __repr__(self):
return f"Post('{self.content}', '{self.create_dttm}')"
class AdminAssociation(db.Model):
__tablename__ = 'administrators'
id = db.Column(db.Integer, primary_key=True)
create_dttm = db.Column(db.DateTime, default=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'))
widget_id = db.Column(db.Integer, db.ForeignKey('widgets.id', ondelete='CASCADE'))
user = db.relationship(User, backref=db.backref("administrators", cascade="all, delete-orphan"))
widget = db.relationship(Widget, backref=db.backref("administrators", cascade="all, delete-orphan"))
__mapper_args__ = {
'confirm_deleted_rows' : False
}
def __repr__(self):
return f"AdminAssociation(Admin: '{self.user.netid}', Widget: '{self.widget.name}')"
class Subscription(db.Model):
__tablename__ = 'subscriptions'
id = db.Column(db.Integer, primary_key=True)
create_dttm = db.Column(db.DateTime, default=datetime.utcnow)
grid_location = db.Column(JSONEncodedDict, nullable=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'))
widget_id = db.Column(db.Integer, db.ForeignKey('widgets.id', ondelete='CASCADE'))
user = db.relationship(User, backref=db.backref("subscriptions", cascade="all, delete-orphan"))
widget = db.relationship(Widget, backref=db.backref("subscriptions", cascade="all, delete-orphan"))
__mapper_args__ = {
'confirm_deleted_rows' : False
}
def __repr__(self):
return f"Subscription('{self.user}', '{self.widget}')"
class User(db.Model, UserMixin):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
netid = db.Column(db.String(120), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=True)
first_name = db.Column(db.String(120), nullable=True, default="")
last_name = db.Column(db.String(120), nullable=True, default="")
class_year = db.Column(db.Integer(), nullable=True)
display_name = db.Column(db.String(30), nullable=True)
create_dttm = db.Column(db.DateTime, default=datetime.utcnow)
birthday = db.Column(db.DateTime, nullable=True)
widgets = db.relationship('Widget', secondary='subscriptions', passive_deletes=True)
widgets_admin = db.relationship('Widget', secondary='administrators', passive_deletes=True)
posts = db.relationship('Post', backref='author', cascade="all,delete", lazy='dynamic', passive_deletes=True)
def __repr__(self):
return f"User('{self.netid}')"
class CustomPost(db.Model):
__tablename__ = 'custom_posts'
id = db.Column(db.Integer, primary_key=True)
widget_id = db.Column(db.Integer, db.ForeignKey('widgets.id', ondelete='CASCADE'))
custom_author = db.Column(db.String(), default="")
content = db.Column(db.String(), default="")
url = db.Column(db.String(), default="")
create_dttm = db.Column(db.DateTime, default=datetime.utcnow)
widget = db.relationship(Widget, backref=db.backref("customposts", cascade="all, delete-orphan"))
def __repr__(self):
return f"CustomPost('{self.widget.name}', '{self.id}')"
class Widget(db.Model):
__tablename__ = 'widgets'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(), unique=True, nullable=False)
alias_name = db.Column(db.String(), default="")
description = db.Column(db.String(), nullable=False)
type = db.Column(db.String(), default='generic')
active = db.Column(db.Boolean, default=False)
post_limit = db.Column(db.Integer, default=1)
handle_display = db.Column(db.String(), default="author")
style = db.Column(db.String(), nullable=True)
access_type = db.Column(db.String(), default='public')
post_type = db.Column(db.String(), default='private')
create_dttm = db.Column(db.DateTime, default=datetime.utcnow)
admins = db.relationship('User', secondary='administrators', passive_deletes=True)
users = db.relationship('User', secondary='subscriptions', passive_deletes=True)
posts = db.relationship('Post', backref='widget', lazy='dynamic', passive_deletes=True)
custom_posts = db.relationship('CustomPost', backref='custom_widget', lazy='dynamic', passive_deletes=True)
def __repr__(self):
return f"Widget('{self.name}', '{self.id}')"