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):
__tablename__ = "User"
id = db.Column(db.Integer(),primary_key=True)
name = db.Column(db.String(),nullable=False)
surname = db.Column(db.String(),nullable=False)
nickname = db.Column(db.String(),nullable=False)
password = db.Column(db.String(),nullable=False)
email = db.Column(db.String(),unique=True,nullable=False)
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 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 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 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()