def test(self): conn = sqlite3.connect('DunSuciRun.sqlite') c = conn.cursor() d = conn.cursor() a = conn.cursor() print("Run test") d.execute("SELECT * FROM DUNGEONS") c.execute("SELECT * FROM BIGSCARIES") a.execute("SELECT * FROM CHARACTERS") dungeons = d.fetchall() bosses = c.fetchall() characters = a.fetchall() # Make bosses for boss in bosses: print(boss) b = Boss(boss[0], boss[1], boss[2]) b.talk() for dungeon in dungeons: print(dungeon) d = Dungeon(dungeon[0], dungeon[1], dungeon[2]) d.sign() for character in characters: print(character) a = Character(character[0], character[1], character[2]) a.announce() conn.close()
def dungeon_pick(self, name): try: self.twtr_manager.printTweet("What level of dungeon would you like? (Easy, Medium or Hard)") level = self.twtr_manager.homeTimeline() level = level.lower() #Changed to text. if "easy" in level: #keeps getting stuck in try/catch error self.twtr_manager.printTweet("You selected: Easy") level = 1 elif "medium" in level: self.twtr_manager.printTweet("You selected: Medium") level = 2 elif "hard" in level: self.twtr_manager.printTweet("You selected: Hard") level = 3 else: self.twtr_manager.printTweet('Level not recognized. Please choose Easy, Medium or Hard.') self.dungeon_pick(name) if 1 <= level <= 3: conn = sqlite3.connect('DunSuciRun.sqlite') c = conn.cursor() m = conn.cursor() n = conn.cursor() p = conn.cursor() c.execute('SELECT * FROM DUNGEONS WHERE DIFFICULTY =' + str(level)) dungeons = c.fetchall() p.execute('SELECT * FROM PLAYERS') getDate = p.fetchall() useName = getDate[0][0] gold = getDate[4][0] #I could have this backwards randomNum= random.randint(0, len(dungeons)-1) newTuple = dungeons[randomNum] dun = Dungeon(newTuple[0],newTuple[1],newTuple[2]) # dun.sign() m.execute('SELECT * FROM BIGSCARIES WHERE THEME =?',(dun.theme,)) monsters = m.fetchall() randoMon = random.randint(0, len(monsters)-1) monsterTuple = monsters[randoMon] mob = Boss(monsterTuple[0], monsterTuple[1], int(monsterTuple[2])) horde = random.randint(0,(level*dun.difficulty)) #Updates character date with new health and treasure n.execute('UPDATE CHARACTERS SET HEALTH = ?, GOLD = ? WHERE NAME = ?',(str((name.health - (mob.damage*dun.difficulty))), horde, useName)) conn.commit() conn.close() self.twtr_manager.printTweet("You slay a " + mob.name + " and collect " + str(horde) + " gold! " "It hurt you for " + str((mob.damage*dun.difficulty)) + " damage.") else: self.twtr_manager.printTweet('Level not recognized. Please choose 1, 2, or 3.') self.dungeon_pick(name) except StandardError as e: self.twtr_manager.printTweet('Level not recognized. Please choose Easy, Medium or Hard.') # self.menu_manager.write('Level not recognized. Please choose Easy, Medium or Hard.') self.dungeon_pick(name)
def dungeon_pick(self, name): try: self.menu_manager.title(name.name) # level = raw_input("What level of dungeon would you like? (Easy, Medium or Hard)\n").lower() self.twtr_manager.printTweet("What level of dungeon would you like? (Easy, Medium or Hard)") level = self.twtr_manager.homeTimeline() level = level.lower() print "You selected: " + level self.printTweet("You selected: " + level) if "easy" in level: level = 1 elif "medium" in level: level = 2 elif "hard" in level: level = 3 else: # self.menu_manager.write('Level not recognized. Please choose Easy, Medium or Hard.') self.printTweet('Level not recognized. Please choose Easy, Medium or Hard.') self.dungeon_pick(name) if 1 <= level <= 3: conn = sqlite3.connect('DunSuciRun.sqlite') c = conn.cursor() m = conn.cursor() n = conn.cursor() p = conn.cursor() c.execute('SELECT * FROM DUNGEONS WHERE DIFFICULTY =' + str(level)) dungeons = c.fetchall() p.execute('SELECT * FROM PLAYERS') useName = p.fetchall() useName = useName[0][0] randomNum= random.randint(0, len(dungeons)-1) newTuple = dungeons[randomNum] dun = Dungeon(newTuple[0],newTuple[1],newTuple[2]) # dun.sign() m.execute('SELECT * FROM BIGSCARIES WHERE THEME =?',(dun.theme,)) monsters = m.fetchall() # print (monsters) randoMon = random.randint(0, len(monsters)-1) monsterTuple = monsters[randoMon] mob = Boss(monsterTuple[0], monsterTuple[1], int(monsterTuple[2])) horde = random.randint(0,(level*dun.difficulty)) # n.execute('UPDATE CHARACTERS SET HEALTH = ' + str((name.health - (mob.damage*dun.difficulty)))+ ', GOLD = ' + str(horde)+ ' WHERE NAME ="' + name.name + '"') n.execute('UPDATE CHARACTERS SET HEALTH = ?, GOLD = ? WHERE NAME = ?',(str((name.health - (mob.damage*dun.difficulty))), horde, useName)) conn.commit() conn.close() # self.menu_manager.write("You slay a " + mob.name + " and collect " + str(horde) + " gold! " "It hurt you for " + str((mob.damage*dun.difficulty)) + " damage.") self.twtr_manager.printTweet("You slay a " + mob.name + " and collect " + str(horde) + " gold! " "It hurt you for " + str((mob.damage*dun.difficulty)) + " damage.") else: # self.menu_manager.write('Level not recognized. Please choose 1, 2, or 3.') self.twtr_manager.printTweet('Level not recognized. Please choose 1, 2, or 3.') self.dungeon_pick(name) except: self.twtr_manager.printTweet('Level not recognized. Please choose Easy, Medium or Hard.') # self.menu_manager.write('Level not recognized. Please choose Easy, Medium or Hard.') self.dungeon_pick(name)