class DBTests(unittest.TestCase):

    def test_connect(self):
        """ Test that a connection to the default address and port works and returns true. """
        self.assertTrue(connect())

    def test_bad_connect(self):
        """ Test that a connection to an invalid address fails gracefully and returns false. """
        self.assertFalse(connect(address = "99.99.99.99"))

    def test_getAllPlayers(self):
        """ Test that we can get a list of all players in the database. Fails if there are no players. """
        self.assertTrue(len(getAllPlayers()) > 0, "No players found in database.")

    def test_insertPlayer(self):
        """ Test that we can insert a new player into the database. """
        deletePlayerByUsername("testplayer9812")
        newPlayer = Player("testplayer9812", "asdf")
        insertPlayer(newPlayer)
        player = getPlayerByUuid(newPlayer.uuid)
        self.assertTrue(str(player.uuid) == str(newPlayer.uuid))
        self.assertTrue(player.username == newPlayer.username)
        self.assertTrue(player.password == newPlayer.password)

    def test_getPlayerByUuid(self):
        """ Test that we can get a player by its uuid. """
        deletePlayerByUsername("testplayer9812")
        newPlayer = Player("testplayer9812", "asdf")
        insertPlayer(newPlayer)
        player = getPlayerByUuid(newPlayer.uuid)
        self.assertTrue(str(player.uuid) == str(newPlayer.uuid))
        self.assertTrue(player.username == newPlayer.username)
        self.assertTrue(player.password == newPlayer.password)

    def test_deletePlayerByUsername(self):
        newPlayer = Player("testplayer9812", "asdf")
        insertPlayer(newPlayer)
        player = getPlayerByUuid(newPlayer.uuid)