class techEras(db.Model):
id = db.Column(db.Integer, primary_key=True)
era = db.Column(db.String(50), nullable=False)
nextEra = db.Column(db.String(50), nullable=False)
def __repr__(self):
return f"era:{self.era} \n nextEra:{self.nextEra} \n"
class warDataBase(db.Model):
id = db.Column(db.Integer, primary_key=True)
era = db.Column(db.String(50), nullable=False)
unit_key = db.Column(db.Integer, nullable=False)
unit_name = db.Column(db.String(50), nullable=False)
power = db.Column(db.Integer, nullable=False)
price = db.Column(db.Integer, nullable=False)
buildTime = db.Column(db.Integer, nullable=False)
mightBonus = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f" Era: {self.era} \n unit_key: {self.unit_key} \n unit_name: {self.unit_name} \n power: {self.power} \n price: {self.price} \n buildTime: {self.buildTime} \n mightBonus: {self.mightBonus} \n "
class PTc(db.Model):
# id column
id = db.Column(db.Integer, primary_key=True)
goldPrice = db.Column(db.Integer, nullable=False)
gold = db.Column(db.Integer, nullable=False)
goldPriceChange = db.Column(db.String(50), nullable=False)
goldHistory = db.Column(db.String(100), nullable=False)
goldAverage = db.Column(db.Integer, nullable=False)
rareMetalsPrice = db.Column(db.Integer, nullable=False)
rareMetals = db.Column(db.Integer, nullable=False)
rareMetalsPriceChange = db.Column(db.String(50), nullable=False)
rareMetalsHistory = db.Column(db.String(100), nullable=False)
rareMetalsAverage = db.Column(db.Integer, nullable=False)
gemsPrice = db.Column(db.Integer, nullable=False)
gems = db.Column(db.Integer, nullable=False)
gemsPriceChange = db.Column(db.String(50), nullable=False)
gemsHistory = db.Column(db.String(100), nullable=False)
gemsAverage = db.Column(db.Integer, nullable=False)
oilPrice = db.Column(db.Integer, nullable=False)
oil = db.Column(db.Integer, nullable=False)
oilPriceChange = db.Column(db.String(50), nullable=False)
oilHistory = db.Column(db.String(100), nullable=False)
oilAverage = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f" goldPrice: {self.goldPrice} \n gold: {self.gold} \n goldPriceChange: {self.goldPriceChange} \n goldHistory: {self.goldHistory} \n goldAverage: {self.goldAverage} \n rareMetalsPrice: {self.rareMetalsPrice} \n rareMetals: {self.rareMetals} \n rareMetalsPriceChange: {self.rareMetalsPriceChange} \n rareMetalsHistory: {self.rareMetalsHistory} \n rareMetalsAverage: {self.rareMetalsAverage} \n gemsPrice: {self.gemsPrice} \n gems: {self.gems} \n gemsPriceChange: {self.gemsPriceChange} \n gemsHistory: {self.gemsHistory} \n gemsAverage: {self.gemsAverage} \n oilPrice: {self.oilPrice} \n oil: {self.oil} \n oilPriceChange: {self.oilPriceChange} \n oilHistory: {self.oilHistory} \n oilAverage: {self.oilAverage} \n "
class friendship(db.Model):
id = db.Column(db.Integer, primary_key=True)
country = db.Column(db.String(50), nullable=False)
targetCountry = db.Column(db.String(50), nullable=False)
level = db.Column(db.Integer, nullable=False)
warDate = db.Column(db.String(50), nullable=False)
initiated = db.Column(db.Integer, nullable=False)
numWars = db.Column(db.Integer, nullable=False)
declared = db.Column(db.String(50), nullable=False)
attacked = db.Column(db.String(50), nullable=False)
lost = db.Column(db.Integer, nullable=False)
won = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f"country:{self.country} \n targetCountry:{self.targetCountry} \n level:{self.level} \n warDate:{self.warDate} \n initiated:{self.initiated} \n numWars :{self.numWars} \n declared:{self.declared} \n attacked:{self.attacked} \n lost:{self.lost} \n won:{self.won} "
class warAssets(db.Model):
id = db.Column(db.Integer, primary_key=True)
country = db.Column(db.String(50), nullable=False)
era = db.Column(db.String(50), nullable=False)
active = db.Column(db.Integer, nullable=False, default=0)
wOne = db.Column(db.String(50), nullable=False)
wOneAmount = db.Column(db.Integer, nullable=False)
wOneLevel = db.Column(db.Integer, nullable=False)
wOnePower = db.Column(db.Integer, nullable=False)
wTwo = db.Column(db.String(50), nullable=False)
wTwoAmount = db.Column(db.Integer, nullable=False)
wTwoLevel = db.Column(db.Integer, nullable=False)
wTwoPower = db.Column(db.Integer, nullable=False)
wThree = db.Column(db.String(50), nullable=False)
wThreeAmount = db.Column(db.Integer, nullable=False)
wThreeLevel = db.Column(db.Integer, nullable=False)
wThreePower = db.Column(db.Integer, nullable=False)
wFour = db.Column(db.String(50), nullable=False)
wFourAmount = db.Column(db.Integer, nullable=False)
wFourLevel = db.Column(db.Integer, nullable=False)
wFourPower = db.Column(db.Integer, nullable=False)
wFive = db.Column(db.String(50), nullable=False)
wFiveAmount = db.Column(db.Integer, nullable=False)
wFiveLevel = db.Column(db.Integer, nullable=False)
wFivePower = db.Column(db.Integer, nullable=False)
wSix = db.Column(db.String(50), nullable=False)
wSixAmount = db.Column(db.Integer, nullable=False)
wSixLevel = db.Column(db.Integer, nullable=False)
wSixPower = db.Column(db.Integer, nullable=False)
wSeven = db.Column(db.String(50), nullable=False)
wSevenAmount = db.Column(db.Integer, nullable=False)
wSevenLevel = db.Column(db.Integer, nullable=False)
wSevenPower = db.Column(db.Integer, nullable=False)
wEight = db.Column(db.String(50), nullable=False)
wEightAmount = db.Column(db.Integer, nullable=False)
wEightLevel = db.Column(db.Integer, nullable=False)
wEightPower = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f"ID:{self.id} \n Country: {self.country} \n era: {self.era} \n active: {self.active} \n wOne: {self.wOne} {self.wOneAmount} {self.wOneLevel} {self.wOnePower} \n wTwo: {self.wTwo} {self.wTwoAmount} {self.wTwoLevel} {self.wTwoPower} \n wThree: {self.wThree} {self.wThreeAmount} {self.wThreeLevel} {self.wThreePower} \n wFour: {self.wFour} {self.wFourAmount} {self.wFourLevel} {self.wFourPower}\n wFive: {self.wFive} {self.wFiveAmount} {self.wFiveLevel} {self.wFivePower} \n wSix: {self.wSix} {self.wSixAmount} {self.wSixLevel}{self.wSixPower} \n wSeven: {self.wSeven} {self.wSevenAmount} {self.wSevenLevel} {self.wSevenPower} \n wEight: {self.wEight} {self.wEightAmount} {self.wEightLevel} {self.wEightPower} \n"
class techAssets(db.Model):
id = db.Column(db.Integer, primary_key=True)
country = db.Column(db.String(50), nullable=False)
era = db.Column(db.String(50), nullable=False)
active = db.Column(db.Integer, nullable=False, default=0)
one = db.Column(db.String(50), nullable=False)
oneRp = db.Column(db.Integer, nullable=False)
oneP = db.Column(db.Integer, nullable=False)
two = db.Column(db.String(50), nullable=False)
twoRp = db.Column(db.Integer, nullable=False)
twoP = db.Column(db.Integer, nullable=False)
three = db.Column(db.String(50), nullable=False)
threeRp = db.Column(db.Integer, nullable=False)
threeP = db.Column(db.Integer, nullable=False)
four = db.Column(db.String(50), nullable=False)
fourRp = db.Column(db.Integer, nullable=False)
fourP = db.Column(db.Integer, nullable=False)
five = db.Column(db.String(50), nullable=False)
fiveRp = db.Column(db.Integer, nullable=False)
fiveP = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f"ID:{self.id} \n Country: {self.country} \n era: {self.era} \n active: {self.active} \nrOne:{self.one} C:{self.oneRp} P:{self.oneP} \n two:{self.two} C:{self.twoRp} P:{self.twoP} \n three:{self.three} C:{self.threeRp} P:{self.threeP} \n four:{self.four} C:{self.fourRp} P:{self.fourP} \n five:{self.five} C:{self.fiveRp} P:{self.fiveP} \n"
class techEraCost(db.Model):
id = db.Column(db.Integer, primary_key=True)
era = db.Column(db.String(50), nullable=False)
oneRp = db.Column(db.Integer, nullable=False)
oneW = db.Column(db.Integer, nullable=False)
twoRp = db.Column(db.Integer, nullable=False)
twoW = db.Column(db.Integer, nullable=False)
threeRp = db.Column(db.Integer, nullable=False)
threeW = db.Column(db.Integer, nullable=False)
fourRp = db.Column(db.Integer, nullable=False)
fourW = db.Column(db.Integer, nullable=False)
fiveRp = db.Column(db.Integer, nullable=False)
fiveW = db.Column(db.Integer, nullable=False)
class gameTracker(db.Model):
id = db.Column(db.Integer, primary_key=True)
countryID = db.Column(db.Integer, nullable=False, default=1)
country = db.Column(db.String(50), nullable=False, default="USA")
started = db.Column(db.Integer, nullable=False, default=0)
year = db.Column(db.Integer, nullable=False, default=1949)
month = db.Column(db.Integer, nullable=False, default=1)
# Only need once
eraOneAverageRP = db.Column(db.Integer, nullable=False, default=1)
eraTwoAverageRP = db.Column(db.Integer, nullable=False, default=1)
eraThreeAverageRP = db.Column(db.Integer, nullable=False, default=1)
def __repr__(self):
return f"countryID:{self.countryID} \n country:{self.country} \n started:{self.started} \n year:{self.year} \n month:{self.month} \n eraOneAverageRP:{self.eraOneAverageRP} \n eraTwoAverageRP:{self.eraTwoAverageRP} \n eraThreeAverageRP:{self.eraThreeAverageRP} \n "
class techEraBonus(db.Model):
id = db.Column(db.Integer, primary_key=True)
era = db.Column(db.String(50), nullable=False)
one = db.Column(db.String(50), nullable=False)
two = db.Column(db.String(50), nullable=False)
three = db.Column(db.String(50), nullable=False)
four = db.Column(db.String(50), nullable=False)
five = db.Column(db.String(50), nullable=False)
def __repr__(self):
return f"one:{self.one} \n two:{self.two} \n three:{self.three} \n four:{self.four} \n five:{self.five} \n "
class NATIONS(db.Model):
id = db.Column(db.Integer, primary_key=True)
country = db.Column(db.String(50), nullable=False)
selected = db.Column(db.Integer, nullable=False, default=0)
score = db.Column(db.Integer, nullable=False, default=0)
wealth = db.Column(db.Integer, nullable=False)
fLevel = db.Column(db.String(50), nullable=False)
gold = db.Column(db.Integer, nullable=False)
gems = db.Column(db.Integer, nullable=False)
rareMetals = db.Column(db.Integer, nullable=False)
oil = db.Column(db.Integer, nullable=False)
might = db.Column(db.Integer, nullable=False)
wLevel = db.Column(db.String(50), nullable=False)
firePower = db.Column(db.Integer, nullable=False)
KP = db.Column(db.Integer, nullable=False)
tLevel = db.Column(db.Integer, nullable=False)
era = db.Column(db.String(50), nullable=False)
RP = db.Column(db.Integer, nullable=False)
influence = db.Column(db.Integer, nullable=False)
pLevel = db.Column(db.String(50), nullable=False)
stability = db.Column(db.Integer, nullable=False)
backing = db.Column(db.Integer, nullable=False)
chance = db.Column(db.Integer, nullable=False)
aggression = db.Column(db.Integer, nullable=False)
creativity = db.Column(db.Integer, nullable=False)
materialism = db.Column(db.Integer, nullable=False)
prudence = db.Column(db.Integer, nullable=False)
bonusUnits = db.Column(db.Integer, nullable=False)
notes = db.Column(db.String(50), nullable=False)
hints = db.Column(db.String(50), nullable=False)
Nextmoves = db.Column(db.String(50), nullable=False, default='')
moveLimit = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f"ID:{self.id} \n Country: {self.country} \n Selected?: {self.selected} \n Score: {self.score} \n Wealth: {self.wealth} \n Finance: {self.fLevel} \n Gold: {self.gold} \n Gems: {self.gems} \n RareMetals: {self.rareMetals} \n Oil: {self.oil} \n Might: {self.might} \n wLevel: {self.wLevel}\n Firepower: {self.firePower} \n KP:{self.KP} \n tLevel:{self.tLevel} \n era:{self.era} \n RP:{self.RP} \n influence:{self.influence} \n pLevel:{self.pLevel} \n stability:{self.stability} \n backing:{self.backing} \n chance:{self.chance} \n moveLimit:{self.moveLimit} \n aggression:{self.aggression} \n creativity:{self.creativity} \n materialism:{self.materialism} \n prudence:{self.prudence} \n bonusUnits:{self.bonusUnits} \n notes:{self.notes} \n hints:{self.hints} \n Nextmoves:{self.Nextmoves} \n"
class dialogue(db.Model):
id = db.Column(db.Integer, primary_key=True)
playerPrintLine = db.Column(db.String(80))
AIPrintLine = db.Column(db.String(80))
gamePrintLine = db.Column(db.String(80))