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)