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()}
