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))