def special_page_n(page): query = (db.session.query(Rooms, MiiData, ParadeMiis).filter( Rooms.room_id == page).filter(Rooms.room_id == MiiData.mii_id).filter( Rooms.room_id == ParadeMiis.mii_id).first()) if not query: return exceptions.NotFound() queried_room, queried_mii, queried_parade = query return { "sppageid": page, # TODO: database schema should handle proper times regarding catalog. "strdt": current_date_and_time(), "enddt": current_date_and_time(), "name": queried_parade.news, "stopflag": 0, "level": queried_parade.level, "bgm": queried_room.bgm.value, "mascot": queried_room.mascot, "contact": queried_room.contact, "intro": { "inmsginfo": { "inmsgseq": 1, "inmsg": queried_room.intro_msg, } }, "miiinfo": { "seq": 1, "miiid": queried_mii.mii_id, "color1": queried_mii.color1, "color2": queried_mii.color2, "msginfo": [ RepeatedElement({ "msgseq": 1, "msg": queried_room.mii_msg, }), ], }, "menu": { "place": 1, "type": 4, "imageid": "d1234", "coup": { "coupid": 1, "couptitle": "coupon test", "couplimit": 10, "coupmov": 1, "coupmovap": 0, }, }, "logo": { "logo1id": queried_parade.logo_id, "logo2id": queried_room.logo2_id }, }
def special_page_n(page): # TODO: revert from temporary, pre-determined value to database schema intro_filler = [] for i in range(9): intro_filler.append( RepeatedElement({ "inmsgseq": i + 1, "inmsg": "Hello!", })) msginfo_filler = [] for i in range(3): msginfo_filler.append( RepeatedElement({ "msgseq": i + 1, "msg": "Testing...", })) return { "sppageid": page, # TODO: database schema should handle proper times regarding catalog. "strdt": current_date_and_time(), "enddt": current_date_and_time(), "name": "Testing: The Movie", "stopflag": 0, "level": 1, "bgm": 2, "mascot": 0, "contact": 0, "intro": { "inmsginfo": intro_filler }, "miiinfo": { "seq": 1, "miiid": 1, "color1": "ffcd00", "color2": "000000", "msginfo": msginfo_filler, }, "menu": { "place": 1, "type": 5, "imageid": "h1234", "link": { "linkid": 1, "linktitle": "Welcome to nginx", "linktype": 0, "linkmov": 0, "linkpicnum": 1, "linkurl": "http://example.com", "linkpicbgm": 1, }, }, "logo": { "logo1id": "g1234", "logo2id": "f1234" }, }
def special_page_n(page): query = (db.session.query(Rooms, MiiData, ParadeMiis).filter( Rooms.room_id == page).filter(Rooms.room_id == MiiData.mii_id).filter( Rooms.room_id == ParadeMiis.mii_id).first()) if not query: return exceptions.NotFound() queried_room, queried_mii, queried_parade = query menu_data = db.session.query(RoomMenu).filter(Rooms.room_id == page).all() menus = [] for place, data in enumerate(menu_data): menus.append(RepeatedElement(data.data | {"place": place + 1})) return { "sppageid": page, # TODO: database schema should handle proper times regarding catalog. "strdt": current_date_and_time(), "enddt": current_date_and_time(), "name": queried_parade.news, "stopflag": 0, "level": queried_parade.level, "bgm": queried_room.bgm.value, "mascot": queried_room.mascot, "contact": queried_room.contact, "intro": { "inmsginfo": { "inmsgseq": 1, "inmsg": queried_room.intro_msg, } }, "miiinfo": { "seq": 1, "miiid": queried_mii.mii_id, "color1": queried_mii.color1, "color2": queried_mii.color2, "msginfo": [ RepeatedElement({ "msgseq": 1, "msg": queried_room.mii_msg, }), ], }, "menu": menus, "logo": { "logo1id": queried_parade.logo_id, "logo2id": queried_room.logo2_id }, }
def search_movies(category_id): retrieved_data = (db.session.query(PayCategoriesPosters).filter( PayCategoriesPosters.category_id == category_id).order_by( PayCategoriesPosters.movieid).all()) results = [] if not retrieved_data: # Looks like this category does not exist, or contains no movies. return exceptions.NotFound() for i, paycategoryposters in enumerate(retrieved_data): results.append( RepeatedElement({ "rank": paycategoryposters.rank, "movieid": paycategoryposters.movieid, "title": paycategoryposters.title, "strdt": current_date_and_time(), "pop": paycategoryposters.pop, "kana": 12345678, "refid": "01234567890123456789012345678912", "released": paycategoryposters.release_date, "term": 1, "price": paycategoryposters.price, })) return { "num": paycategoryposters.num, "categid": category_id, "movieinfo": results, }
def special_all(): page_info = [] parade_miis = (db.session.query(ParadeMiis, MiiData).filter( ParadeMiis.mii_id == MiiData.mii_id).order_by(ParadeMiis.mii_id).all()) for parade_mii, mii_data in parade_miis: page_info.append( RepeatedElement({ "sppageid": mii_data.mii_id, "name": mii_data.name, "level": parade_mii.level, "miiid": mii_data.mii_id, "color1": mii_data.color1, "color2": mii_data.color2, "logo1id": parade_mii.logo_id, "news": parade_mii.news, "valid": 1, "pref": "11111111111111111111111111111111111111111111111", })) return { "pageinfo": page_info, "upddt": current_date_and_time(), }
def search(): q = request.args.get("q") if q is None: return {"num": 1, "categid": 12345} s = es.search(index="tv_index", body={"query": {"match": {"title": q}}}) shows = s["hits"]["hits"] show_ids = {} for i in shows: show_ids[i["_source"]["id"]] = i["_source"]["title"] movieinfos = [] rank = 0 has_results = False if len(shows) != 0: has_results = True for i in show_ids.keys(): rank += 1 movieinfos.append( RepeatedElement({ "rank": rank, "movieid": i, "title": show_ids[i], "genre": 1, "strdt": current_date_and_time(), "pop": 0, })) if has_results: return {"num": 1, "categid": 12345, "movieinfo": movieinfos} else: return {"num": 1, "categid": 12345}
def list_category_search(categ_id): retrieved_data = (db.session.query( CategoryMovies, Movies).filter(CategoryMovies.category_id == categ_id).filter( CategoryMovies.movie_id == Movies.movie_id).order_by( Movies.movie_id).all()) results = [] if not retrieved_data: # Looks like this category does not exist, or contains no movies. return exceptions.NotFound() for i, data in enumerate(retrieved_data): _, movie_data = data # Items must be indexed by 1. results.append( RepeatedElement({ "rank": i + 1, "movieid": movie_data.movie_id, "title": movie_data.title, "genre": movie_data.genre, "strdt": current_date_and_time(), "pop": 0, })) return { "num": 1, "categid": categ_id, "movieinfo": results, }
def conf_first_bin_xml(): return { "maint": 0, "url1": get_config_url("url1"), "url2": get_config_url("url2"), "url3": get_config_url("url3"), "eulaver": 3, "shopurl": get_config_url("shop") + "index.esf", "shopkey": "7fce738e542f0a60fe5d8d8e1e8781af", "shopvalid": 1, "akahost": 5, "akaca": 1, "smpkey": "5ab362aa57dbb1dc16849e3e2d1cf2ff", "fmax": 30, "bmax": 10, "upddt": current_date_and_time(), }
def popular_all(): # TODO: revert from temporary, pre-determined value to database schema filler = [] for i in range(3): # Items must be indexed by 1. filler.append( RepeatedElement({ "rank": i + 1, "movieid": 1, "title": "Shiba: The Movie", "genre": 1, "strdt": current_date_and_time(), "pop": 0, })) return { "movieinfo": filler, }
def new_all(): queried_categories = NewMovies.query.order_by(NewMovies.title.asc()).all() filler = [] for i, new_movies in enumerate(queried_categories): # Items must be indexed by 1. filler.append( RepeatedElement({ "rank": i + 1, "movieid": new_movies.movie_id, "title": new_movies.title, "genre": 1, "strdt": current_date_and_time(), "pop": 0, })) return { "movieinfo": filler, }
def reginfo_cgi(): return { "sdt": current_date_and_time(), "cdt": current_date_and_time(), "limited": "0", }
def datetime_xml(): # DateTime is roughly equivalent to RegInfo as seen in v1025. return {"upddt": current_date_and_time()}