def get_search_requests(page=0, limit=100, type=None):
query = Search().select(
Search.time, Search.internal, Search.query, Search.identifier_key,
Search.identifier_value, Search.category, Search.season,
Search.episode, Search.type, Search.username, Search.title,
Search.author, TvIdCache.title.alias("tvtitle"),
MovieIdCache.title.alias("movietitle")).join(
TvIdCache,
JOIN.LEFT_OUTER,
on=(((Search.identifier_value == TvIdCache.tvdb) &
(Search.identifier_key == "tvdbid")) |
((Search.identifier_value == TvIdCache.tvrage) &
(Search.identifier_key == "rid")))).join(
MovieIdCache,
JOIN.LEFT_OUTER,
on=(((Search.identifier_value == MovieIdCache.imdb) &
(Search.identifier_key == "imdbid")) |
((Search.identifier_value == MovieIdCache.tmdb) &
(Search.identifier_key == "tmdbid"))))
if type is not None and type != "All":
query = query.where(
Search.internal) if type == "Internal" else query.where(
~Search.internal)
total_requests = query.count()
requests = list(
query.order_by(Search.time.desc()).paginate(page, limit).dicts())
search_requests = {
"totalRequests": total_requests,
"searchRequests": requests
}
return search_requests
def get_search_requests(page=0, limit=100, type=None):
query = Search().select(Search.time, Search.internal, Search.query, Search.identifier_key, Search.identifier_value, Search.category, Search.season, Search.episode, Search.type)
if type is not None and type != "All":
query = query.where(Search.internal) if type == "Internal" else query.where(~Search.internal)
total_requests = query.count()
requests = list(query.order_by(Search.time.desc()).paginate(page, limit).dicts())
search_requests = {"totalRequests": total_requests, "searchRequests": requests}
return search_requests
def get_search_requests(page=0, limit=100, type=None):
query = Search().select(Search.time, Search.internal, Search.query, Search.identifier_key, Search.identifier_value, Search.category, Search.season, Search.episode, Search.type, Search.username, TvIdCache.title.alias("tvtitle"), MovieIdCache.title.alias("movietitle")).join(TvIdCache, JOIN.LEFT_OUTER, on=(
((Search.identifier_value == TvIdCache.tvdb) & (Search.identifier_key == "tvdbid")) |
((Search.identifier_value == TvIdCache.tvrage) & (Search.identifier_key == "rid"))
)).join(MovieIdCache, JOIN.LEFT_OUTER, on=(
((Search.identifier_value == MovieIdCache.imdb) & (Search.identifier_key == "imdbid")) |
((Search.identifier_value == MovieIdCache.tmdb) & (Search.identifier_key == "tmdbid"))))
if type is not None and type != "All":
query = query.where(Search.internal) if type == "Internal" else query.where(~Search.internal)
total_requests = query.count()
requests = list(query.order_by(Search.time.desc()).paginate(page, limit).dicts())
search_requests = {"totalRequests": total_requests, "searchRequests": requests}
return search_requests
def get_search_requests(page=0, limit=100, type=None):
query = Search().select(Search.time, Search.internal, Search.query,
Search.identifier_key, Search.identifier_value,
Search.category, Search.season, Search.episode,
Search.type, Search.username)
if type is not None and type != "All":
query = query.where(
Search.internal) if type == "Internal" else query.where(
~Search.internal)
total_requests = query.count()
requests = list(
query.order_by(Search.time.desc()).paginate(page, limit).dicts())
search_requests = {
"totalRequests": total_requests,
"searchRequests": requests
}
return search_requests
