def getClientCharacter(self, char_id):
DA = DataAccess()
char = DA.getCharacter(char_id)
ability_list = []
for ab in DA.getCharAbilities(char.id):
ability_list.append(ClientAbility(ab.ability_id, DA.getAbilityDetails(ab.ability_id).name,
ab.ability_value, ab.ability_note))
weakness_list = []
for wk in DA.getCharWeaknesses(char.id):
weakness_list.append(ClientWeakness(wk.weakness_id,DA.getWeaknessDetails(wk.weakness_id).name,
wk.weakness_value, wk.weakness_note))
attack_list = []
for at in DA.getCharAttacks(char.id):
perks = []
for pk in DA.getAttackPerks(at.id):
perks.append(ClientPerk(pk.perk_id, DA.getPerkDetails(pk.perk_id).name, pk.multiplier, pk.note))
flaws = []
for fl in DA.getAttackFlaws(at.id):
flaws.append(ClientFlaw(fl.flaw_id, DA.getFlawDetails(fl.flaw_id).name, fl.multiplier, fl.note))
attack_list.append(ClientAttack(at.name, perks, flaws, at.roll,
at.dx, at.end, at.note))
cchar = ClientCharacter(char.user_id, char.name, char.combat_notes,
ability_list, weakness_list, attack_list,
char.defense, char.health, char.endurance, char.tv,
char.background, char.appearance, char.personality,
char.other_notes, char.portrait_url, char.icon_url)
cchar.id = char_id
return cchar
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()