@login_manager.user_loader
def load_user(user_id):
return User.query.get(int(user_id))
# subs = db.Table('subs',
# db.Column('buyer_id', db.Integer, db.ForeignKey('user.id')),
# db.Column('seller_id', db.Integer, db.ForeignKey('user.id')),
# db.relationship("User", foreign_keys=['user.id']),
# db.relationship("User", foreign_keys=['user.id'])
# )
ords = db.Table('ords',
db.Column('order_id', db.Integer, db.ForeignKey('order.id')),
db.Column('fish_id', db.Integer, db.ForeignKey('fish.id')))
followers = db.Table(
'followers', db.Column('follower_id', db.Integer,
db.ForeignKey('user.id')),
db.Column('followed_id', db.Integer, db.ForeignKey('user.id')))
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
fullname = db.Column(db.String(60))
email = db.Column(db.String(20), unique=True)
address = db.Column(db.String(120))
image_file = db.Column(db.String(20),
from datetime import datetime
from itsdangerous import TimedJSONWebSignatureSerializer as Serializer
from flaskblog import db, login_manager, app
from flask_login import UserMixin
@login_manager.user_loader
def load_user(user_id):
return User.query.get(int(user_id))
membership = db.Table(
'membership', db.Column('member_id', db.Integer, db.ForeignKey('user.id')),
db.Column('club_id', db.Integer, db.ForeignKey('clubs.id')))
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
image_file = db.Column(db.String(20),
nullable=False,
default='default.jpg')
password = db.Column(db.String(60), nullable=False)
level = db.Column(db.String(20), nullable=False)
posts = db.relationship('Post', backref='student', lazy=True)
memberof = db.relationship('Clubs',
secondary=membership,
backref=db.backref('members', lazy='dynamic'))
def get_reset_token(self, expires_sec=1800):
from datetime import datetime
from flaskblog import db, login_manager, bcrypt
from flask_login import UserMixin
from hashlib import md5
from wtforms import BooleanField, widgets, TextAreaField
@login_manager.user_loader
def load_user(user_id):
return User.query.get(int(user_id))
followers = db.Table('followers',
db.Column('follower_id', db.Integer, db.ForeignKey('user.id')),
db.Column('followed_id', db.Integer, db.ForeignKey('user.id'))
)
likers = db.Table('likers',
db.Column('liker_id', db.Integer, db.ForeignKey('post.id')),
db.Column('liked_id', db.Integer, db.ForeignKey('post.id'))
)
class User(db.Model, UserMixin):
id = db.Column(db. Integer, primary_key=True)
#public_id = db.Column(db.String(50), unique=True)
name = db.Column(db.String(50))
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
image_file = db.Column(db.String(20), nullable=False, default='default.jpg')
password = db.Column(db.String(60), nullable=False)
posts = db.relationship( 'Post', backref='author', lazy=True)
comments = db.relationship('Comment', backref='author', lazy=True)
about_me = db.Column(db.String(140))
from flask_sqlalchemy import SQLAlchemy
from flask_login import UserMixin
from itsdangerous import TimedJSONWebSignatureSerializer as Serializer
from flaskblog import db
from flaskblog import login_manager
from datetime import datetime
@login_manager.user_loader
def load_user(account_id):
return Account.query.get(account_id)
account_subs = db.Table(
'user_subs',
db.Column('following_id', db.Integer, db.ForeignKey('account.id')),
db.Column('follower_id', db.Integer, db.ForeignKey('account.id')),
)
post_subs = db.Table(
'post_subs', db.Column('star_id', db.Integer, db.ForeignKey('post.id')),
db.Column('subscriber_id', db.Integer, db.ForeignKey('account.id')))
class Account(db.Model, UserMixin):
__tablename__ = 'account'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
username = db.Column(db.String(50), nullable=True)
email = db.Column(db.String(200), nullable=True)
from datetime import datetime
from flaskblog import db, login_manager
from flask_login import UserMixin
from itsdangerous import TimedJSONWebSignatureSerializer as Serializer
from flask import current_app
from flaskblog.search import add_to_index, remove_from_index, query_index
@login_manager.user_loader
def load_user(user_id):
return User.query.get((int(user_id)))
followers = db.Table(
'followers',
db.Column('follower_id', db.Integer, db.ForeignKey('user.id')),
db.Column('followed_id', db.Integer, db.ForeignKey('user.id')),
)
domain_followers = db.Table(
'domain_followers',
db.Column('follower_id', db.Integer, db.ForeignKey('user.id')),
db.Column('followed_id', db.Integer, db.ForeignKey('domain.id')),
)
class SearchableMixin(object):
@classmethod
def search(cls, expression, page, per_page):
ids, total = query_index(cls.__tablename__, expression, page, per_page)
if total == 0:
return cls.query.filter_by(id=0), 0
from datetime import datetime
from flaskblog import db, login_manager
from flask_login import UserMixin
tags = db.Table(
'tags',
db.Column('tag_id', db.Integer, db.ForeignKey('tag.id'), primary_key=True),
db.Column('post_id',
db.Integer,
db.ForeignKey('post.id'),
primary_key=True))
@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)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
image_file = db.Column(db.String(20),
nullable=False,
default='default.jpg')
password = db.Column(db.String(60), nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
def __repr__(self):
return f"User('{self.username}', '{self.email}', '{self.image_file}')"
return False
def is_administrator(self):
return False
login_manager.anonymous_user = AnonymousUser
@login_manager.user_loader # decorator used for reloading the user based on the user id stored in the session
def load_user(user_id): # this function gets the user id
return User.query.get(int(user_id))
post_tag = db.Table('post_tag',
db.Column('tag_id', db.Integer, db.ForeignKey('tag.id')),
db.Column('post_id', db.Integer, db.ForeignKey('post.id')))
class Post(db.Model):
__searchable__ = ['title', 'content']
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'),
nullable=False) # a foreign key
tag = db.relationship('Tag',
secondary=post_tag,
#columns are gg
class Venues(db.Model): #FK from User, Declare FK for Events
id = db.Column(db.Integer, primary_key=True)
venue = db.Column(db.String(100), nullable=False)
event_capacity = db.Column(db.Text, nullable=False)
#Fk relationships
venue_event = db.relationship('Event', backref='Venue', lazy=True)
#user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) #should be good
#^For listing creator
def __repr__(self):
return f"Venues('{self.venue}', '{self.event_capacity}')"
UserEvent = db.Table(
'UserEvent',
db.Column(db.Integer, db.ForeignKey('fkvenue.id'), primary_key=True),
dbColumn(db.Integer, db.ForeignKey('event.id'), primary_key=True))
#columns are gg
class Events(db.Model): #2 FK declare for User-Event and Event and Creator?
id = db.Column(db.Integer, primary_key=True)
event_name = db.Column(db.String(100), nullable=False)
event_description = db.Column(db.String(1000), nullable=False)
user_capacity = db.Column(db.Integer, nullable=False)
time_start = db.Column(db.Integer, nullable=False) #dc data type
time_end = db.Column(db.Integer, nullable=False) #dc data type
tag = db.Column(db.String(10))
#fk
venue_id = db.Column(db.Integer, db.ForeignKey('venue.id'), nullable=False)
from datetime import datetime
from itsdangerous import TimedJSONWebSignatureSerializer as Serializer
from flask import current_app
from flaskblog import db, login_manager
from flask_login import UserMixin
images_posts = db.Table('images_posts',
db.Column('image_id',db.Integer,db.ForeignKey('image.id')),
db.Column('post_id',db.Integer,db.ForeignKey('post.id')),
db.PrimaryKeyConstraint('image_id','post_id'))
user_favorites = db.Table('user_favorites',
db.Column('image_id',db.Integer,db.ForeignKey('user.id')),
db.Column('post_id',db.Integer,db.ForeignKey('post.id')),
db.PrimaryKeyConstraint('image_id','post_id'))
@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)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
phonenumber = db.Column(db.String(15), nullable=False)
image_file = db.Column(db.String(20), nullable=False, default='default.jpg')
password = db.Column(db.String(60), nullable=False)
event = db.Column(db.String(100), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
note_id = db.Column(db.Integer, db.ForeignKey('note.id'), nullable=False)
def __repr__(self):
return f"Interaction('{self.event}', '{self.user_id}', '{self.note_id}',, '{self.date}')"
class Note(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
date_created = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
mode = db.Column(db.String(10), nullable=False)
likes = db.Column(db.Integer, default=0)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"Note('{self.title}', '{self.date_created}')"
tagmapper = db.Table(
'tagmapper', db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
db.Column('tag_id', db.Integer, db.ForeignKey('tag.id')))
notemapper = db.Table(
'notemapper', db.Column('tag_id', db.Integer, db.ForeignKey('tag.id')),
db.Column('note_id', db.Integer, db.ForeignKey('note.id')))
from datetime import datetime
from flaskblog import db, login_manager, app
from flask_login import UserMixin
from itsdangerous import TimedJSONWebSignatureSerializer as Serializer
@login_manager.user_loader
def load_user(user_id):
return User.query.get(int(user_id))
friends = db.Table(
'friends',
db.Column('frnd_id',
db.Integer,
db.ForeignKey('friend.id'),
primary_key=True),
db.Column('user_id',
db.Integer,
db.ForeignKey('user.id'),
primary_key=True))
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(20), unique=True, nullable=False)
image_file = db.Column(db.String(20),
nullable=False,
default='newLogo.jpg')
password = db.Column(db.String(60), nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
@staticmethod
def verify_reset_token(token):
s = Serializer(current_app.config['SECRET_KEY'])
try:
user_id = s.loads(token)['user_id']
except:
return None
return User.query.get(user_id)
def __repr__(self):
return f"User('{self.username}', '{self.email}', '{self.image_file}')"
association_guideline = db.Table(
'association_guideline',
db.metadata,
db.Column('pub_id', db.Integer, db.ForeignKey('publication.pub_id')),
db.Column('guide_id', db.Integer, db.ForeignKey('guideline.guide_id')),
)
class Publication(db.Model):
pub_id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(200), nullable=False)
year = db.Column(db.Integer, nullable=False)
venue = db.Column(db.String(20), nullable=False)
authors = db.Column(db.String(200), nullable=False)
experiments = db.relationship("Experiment", backref="exp_pub", lazy=True)
class Guideline(db.Model):
guide_id = db.Column(db.Integer, primary_key=True)
from datetime import datetime
from itsdangerous import TimedJSONWebSignatureSerializer as Serializer
from flask import current_app
from flaskblog import db, login_manager
from flask_login import UserMixin
@login_manager.user_loader
def load_user(user_id):
return User.query.get(int(user_id))
# Many to Many relationship
follows = db.Table(
'follows', db.Model.metadata, db.Column('id', db.Integer,
primary_key=True),
db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
db.Column('follower_id', db.Integer, db.ForeignKey('user.id')))
class User(db.Model, UserMixin):
# Columns
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(25), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
first_name = db.Column(db.String(25), nullable=False)
last_name = db.Column(db.String(25), nullable=False)
email = db.Column(db.String(25), unique=True, nullable=False)
image_file = db.Column(db.String(20),
nullable=False,
default='default.jpg')
from datetime import datetime
from flaskblog import db, login_manager
from flask_login import UserMixin
@login_manager.user_loader
def load_user(user_id):
return User.query.get(int(user_id))
tagmapper = db.Table(
'tagmapper',
db.Column('user_id',
db.Integer,
db.ForeignKey('user.id'),
primary_key=True),
db.Column('tag_id', db.Integer, db.ForeignKey('tag.id'), primary_key=True))
notemapper = db.Table(
'notemapper',
db.Column('tag_id', db.Integer, db.ForeignKey('tag.id'), primary_key=True),
db.Column('note_id',
db.Integer,
db.ForeignKey('post.id'),
primary_key=True))
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
