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 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 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 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
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 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 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
class Urls(db.Model):
__tablename__ = 'urls'
id = db.Column(db.Integer, primary_key=True)
og_url = db.Column(db.String)
short_url = db.Column(db.String)
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))