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
