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 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) rpa = db.relationship('Rpa', 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 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}')"
class Rpacat(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) id_rpa = db.Column(db.Integer, db.ForeignKey('rpaarea.id'), nullable=False) cat = db.relationship('Rpa', backref='Category', lazy=True) cat1 = db.relationship('Rpa', backref='cat1', lazy=True) r_subcat = db.relationship('Rpasubcat', backref='Category', lazy=True) def __repr__(self): return f"{self.title}"
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 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 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 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 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 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)