search

Jmartz007 / Wow_mythic_groups

Tool that helps create mythic+ groups for weekly guild night.
0 stars 1 forks source link

SQL reader script or functions #6

Closed Jmartz007 closed 1 year ago

Jmartz007 commented 1 year ago

Need to be able to read the 4 tables in the database and iterate through the rows. The data needs to be appropriately placed into dictionaries with dictionaries inside in the following format:

"Jmartz": {"Calioma" : {"Level": 7, "Dungeon": "freehold", "Class": "Priest", "Role": ["Healer"]},
                        "Solemartz": {"Level": 3, "Dungeon": "Vortex Pinnacle", "Class": "Mage", "Role": ["DPS"]},
                        "Jmartz": {"Level": 16, "Dungeon": "Halls of Infusion", "Class": "Warrior", "Role": ["Tank", "DPS"]}},
                "Cardinal": {"Fluke" : {"Level": 14, "Dungeon": "Underrot", "Class": "Hunter", "Role": ["DPS"]},
                        "Gael" : {"Level": 10, "Dungeon": "Brackenhide", "Class": "Druid", "Role": ["DPS"]}}

This is the required format for the current group making python script.

Jmartz007 commented 1 year ago

Can currently read database.db and assign players.PlayerNames, characters.CharacterNames, characters.Role int he sqlReader.py Main branch is up to this point.