def remove_user(self, email): user_to_be_removed = db_session.query(UserDB).filter( UserDB.email == email).one() db_session.delete(user_to_be_removed) db_session.commit() db_session.flush()
def attend_next_customer(): next_customer = db_session.query(AppointmentsDB).filter( AppointmentsDB.request_addressed is False).one() next_customer.request_addressed = True db_session.update(next_customer) db_session.commit() db_session.flush()
def remove_insurance_plan(self, plan_id): update_plan = db_session.query(InsurancePlanDB).filter( InsurancePlanDB.plan_id == plan_id).one() update_plan.plan_active = False db_session.update(update_plan) db_session.commit() db_session.flush()
def buy_plan(self, plan_details): curr_customer = db_session.query(UserDB).filter( UserDB.email == self.email).one() curr_customer.additional_metadata = eval( curr_customer.additional_metadata.replace('null', 'None')) curr_customer.additional_metadata['plan_details'] = plan_details db_session.add(curr_customer) db_session.commit() db_session.flush()
def request_sales_rep(self): email = self.email appointment_request_date = datetime.utcnow() request_addressed_details = dict() appointment = AppointmentsDB( email=email, appointment_request_date=appointment_request_date, request_addressed=False, request_addressed_details=request_addressed_details) db_session.add(appointment) db_session.commit() db_session.flush()
def add_user(self, username, email, password, phone_no, postal_address, role, session_id): additional_metadata = dict() additional_metadata['phone_no'] = phone_no additional_metadata['postal_address'] = postal_address additional_metadata['session_id'] = session_id new_user = UserDB(name=username, email=email, password=password, role=role, additional_metadata=additional_metadata) db_session.add(new_user) db_session.commit() db_session.flush() return new_user
def add_insurance_plan(self, plan_details): new_plan = InsurancePlanDB(True, plan_details=plan_details) db_session.add(new_plan) db_session.commit() db_session.flush()