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