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 get_reset_token(self, expires_sec=1800):
s = Serializer(current_app.config['SECRET_KEY'], expires_sec)
return s.dumps({'user_id': self.id}).decode('utf-8')
@staticmethod
def varify_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}')"
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)
profile_image = db.Column(db.String(20),
nullable=False,
default="default.jpg")
password = db.Column(db.String(60), nullable=False)
post = db.relationship('Post', backref="author", lazy=True)
def get_reset_token(self, expires_sec=1800):
s = Serializer(current_app.config['SECRET_KEY'], expires_sec)
return s.dumps({
'user_id': self.id
}).decode("utf-8"
) #returns a token decoded with an expiration of 30 minutese
@staticmethod #tells python that it is a static metho
def verify_reset_token(token):
s = Serializer(current_app.config["SECRET_KEY"])
try:
user_id = s.loads(token)["user_id"] #try and load id
except:
return None
return User.query.get(user_id)
def __repr__(self): #how the object is printed when we print it out
return f"User('{self.username}','{self.email}','{self.profile_image}')"
class PurchaseInfo(db.Model):
id = db.Column(db.Integer, primary_key=True)
delivery = db.Column(db.String(100), nullable=False, default='pick up')
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'), nullable=False)
good_id = db.Column(db.Integer,
db.ForeignKey('products.id'),
nullable=False)
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(40),unique=True,nullable=False)
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})'
class Post(db.Model):
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)
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}')"
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}')"
class Rpasubcat(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
id_rpacat = db.Column(db.Integer,
db.ForeignKey('rpacat.id'),
nullable=False)
subcat = db.relationship('Rpa', backref='Subcategory', lazy=True)
def __repr__(self):
return f"{self.title}"
class Post(db.Model,UserMixin):
id=db.Column(db.Integer,primary_key=True)
title=db.Column(db.String(40),nullable=False)
description=db.Column(db.String(80),nullable=False)
date_posted=db.Column(db.DateTime,default=datetime.utcnow)
user_id=db.Column(db.Integer,db.ForeignKey('user.id'),nullable=False)
def __repr__(self):
return f'User({self.title},{self.description})'
class ProductItem(db.Model):
__tablename__ = 'products'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), unique=False)
descr = db.Column(db.Text, unique=True, nullable=True)
price = db.Column(db.Float, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
cartitems = db.relationship('PurchaseInfo',
backref='product_name',
lazy=True)
def __repr__(self):
return '<ProductName %r>' % self.name
class Post(db.Model):
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)
tags = db.relationship('Tag',
secondary=posts_tag,
backref=db.backref('posts', lazy='dynamic'))
def __init__(self, *args, **kwargs):
super(Post, self).__init__(*args, **kwargs)
def __repr__(self):
return f"Post('{self.title}','{self.date_posted}')"
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='defaultprofilepic.jpg')
password = db.Column(db.String(60), nullable=False)
role = db.Column(db.String(15), nullable=False)
check = db.Column(db.Integer, nullable=False, default=0)
posts = db.relationship('Post', backref='author', lazy=True)
products = db.relationship('ProductItem', backref='producer', lazy=True)
userorders = db.relationship('PurchaseInfo', backref='buyer', lazy=True)
usercomments = db.relationship('Comments',
backref='personwhocommented',
lazy=True)
def __repr__(self):
return "User(%r, %r, %r)" % (self.username, self.email,
self.image_file)
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'])
# the token could expired or something else so
try:
user_id = s.loads(token)['user_id']
except:
return None
return User.query.get(user_id)
class Post(db.Model):
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)
image_farm_file = db.Column(db.String(20),
nullable=False,
default='farm_pic.jpg')
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
user_order_farms = db.relationship('PurchaseInfo',
backref='farm_that_sold',
lazy=True)
user_order_comment_farms = db.relationship('Comments',
backref='farm_got_commented',
lazy=True)
city = db.Column(db.String(20), nullable=False, default='Torino')
def __repr__(self):
return "Post(%r, %r)" % (self.title, self.date_posted)
class Comments(db.Model):
id = db.Column(db.Integer, primary_key=True)
title_comment = db.Column(db.String(100), nullable=False)
comment = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'), nullable=False)
class Question(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
question = db.Column(db.String(400), unique=True, nullable=False)
class Rpa(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
content = db.Column(db.Text, nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
rpaarea = db.Column(db.Integer,
db.ForeignKey('rpaarea.id'),
nullable=False)
rpacat = db.Column(db.Integer, db.ForeignKey('rpacat.id'), nullable=False)
rpasubcat = db.Column(db.Integer,
db.ForeignKey('rpasubcat.id'),
nullable=False)
email = db.Column(db.String(120), nullable=False)
docrate = db.Column(db.Integer, nullable=False)
# docrate1 = db.Column( db.Integer,nullable=False )
# docrate2 = db.Column( db.Integer,nullable=False )
# docrate3 = db.Column( db.Integer,nullable=False )
# docrate4 = db.Column( db.Integer,nullable=False )
indatastructrate = db.Column(db.Integer, nullable=False)
changesrate = db.Column(db.Integer, nullable=False)
indatarate = db.Column(db.Integer, nullable=False)
rulebasedrate = db.Column(db.Integer, nullable=False)
b = db.Column(db.Boolean(), nullable=False)
doc1 = db.Column(db.Boolean(), nullable=False)
doc2 = db.Column(db.Boolean(), nullable=False)
doc3 = db.Column(db.Boolean(), nullable=False)
doc4 = db.Column(db.Boolean(), nullable=False)
def __repr__(self):
return f"RPA ideas ('{self.title}','{self.date_posted}')"
class Rpaarea(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
r_cat = db.relationship('Rpacat', backref='Category', lazy=True)
class Tag(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
def __repr__(self):
return f"{self.name}"
@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}')"
posts_tag = db.Table(
'posts_tag', db.Column('post_id', db.Integer, db.ForeignKey('post.id')),
db.Column('tag_id', db.Integer, db.ForeignKey('tag.id')))
"""rpa_tag = db.Table('rpa_tag',
db.Column('rpa_id', db.Integer, db.ForeignKey('post.id')),
db.Column('tag_id', db.Integer, db.ForeignKey('tag.id'))
)
"""
class Post(db.Model):
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)
