BotQuest game

import sqlite3
from random import randint
from time import time
from time import sleep
import sys


def getConnection():
    #create connection to the database
    print('Creating connection to the Database')
    conn = ''
    try:
        conn = sqlite3.connect('computer_cards.db')
    except Exception as ex:
        print('Failed to establish connection to database - {}'.format(ex))
        conn = ''
    return conn

def closeConnection(conn):
    #close connection to database
    print('Closing connection to the Database')
    try:
        conn.close()
    except Exception as ex:
        print('Error closing connection {}'.format(ex))

def clearTable(conn):
    #clear all records from the picked table
    try:
        sql = "DELETE FROM picked"
        cursor = conn.execute(sql)
        conn.commit()
        print('Rows deleted - {}'.format(cursor.rowcount))
    except Exception as ex:
        print('Failed to clear table - {}'.format(ex))

def getCards(conn):
    #create list of all card names from the computer table
    try:
        result = conn.execute("SELECT * FROM computer")
        return result.fetchall()
    except Exception as ex:
        print('Failed to get table - {}'.format(ex))
        return ''

def displayRecords(conn):
    cursor = conn.execute('SELECT * FROM picked')
    records = cursor.fetchall()
    for record in records:
        print(record)

def pickAnotherCard(conn):
    response = input('Pick Another Card? ').strip().upper()
    if response == 'D':
        displayRecords(conn)
        response = 'Y'
    return (response == 'Y')

def pickCard():
    response = input('Pick Another Card? ').strip().upper()
    return (response == 'Y')

def numberOfRounds():
    rounds = -1
    while rounds < 0:
        try:
            rounds = int(input('Enter rounds to play (3 - 20): ').strip())
            if rounds < 3 or rounds > 20:
                print('Invalid Input')
                rounds = -1
        except:
            print('Invalid Input')
            rounds = -1
    return rounds

def getPlayerNames():
    name1 = input('Enter Player Name 1:').strip()
    if name1 == '':
        name1 = 'Player 1'

    name2 = input('Enter Player Name 2:').strip()
    if name2 == '':
        name2 = 'Player 2'
    return name1,name2


def addCard(conn,name):
    #add card to the picked table
    try:
        sql = "INSERT INTO picked(name, time) VALUES ('{}', {})".format(name,time())
        cursor = conn.execute(sql)
        conn.commit()
        print('Added {}'.format(name))
    except Exception as ex:
        print('Failed to enter card {} - {}'.format(name, ex))

def getLastCard(conn):
    try:
        result = conn.execute("SELECT name FROM picked ORDER BY time DESC")
        return result.fetchone()[0]
    except Exception as ex:
        #print('Error getting last card picked, table empty - {}'.format(ex))
        return ''

def buildCardString(card):
    details = ''
    details += '----------' + '\n'
    details += 'Name:' + '\t' + card[0] + '\n'
    details += 'Cores:' + '\t' + str(card[1]) + '\n'
    details += 'Speed:' + '\t' + str(card[2]) + '\n'
    details += 'Ram:' + '\t' + str(card[3]) + '\n'
    details += 'Cost:' + '\t' + str(card[4]) + '\n'
    details += '----------' + '\n'
    return details

def chooseStat():
    response = 0
    while response == 0:
        try:
            response = int(input('Choose Stat (1>Cores  2>Speed  3>Ram  4>Cost): '))
            if response < 1 or response > 4:
                response = 0
        except:
            response = 0
    return response

def roundResult(win1,win2,currentPlayer, stat1,stat2,name1,name2):
    if(stat1 > stat2):
        win1 += 1
        currentPlayer = 1
        print('*** PLAYER {} WON ***'.format(name1))
    elif(stat2 > stat1):
        win2 += 1
        currentPlayer = 2
        print('*** PLAYER {} WON ***'.format(name2))
    else:
        print('*** DRAW ***')
    print('*** CURRENT SCORE {} v {} ***'.format(win1,win2) + '\n')
    return win1,win2,currentPlayer

def finalResult(win1,win2,name1,name2):
    if(win1 > win2):
        print('*** PLAYER {} WON ***'.format(name1) + '\n')
    elif(win2 > win1):
        print('*** PLAYER {} WON ***'.format(name2) + '\n')
    else:
        print('*** GAME IS A DRAW ***' + '\n')


def mainLoop(conn,rounds,name1,name2):
    #pick random cards and add to picked table
    cards = getCards(conn)
    win1 = 0
    win2 = 0
    currentPlayer = 1
    for round in range(rounds):
        print('ROUND {}'.format(round + 1))
        print('CURRENT PICKER - PLAYER {}'.format(name1))
        card1 = cards[randint(0, len(cards) - 1)]
        while card1[0] == getLastCard(conn):
            card1 = cards[randint(0, len(cards) - 1)]

        card2 = cards[randint(0, len(cards) - 1)]
        while card2[0] == card1[0] or card2[0] == getLastCard(conn):
            card2 = cards[randint(0, len(cards) - 1)]

        if currentPlayer == 1:
            print('CARD FOR {}'.format(name1))
            print(buildCardString(card1))
            stat = chooseStat()
            print('CARD FOR {}'.format(name2))
            print(buildCardString(card2)+'\n')
            sleep(2)
            print('Statistic for {} > {} - {}'.format(name1,stat,card1[stat]))
            print('Statistic for {} > {} - {}'.format(name2,stat,card2[stat]))
            sleep(2)
        else:
            print('CARD FOR {}'.format(name1))
            print(buildCardString(card1))
            sleep(2)
            print('CARD FOR {}'.format(name2))
            print(buildCardString(card2)+'\n')
            print('{} choosing stat'.format(name2))
            stat = randint(1, 4)
            sleep(2)
            print('Statistic for {} > {} - {}'.format(name1,stat,card1[stat]))
            print('Statistic for {} > {} - {}'.format(name2,stat,card2[stat]))
            sleep(2)
        win1,win2,currentPlayer = roundResult(win1,win2,currentPlayer,card1[stat],card2[stat],name1,name2)
        sleep(3)

    finalResult(win1,win2,name1,name2)

#Main Program
conn = getConnection()
if conn != '':
    clearTable(conn)
    rounds = numberOfRounds()
    name1,name2 = getPlayerNames()
    mainLoop(conn,rounds,name1,name2)
    closeConnection(conn)