class User(db.Model): __tablename__ = "User" id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(), nullable=False) surname = db.Column(db.String(), nullable=False) password = db.Column(db.String(), nullable=False) Article = db.relationship('Article') def set_password(self): self.password = generate_password_hash(self.password) def check_password(self, password): return check_password_hash(self.password, password) def savedb(self): db.session.add(self) db.session.commit() def deletedb(self): db.session.delete(self) db.session.commit() def update(self, **kwargs): for key, value in kwargs.items(): setattr(self, key, value) self.savedb()
class User(db.Model): __tablename__="userlogin" id = db.Column(db.Integer(), primary_key = True) email = db.Column(db.String(), nullable = True) password = db.Column(db.String(), nullable = True) def generate_password(self): self.password = generate_password_hash(self.password) def chech_password(self, password_hash): return check_password_hash(self.password, password_hash) def save_db(self): db.session.add(self) db.session.commit() return self def delete_from_db(self): db.session.delete(self) db.session.commit() return self def update_db(self, **kwargs): for key, val in kwargs.items(): setattr(self, key, val) self.save_db()
class User(db.Model): user_id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(50), unique=True, nullable=False) password = db.Column(db.String(255), unique=True, nullable=False) firstname = db.Column(db.String(50), nullable=False) lastname = db.Column(db.String(50), nullable=False) email = db.Column(db.String(150), unique=True, nullable=False) email_status = db.Column(db.Boolean, default=False) email_created_at = db.Column(db.DateTime(timezone=True)) role = db.Column(db.String(255), default='user') def __init__(self, username, password, firstname, lastname, email): self.username = username self.password = password self.email = email self.firstname = firstname self.lastname = lastname self.role = 'user' self.email_status = False self.email_created_at = datetime.utcnow() def to_str_date(self): normal_date = self.email_created_at str_date = normal_date.strftime("%Y/%m/%d,%H:%M:%S") return str_date def write_to_dict(self): return { 'id': self.user_id, 'user': { 'username': self.username, 'email': self.email, 'firstname': self.firstname, 'lastname': self.lastname, 'role': self.role, 'email_status': self.email_status, 'email_created_at': self.to_str_date() } } @classmethod def find_user_by_id(cls, id): return User.query.filter(User.user_id == id).first() @classmethod def find_user_by_email(cls, email): return User.query.filter(User.email == email).first() @classmethod def find_user_by_username(cls, username): return User.query.filter(User.username == username).first() @classmethod def find_all_user(cls): return User.query.all()
class Category(db.Model): __tablename__ = "Category" id = db.Column(db.Integer(),primary_key=True) name = db.Column(db.String(),nullable=False) def savedb(self): db.session.add(self) db.session.commit() def deletedb(self): db.session.delete(self) db.session.commit() def update(self,**kwargs): for key,value in kwargs.items(): setattr(self,key,value) self.savedb()
class Article(db.Model): __tablename__ = "Article" id = db.Column(db.Integer(), primary_key=True) title = db.Column(db.String(), nullable=False) content = db.Column(db.String(), nullable=False) user_id = db.Column(db.Integer(), db.ForeignKey("User.id"), nullable=False) def savedb(self): db.session.add(self) db.session.commit() def deletedb(self): db.session.delete(self) db.session.commit() def update(self, **kwargs): for key, value in kwargs.items(): setattr(self, key, value) self.savedb()
class Product(db.Model): __tablename__ = 'PRoduct' id = db.Column(db.Integer(),primary_key=True) name = db.Column(db.String(),nullable=False) user_id= db.Column(db.Integer(), db.ForeignKey( 'User.id'), nullable=False) category_id = db.Column(db.Integer(),db.ForeignKey('Category.id'), nullable=False) def savedb(self): db.session.add(self) db.session.commit() def deletedb(self): db.session.delete(self) db.session.commit() def update(self, **kwargs): for key, value in kwargs.items(): setattr(self, key, value) self.savedb()
class Books(db.Model): id = db.Column(db.Integer(), primary_key=True) title = db.Column(db.String(), nullable=False) page = db.Column(db.Integer(), nullable=False) author = db.Column(db.String(), nullable=False) def save_db(self): db.session.add(self) db.session.commit() def delete_from_db(self): db.session.delete(self) db.session.commit() def update_db(self, **kwargs): for key, val in kwargs.items(): setattr(self, key, val) self.save_db()
class UserBooks(db.Model): __tablename__ = "user_books" id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False) book_id = db.Column(db.Integer, nullable=False) def save_db(self): db.session.add(self) db.session.commit() return self def delete_from_db(self): db.session.delete(self) db.session.commit() return self def update_db(self, **kwargs): for key, val in kwargs.items(): setattr(self, key, val) self.save_db()
class User(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(), nullable=False) surname = db.Column(db.String(), nullable=False) email = db.Column(db.String(), unique=True, nullable=False) password = db.Column(db.String(), nullable=False) filename = db.Column(db.String()) def set_password(self): self.password = generate_password_hash(self.password) def check_password(self, password_hash): return check_password_hash(self.password, password_hash) def save_db(self): db.session.add(self) db.session.commit() return self def delete_from_db(self): db.session.delete(self) db.session.commit() return self def update_db(self, **kwargs): for key, val in kwargs.items(): setattr(self, key, val) self.save_db()
class Car(db.Model): __tablename__ = "Car" id = db.Column(db.Integer(), primary_key=True) mark = db.Column(db.String(), nullable=True) model = db.Column(db.String(), nullable=True) color = db.Column(db.String(), nullable=True) manufacture_year = db.Column(db.Integer(), nullable=True) def save_db(self): db.session.add(self) db.session.commit() return self def delete_from_db(self): db.session.delete(self) db.session.commit() return self def update_db(self, **kwargs): for key, val in kwargs.items(): setattr(self, key, val) self.save_db()
class RevokedToken(db.Model): __tablename__ = 'revoke_jwt' id = db.Column(db.Integer, primary_key=True) access_jti = db.Column(db.String, unique=True, nullable=False) refresh_jti = db.Column(db.String, unique=True, nullable=False) created_at = db.Column(db.DateTime, nullable=False)