class Minutes(db.Model):
id = db.Column(db.Integer, primary_key=True)
club_id = db.Column(db.Integer, db.ForeignKey('club.id'))
date = db.Column(db.Date, nullable=False) #0000-00-00
time = db.Column(db.Time) #00:00:00
location = db.Column(db.String(100), nullable=False)
attendance = db.relationship('Attendance', backref='minutes', lazy=True) #check code
purchase = db.Column(db.String(500))
purchasemotion = db.Column(db.Text)
fundraiser = db.Column(db.Text)
fundmotion = db.Column(db.Text)
minute = db.Column(db.Text, nullable=False) #notes
def __repr__(self):
return f'{self.club_id} {self.date}'
class Attendance(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
student_name = db.Column(db.String(35), nullable=False)
present = db.Column(db.Boolean, default=False) #set correctly
minutes_id = db.Column(db.Integer, db.ForeignKey('minutes.id'))
def __repr__(self):
return self.student_name
class Club(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), unique=True, nullable=False)
members = db.relationship('User', secondary=user_club_assoc_table)
contacts = db.Column(db.Text)
minutes = db.relationship('Minutes', backref='club')
def __repr__(self):
return f'{self.name}'#Club(name={self.name!r})
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
club = db.Column(db.String(80))
advisor = db.Column(db.Text)
room = db.Column(db.Text)
contact = db.Column(db.Text)
def __init__(self, club, advisor, room, contact):
self.club = club
self.advisor = advisor
self.room = room
self.contact = contact
def __repr__(self):
user_club_assoc_table = db.Table('user_club_assoc_table',
db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
db.Column('club_id', db.Integer, db.ForeignKey('club.id')))
roles = db.relationship('Role', secondary='user_roles',
backref=db.backref('users', lazy='dynamic'))
@login_manager.user_loader
def load_user(user_id):
return User.query.get(int(user_id))
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
<<<<<<< HEAD
firstname = db.Column(db.String(20), nullable=False)
lastname = db.Column(db.String(20), nullable=False)
school = db.Column(db.String(30), nullable=False)
schoolid = db.Column(db.String(60), unique=True, nullable=False)
=======
firstname = db.Column(db.String(15), nullable=False)
lastname = db.Column(db.String(15), nullable=False)
>>>>>>> 571b656d3b3ad9b9da31363aeaae5115b7c7eb78
email = db.Column(db.String(60), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
role = db.Column(db.Integer(), nullable=False, default=ROLES['student'])
clubs = db.relationship('Club', secondary=user_club_assoc_table)
<<<<<<< HEAD
def get_reset_token(self, expires_sec=1800):
s = Serializer('SECRET_KEY', expires_sec)