def addClientCharacter(self, cchar): DA = DataAccess() session = DA.getSession() character = Character(user_id=cchar.user_id, name=cchar.name, combat_notes=cchar.combat_notes, defense=cchar.defense, health=cchar.health, endurance=cchar.endurance, tv=cchar.tv, background=cchar.background, appearance=cchar.appearance, personality=cchar.personality, other_notes=cchar.other_notes) session.add(character) session.commit() cchar.id = character.id for at in cchar.attacks: attack = CharacterAttack(character_id=character.id, name=at.name, roll=at.roll, dx=at.dx, end=at.end, note=at.note) session.add(attack) session.commit() for pk in at.perks: aperk = AttackPerk(perk_id=pk.perk_id, attack_id=attack.id, multiplier=pk.multiplier, note=pk.note) session.add(aperk) session.commit() for fl in at.flaws: aflaw = AttackFlaw(flaw_id=fl.flaw_id, attack_id=attack.id, multiplier=fl.multiplier, note=fl.note) session.add(aflaw) session.commit() for ab in cchar.abilities: cability = CharacterAbility(ability_id=ab.ability_id, character_id=character.id, ability_value=ab.value, ability_note=ab.note) session.add(cability) session.commit() for wk in cchar.weaknesses: cweakness = CharacterWeakness(weakness_id=wk.weakness_id, character_id=character.id, weakness_value=wk.value, weakness_note=wk.note) session.add(cweakness) session.commit() session.commit() print cchar.id
def deleteClientCharacter(self, char_id): DA = DataAccess() session = DA.getSession() character = DA.getCharacter(char_id) if character != None: session.delete(character) for atk in DA.getCharAttacks(char_id): session.delete(atk) for pk in DA.getAttackPerks(atk.id): session.delete(pk) for fl in DA.getAttackFlaws(atk.id): session.delete(fl) for abi in DA.getCharAbilities(char_id): session.delete(abi) for wkn in DA.getCharWeaknesses(char_id): session.delete(wkn) session.commit()
def updateClientCharacter(self, cchar, char_id): DA = DataAccess() session = DA.getSession() character = DA.getCharacter(char_id) character.user_id=cchar.user_id character.name=cchar.name character.combat_notes=cchar.combat_notes character.defense=cchar.defense character.health=cchar.health character.endurance=cchar.endurance character.tv=cchar.tv character.background=cchar.background character.appearance=cchar.appearance character.personality=cchar.personality character.other_notes=cchar.other_notes session.add(character) session.commit() cchar.id = character.id for atk in DA.getCharAttacks(char_id): session.delete(atk) for pk in DA.getAttackPerks(atk.id): session.delete(pk) for fl in DA.getAttackFlaws(atk.id): session.delete(fl) for at in cchar.attacks: attack = CharacterAttack(character_id=character.id, name=at.name, roll=at.roll, dx=at.dx, end=at.end, note=at.note) session.add(attack) session.commit() for pk in at.perks: aperk = AttackPerk(perk_id=pk.perk_id, attack_id=attack.id, multiplier=pk.multiplier, note=pk.note) session.add(aperk) session.commit() for fl in at.flaws: aflaw = AttackFlaw(flaw_id=fl.flaw_id, attack_id=attack.id, multiplier=fl.multiplier, note=fl.note) session.add(aflaw) session.commit() for abi in DA.getCharAbilities(char_id): session.delete(abi) for ab in cchar.abilities: cability = CharacterAbility(ability_id=ab.ability_id, character_id=character.id, ability_value=ab.value, ability_note=ab.note) session.add(cability) session.commit() for wkn in DA.getCharWeaknesses(char_id): session.delete(wkn) for wk in cchar.weaknesses: cweakness = CharacterWeakness(weakness_id=wk.weakness_id, character_id=character.id, weakness_value=wk.value, weakness_note=wk.note) session.add(cweakness) session.commit() session.commit()