def add_sip(self, sip):
session = sql.get_session()
with session.begin():
ref = AzureSIPModel.from_dict(sip)
session.add(ref)
return ref.to_dict()
def update_sip(self, sip_account_id, sip):
session = sql.get_session()
with session.begin():
ref = self._get_sip(session, sip_account_id)
old_dict = ref.to_dict()
for k in sip:
old_dict[k] = sip[k]
new_sip = AzureSIPModel.from_dict(old_dict)
ref.account_name = new_sip.account_name
ref.sip_members = new_sip.sip_members
ref.status = new_sip.status
return ref.to_dict()
def update_sip(self, sip_project_id, sip):
session = sql.get_session()
with session.begin():
ref = self._get_sip(session, sip_project_id)
old_dict = ref.to_dict()
for k in sip:
old_dict[k] = sip[k]
new_sip = SIPModel.from_dict(old_dict)
ref.project_name = new_sip.project_name
ref.sip_members = new_sip.sip_members
ref.available_status = new_sip.available_status
ref.sid_id = new_sip.sid_id
return ref.to_dict()
def delete_sip(self, sip_account_id):
session = sql.get_session()
with session.begin():
ref = self._get_sip(session, sip_account_id)
session.delete(ref)
return
def get_sip(self, sip_account_id):
session = sql.get_session()
ref = session.query(AzureSIPModel).get(sip_account_id)
if not ref:
raise exception.NotFound(target=sip_account_id)
return ref.to_dict()
def list_available_sips(self):
session = sql.get_session()
#refs = session.query(AzureSIPModel).all()
refs = session.query(AzureSIPModel).filter_by(status="0").all()
return [ref.to_dict() for ref in refs]
def list_sips(self):
session = sql.get_session()
refs = session.query(AzureSIPModel).all()
return [ref.to_dict() for ref in refs]
def list_sips_by_sid(self, sid_id):
session = sql.get_session()
refs = session.query(SIPModel).filter_by(sid_id=sid_id).all()
return [ref.to_dict() for ref in refs]
def get_sid(self, sid_id):
session = sql.get_session()
ref = session.query(SIDModel).get(sid_id)
if not ref:
raise exception.NotFound(target=sid_id)
return ref.to_dict()
def add_sid(self, sid):
session = sql.get_session()
with session.begin():
ref = SIDModel.from_dict(sid)
session.add(ref)
return ref.to_dict()
