utils.py 7.7 KB

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