utils.py 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253
  1. from games.constants import (
  2. ENGLISH_PATCHED_KEYWORDS,
  3. HACK_KEYWORDS,
  4. KNOWN_DUPLICATE_TITLES,
  5. REGION_KEYWORDS,
  6. UNDUB_KEYWORDS,
  7. )
  8. import os
  9. import xml.etree.ElementTree as ET
  10. import subprocess
  11. from dateutil import parser
  12. from django.conf import settings
  13. from .models import Developer, Game, GameSystem, Genre, Publisher, GameCollection
  14. import logging
  15. logger = logging.Logger(__name__)
  16. def update_media_root_for_import(file_path):
  17. """Given a file path, re-write it for our app MEDIA_ROOT"""
  18. suffix = ""
  19. if file_path:
  20. suffix = file_path.split("/media/")[-1]
  21. return suffix
  22. def import_gamelist_file_to_db_for_system(
  23. game_system_slug, file_path=None, full_scan=False
  24. ):
  25. imported_games = []
  26. not_imported_games = []
  27. if not file_path:
  28. file_path = os.path.join(settings.ROMS_DIR, game_system_slug, "gamelist.xml")
  29. if not os.path.exists(file_path):
  30. logger.info(
  31. "File path for {game_system_slug} had no gamelist.xml file, run a scraper first!"
  32. )
  33. return
  34. gamelist = ET.parse(file_path)
  35. game_system = GameSystem.objects.filter(retropie_slug=game_system_slug).first()
  36. if not game_system:
  37. defaults = settings.GAME_SYSTEM_DEFAULTS.get(game_system_slug, None)
  38. full_system_name = game_system_slug
  39. if defaults:
  40. full_system_name = defaults.get("name", game_system_slug)
  41. game_system = GameSystem.objects.create(
  42. name=full_system_name, retropie_slug=game_system_slug
  43. )
  44. games = gamelist.findall("game")
  45. for game in games:
  46. name = game.find("name").text
  47. game_path = game.find("path").text.lower()
  48. region = Game.Region.X.name
  49. if any(us in game_path for us in REGION_KEYWORDS["US"]):
  50. region = Game.Region.US.name
  51. if any(jp in game_path for jp in REGION_KEYWORDS["JP"]):
  52. region = Game.Region.JP.name
  53. if any(eu in game_path for eu in REGION_KEYWORDS["EU"]):
  54. region = Game.Region.EU.name
  55. try:
  56. obj, created = Game.objects.get_or_create(
  57. name=name, game_system=game_system, region=region
  58. )
  59. except Game.MultipleObjectsReturned:
  60. logger.warning(
  61. f"While importing {name} for {game_system}, duplicate entry found"
  62. )
  63. if name in KNOWN_DUPLICATE_TITLES:
  64. obj, created = Game.objects.get_or_create(
  65. name=" ".join([name, region]), game_system=game_system
  66. )
  67. print(f"While importing {name} for {game_system}, duplicate entry found")
  68. continue
  69. if not created and not full_scan:
  70. not_imported_games.append(game)
  71. logger.info(f"Found game {game} and not doing full scan, so skipping")
  72. continue
  73. english_patched = game_path.lower() in ENGLISH_PATCHED_KEYWORDS
  74. undub = game_path.lower() in UNDUB_KEYWORDS
  75. hack = game_path.lower() in HACK_KEYWORDS
  76. release_date_str = game.find("releasedate").text
  77. developer_str = game.find("developer").text
  78. publisher_str = game.find("publisher").text
  79. genres_str = game.find("genre").text
  80. rating_str = game.find("rating").text
  81. players_str = "1"
  82. if game.find("players"):
  83. players_str = game.find("players").text
  84. try:
  85. kid_game = game.find("kidgame").text == "true"
  86. except AttributeError:
  87. kid_game = False
  88. genre_list = []
  89. if genres_str:
  90. genre_str_list = genres_str.split(", ")
  91. for genre_str in genre_str_list:
  92. genre, _created = Genre.objects.get_or_create(name=genre_str)
  93. genre_list.append(genre)
  94. players = int(players_str) if players_str else 1
  95. rating = float(rating_str) if rating_str else None
  96. publisher = None
  97. if publisher_str:
  98. publisher, _created = Publisher.objects.get_or_create(name=publisher_str)
  99. developer = None
  100. if developer_str:
  101. developer, _created = Developer.objects.get_or_create(name=developer_str)
  102. release_date = parser.parse(release_date_str) if release_date_str else None
  103. description = game.find("desc").text
  104. screenshot_path = update_media_root_for_import(game.find("image").text)
  105. rom_path = update_media_root_for_import(game.find("path").text)
  106. video_path_elem = game.find("video")
  107. video_path = ""
  108. if video_path_elem:
  109. video_path = update_media_root_for_import(video_path_elem.text)
  110. marquee_path = update_media_root_for_import(game.find("marquee").text)
  111. obj.game_system = game_system
  112. obj.developer = developer
  113. obj.publisher = publisher
  114. obj.players = players
  115. obj.description = description
  116. obj.release_date = release_date
  117. obj.rating = rating
  118. obj.genre.set(genre_list)
  119. obj.screenshot = screenshot_path
  120. obj.rom_file = rom_path
  121. obj.video = video_path
  122. obj.marquee = marquee_path
  123. obj.kid_game = kid_game
  124. obj.english_patched = english_patched
  125. obj.hack = hack
  126. obj.undub = undub
  127. obj.region = region
  128. obj.save()
  129. imported_games.append(game)
  130. return {"imported": imported_games, "not_imported": not_imported_games}
  131. def export_gamelist_file_to_path_for_system(game_system_slug, file_path=None):
  132. exported_games = []
  133. game_system = GameSystem.objects.get(retropie_slug=game_system_slug)
  134. if not file_path:
  135. file_path = f"/tmp/{game_system_slug}-gamelist.xml"
  136. # file_path = os.path.join(settings.ROMS_DIR, game_system_slug, "gamelist.xml")
  137. root = ET.Element("gameList")
  138. tree = ET.ElementTree(root)
  139. tree.write(file_path)
  140. games = Game.objects.filter(game_system=game_system)
  141. for game in games:
  142. game_node = ET.SubElement(root, "game")
  143. genre_str = ", ".join(game.genre.all().values_list("name", flat=True))
  144. release_date_str = ""
  145. if game.release_date:
  146. release_date_str = game.release_date.strftime("%Y%m%dT00000")
  147. ET.SubElement(game_node, "path").text = (
  148. game.rom_file.path if game.rom_file else ""
  149. )
  150. ET.SubElement(game_node, "name").text = game.name
  151. ET.SubElement(game_node, "thumbnail").text = ""
  152. ET.SubElement(game_node, "image").text = (
  153. game.screenshot.path if game.screenshot else ""
  154. )
  155. ET.SubElement(game_node, "marquee").text = (
  156. game.marquee.path if game.marquee else ""
  157. )
  158. ET.SubElement(game_node, "video").text = game.video.path if game.video else ""
  159. ET.SubElement(game_node, "rating").text = str(game.rating)
  160. ET.SubElement(game_node, "desc").text = game.description
  161. ET.SubElement(game_node, "releasedate").text = release_date_str
  162. ET.SubElement(game_node, "developer").text = str(game.developer)
  163. ET.SubElement(game_node, "publisher").text = str(game.publisher)
  164. ET.SubElement(game_node, "genre").text = genre_str
  165. ET.SubElement(game_node, "players").text = str(game.players)
  166. if game.kid_game:
  167. ET.SubElement(game_node, "kidgame").text = "true"
  168. exported_games.append(game)
  169. tree = ET.ElementTree(root)
  170. tree.write(file_path, xml_declaration=True, encoding="utf-8")
  171. return exported_games, file_path
  172. def skyscrape_console(game_system_slug):
  173. scraper_config = settings.SCRAPER_CONFIG_FILE
  174. scraper_binary = settings.SCRAPER_BIN_PATH
  175. scraper_site = settings.SCRAPER_SITE
  176. # If the config file is relative, append our base dir
  177. if scraper_config[0] != "/":
  178. scraper_config = os.path.join(settings.BASE_DIR, scraper_config)
  179. if not os.path.exists(scraper_config):
  180. logger.info(f"Config file not found at {scraper_config}")
  181. return
  182. logger.info(f"Scraping game info using configuration file from {scraper_config}")
  183. scrape_output = subprocess.run(
  184. [
  185. scraper_binary,
  186. "-c",
  187. f"{scraper_config}",
  188. "-s",
  189. f"{scraper_site}",
  190. "-f",
  191. "emulationstation",
  192. "-p",
  193. f"{game_system_slug}",
  194. ],
  195. capture_output=True,
  196. )
  197. load_output = subprocess.run(
  198. [
  199. scraper_binary,
  200. "-c",
  201. f"{scraper_config}",
  202. "-f",
  203. "emulationstation",
  204. "-p",
  205. f"{game_system_slug}",
  206. ],
  207. capture_output=True,
  208. )
  209. # TODO We should progressively pipe output to a log file instead of this
  210. # print(scrape_output)
  211. # print(load_output)
  212. print(f"Scraped info for {game_system_slug}")
  213. return scrape_output, load_output
  214. def export_collections(dryrun=True):
  215. exported = []
  216. for collection in GameCollection.objects.all():
  217. collection.export_to_file(dryrun)
  218. exported.append(collection)
  219. return exported