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: