def add_products_to_purchase(self, products):
for product in products:
productinpurchase = ProductsInPurchasesORM(
purchase_id=self.id,
product_name=product.product_name,
store_id=product.store_id,
quantity=pquantity)
session.add(productinpurchase)
session.commit()
def appoint_manager(self, owner, to_appoint):
Base.metadata.create_all(engine, [Base.metadata.tables['managers']],
checkfirst=True)
manager = ManagerORM(username=to_appoint,
store_id=id,
appointed_by=owner)
self.managed_by.append(manager)
session.add(manager)
session.commit()
def appoint_owner(self, owner, appointed_by):
Base.metadata.create_all(engine, [Base.metadata.tables['stores']],
checkfirst=True)
Base.metadata.create_all(engine, [Base.metadata.tables['owners']],
checkfirst=True)
Base.metadata.create_all(engine, [Base.metadata.tables['regusers']],
checkfirst=True)
owner = OwnerORM(username=owner,
store_id=id,
appointed_by=appointed_by)
self.owned_by.append(owner)
session.add(owner)
session.commit()
def add(self):
Base.metadata.create_all(engine,
[Base.metadata.tables['CompositeDiscounts']],
checkfirst=True)
session.add(self)
session.commit()
def add(self, owner):
Base.metadata.create_all(engine, [Base.metadata.tables['owners']],
checkfirst=True)
session.add(owner)
session.commit()
def add(self):
Base.metadata.create_all(engine,
[Base.metadata.tables['storepolicies']],
checkfirst=True)
session.add(self)
session.commit()
def add(self):
Base.metadata.create_all(
engine, [Base.metadata.tables['conditionalproductdiscounts']],
checkfirst=True)
session.add(self)
session.commit()
def add(self):
Base.metadata.create_all(engine, [Base.metadata.tables['passwords']],
checkfirst=True)
session.add(self)
session.commit()
def add(self):
Base.metadata.create_all(engine, [Base.metadata.tables['productsinbaskets']], checkfirst=True)
session.add(self)
session.commit()
def add_notification(self, username, message):
from project.data_access_layer.UserNotificationsORM import UserNotificationORM
notif = UserNotificationORM(username=username, notification=message)
session.add(notif)
session.commit()
