def __init__(self, code ):
child_row = DataManager.getRow( "SELECT * FROM Child WHERE ChildCode=?", [code] )
self.code = code
self.cost = child_row['Cost']
self.skills = DataManager.getRows( "SELECT * FROM ChildSkill WHERE ChildCode=?", [code] )
self.needs = DataManager.getRows( "SELECT * FROM ChildNeed WHERE ChildCode=?", [code] )
def __init__(self, code ):
hobby_row = DataManager.getRow( "SELECT * FROM Hobby WHERE HobbyCode=?", [code] )
self.code = code
self.expense = hobby_row['Expense']
self.skills = DataManager.getRows( "SELECT * FROM HobbySkill WHERE HobbyCode=?", [code] )
self.needs = DataManager.getRows( "SELECT * FROM HobbyNeed WHERE HobbyCode=?", [code] )
def __init__(self, code ):
job_row = DataManager.getRow( "SELECT * FROM Job WHERE JobCode=?", [code] )
self.code = code
self.pay = job_row['Pay']
self.skillRequirements = DataManager.getRows( "SELECT * FROM JobSkillRequirement WHERE JobCode=?", [code] )
self.needs = DataManager.getRows( "SELECT * FROM JobNeed WHERE JobCode=?", [code] )
def __init__(self, code ):
partner_row = DataManager.getRow( "SELECT * FROM Partner WHERE PartnerCode=?", [code] )
self.code = code
self.finances = partner_row['Finances']
self.moneyRequirement = partner_row['MoneyRequirement']
self.skillRequirements = DataManager.getRows( "SELECT * FROM PartnerSkillRequirement WHERE PartnerCode=?", [code] )
self.needs = DataManager.getRows( "SELECT * FROM PartnerNeed WHERE PartnerCode=?", [code] )
#SKILL TITLE ROW
csvOut.append( [ 'SKILLS' ] )
#SKILL TABLE HEADER ROW
csvOut.append( [ 'Name', '# player points', '# jobs required for', 'job names', \
'Total job point requirement', '# partners required for', 'Total partner point requirement' ] )
skill_rows = DataManager.getRows( "SELECT * FROM Skill ORDER BY Name" )
for skill in skill_rows:
row = []
row.append(skill['Name'])
skill_code = skill['SkillCode']
player_usage = DataManager.getRow( "SELECT SUM(Value) AS ValSum FROM PlayerSkill WHERE SkillCode=?", [skill_code] )
row.append(player_usage['ValSum'])
job_usage = DataManager.getRow( "SELECT COUNT(*) AS Cnt, SUM(Value) AS ValSum FROM JobSkillRequirement WHERE SkillCode=?", [skill_code] )
jobs = DataManager.getRows( """
SELECT
Job.Name
FROM
JOB
INNER JOIN JobSkillRequirement ON JobSkillRequirement.JobCode = Job.JobCode
WHERE
JobSkillRequirement.SkillCode=?
""", [skill_code] )
job_names = []
for j in jobs:
