class ProcessedOrder(GenericModel):
pid = db.Column('pr_order_id', db.Integer(), primary_key=True)
orderId = db.Column("order_id",db.ForeignKey("mainorder.order_id"),unique=False)
menuid = db.Column("menus",db.ForeignKey("menu.menu_id"),unique=False,nullable=True)
roomid = db.Column("room",db.ForeignKey("room.room_id"),unique=False,nullable=True)
finalprice = db.Column('menu_price', db.Float())
qty = db.Column('menu_qty', db.Integer())
class Customer(GenericModel):
id = db.Column('cust_id', db.Integer(), primary_key=True)
name = db.Column('cust_name', db.String(40), unique=True)
address = db.Column('cust_address', db.String(40),)
contact = db.Column('cust_contact',db.BigInteger())
email = db.Column('cust_email',db.String(40))
accno = db.Column("acc_id", db.ForeignKey("account.acc_no"), unique=False, nullable=True)
orderref = db.relationship("Mainorder",lazy=True,backref="custref",uselist=True)
@staticmethod
def get_dummy_customer():
return Customer(id=0,name='',address='',contact='',email='')
class Hotel(GenericModel):
id = db.Column('hotel_id',db.Integer(),primary_key=True)
name = db.Column('hotel_name',db.String(40),unique=True)
address = db.Column('hotel_address',db.String(40))
contact = db.Column('hotel_contact',db.Integer())
website = db.Column('hotel_website', db.String(40))
accno = db.Column("acc_id", db.ForeignKey("account.acc_no"), unique=False, nullable=True)
#menuref = db.relationship("Menu",secondary='menu_hotel',backref=db.backref("hotelref1",uselist=True))
roomref = db.relationship("Room", secondary=room_hotel, backref=db.backref("rhotelref", uselist=True))
orderref = db.relationship("Mainorder", lazy=True, backref="ohotelref", uselist=True)
@staticmethod
def get_dummy_hotel():
return Hotel(id=0, name='', address='', contact=0,website='')
class userZip(db.Model, UserMixin):
__tablename__ = 'userZip'
id = db.Column(db.Integer, primary_key=True)
usermsg = db.Column(db.String(100))
img_name = db.Column(db.String(40))
img = db.Column(db.LargeBinary(length=2048))
userId = db.Column(db.Integer, db.ForeignKey('User.userId'))
def __init__(self, id, usermsg, img_name, img, userId):
self.id = id
self.usermsg = usermsg
self.img_name = img_name
self.img = img
self.userId = userId
class Mainorder(GenericModel):
id = db.Column('order_id', db.Integer(), primary_key=True)
csid = db.Column('cust_id', db.ForeignKey("customer.cust_id"),nullable=False,unique=False)
htid = db.Column('hotel_id', db.ForeignKey("hotel.hotel_id"),nullable=False,unique=False)
billamount = db.Column('total_bill', db.Float())
from configuration import db,app
class GenericModel(db.Model):
__abstract__ = True
created = db.Column(db.DateTime, default=db.func.current_timestamp())
updated = db.Column(db.DateTime, default=db.func.current_timestamp(),onupdate=db.func.current_timestamp())
active = db.Column('active', db.String(10),default='Yes')
menu_hotel = db.Table('menu_hotel',
db.Column('menu_id',db.ForeignKey('menu.menu_id')),
db.Column('hotel_id',db.ForeignKey('hotel.hotel_id'))
)
class Menu(GenericModel):
id = db.Column('menu_id', db.Integer(), primary_key=True)
name = db.Column('menu_name', db.String(40),)
price = db.Column('menu_price', db.Float())
href = db.relationship('Hotel',secondary=menu_hotel, backref=db.backref("menuref", lazy=True))
@staticmethod
def get_dummy_menu():
return Menu(id=0,name='',price=0.0)
room_hotel = db.Table('room_hotel',
db.Column('room_id',db.ForeignKey('room.room_id'),unique=False),
db.Column('hotel_id',db.ForeignKey('hotel.hotel_id'),unique=False)
)
class Hotel(GenericModel):
id = db.Column('hotel_id',db.Integer(),primary_key=True)
name = db.Column('hotel_name',db.String(40),unique=True)
address = db.Column('hotel_address',db.String(40))