ViewVC Help
View File | Revision Log | Show Annotations | View Changeset | Root Listing
root/ns_dev/Python/NinoCode/Active_prgs/Gromulus/Gromulus_UI.py
Revision: 976
Committed: Fri Feb 13 02:00:16 2026 UTC (6 weeks, 1 day ago) by nino.borges
Content type: text/x-python
File size: 14789 byte(s)
Log Message:
Refactor catalog data flow: unify schema usage, fix UI data contracts, and match metadata via main_app_file_hash

File Contents

# User Rev Content
1 nino.borges 795 """
2     Created by Emanuel Borges
3     05.19.2023
4    
5     This is the main UI for Gromulus, which is a catalog inventory for roms, games and maybe one day applications.
6     Like most of my GUI programs, this will import a separate library with my methods for doing the actual work.
7    
8     """
9    
10    
11     import sys, os, wx
12     #import wx.lib.buttons as buttons
13     import Gromulus_Lib
14    
15    
16    
17     class MyFrame(wx.Frame):
18     def __init__(self, parent, ID, title, pos=wx.DefaultPosition):
19 nino.borges 976 wx.Frame.__init__(self, parent, ID, title, pos, size = (1450,725))
20 nino.borges 909 self.db = Gromulus_Lib.DatabaseManager()
21 nino.borges 976 self.dbConnection = self.db.get_connection()
22 nino.borges 795 self.panel = wx.Panel(self,-1)
23 nino.borges 976 self.currentSystemKey = "SNES"
24     self.gamesListMatrix = Gromulus_Lib.GetGameListBySystem(self.currentSystemKey, self.dbConnection)
25 nino.borges 795 gamesList = list(self.gamesListMatrix.keys())
26     gamesList.sort()
27 nino.borges 806 self.gamesCount = len(gamesList)
28     unmatchedGamesList=[i for i in gamesList if "." in i]
29     self.unmatchedGamesCount = len(unmatchedGamesList)
30     print(f"{self.gamesCount} total games for this system. {self.gamesCount - self.unmatchedGamesCount} matched and {self.unmatchedGamesCount} unmatched.")
31 nino.borges 795
32     self.CreateSystemButtonSection()
33     self.gameSelectionListBox = wx.ListBox(self.panel, 60, (100, 50), (490, 320), gamesList , wx.LB_SINGLE|wx.LB_OWNERDRAW)
34     self.CreateFieldsFirstRow()
35    
36    
37    
38     mainSizer = wx.BoxSizer(wx.HORIZONTAL)
39     mainSizer.Add(self.buttonSizer, 0, wx.ALIGN_TOP|wx.LEFT|wx.TOP,25)
40     mainSizer.Add(self.gameSelectionListBox, 0, wx.ALIGN_TOP|wx.LEFT|wx.TOP,25)
41     mainSizer.Add(self.fieldsFirstRowSizer, 0, wx.ALIGN_TOP|wx.LEFT|wx.TOP,25)
42     self.panel.SetSizer(mainSizer)
43    
44    
45     self.CreateStatusBar()
46     self.SetStatusText("Ready.")
47     self.CreateMenuBar()
48    
49     self.Bind(wx. EVT_TOGGLEBUTTON, self.OnSystemSelected, self.snesSystemButton)
50     self.Bind(wx. EVT_TOGGLEBUTTON, self.OnSystemSelected, self.nesSystemButton)
51     self.Bind(wx. EVT_TOGGLEBUTTON, self.OnSystemSelected, self.genesisSystemButton)
52     self.Bind(wx. EVT_TOGGLEBUTTON, self.OnSystemSelected, self.fz1SystemButton)
53     self.Bind(wx. EVT_TOGGLEBUTTON, self.OnSystemSelected, self.ps1SystemButton)
54    
55     self.Bind(wx.EVT_LISTBOX, self.OnGameSelected, self.gameSelectionListBox)
56    
57 nino.borges 976 def _set_text(self, text_ctrl, value):
58     text_ctrl.SetValue(value if value else "")
59 nino.borges 795
60 nino.borges 976 def _load_games_for_system(self, system_key):
61     self.currentSystemKey = system_key
62     self.gamesListMatrix = Gromulus_Lib.GetGameListBySystem(system_key, self.dbConnection)
63     gamesList = list(self.gamesListMatrix.keys())
64     gamesList.sort()
65    
66     self.gameSelectionListBox.Clear()
67     self.gameSelectionListBox.AppendItems(gamesList)
68    
69     self._set_text(self.gameNameTextCtrl, "")
70     self._set_text(self.gameHashTextCtrl, "")
71     self._set_text(self.gameFileNameTextCtrl, "")
72     self._set_text(self.gameFilePathTextCtrl, "")
73     self._set_text(self.noIntroGameNameTextCtrl, "")
74     self._set_text(self.noIntroSystemNameTextCtrl, "")
75    
76    
77 nino.borges 795 def CreateSystemButtonSection(self):
78     #systemsList = ['SNES','NES','Genisys']
79     #for system in systemsList:
80     #self.snesSystemButton = buttons.GenToggleButton(self.panel, -1, "SNES")
81     #self.nesSystemButton = buttons.GenToggleButton(self.panel, -1, "NES")
82     #self.genesisSystemButton = buttons.GenToggleButton(self.panel, -1, "Genesis")
83     #self.ps1SystemButton = buttons.GenToggleButton(self.panel, -1, "Playstation")
84    
85     ## Create a dictionary that holds the button instances by label text, so that you can toggle the other ones off in the bind event.
86     self.systemButtonDict = {}
87 nino.borges 976 self.buttonSystemMap = {}
88 nino.borges 795 self.snesSystemButton = wx.ToggleButton(self.panel, -1, "SNES")
89     self.systemButtonDict[self.snesSystemButton.GetLabelText()] = self.snesSystemButton
90 nino.borges 976 self.buttonSystemMap[self.snesSystemButton.GetLabelText()] = "SNES"
91 nino.borges 795
92     self.nesSystemButton = wx.ToggleButton(self.panel, -1, "NES")
93     self.systemButtonDict[self.nesSystemButton.GetLabelText()] = self.nesSystemButton
94 nino.borges 976 self.buttonSystemMap[self.nesSystemButton.GetLabelText()] = "NES"
95 nino.borges 795
96     self.genesisSystemButton = wx.ToggleButton(self.panel, -1, "Genesis")
97     self.systemButtonDict[self.genesisSystemButton.GetLabelText()] = self.genesisSystemButton
98 nino.borges 976 self.buttonSystemMap[self.genesisSystemButton.GetLabelText()] = "Genesis"
99 nino.borges 795
100     self.fz1SystemButton = wx.ToggleButton(self.panel, -1, "3DO")
101     self.systemButtonDict[self.fz1SystemButton.GetLabelText()] = self.fz1SystemButton
102 nino.borges 976 self.buttonSystemMap[self.fz1SystemButton.GetLabelText()] = "3DO"
103 nino.borges 795
104     self.ps1SystemButton = wx.ToggleButton(self.panel, -1, "Playstation")
105     self.systemButtonDict[self.ps1SystemButton.GetLabelText()] = self.ps1SystemButton
106 nino.borges 976 self.buttonSystemMap[self.ps1SystemButton.GetLabelText()] = "Playstation"
107     self.snesSystemButton.SetValue(True)
108 nino.borges 795
109    
110     self.buttonSizer = wx.BoxSizer(wx.VERTICAL)
111     self.buttonSizer.Add(self.snesSystemButton, 0, wx.ALL,10)
112     self.buttonSizer.Add(self.nesSystemButton,0,wx.ALL,10)
113     self.buttonSizer.Add(self.genesisSystemButton,0,wx.ALL,10)
114     self.buttonSizer.Add(self.fz1SystemButton,0,wx.ALL,10)
115     self.buttonSizer.Add(self.ps1SystemButton,0,wx.ALL,10)
116    
117     def CreateFieldsFirstRow(self):
118     self.gameNameStaticText = wx.StaticText(self.panel, -1, "Game Name:")
119     self.gameNameTextCtrl = wx.TextCtrl(self.panel, -1, size=(325, -1))
120    
121     self.gameHashStaticText = wx.StaticText(self.panel, -1, "Game Hash:")
122     self.gameHashTextCtrl = wx.TextCtrl(self.panel, -1, size=(325, -1))
123    
124     self.gameFileNameStaticText = wx.StaticText(self.panel, -1, "Game File Name:")
125     self.gameFileNameTextCtrl = wx.TextCtrl(self.panel, -1, size=(325, -1))
126    
127     self.gameFilePathStaticText = wx.StaticText(self.panel, -1, "Game File Path:")
128     self.gameFilePathTextCtrl = wx.TextCtrl(self.panel, -1, size=(425, -1))
129    
130     self.noIntroGameNameStaticText = wx.StaticText(self.panel, -1, "No Intro Game Name:")
131     self.noIntroGameNameTextCtrl = wx.TextCtrl(self.panel, -1, size=(325, -1))
132    
133     self.noIntroSystemNameStaticText = wx.StaticText(self.panel, -1, "No Intro System:")
134     self.noIntroSystemNameTextCtrl = wx.TextCtrl(self.panel, -1, size=(380, -1))
135    
136 nino.borges 976 self.tosecGameNameStaticText = wx.StaticText(self.panel, -1, "TOSEC Game Name:")
137     self.tosecGameNameTextCtrl = wx.TextCtrl(self.panel, -1, size=(325, -1))
138    
139 nino.borges 795 self.gameNameSizer = wx.BoxSizer(wx.HORIZONTAL)
140     self.gameNameSizer.Add(self.gameNameStaticText,0,wx.ALL, 10)
141     self.gameNameSizer.Add(self.gameNameTextCtrl,0,wx.ALL, 10)
142    
143     self.gameHashSizer = wx.BoxSizer(wx.HORIZONTAL)
144     self.gameHashSizer.Add(self.gameHashStaticText,0,wx.ALL, 10)
145     self.gameHashSizer.Add(self.gameHashTextCtrl,0,wx.ALL, 10)
146    
147     self.gameFileNameSizer = wx.BoxSizer(wx.HORIZONTAL)
148     self.gameFileNameSizer.Add(self.gameFileNameStaticText,0,wx.ALL, 10)
149     self.gameFileNameSizer.Add(self.gameFileNameTextCtrl,0,wx.ALL, 10)
150    
151     self.gameFilePathSizer = wx.BoxSizer(wx.HORIZONTAL)
152     self.gameFilePathSizer.Add(self.gameFilePathStaticText,0,wx.ALL, 10)
153     self.gameFilePathSizer.Add(self.gameFilePathTextCtrl,0,wx.ALL, 10)
154    
155     self.noIntroGameNameSizer = wx.BoxSizer(wx.HORIZONTAL)
156     self.noIntroGameNameSizer.Add(self.noIntroGameNameStaticText,0,wx.ALL, 10)
157     self.noIntroGameNameSizer.Add(self.noIntroGameNameTextCtrl,0,wx.ALL, 10)
158    
159     self.noIntroSystemNameSizer = wx.BoxSizer(wx.HORIZONTAL)
160     self.noIntroSystemNameSizer.Add(self.noIntroSystemNameStaticText,0,wx.ALL, 10)
161     self.noIntroSystemNameSizer.Add(self.noIntroSystemNameTextCtrl,0,wx.ALL, 10)
162    
163 nino.borges 976 self.tosecGameNameSizer = wx.BoxSizer(wx.HORIZONTAL)
164     self.tosecGameNameSizer.Add(self.tosecGameNameStaticText,0,wx.ALL, 10)
165     self.tosecGameNameSizer.Add(self.tosecGameNameTextCtrl,0,wx.ALL, 10)
166    
167 nino.borges 795 self.fieldsFirstRowSizer = wx.BoxSizer(wx.VERTICAL)
168     self.fieldsFirstRowSizer.Add(self.gameNameSizer,0,wx.ALL, 10)
169     self.fieldsFirstRowSizer.Add(self.gameHashSizer,0,wx.ALL, 10)
170     self.fieldsFirstRowSizer.Add(self.gameFileNameSizer,0,wx.ALL, 10)
171     self.fieldsFirstRowSizer.Add(self.gameFilePathSizer,0,wx.ALL, 10)
172     self.fieldsFirstRowSizer.Add(self.noIntroGameNameSizer,0,wx.ALL, 10)
173     self.fieldsFirstRowSizer.Add(self.noIntroSystemNameSizer,0,wx.ALL, 10)
174 nino.borges 976 self.fieldsFirstRowSizer.Add(self.tosecGameNameSizer,0,wx.ALL, 10)
175 nino.borges 795
176    
177     def MenuData(self):
178     return(("&Tools",
179 nino.borges 805 ("&Add Roms","Adds new Roms to a selected system.", self.OnAddNewRoms),
180     ("Import &NoIntro DAT", "Allows for the import of any of the No Intro DAT files.", self.OnImportNewNoIntroDat),
181 nino.borges 806 ("Import &TOSEC DAT", "Allows for the import of any of the TOSEC DAT files.", self.OnImportNewTosecDat)),
182 nino.borges 795 ("&Reports",
183     ("&Duplicates Report","Generates a report detailing duplicates that exist in your collection.", self.NothingYet)),
184     ("&Help",
185     ("&About", "Displays the About Window", self.NothingYet)))
186    
187     def CreateMenuBar(self):
188     menuBar = wx.MenuBar()
189     for eachMenuData in self.MenuData():
190     menuLabel = eachMenuData[0]
191     menuItems = eachMenuData[1:]
192     menuBar.Append(self.CreateMenu(menuItems), menuLabel)
193     self.SetMenuBar(menuBar)
194    
195     def CreateMenu(self, menuData):
196     menu = wx.Menu()
197     for eachLabel, eachStatus, eachHandler in menuData:
198     if not eachLabel:
199     menu.AppendSeparator()
200     continue
201     menuItem = menu.Append(-1, eachLabel, eachStatus)
202     self.Bind(wx.EVT_MENU, eachHandler, menuItem)
203     return menu
204    
205     def OnSystemSelected(self, evt):
206 nino.borges 976 if not evt.GetEventObject().GetValue():
207     evt.GetEventObject().SetValue(True)
208     return
209    
210 nino.borges 795 systemsButtonNamesList = list(self.systemButtonDict.keys())
211     systemsButtonNamesList.remove(evt.GetEventObject().GetLabelText())
212     for i in systemsButtonNamesList:
213     self.systemButtonDict[i].SetValue(False)
214    
215 nino.borges 976 system_key = self.buttonSystemMap.get(evt.GetEventObject().GetLabelText(), "SNES")
216     self._load_games_for_system(system_key)
217 nino.borges 795
218    
219     def OnGameSelected(self, evt):
220     print(self.gameSelectionListBox.GetStringSelection())
221 nino.borges 976 selected = self.gameSelectionListBox.GetStringSelection()
222     if not selected:
223     return
224 nino.borges 795
225 nino.borges 976 gameData = Gromulus_Lib.GetSingleGameById(self.gamesListMatrix[selected], self.dbConnection)
226     if not gameData:
227     return
228 nino.borges 795
229 nino.borges 976 display_name = gameData.get("game_name") or gameData.get("no_intro_game") or gameData.get("tosec_game") or gameData.get("filename")
230     no_intro_name = gameData.get("no_intro_game")
231     no_intro_system = gameData.get("no_intro_system") or gameData.get("tosec_system")
232     tosec_name = gameData.get("tosec_game")
233    
234     self._set_text(self.gameNameTextCtrl, display_name)
235     self._set_text(self.gameHashTextCtrl, gameData.get("hash"))
236     self._set_text(self.gameFileNameTextCtrl, gameData.get("filename"))
237     self._set_text(self.gameFilePathTextCtrl, gameData.get("path"))
238     self._set_text(self.noIntroGameNameTextCtrl, no_intro_name)
239     self._set_text(self.noIntroSystemNameTextCtrl, no_intro_system)
240     self._set_text(self.tosecGameNameTextCtrl, tosec_name)
241    
242 nino.borges 795 def NothingYet(self, event):
243     diag = wx.MessageDialog(self, "Nothing here yet!", "Disabled...", wx.OK | wx.ICON_INFORMATION)
244     diag.ShowModal()
245     diag.Destroy()
246    
247 nino.borges 805 def OnImportNewNoIntroDat(self,event):
248     dlg = wx.FileDialog(
249     self, message="Import New NoIntro DAT ...", defaultDir=os.getcwd(),
250     defaultFile="", wildcard="DAT files (*.dat)|*.dat", style=wx.FD_OPEN | wx.FD_CHANGE_DIR
251     )
252     if dlg.ShowModal() == wx.ID_OK:
253     datPath = dlg.GetPath()
254 nino.borges 908 Gromulus_Lib.ImportNewNoIntroDat(datPath, self.dbConnection)
255 nino.borges 805 doneDiag = wx.MessageDialog(self, "NoIntro DAT imported","All Done!",wx.OK | wx.ICON_INFORMATION)
256     doneDiag.ShowModal()
257     doneDiag.Destroy()
258 nino.borges 795
259 nino.borges 806 def OnImportNewTosecDat(self,event):
260     dlg = wx.FileDialog(
261     self, message="Import New Tosec DAT ...", defaultDir=os.getcwd(),
262     defaultFile="", wildcard="DAT files (*.dat)|*.dat", style=wx.FD_OPEN | wx.FD_CHANGE_DIR
263     )
264     if dlg.ShowModal() == wx.ID_OK:
265     datPath = dlg.GetPath()
266 nino.borges 908 Gromulus_Lib.ImportNewTosecDat(datPath, self.dbConnection)
267 nino.borges 806 doneDiag = wx.MessageDialog(self, "Tosec DAT imported","All Done!",wx.OK | wx.ICON_INFORMATION)
268     doneDiag.ShowModal()
269     doneDiag.Destroy()
270    
271    
272 nino.borges 805 def OnAddNewRoms(self,event):
273 nino.borges 908 systemMatrix = Gromulus_Lib.GetSystemList(self.dbConnection)
274 nino.borges 805 systemsList = list(systemMatrix.keys())
275     dlg = wx.SingleChoiceDialog(self,
276     "Select system for new ROMs",
277     "List of systemss", systemsList)
278     if (dlg.ShowModal() == wx.ID_OK):
279     dlg2 = wx.DirDialog(self, "Choose a directory:",
280     style=wx.DD_DEFAULT_STYLE)
281     if (dlg2.ShowModal() == wx.ID_OK):
282     romsToImportPath = dlg2.GetPath()
283     systemID = systemMatrix[dlg.GetStringSelection()][0]
284 nino.borges 908 importedCount, alreadyExistsCount, errImportCount = Gromulus_Lib.AddNewRoms(romsToImportPath, systemID, self.dbConnection)#, testOnly=True)
285 nino.borges 805 #print(systemMatrix[dlg.GetStringSelection()])
286     #print(dlg2.GetPath())
287     doneDiag = wx.MessageDialog(self, f"{str(importedCount)} files imported.\n{str(alreadyExistsCount)} files not imported because you already have them.\n{str(errImportCount)} files imported because of errors.", "Rom import process complete",wx.OK | wx.ICON_INFORMATION)
288     doneDiag.ShowModal()
289     doneDiag.Destroy()
290    
291    
292    
293 nino.borges 795 class MyApp(wx.App):
294     def OnInit(self):
295 nino.borges 909 self.frame = MyFrame(None, -1, "Gromulus v1.2")
296 nino.borges 795 self.frame.Show(True)
297     self.SetTopWindow(self.frame)
298     return True
299 nino.borges 908 def OnExit(self):
300 nino.borges 910 if hasattr(self, "frame") and hasattr(self.frame, "db"):
301     self.frame.db.close()
302 nino.borges 908 print("Closed DB")
303     return 0
304 nino.borges 795
305    
306     if __name__ == '__main__':
307     app = MyApp(0)
308 nino.borges 976 app.MainLoop()