Identified major issue in database layout -> cascade="all, delete, delete-orphan"

[klondikemarlen]

Do to the nature of the way I set up the relationships in the database it is extremely hard to delete any of the tables. See:

• http://docs.sqlalchemy.org/en/latest/orm/tutorial.html?highlight=cascade#configuring-delete-delete-orphan-cascade
• https://stackoverflow.com/questions/1905470/cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails#17828127
• http://www.mysqltutorial.org/mysql-on-delete-cascade/

I will have to reorganize most of the database to make it convenient to delete a Hero or User object. Specs (when deleting):

User account -> it should delete all associated:

• Heroes

Hero -> it should delete all associated:

• Inventory
• Proficiency
• Atribute
• etc
• etc?

[klondikemarlen]

Some of these are fixed ... but the dam thing is so big ... I can't every hope to find them all :P

[klondikemarlen]

Tables fixed:

• [x] abilities
• [x] ability
• [x] adjacent_location
• [x] alembic_version
• [x] attribute
• [x] attributes
• [x] base_dict
• [x] base_item
• [x] base_list
• [x] board
• [x] condition
• [x] display
• [x] event
• [x] forum
• [x] hero
• [x] inbox
• [x] inventory
• [x] item
• [x] journal
• [x] location
• [x] message
• [x] monster_template
• [x] post
• [x] proficiencies
• [x] proficiency
• [x] quest
• [x] quest_path
• [x] quest_path_to_quest
• [x] specialization
• [x] specialization_container
• [x] thread
• [x] trigger
• [x] user

[klondikemarlen]

Fixed in https://github.com/elthran/RPG-Game/commit/d32d7a3ac5c663dff4fa6dadb6f48f57086305f6.

I hope. I probably introduce some bugs but hey .. that's what a test suite if for ...