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()