def _select_all(self, condition):
with Persistance().session as session:
if condition:
result = session.query(Movies).filter(text(condition)).all()
else:
result = session.query(Movies).all()
if result:
return [each_row.to_obj() for each_row in result if each_row]
else:
return []
def _select_one(self, condition):
with Persistance().session as session:
if condition:
result = session.query(Movies).filter(text(condition)).first()
else:
result = session.query(Movies).first()
if result:
return [result.to_obj()]
else:
return []
def delete(moviename):
with Persistance().session as session:
session.query(Movies).filter(
text(f"movies.movie_name={moviename}")).delete(
synchronize_session=False)
def update(dict_args):
with Persistance().session as session:
session.query(Movies).filter(
text(
f"movies.movie_name={dict_args.get('moviename')}")).update(
dict_args, synchronize_session=False)
def create(dict_args):
#print(dict_args)
movies_model_ins = Movies(dict_args)
with Persistance().session as session:
session.add(movies_model_ins)