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)