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)