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)
