class Knowledge(db.Model): __tablename__ = 'knowledge' id = db.Column(db.Integer, primary_key=True) date = db.Column(db.DateTime, nullable=False, default=datetime.now) title = db.Column(db.String) content = db.Column(db.String) image = db.Column(db.String(64), nullable=True) teamid = db.Column(db.Integer, db.ForeignKey('teams.id')) userid = db.Column(db.Integer, db.ForeignKey('users.id')) def __init__(self, title, content, teamid, userid): self.title = title self.content = content self.teamid = teamid self.userid = userid
class Completed(db.Model): __tablename__ = 'completed' id = db.Column(db.Integer, primary_key = True) teamid = db.Column(db.Integer, db.ForeignKey('teams.id')) event = db.Column(db.String) def __init__(self,teamid,event): self.teamid = teamid self.event = event
class Events(db.Model): __tablename__ = 'events' id = db.Column(db.Integer, primary_key=True) teamid = db.Column(db.Integer, db.ForeignKey('teams.randomid')) date = db.Column(db.DateTime, nullable=False, default=datetime.now) start_date = db.Column(db.DateTime, nullable=True) end_date = db.Column(db.DateTime, nullable=True) title = db.Column(db.String) event = db.Column(db.String) type = db.Column(db.String) def __init__(self, teamid, title, event, type): self.teamid = teamid self.title = title self.event = event self.type = type
class Rent(db.Model): __tablename__ = 'rent' id = db.Column(db.Integer, primary_key=True) thing = db.Column(db.String) description = db.Column(db.String) price = db.Column(db.Integer) image = db.Column(db.String(64), nullable=False) rented = db.Column(db.String, default='No') userid = db.Column(db.Integer, db.ForeignKey('users.id')) def __init__(self, thing, description, image, userid, price): self.thing = thing self.description = description self.image = image self.userid = userid self.price = price
from Tool import db, login_manager from werkzeug.security import generate_password_hash, check_password_hash from flask_login import UserMixin from datetime import datetime @login_manager.user_loader def load_user(user_id): return User.query.get(user_id) work = db.Table('work', db.Column('user_id', db.Integer, db.ForeignKey('users.id')), db.Column('team_id', db.Integer, db.ForeignKey('teams.id'))) event = db.Table('event', db.Column('user_id', db.Integer, db.ForeignKey('users.id')), db.Column('event_id', db.Integer, db.ForeignKey('events.id'))) class User(db.Model, UserMixin): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64)) username = db.Column(db.String, unique=True) profile_image = db.Column(db.String(64), nullable=False, default='head_res.png') email = db.Column(db.String(64), unique=True, index=True) password_hash = db.Column(db.String(128))