def get_between_indexes_movie(cls, begin_index=0, end_index=10):
end_id = cls.movie_dal.get_end_id()
if (end_id > end_index and begin_index < end_index):
where_code = "WHERE id<={} AND id>={}".format(
end_id - begin_index, end_id - end_index)
else:
raise Exception()
result_list = cls.movie_dal.get(where_code, True)
return SuccessDataResult(result_list).toMap()
def fonk3(self, value1):
result = value1
return SuccessDataResult("OK", result).toMap()
def get_by_name_movie(cls, name):
result_list = cls.movie_dal.get("WHERE name LIKE '%{}%'".format(name),
True)
return SuccessDataResult(result_list).toMap()
def get_by_year_movie(cls, year):
result_list = cls.movie_dal.get("WHERE year>={}".format(year), True)
return SuccessDataResult(result_list).toMap()
def get_by_imdb_movie(cls, imdb):
result_list = cls.movie_dal.get("WHERE imdb>={}".format(imdb), True)
return SuccessDataResult(result_list).toMap()
def get_by_category_movie(cls, category_id):
where_code = """WHERE category_indexes LIKE '{id}' OR category_indexes LIKE '{id}-%'
OR category_indexes LIKE '%-{id}' OR category_indexes LIKE '%-{id}-%' """.format(
id=category_id)
result_list = cls.movie_dal.get(where_code, True)
return SuccessDataResult(result_list).toMap()
def get_by_language_movie(cls, language_id):
result_list = cls.movie_dal.get(
"WHERE language_index={}".format(language_id), True)
return SuccessDataResult(result_list).toMap()
def get_all_movie(cls):
result_list = cls.movie_dal.get("", True)
return SuccessDataResult(result_list).toMap()
def get_by_custom_code(cls, sql_code):
result_list = cls.movie_dal.get_custom_code(sql_code)
return SuccessDataResult(result_list).toMap()
def get_by_id_movie(cls, id):
result_list = cls.movie_dal.get("WHERE id={}".format(id), True)
return SuccessDataResult(result_list).toMap()