def find_zaruba_entity_name(keyword: str='', limit: int=100, offset: int=0):
try:
results = mb.call_rpc('find_zaruba_entity_name', keyword, limit, offset)
return [ZarubaEntityName.parse_obj(result) for result in results]
except HTTPException as error:
raise error
except Exception as error:
print(traceback.format_exc())
raise HTTPException(status_code=500, detail='Internal Server Error')
def delete_zaruba_entity_name(id: str):
try:
result = mb.call_rpc('delete_zaruba_entity_name', id)
if result is None:
raise HTTPException(status_code=404, detail='Not Found')
return ZarubaEntityName.parse_obj(result)
except HTTPException as error:
raise error
except Exception as error:
print(traceback.format_exc())
raise HTTPException(status_code=500, detail='Internal Server Error')
def insert_zaruba_entity_name(data: ZarubaEntityNameData):
try:
result = mb.call_rpc('insert_zaruba_entity_name', data.dict())
if result is None:
raise HTTPException(status_code=404, detail='Not Found')
return ZarubaEntityName.parse_obj(result)
except HTTPException as error:
raise error
except Exception as error:
print(traceback.format_exc())
raise HTTPException(status_code=500, detail='Internal Server Error')
def find_by_id(self, id: str) -> ZarubaEntityName:
db = Session(self.engine)
result: ZarubaEntityName
try:
db_result = db.query(DBZarubaEntityNameEntity).filter(
DBZarubaEntityNameEntity.id == id).first()
if db_result is None:
return None
result = ZarubaEntityName.from_orm(db_result)
finally:
db.close()
return result
def delete(self, id: str) -> ZarubaEntityName:
db = Session(self.engine)
result: ZarubaEntityName
try:
db_entity = db.query(DBZarubaEntityNameEntity).filter(
DBZarubaEntityNameEntity.id == id).first()
if db_entity is None:
return None
db.delete(db_entity)
db.commit()
result = ZarubaEntityName.from_orm(db_entity)
finally:
db.close()
return result
def insert(
self,
zaruba_entity_name_data: ZarubaEntityNameData) -> ZarubaEntityName:
db = Session(self.engine)
result: ZarubaEntityName
try:
db_entity = DBZarubaEntityNameEntity(
id=str(uuid.uuid4()), created_at=datetime.datetime.utcnow())
db.add(db_entity)
db.commit()
db.refresh(db_entity)
result = ZarubaEntityName.from_orm(db_entity)
finally:
db.close()
return result
def find(self, keyword: str, limit: int,
offset: int) -> List[ZarubaEntityName]:
db = Session(self.engine)
results: List[ZarubaEntityName] = []
try:
keyword = '%{}%'.format(keyword) if keyword != '' else '%'
db_results = db.query(DBZarubaEntityNameEntity).filter(
DBZarubaEntityNameEntity.zaruba_field_name.like(
keyword)).offset(offset).limit(limit).all()
results = [
ZarubaEntityName.from_orm(db_result)
for db_result in db_results
]
finally:
db.close()
return results
def update(
self, id: str,
zaruba_entity_name_data: ZarubaEntityNameData) -> ZarubaEntityName:
db = Session(self.engine)
result: ZarubaEntityName
try:
db_entity = db.query(DBZarubaEntityNameEntity).filter(
DBZarubaEntityNameEntity.id == id).first()
if db_entity is None:
return None
db_entity.updated_at = datetime.datetime.utcnow()
db.add(db_entity)
db.commit()
db.refresh(db_entity)
result = ZarubaEntityName.from_orm(db_entity)
finally:
db.close()
return result