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
