Re: [sqlalchemy] Inherit foreign key to a dynamic table based on inherited column value

2018-04-05 Thread Johnathan Norton
I wasnt looking to use the monster,race,foliage, and fauna classes as mixins for the character ones. There's not a monster, or fauna stat that i want to add on to a character object. Didnt realize this is what I'm trying to do until you asked the right questions. I guess I'm trying to make it

Re: [sqlalchemy] Inherit foreign key to a dynamic table based on inherited column value

2018-04-05 Thread Mike Bayer
when you have CharacterEntity, would there also be MonsterCharacterEntity, FaunaCharacterEntity, etc. ? if you had "Monster", "Fauna", "Race", "Foliage" mixins that are applied to the LivingEntity hierarchy that would be a place to hold your "species_lookup" relationship. What is the base of the

[sqlalchemy] Inherit foreign key to a dynamic table based on inherited column value

2018-04-05 Thread Johnathan Norton
Disclaimer: I'm very new at this. Only been learning databases for a couple weeks, and been working with python for about a month and 1/2. I did do several searches, phrasing things differently, but I can't seem to find my answer. I'm trying to build a overly complex DnD database and cmdline