Pasted

import sqlite3
from random import randint
import sys
from time import time
 
verbose = False
# verbose = False
 
conn = sqlite3.connect("computer_cards.db")
 
 
def log(msg):
    if verbose:
        print("LOG:", msg)
 
 
def read_all_cards():
    sql = "SELECT * FROM computer"
    log("SQL:>>>>>" + sql + "<<<<<")
    result = conn.execute(sql)
    return result.fetchall()
 
 
def insert_picked(name):
    sql = "INSERT INTO picked(name, time) VALUES ('{}', {})".format(name, time())
    log("SQL:>>>>>" + sql + "<<<<<")
    conn.execute(sql)
    conn.commit()
 
 
def read_last_picked():
    sql = "SELECT * FROM picked ORDER BY time DESC"
    log("SQL:>>>>>" + sql + "<<<<<")
    result = conn.execute(sql)
    return result.fetchone()
 
 
def pick_card():
    last_picked_card = read_last_picked()
    log("last_picked_card:")
    log(last_picked_card)
 
    random_card = cards[randint(0, len(cards) - 1)]
 
    if last_picked_card is not None:
        while random_card[0] == last_picked_card[0]:
            random_card = cards[randint(0, len(cards) - 1)]
 
    insert_picked(random_card[0])
    return random_card
 
 
while True:
    player = input("Are you player (1) or (2) >")
    if player == "q":
        sys.exit(0)
    if player in ["1", "2"]:
        break
 
cards = read_all_cards()
choosing_player = "1"
for r in range(5):
    input("Press enter to pick a card when both players are ready >")
 
    card = pick_card()
    print("picked card:")
    print("{:10}: {}".format("name", card[0]))
    print("{:10}: {}".format("cores", card[1]))
    print("{:10}: {}".format("cpu_speed", card[2]))
    print("{:10}: {}".format("ram", card[3]))
    print("{:10}: {}".format("cost", card[4]))
 
    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()