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)
imagef = db.Column(db.String(20), nullable=False, default='default.jpg')
password = db.Column(db.String(120), nullable=False)
#Begin S-1 added mail validation
activate = db.Column(db.Boolean(), nullable=False, default=False)
#End S-1 added mail validation
post = db.relationship('Post', backref='Author', lazy=True)
def __repr__(self):
return f"User('{self.username}','{self.email}','{self.imagef}')"
def get_reset_token(self, expire_sec=1800):
s = Serializer(current_app.config['SECRET_KEY'], expire_sec)
return s.dumps({'user_id': self.id}).decode('utf-8')
@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)
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)
tutor = db.Boolean()
course1 = db.Column(db.String(50))
course3 = db.Column(db.String(50))
course4 = db.Column(db.String(50))
course5 = db.Column(db.String(50))
course6 = db.Column(db.String(50))
course7 = db.Column(db.String(50))
course2 = db.Column(db.String(50))
barcode = db.Column(db.String(500))
def get_reset_token(self, expires_sec=1800):
s = Serializer(app.config['SECRET_KEY'], expires_sec)
return s.dumps({'user_id': self.id}).decode('utf-8')
@staticmethod
def verify_reset_token(token):
s = Serializer(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"('{self.id}','{self.username}')"
class User(db.Model,UserMixin):
__tablename__ = 'users'
id = db.Column(db.Integer(), primary_key=True)
username = db.Column(db.String(20), nullable=False, unique=True)
email = db.Column(db.String(50), nullable=False, unique=True)
avatar = db.Column(db.String(20), nullable=False, default='default.jpg')
password = db.Column(db.String(20), nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
admin = db.Column(db.Boolean(), default=False)
def get_reset_token(self, expires_sec=600):
token = TimedJSONWebSignatureSerializer(app.config['SECRET_KEY'], expires_sec)
return token.dumps({'user_id': self.id}).decode('utf-8')
@staticmethod
def verify_token_reset(token):
s = TimedJSONWebSignatureSerializer(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 self.username
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)
orders = db.relationship('Order', lazy=True)
about_me = db.Column(db.String(140))
last_seen = db.Column(db.DateTime, default=datetime.utcnow)
admin = db.Column(db.Boolean())
notes = db.Column(db.UnicodeText)
def __init__(self, username, email, password, notes='', admin=False):
self.username = username
self.email = email
#self.password = bcrypt.generate_password_hash(password)
self.password = password
self.admin = admin
self.notes = notes
def is_admin(self):
return self.admin
def __repr__(self):
return "User('{self.username}', '{self.email}', '{self.image_file}')"
def avatar(self, size):
digest = md5(self.email.lower().encode('utf-8')).hexdigest()
return 'https://www.gravatar.com/avatar/{}?d=identicon&s={}'.format(
digest, size)
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.png')
password = db.Column(db.String(60), nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
about_me = db.Column(db.String(140))
last_seen = db.Column(db.DateTime, default=datetime.utcnow)
admin = db.Column(db.Boolean())
notes = db.Column(db.UnicodeText)
def __init__(self, username, email, password, notes='', admin=False):
self.username = username
self.email = email
self.password = password
self.admin = admin
self.notes = notes
def is_admin(self):
return self.admin
def __repr__(self):
return f"User('{self.username}', '{self.email}', '{self.image_file}')"
class Item(db.Model):
id = db.Column(db.Integer(), primary_key=True)
titles = db.Column(db.String(100), nullable=False)
price = db.Column(db.Integer(), nullable=False)
isActive = db.Column(db.Boolean(), default=True)
def __repr__(self):
return self.titles
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)
about_me = db.Column(db.String(140))
last_seen = db.Column(db.DateTime, default=datetime.utcnow)
admin = db.Column(db.Boolean())
notes = db.Column(db.UnicodeText)
followed = db.relationship('User',
secondary=followers,
primaryjoin=(followers.c.follower_id == id),
secondaryjoin=(followers.c.followed_id == id),
backref=db.backref('followers', lazy='dynamic'),
lazy='dynamic')
def __init__(self, username, email, password, notes='', admin=False):
self.username = username
self.email = email
self.password = password
self.admin = admin
self.notes = notes
def is_admin(self):
return self.admin
def __repr__(self):
return f"User('{self.username}', '{self.email}', '{self.image_file}')"
def avatar(self, size):
digest = md5(self.email.lower().encode('utf-8')).hexdigest()
return 'https://www.gravatar.com/avatar/{}?d=identicon&s={}'.format(
digest, size)
def follow(self, user):
if not self.is_following(user):
self.followed.append(user)
def unfollow(self, user):
if self.is_following(user):
self.followed.remove(user)
def is_following(self, user):
return self.followed.filter(
followers.c.followed_id == user.id).count() > 0
def followed_posts(self):
followed = Post.query.join(
followers, (followers.c.followed_id == Post.user_id)).filter(
followers.c.follower_id == self.id)
own = Post.query.filter_by(user_id=self.id)
return followed.union(own).order_by(Post.timestamp.desc())
class Comment(db.Model):
id = db.Column(db.Integer, primary_key=True)
content = db.Column(db.String(255), nullable=False)
created_date = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
user = db.Column(db.Boolean(), default=False)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'), nullable=False)
def __repr__(self):
return f"Comment('{self.user}')"
class User(db.Model, UserMixin):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(15), unique=True, nullable=False)
email = db.Column(db.String(30), unique=True, nullable=False)
email_confirmed_at = db.Column(db.DateTime(), default=datetime.utcnow)
password = db.Column(db.String(60), nullable=False)
roles = db.relationship('Role', secondary='user_roles')
comments = db.relationship('Comment', backref = 'user', lazy= 'dynamic')
active = db.Column(db.Boolean(), default=True)
def __repr__(self):
return f"User('{self.username}', '{self.email}')"
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
mobile = db.Column(db.String(10), unique=False, nullable=False)
aadhaar = db.Column(db.String(12), unique=False, 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)
user_type = db.Column(db.Boolean(), default=False, nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
def __repr__(self):
return f"User('{self.username}', '{self.email}', '{self.image_file}')"
