import random
def play_casino(login):
print("\n CASINO <3 <3")
try:
db = sqlite3.connect("database.db")
cursor = db.cursor()
cursor.execute("SELECT age FROM users WHERE login =? AND age >= ?", [login, 18])
if cursor.fetchone() is None:
print("Вам недостаточно лет!")
else:
bet = int(input("Bet: "))
number = random.randint(1, 100)
balance = cursor.execute("SELECT balance FROM users WHERE login = ?", [login]).fetchone()[0]
if balance < bet:
print("Недостаточно средств, нужно больше золота!")
elif balance <=0:
print("Недостаточно средств, нужно больше золота!")
else:
if number < 50:
cursor.execute("UPDATE users SET balance = balance - ? WHERE login = ?", [bet, login])
cursor.execute("UPDATE casino SET balance = balance + ?", [bet])
print("Ты проиграл :(")
else:
cursor.execute("UPDATE users SET balance = balance + ? WHERE login = ?", [bet, login])
cursor.execute("UPDATE casino SET balance = balance - ?", [bet])
print("ура победа!")
except sqlite3.Error as e:
print("Error", e)
finally:
cursor.close()
db.close()