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