class ProductVO(database.Model):
__tablename__ = 'product_table'
product_id = database.Column('product_id',
database.Integer,
primary_key=True,
autoincrement=True)
product_name = database.Column('product_name', database.String(100))
product_description = database.Column('product_description',
database.String(100))
product_price = database.Column('product_price', database.Integer)
product_image_name = database.Column('product_image_name',
database.String(100),
nullable=False)
product_image_path = database.Column('product_image_path',
database.String(100),
nullable=False)
product_category_name = database.Column(
'product_category_name', database.Integer,
database.ForeignKey(CategoryVO.category_id))
product_subcategory_name = database.Column(
'product_subcategory_name', database.Integer,
database.ForeignKey(SubCategoryVO.subcategory_id))
def as_dict(self):
return {
'product_id': self.product_id,
'product_name': self.product_name,
'product_description': self.product_description,
'product_price': self.product_price,
'product_image_name': self.product_image_name,
'product_image_path': self.product_image_path,
'category_name': self.product_category_name,
'subcategory_name': self.product_subcategory_name
}
class RegisterVO(database.Model):
__tablename__ = 'user_table'
user_id = database.Column('user_id',
database.Integer,
primary_key=True,
autoincrement=True)
user_firstname = database.Column('user_firstname', database.String(100))
user_lastname = database.Column('user_lastname', database.String(100))
user_gender = database.Column('user_gender', database.String(100))
user_address = database.column('user_address', database.String(255))
user_pincode = database.Column('user_pincode', database.Integer)
user_email = database.column('user_email', database.String(255))
user_password = database.column('user_password', database.String(255))
user_state_id = database.Column('user_state_id', database.Integer,
database.ForeignKey(StateVO.state_id))
user_city_id = database.Column('user_city_id', database.Integer,
database.ForeignKey(CityVO.city_id))
user_login_id = database.Column('user_login_id', database.Integer,
database.ForeignKey(LoginVO.login_id))
def as_dict(self):
return {
'user_id': self.user_id,
'user_firstname': self.user_firstname,
'user_lastname': self.user_lastname,
'user_gender': self.user_gender,
'user_address': self.user_address,
'user_pincode': self.user_pincode,
'user_state_id': self.user_state_id,
'user_city_id': self.user_city_id,
'user_login_id': self.user_login_id
}
class AreaVO(database.Model):
__tablename__ = 'area_table'
area_id = database.Column('area_id', database.Integer, primary_key=True, autoincrement=True)
area_name = database.Column('area_name', database.String(100))
area_pincode = database.Column('area_pincode', database.Integer)
area_state_id = database.Column('area_state_id', database.Integer, database.ForeignKey(StateVO.state_id))
area_city_id = database.Column('area_city_id', database.Integer, database.ForeignKey(CityVO.city_id))
def as_dict(self):
return {
'area_id': self.area_id,
'area_name': self.area_name,
'area_pincode': self.area_pincode,
'area_state_id': self.area_state_id,
'area_city_id': self.area_city_id
}
class SubCategoryVO(database.Model):
__tablename__ = 'subcategory_table'
subcategory_id = database.Column('subcategory_id', database.Integer, primary_key=True, autoincrement=True)
subcategory_name = database.Column('subcategory_name', database.String(100), nullable=False)
subcategory_description = database.Column('subcategory_description', database.String(100), nullable=False)
subcategory_category_id = database.Column('subcategory_category_id', database.Integer,
database.ForeignKey(CategoryVO.category_id))
def as_dict(self):
return {
'subcategory_id': self.subcategory_id,
'subcategory_name': self.subcategory_name,
'subcategory_description': self.subcategory_description,
'subcategory_category_id': self.subcategory_category_id
}
class CityVO(database.Model):
__tablename__ = 'city_table'
city_id = database.Column('city_id',
database.Integer,
primary_key=True,
autoincrement=True)
city_name = database.Column('city_name', database.String(100))
city_description = database.Column('city_description',
database.String(100))
city_state_id = database.Column('city_state_id', database.Integer,
database.ForeignKey(StateVO.state_id))
def as_dict(self):
return {
'city_id': self.city_id,
'city_name': self.city_name,
'city_description': self.city_description,
'city_state_id': self.city_state_id
}
class ComplainVO(database.Model):
__tablename__ = "complain_table"
complain_id = database.Column("complain_id", database.Integer, primary_key=True, autoincrement=True)
complain_subject = database.Column("complain_subject", database.String(255), nullable=False)
complain_description = database.Column("complain_description", database.String(255), nullable=False)
complain_datetime = database.Column("complain_datetime", database.DateTime)
complain_status = database.Column("complain_status", database.String(20))
complain_from_login_id = database.Column("complain_from_login_id", database.Integer, database.ForeignKey(LoginVO.login_id))
complain_to_login_id = database.Column("complain_to_login_id", database.Integer, database.ForeignKey(LoginVO.login_id))
complain_reply_description = database.Column("complain_reply_description", database.String(255))
complain_reply_datetime = database.Column("complain_reply_datetime", database.DateTime)
def as_di1ct(self):
return {
"complain_id": self.complain_id,
"complain_subject": self.complain_subject,
"complain_description": self.complain_description,
"complain_datetime": self.complain_datetime,
"complain_status": self.complain_status,
"complain_from_login_id": self.complain_from_login_id,
"complain_to_login_id": self.complain_to_login_id,
"complain_reply_description": self.complain_reply_description,
"complain_reply_datetime": self.complain_reply_datetime,
}
class FeedbackVO(database.Model):
__tablename__ = "feedback_table"
feedback_id = database.Column("feedback_id",
database.Integer,
primary_key=True,
autoincrement=True)
feedback_description = database.Column("feedback_description",
database.String(255),
nullable=False)
feedback_rating = database.Column("feedback_rating",
database.Integer,
nullable=False)
feedback_datetime = database.Column("feedback_datetime", database.DateTime)
feedback_login_id = database.Column("feedback_login_id", database.Integer,
database.ForeignKey(LoginVO.login_id))
def as_di1ct(self):
return {
"feedback_id": self.feedback_id,
"feedback_description": self.feedback_description,
"feedback_rating": self.feedback_rating,
"feedback_datetime": self.feedback_datetime,
"feedback_login_id": self.feedback_login_id,
}