blackjack

- irc bot to play blackjack
git clone git://git.acid.vegas/blackjack.git
database.py (855B)
      1 #!/usr/bin/env python
      2 # BlackJack IRC Bot - Developed by acidvegas in Python (https://acid.vegas/blackjack)
      3 # functions.py
      4 
      5 import datetime
      6 import os
      7 import sqlite3
      8 
      9 # Globals
     10 db  = sqlite3.connect(os.path.join('data', 'bot.db'), check_same_thread=False)
     11 sql = db.cursor()
     12 
     13 def check():
     14 	tables = sql.execute('SELECT name FROM sqlite_master WHERE type=\'table\'').fetchall()
     15 	if not len(tables):
     16 		sql.execute('CREATE TABLE IGNORE (IDENT TEXT NOT NULL);')
     17 		db.commit()
     18 
     19 class Player:
     20     def register(nick, ident):
     21         now = str(datetime.datetime.now())
     22         sql.execute('INSERT INTO PLAYERS (NICK,IDENT,MONEY,LAST) VALUES (\'{0}\', \'{1}\', \'{2}\', \'{3}\')'.format(nick, ident, '0', now))
     23         db.commit()
     24 
     25     def get_money(ident):
     26         return sql.execute('SELECT MONEY FROM PLAYERS WHERE IDENT=\'{0}\''.format(ident)).fetchall()[0][0]
     27