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 ): 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 ): 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] )
def __init__(self): self.decisionMaker = RandomDecisionMaker() self.playerCardDeck = [] self.hobbyCardDeck = [] self.partnerCardDeck = [] self.childCardDeck = [] self.jobCardDeck = [] self.revealedHobbyCards = [] self.revealedPartnerCards = [] self.revealedJobCards = [] self.players = [] #Initialize and shuffle all decs playerCardRows = DataManager.getRows( "SELECT PlayerCode FROM Player" ) for playerCard in playerCardRows: self.playerCardDeck.append( PlayerCard(playerCard['PlayerCode']) ) hobbyCardRows = DataManager.getRows( "SELECT HobbyCode FROM Hobby" ) for hobbyCard in hobbyCardRows: self.hobbyCardDeck.append( HobbyCard(hobbyCard['HobbyCode']) ) partnerCardRows = DataManager.getRows( "SELECT PartnerCode FROM Partner" ) for partnerCard in partnerCardRows: self.partnerCardDeck.append( PartnerCard(partnerCard['PartnerCode']) ) childCardRows = DataManager.getRows( "SELECT ChildCode FROM Child" ) for childCard in childCardRows: self.childCardDeck.append( ChildCard(childCard['ChildCode']) ) jobCardRows = DataManager.getRows( "SELECT JobCode FROM Job" ) for jobCard in jobCardRows: self.jobCardDeck.append( JobCard(jobCard['JobCode']) ) self.resetGame()
def __init__(self, code ): self.code = code self.skills = DataManager.getRows( "SELECT * FROM PlayerSkill WHERE PlayerCode=?", [code] ) self.needs = DataManager.getRows( "SELECT * FROM PlayerNeed WHERE PlayerCode=?", [code] )
import sqlite3 import csv import json from DataManager import DataManager csvOut = [] #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