Prog 103 - Ex3_10

# Prog 103 - wk3 - ex3.10 - battle cards - 2 players
# 22 nov 19
# file name: ex3_10

import sqlite3
from random import randint
from time import time
conn = sqlite3.connect("computer_cards.db")

def read_all_cards():
    result = conn.execute("SELECT * FROM computer")
    return result.fetchall()

def pick_card():
    cards = read_all_cards()
    last_picked_card = read_last_picked()
    random_card = cards [randint(0, len(cards) - 1)]

    while random_card[0] == last_picked_card[0]:
        random_card = cards [randint(0, len(cards) - 1)]
    insert_picked(random_card[0])
    return random_card

def insert_picked(name):
    insert_sql = "INSERT INTO picked(name, time) VALUES ('{}', {})".format(name, time())
    conn.execute(insert_sql)
    conn.commit()

def read_last_picked():
    result = conn.execute("SELECT * FROM picked ORDER BY time DESC")
    return result.fetchone()


print("Battle Cards Game")

player = input("Are you player (1) or (2) > ")

choosing_player = "1"

for round in range(5):
    input("Press enter to pick a card when both players are ready >")
    card = pick_card()
    card_text = "{}, cores={}, speed={}GHz, RAM={}MB, cost={}$".format(card[0], card[1], card[2], card[3], card[4])
    print(card_text)

    print("Player " + choosing_player + " picks. ")

    winner = input("Did you win? (Y)es, (N)o, (D)raw >").lower()

    if winner == "y":
        choosing_player = player
    elif winner == "n":
        choosing_player = "2" if player == "1" else "1"

conn.close()