def remove_appointed_by(self, to_remove):
owners = session.query(OwnerORM).filter_by(appointed_by=to_remove)
for owner in owners:
owner.remove()
managers = session.query(OwnerORM).filter_by(appointed_by=to_remove)
for manager in managers:
manager.remove()
session.commit()
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, 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 remove_permission(self, manager, permission):
session.query(ManagerPermissionORM).delete.where(username=manager,
store_id=self.id,
permission=permission)
session.commit()
def remove_basket(self):
session.query(ProductsInBasketORM).delete.where(basket_id=self.id)
session.query(BasketORM).delete.where(id=self.id)
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 update_quantity(self, id, product_name, amount):
update('productsinbaskets').where(basket_id=id, product_name=product_name).values(quantity=amount)
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()
def remove(self):
session.delete(self)
session.commit()
def remove_manager(self, to_remove):
self.remove_appoint_by(to_remove)
session.query(ManagerORM).delete.where(username=to_remove)
session.commit()
def add(self):
Base.metadata.create_all(engine,
[Base.metadata.tables['CompositeDiscounts']],
checkfirst=True)
session.add(self)
session.commit()
def remove_product_from_basket(self, product_name):
session.query(ProductsInBasketORM).delete.where(
basket_id=self.id, product_name=product_name)
session.commit()
