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