def test_cascade_gem_slot_association_delete(db_session):
clegg = Character('clegg')
gemslot = GemSlotAssociation(
'wrist',
Gem(168641, 5, 'Quick Sand Spinel',
'inv_misc_gem_x4_uncommon_perfectcut_yellow', '+50 Haste'))
clegg.gems.append(gemslot)
db_session.add(clegg)
db_session.flush()
clegg.gems = []
assert None == db_session.query(GemSlotAssociation).first()
def test_serialize_gems():
jack = Character('jack')
jack.gems = [
GemSlotAssociation('wrist',
Gem(168641, 5, 'Quick Sand Spinel', 'inv_misc_gem_x4_uncommon_perfectcut_yellow', '+50 Haste')),
GemSlotAssociation('waist',
Gem(168645, 5, 'Masterful Name', 'inv_misc_gem_x5_uncommon_perfectcut_purple', '+50 Mastery'))
]
_serialize_gems(jack)
assert jack.gem_ids == '168641|168645'
assert jack.gem_qualities == '5|5'
assert jack.gem_names == 'Quick Sand Spinel|Masterful Name'
assert jack.gem_icons == 'inv_misc_gem_x4_uncommon_perfectcut_yellow|inv_misc_gem_x5_uncommon_perfectcut_purple'
assert jack.gem_stats == '+50 Haste|+50 Mastery'
assert jack.gem_slots == 'wrist|waist'
