class Mon_an(sqldb.Model):
__tablename__ = 'mon_an'
__searchable__ = ['body']
ma_mon = sqldb.Column(sqldb.Integer, primary_key = True)
ten_mon = sqldb.Column(sqldb.String(255), unique = True, nullable = False)
image = sqldb.Column(sqldb.String(255), nullable = False)
cong_thuc = sqldb.Column(sqldb.Text, nullable = False)
nguyen_lieu = sqldb.Column(sqldb.Text, nullable = False)
ma_nl = sqldb.Column(sqldb.Integer, sqldb.ForeignKey('thanh_phan.id'), nullable = True)
ma_vh = sqldb.Column(sqldb.Integer, sqldb.ForeignKey('van_hoa.id'), nullable = True)
ma_cach_cb = sqldb.Column(sqldb.Integer, sqldb.ForeignKey('cach_cb.id'), nullable = True)
ma_mua = sqldb.Column(sqldb.Integer, sqldb.ForeignKey('_mua.id'), nullable = True)
video = sqldb.Column(sqldb.String(255), nullable = True)
def addMonan(self, ten_mon, image, cong_thuc, nguyen_lieu, ma_nl, ma_vh , ma_cach_cb, ma_mua , video):
self.ten_mon = ten_mon
self.image = image
self.cong_thuc = cong_thuc
self.nguyen_lieu = nguyen_lieu
self.ma_nl = ma_nl
self.ma_vh = ma_vh
self.ma_cach_cb = ma_cach_cb
self.ma_mua = ma_mua
self.video = video
sqldb.session.add(self)
sqldb.session.commit()
class Meovaobep(sqldb.Model):
__tablename__ = 'meovaobep'
__searchable__ = ['body']
id = sqldb.Column(sqldb.Integer, primary_key = True)
name = sqldb.Column(sqldb.String(255), unique = True, nullable = False)
mo_ta = sqldb.Column(sqldb.Text, nullable = False)
image = sqldb.Column(sqldb.String(255))
id_meo = sqldb.Column(sqldb.Integer, sqldb.ForeignKey('meovat.id'), nullable = True)
def addMeovaobep(self, name, mo_ta, image, id_meo):
self.name = name
self.mo_ta = mo_ta
self.image = image
self.id_meo = id_meo
sqldb.session.add(self)
sqldb.session.commit()
class Cach_cb(sqldb.Model):
__tablename__ = 'cach_cb'
__searchable__ = ['body']
id = sqldb.Column(sqldb.Integer, primary_key = True)
name = sqldb.Column(sqldb.String(255), unique = True, nullable = False)
# func add data to table Cach_cb
def addCachchebien(self, excelValue):
self.name = excelValue
sqldb.session.add(self)
sqldb.session.commit()
class Van_hoa(sqldb.Model):
__tablename__ = 'van_hoa'
__searchable__ = ['body']
id = sqldb.Column(sqldb.Integer, primary_key = True)
name = sqldb.Column(sqldb.String(255), unique = True, nullable = False)
# func add data to table Van_hoa
def addVanhoa(self, excelValue):
self.name = excelValue
sqldb.session.add(self)
sqldb.session.commit()
class Thanh_phan(sqldb.Model):
__tablename__ = 'thanh_phan'
__searchable__ = ['body']
id = sqldb.Column(sqldb.Integer, primary_key = True)
name = sqldb.Column(sqldb.String(255), unique = True, nullable = False)
# func add data to table thanh_phan
def addThanhphan(self, excelValue):
# thanhphan = Thanh_phan(excelValue)
self.name = excelValue
sqldb.session.add(self)
sqldb.session.commit()
class Meovat(sqldb.Model):
__tablename__ = 'meovat'
__searchable__ = ['body']
id = sqldb.Column(sqldb.Integer, primary_key = True)
name = sqldb.Column(sqldb.String(255), unique = True, nullable = False)
mo_ta = sqldb.Column(sqldb.Text, nullable = False)
def addMeovat(self, name, mo_ta):
self.name = name
self.mo_ta = mo_ta
sqldb.session.add(self)
sqldb.session.commit()