def search_film_by_name(query): db = DbManager() films = db.open().query(Film).filter(Film.name.like( "%{}%".format(query))).all() db.close() return films
def delete_project(project_id): db = DbManager() # project = db.delete(get_project(project_id)) project = db.open().query(Project).filter(Project.id == project_id).one() project = db.delete(project) db.close() return project
def delete_task(task_id): print('-------------------------------------------') print(task_id) db = DbManager() task = db.open().query(Task).filter(Task.id == task_id).one() task = db.delete(task) db.close() return task
def get_tvshow_by_url(tvshow_url): DB = DbManager() try: tvshow = DB.open().query(TVShow).filter(TVShow.url == tvshow_url).one() DB.close() return tvshow except: DB = DbManager() data = get_request(tvshow_url) tvshow = TVShow() tvshow.parse_json(data) DB.save(tvshow) DB.close() return tvshow
def download_data(query): db = DbManager() datas = json.loads( requests.get( "http://api.tvmaze.com/search/shows?q={}".format(query)).text) for data in datas: try: savingdata = Film() savingdata.parse(data['show']) db.save(savingdata) print('-> created Film in db') except: print('data exist') db.close()
def check_like(user_id, film_id): db = DbManager() try: db.open().query(Like).filter(Like.user_id == user_id, Like.film_id == film_id).one() except: like_film(user_id, film_id) return db.close()
def delete_quote(quote_id): db = DbManager() quote = db.open().query(Quote).filter(Quote.id == quote_id).one() quote = db.delete(quote) db.close() return quote
def _unlike(user_id, show_id): db = DbManager() like = db.open().query(Like).filter(Like.show_id == show_id).filter(Like.user_id == user_id).one() like = db.delete(like) db.close() return like
def delete_project(project_id): db = DbManager() project = db.delete(get_project(project_id)) db.close() return project
def get_all_tasks(project_id): db = DbManager() tasks = db.open().query(Task).filter(Task.project_id == project_id).all() db.close() return tasks
def get_project(project_id): db = DbManager() projects = db.open().query(Project).filter(Project.id == project_id).one() db.close() return projects
def get_task(task_id): db = DbManager() tasks = db.open().query(Task).filter(Task.id == task_id).one() db.close() return tasks
def create_project(title): db = DbManager() project = Project() project.title = title db.close() return db.save(project)
def get_all_projects(): db = DbManager() projects = db.open().query(Project).all() db.close() return projects