Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement