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)) rent = db.relationship('Rent', backref='user', lazy='dynamic') knowledge = db.relationship('Knowledge', backref='user', lazy='dynamic') teams = db.relationship('Team', secondary=work, backref=db.backref('workers', lazy='dynamic')) events = db.relationship('Events', secondary=event, backref=db.backref('doers', lazy='dynamic')) def check_password(self, password): return check_password_hash(self.password_hash, password) def __init__(self, name, username, email, password): self.email = email self.name = name self.username = username self.password_hash = generate_password_hash(password)
class Team(db.Model): __tablename__ = 'teams' id = db.Column(db.Integer, primary_key = True) name = db.Column(db.String(64)) users = db.relationship(User) password_hash = db.Column(db.String(128)) def __init__(self, name,owner, password): self.name = name self.users.team_owner = owner self.password_hash = generate_password_hash(password)
class User(db.Model,UserMixin): __tablename__ = 'users' id = db.Column(db.Integer,primary_key = True) name = db.Column(db.String(64)) email = db.Column(db.String(64),unique = True,index = True) password_hash = db.Column(db.String(128)) team = db.relationship('Team' , backref = 'user_team', lazy = 'dynamic') ownerofteam = db.relationship('Team', backref = 'team_owner', lazy = True) def __init__(self, name, email, password): self.email = email self.name =name self.email = email self.password_hash = generate_password_hash(password)
class Team(db.Model): __tablename__ = 'teams' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64)) team_image = db.Column(db.String(64), nullable=False, default='head_res.png') password_hash = db.Column(db.String(128)) randomid = db.Column(db.String, unique=True) ownerid = db.Column(db.Integer) knowledge = db.relationship('Knowledge', backref='team', lazy='dynamic') events = db.relationship('Events', backref='team', lazy='dynamic') def __init__(self, name, password, randomid, ownerid): self.name = name self.password_hash = generate_password_hash(password) self.randomid = randomid self.ownerid = ownerid def check_password(self, password): return check_password_hash(self.password_hash, password)
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
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 Survey(db.Model): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(64), unique=True, index=True) gender = db.Column(db.String) media = db.Column(db.String) age_limit = db.Column(db.String) information = db.Column(db.String) friend_stranger = db.Column(db.String) policies = db.Column(db.String) victim = db.Column(db.String) government = db.Column(db.String) social_sites = db.Column(db.String) parents = db.Column(db.String) school = db.Column(db.String) opinion = db.Column(db.String) def __init__(self, email): self.email = email