1 # -*- coding: utf-8 -*-
3 # お守りスキルのSeed特定ツールのコントロールクラス
4 # 2013/12/04 written by kei9
18 SETTING_FILE = u"settings"
19 SETTING_THRESHOLD = u"threshold"
20 SETTING_SKILLS = u"skills"
23 u""" for pyinstaller 2.1 """
24 if getattr(sys, 'frozen', False):
25 # we are running in a |PyInstaller| bundle
26 basedir = sys._MEIPASS
28 # we are running in a normal Python environment
29 basedir = os.path.dirname(__file__)
32 class AmuletToolController(wx.App):
33 u""" アプリケーションの制御クラス """
36 self.frame_view = view.MainFrameView(os.path.join(_get_base_dir(), "view", view.XRC_MAIN_FRAME))
40 self.frame_view.Show()
42 self.frame_view.DisableNoteBook()
47 self.frame_view.EnableNoteBook()
50 def _init_events(self):
52 frame = self.frame_view.frame
55 frame.Bind(wx.EVT_MENU, self.OnClose, id=self.frame_view.ID_MENU_ITEM_EXIT)
56 frame.Bind(wx.EVT_MENU, self.OnAboutBox, id=self.frame_view.ID_MENU_ITEM_ABOUT)
57 frame.Bind(wx.EVT_CLOSE, self.CloseHandler)
60 frame.Bind(wx.EVT_BUTTON, self.OnClickSeedSearch, id=self.frame_view.ID_BUTTON_SEED_SEARCH)
61 frame.Bind(wx.EVT_BUTTON, self.OnClickSeedClear, id=self.frame_view.ID_BUTTON_SEED_CLEAR)
62 frame.Bind(wx.EVT_BUTTON, self.OnClickSkillSearchFromSeed, id=self.frame_view.ID_BUTTON_SKILL_FROM_SEED_SEARCH)
63 frame.Bind(wx.EVT_BUTTON, self.OnClickSkillSearch, id=self.frame_view.ID_BUTTON_SKILL_SEARCH)
64 frame.Bind(wx.EVT_BUTTON, self.OnClickSkillClear, id=self.frame_view.ID_BUTTON_SKILL_CLEAR)
65 frame.Bind(wx.EVT_BUTTON, self.OnClickAmuletSearch, id=self.frame_view.ID_BUTTON_AMULET_SEARCH_SEARCH)
66 frame.Bind(wx.EVT_BUTTON, self.OnClickAmuletClear, id=self.frame_view.ID_BUTTON_AMULET_SEARCH_CLEAR)
67 frame.Bind(wx.EVT_BUTTON, self.OnClickSkillSearchFromAmulet, id=self.frame_view.ID_BUTTON_AMULET_SEARCH_SKILL)
68 frame.Bind(wx.EVT_BUTTON, self.OnClickSettingOK, id=self.frame_view.ID_BUTTON_SETTING_OK)
69 frame.Bind(wx.EVT_BUTTON, self.OnClickSettingClear, id=self.frame_view.ID_BUTTON_SETTING_CLEAR)
72 frame.Bind(wx.EVT_RADIOBUTTON, self.OnClickAmuletRadio, id=self.frame_view.ID_RADIO_BUTTON_AMULET1)
73 frame.Bind(wx.EVT_RADIOBUTTON, self.OnClickAmuletRadio, id=self.frame_view.ID_RADIO_BUTTON_AMULET2)
74 frame.Bind(wx.EVT_RADIOBUTTON, self.OnClickAmuletRadio, id=self.frame_view.ID_RADIO_BUTTON_AMULET3)
77 frame.Bind(wx.EVT_COMBOBOX, self.OnClickAmuletCombo, id=self.frame_view.ID_COMBO_BOX_AMULET_SEARCH_SKILL1)
78 frame.Bind(wx.EVT_COMBOBOX, self.OnClickAmuletCombo, id=self.frame_view.ID_COMBO_BOX_AMULET_SEARCH_SKILL2)
80 def _init_database(self):
83 if not os.path.exists(model.DB_FILE_NAME):
84 u""" DBが存在しない時は再生成する """
85 frame = self.frame_view.frame
87 generator = model.DataBaseGenerator(model.DB_FILE_NAME)
88 #generator = model.DataBaseGenerator()
90 dlg_view = view.GaugeDialogView(os.path.join(_get_base_dir(), "view", view.XRC_GAUGE_DIALOG))
93 dlg_view.gauge.Pulse()
95 dlg_view.finish_generation()
97 t1 = threading.Thread(target=generator.generate_db)
98 t2 = threading.Thread(target=_loop)
106 except sqlite3.Error as e:
107 self._show_error_dialog(u"データベース生成中にエラーが発生しました")
111 self.db_accessor = model.DataBaseAccessor(model.DB_FILE_NAME)
112 except sqlite3.Error as e:
113 self._show_error_dialog(u"データベースが壊れています")
116 (self._skill_id2name_dict,
117 self._skill_name2id_dict,
118 self._amulet_id2name_dict,
119 self._amulet_name2id_dict,
120 self._amulet_id2skill1_id_dict,
121 self._amulet_id2skill2_id_dict) = self.db_accessor.get_dicts()
124 def _set_views(self):
125 u""" GUIにDBの各種値をセットする """
126 self._set_combo_views()
127 self._set_spin_views()
128 self._set_check_list_views()
130 def _set_combo_views(self):
131 u""" ComboBoxの値をセットする """
132 combo_dict = self.frame_view.combo_box_skill_dict
135 for amu_key, amu_name in zip([view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3],
136 [view.NAME_AMULET1, view.NAME_AMULET2, view.NAME_AMULET3]):
137 amu_id = self._amulet_name2id_dict[amu_name]
138 skill_ids = self._amulet_id2skill2_id_dict[amu_id]
139 skill_names = [self._skill_id2name_dict[x] for x in skill_ids]
140 for combo in combo_dict[amu_key]:
142 combo.Append(view.VAL_NO_SKILL)
143 for name in skill_names:
145 combo.SetSelection(0)
148 amu_id = self._amulet_name2id_dict[view.NAME_AMULET1]
149 self._set_skill_list_from_amulet(amu_id)
150 self.frame_view.amulet2radio_button_dict[view.NAME_AMULET1].SetValue(True)
152 def _set_skill_list_from_amulet(self, amulet_id):
153 u""" お守り種類の選択が変わった時の動作 """
155 for i, (combo, skill_dict) in enumerate(zip(
156 [self.frame_view.combo_box_amulet_search_skill1,
157 self.frame_view.combo_box_amulet_search_skill2],
158 [self._amulet_id2skill1_id_dict, self._amulet_id2skill2_id_dict]
162 combo.Append(view.VAL_NO_SKILL)
163 skill_ids = skill_dict[amulet_id]
164 for skill_id in skill_ids:
165 combo.Append(self._skill_id2name_dict[skill_id])
166 skill_selected.append(skill_ids[i])
167 combo.SetSelection(0) # combo1 = skill1, combo2 = No Skill
168 self._set_spin_range(amulet_id, skill_selected[0], skill_selected[1])
170 def _set_spin_views(self):
171 u""" Spin Ctrlの最大最小をセット"""
172 min1, max1, min2, max2 = self.db_accessor.get_skill_minmax()
173 self.frame_view.spin_ctrl_amulet_search_slot_num.SetRange(view.SLOT_MIN, view.SLOT_MAX)
174 self.frame_view.spin_ctrl_highlight.SetRange(view.THRESHOLD2_MIN, view.THRESHOLD2_MAX)
175 self.frame_view.spin_ctrl_highlight.SetValue(self._highlight_threshold)
177 def _set_check_list_views(self):
178 u""" CheckListBoxの値のセット """
179 checklist = self.frame_view.check_list_box_highlight_skill
180 checklist.SetItems(self._skill_name2id_dict.keys())
181 checklist.SetCheckedStrings([self._skill_id2name_dict[x] for x in self._highlight_skills])
183 def _set_spin_range(self, amulet_id, skill1_id, skill2_id):
184 u""" スキルに応じてSpinCtrlの最大最小をセットする """
185 if skill2_id is None:
186 minmax_dict = self.db_accessor.select_minmax_from_skill_ids(amulet_id, [skill1_id])
187 min1, max1 = minmax_dict[skill1_id][0], minmax_dict[skill1_id][1]
190 minmax_dict = self.db_accessor.select_minmax_from_skill_ids(amulet_id, [skill1_id, skill2_id])
191 min1, max1 = minmax_dict[skill1_id][0], minmax_dict[skill1_id][1]
192 min2, max2 = minmax_dict[skill2_id][2], minmax_dict[skill2_id][3]
193 self.frame_view.spin_ctrl_amulet_search_skill1_val.SetRange(min1, max1)
194 self.frame_view.spin_ctrl_amulet_search_skill2_val.SetRange(min2, max2)
196 def OnClickSeedSearch(self, evt):
197 u""" search seeds from selected skills """
198 amu_id2skill_id_list_dict = {}
199 for amu_key, amu_name in zip([view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3],
200 [view.NAME_AMULET1, view.NAME_AMULET2, view.NAME_AMULET3]):
201 amu_id = self._amulet_name2id_dict[amu_name]
203 for combo in self.frame_view.combo_box_skill_dict[amu_key]:
204 name = combo.GetStringSelection()
205 if name not in self._skill_name2id_dict:
208 ls.append(self._skill_name2id_dict[name])
209 amu_id2skill_id_list_dict[amu_id] = ls
210 seed_sets = self.db_accessor.select_seeds(amu_id2skill_id_list_dict)
211 self.frame_view.text_ctrl_seed_result.SetValue(u"""Seedの候補は{0}個です。""".format(len(seed_sets)))
213 if len(seed_sets) > 0:
214 for seed in seed_sets:
215 self.frame_view.list_box_seed.Append(u"{0}".format(seed))
216 self.frame_view.list_box_seed.SetSelection(0)
217 self.frame_view.button_skill_from_seed_search.Enable()
219 def OnClickSeedClear(self, evt):
220 u""" reset seed search settings of combo box"""
221 combo_dict = self.frame_view.combo_box_skill_dict
222 for amu_key in [view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3]:
223 for combo in combo_dict[amu_key]:
224 combo.SetSelection(0)
225 self.frame_view.button_skill_from_seed_search.Disable()
226 self.frame_view.list_box_seed.Clear()
228 def OnClickSkillSearchFromSeed(self, evt):
229 u""" change page to skill search from seed"""
230 seed = self.frame_view.list_box_seed.GetStringSelection()
232 self.frame_view.text_ctrl_seed_select.SetValue(seed)
233 self.frame_view.note_book.SetSelection(view.SKILL_SEARCH_PAGE)
234 self.OnClickSkillSearch(evt)
236 def OnClickSkillSearch(self, evt):
237 u""" skill search from seed"""
238 seed = self.frame_view.text_ctrl_seed_select.GetValue()
241 skill_dict, threshold2_dict = self.db_accessor.select_skills_from_seeds([seed])
244 text_ctrl_dict = self.frame_view.text_ctrl_seed_skill_dict
245 for amu_key, amu_name in zip([view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3],
246 [view.NAME_AMULET1, view.NAME_AMULET2, view.NAME_AMULET3]):
247 amu_id = self._amulet_name2id_dict[amu_name]
248 for txt_ctr, skill_id in zip(text_ctrl_dict[amu_key], skill_dict[amu_id][seed]):
249 txt_ctr.SetValue(self._skill_id2name_dict[skill_id])
250 for txt_ctr, threshold2 in zip(text_ctrl_dict[view.KEY_THRESHOLD2], threshold2_dict[seed]):
251 txt_ctr.SetValue(u"{0}".format(threshold2))
252 self._update_highlight()
255 self._show_message_dialog(message=u"指定されたSeed値は存在しません")
257 self._show_message_dialog(message=u"Seed値には数字を入力してください")
259 def OnClickSkillClear(self, evt):
260 u""" clear skills from seed """
261 text_ctrl_dict = self.frame_view.text_ctrl_seed_skill_dict
262 for amu_key, amu_name in zip([view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3],
263 [view.NAME_AMULET1, view.NAME_AMULET2, view.NAME_AMULET3]):
264 amu_id = self._amulet_name2id_dict[amu_name]
265 for txt_ctr in text_ctrl_dict[amu_key]:
267 for txt_ctr in text_ctrl_dict[view.KEY_THRESHOLD2]:
269 self.frame_view.list_box_seed_skill_amulet_prospect.Clear()
271 def OnClickAmuletRadio(self, evt):
272 u""" switch skill lists by amulet id """
274 if btn_id == self.frame_view.ID_RADIO_BUTTON_AMULET1:
275 amu_id = self._amulet_name2id_dict[view.NAME_AMULET1]
276 elif btn_id == self.frame_view.ID_RADIO_BUTTON_AMULET2:
277 amu_id = self._amulet_name2id_dict[view.NAME_AMULET2]
278 elif btn_id == self.frame_view.ID_RADIO_BUTTON_AMULET3:
279 amu_id = self._amulet_name2id_dict[view.NAME_AMULET3]
282 self._set_skill_list_from_amulet(amu_id)
284 def OnClickAmuletCombo(self, evt):
285 u""" switch skill minmax by amulet id and skill_id"""
286 skill1_name = self.frame_view.combo_box_amulet_search_skill1.GetStringSelection()
287 skill2_name = self.frame_view.combo_box_amulet_search_skill2.GetStringSelection()
288 skill1_id = self._skill_name2id_dict[skill1_name]
289 if skill2_name in self._skill_name2id_dict:
290 skill2_id = self._skill_name2id_dict[skill2_name]
293 if self.frame_view.amulet2radio_button_dict[view.NAME_AMULET1].GetValue():
294 amu_id = self._amulet_name2id_dict[view.NAME_AMULET1]
295 elif self.frame_view.amulet2radio_button_dict[view.NAME_AMULET2].GetValue():
296 amu_id = self._amulet_name2id_dict[view.NAME_AMULET2]
297 elif self.frame_view.amulet2radio_button_dict[view.NAME_AMULET3].GetValue():
298 amu_id = self._amulet_name2id_dict[view.NAME_AMULET3]
300 raise IndexError(u"amulet id is unknown")
301 self._set_spin_range(amu_id, skill1_id, skill2_id)
304 def OnClickAmuletSearch(self, evt):
305 u""" search seeds from amulet condition """
306 skill1_name = self.frame_view.combo_box_amulet_search_skill1.GetStringSelection()
307 skill2_name = self.frame_view.combo_box_amulet_search_skill2.GetStringSelection()
308 skill1_val = self.frame_view.spin_ctrl_amulet_search_skill1_val.GetValue()
309 skill2_val = self.frame_view.spin_ctrl_amulet_search_skill2_val.GetValue()
310 slot_val = self.frame_view.spin_ctrl_amulet_search_slot_num.GetValue()
311 if self.frame_view.amulet2radio_button_dict[view.NAME_AMULET1].GetValue():
312 amu_id = self._amulet_name2id_dict[view.NAME_AMULET1]
313 elif self.frame_view.amulet2radio_button_dict[view.NAME_AMULET2].GetValue():
314 amu_id = self._amulet_name2id_dict[view.NAME_AMULET2]
315 elif self.frame_view.amulet2radio_button_dict[view.NAME_AMULET3].GetValue():
316 amu_id = self._amulet_name2id_dict[view.NAME_AMULET3]
318 raise IndexError(u"amulet id is unknown")
320 list_box = self.frame_view.list_box_amulet_search_seeds
321 if skill1_name == skill2_name:
322 self._show_message_dialog(message=u"異なるスキルを選択してください")
323 elif skill1_val == 0:
324 self._show_message_dialog(message=u"第1スキルの値には0以外を指定してください")
326 skill1_id = self._skill_name2id_dict[skill1_name]
327 if skill2_name in self._skill_name2id_dict:
328 skill2_id = self._skill_name2id_dict[skill2_name]
330 skill2_id = None # for skill2 is 0
332 tup = self.db_accessor.get_sufficient_value(
333 amu_id, skill1_id, skill2_id, skill1_val, skill2_val)
336 seeds_set = self.db_accessor.select_seeds_from_sufficient_val(amu_id, suff_val, slot_val, skill2_id)
337 if len(seeds_set) > 0:
338 self.frame_view.text_ctrl_amulet_search_result.SetValue(
339 u"{0}個のSeedで出現するお守りです".format(len(seeds_set)))
341 for seed in seeds_set:
342 list_box.Append(u"{0}".format(seed))
343 list_box.SetSelection(0)
344 self.frame_view.button_amulet_search_skill.Enable()
346 self.frame_view.text_ctrl_amulet_search_result.SetValue(
347 u"指定されたお守りは見つかりませんでした")
348 self.frame_view.button_amulet_search_skill.Disable()
351 self.frame_view.text_ctrl_amulet_search_result.SetValue(
352 u"指定されたお守りは見つかりませんでした")
353 self.frame_view.button_amulet_search_skill.Disable()
356 def OnClickAmuletClear(self, evt):
357 u""" clear amulet conditions """
358 amu_id = self._amulet_name2id_dict[view.NAME_AMULET1]
359 self._set_skill_list_from_amulet(amu_id)
360 self.frame_view.amulet2radio_button_dict[view.NAME_AMULET1].SetValue(True)
361 self.frame_view.button_amulet_search_skill.Disable()
362 self.frame_view.text_ctrl_amulet_search_result.SetValue(u"")
363 self.frame_view.list_box_amulet_search_seeds.Clear()
365 def OnClickSkillSearchFromAmulet(self, evt):
366 u""" change page to skill search from amulet"""
367 seed = self.frame_view.list_box_amulet_search_seeds.GetStringSelection()
369 self.frame_view.text_ctrl_seed_select.SetValue(seed)
370 self.frame_view.note_book.SetSelection(view.SKILL_SEARCH_PAGE)
371 self.OnClickSkillSearch(evt)
373 def OnClickSettingOK(self, evt):
374 u""" get settings of setting tab """
375 self._highlight_threshold = self.frame_view.spin_ctrl_highlight.GetValue()
376 self._highlight_skills = set([self._skill_name2id_dict[x] for x in
377 self.frame_view.check_list_box_highlight_skill.GetCheckedStrings()
378 if x in self._skill_name2id_dict])
379 self._update_highlight()
381 def OnClickSettingClear(self, evt):
382 u""" reset settings of setting tab """
383 self._highlight_threshold = view.HIGHLIGHT_THRESHOLD
384 self.frame_view.spin_ctrl_highlight.SetValue(view.HIGHLIGHT_THRESHOLD)
385 self._highlight_skills = set()
386 for idx in self.frame_view.check_list_box_highlight_skill.GetChecked():
387 self.frame_view.check_list_box_highlight_skill.Check(idx, False)
388 self._update_highlight()
390 def _update_highlight(self):
391 u""" update highlight cells """
392 text_dict = self.frame_view.text_ctrl_seed_skill_dict
393 for key in [view.KEY_AMULET1, view.KEY_AMULET2, view.KEY_AMULET3]:
394 for text_ctrl in text_dict[key]:
395 val = text_ctrl.GetValue()
396 if (val in self._skill_name2id_dict and
397 self._skill_name2id_dict[val] in self._highlight_skills):
398 text_ctrl.SetBackgroundColour("Yellow")
400 text_ctrl.SetBackgroundColour(wx.NullColor)
401 for text_ctrl in text_dict[view.KEY_THRESHOLD2]:
402 val = text_ctrl.GetValue()
403 if val.isdigit() and int(val) >= self._highlight_threshold:
404 text_ctrl.SetBackgroundColour("Yellow")
406 text_ctrl.SetBackgroundColour(wx.NullColor)
409 def _show_error_dialog(self, message=u"予期せぬエラーが発生しました", caption=u"エラー"):
411 OKボタンが押されたらアプリケーションを終了する
413 dlg = wx.MessageDialog(self.frame_view.frame,
415 caption, wx.OK | wx.ICON_ERROR)
420 def _show_message_dialog(self, message, caption=u"メッセージ"):
423 dlg = wx.MessageDialog(self.frame_view.frame,
425 caption, wx.OK | wx.ICON_INFORMATION)
429 def CloseHandler(self, evt):
430 dlg = wx.MessageDialog(parent = self.frame_view.frame,
431 message = u"終了します。よろしいですか?",
434 result = dlg.ShowModal()
436 if result == wx.ID_YES:
437 self._write_settings()
440 def OnClose(self, evt):
441 self.frame_view.Close()
443 def OnAboutBox(self, evt):
444 info = self.frame_view.GetAboutInfo()
447 def _write_settings(self):
448 with open(SETTING_FILE, mode="w") as f:
449 data = {SETTING_THRESHOLD:self._highlight_threshold,
450 SETTING_SKILLS:self._highlight_skills}
453 def _read_settings(self):
454 if os.path.exists(SETTING_FILE):
455 with open(SETTING_FILE, mode="r") as f:
457 data = pickle.load(f)
458 self._highlight_threshold = data[SETTING_THRESHOLD]
459 self._highlight_skills = data[SETTING_SKILLS]
461 self._highlight_threshold = view.HIGHLIGHT_THRESHOLD
462 self._highlight_skills = set()
464 self._highlight_threshold = view.HIGHLIGHT_THRESHOLD
465 self._highlight_skills = set()
467 if __name__ == "__main__":
468 app = AmuletToolController(False)