def setup_args(): db.make_connect({ "host": input("Host: "), "user": input("User: "******"passwd": input("Password: "******"db": input("Database: ") })
def get_last_quetion(): conn, cursor = make_connect() cursor.execute("SELECT * FROM support") try: return cursor.fetchall()[0] except: return 0
def create_game(game_hash, sum_bet, creator_user_id, creator_value, type): #hash INTEGER, sum_bet FLOAT, creator_user_id INTEGER, player_user_id INTEGER, creator_value INTEGER, player_value INTEGER, type TEXT) conn, cursor = make_connect() cursor.execute( "INSERT INTO dice VALUES (?,?,?,?,?,?,?)", (game_hash, sum_bet, creator_user_id, 0, creator_value, 0, type)) conn.commit()
def get_last_withdraw(): try: conn, cursor = make_connect() cursor.execute("SELECT * FROM withdraw") return cursor.fetchall()[0] except: return 0
def update_user_sum_games(user_id, sum): conn, cursor = make_connect() sum_games = get_user_information(user_id)[3] + sum cursor.execute("UPDATE users SET sum_games = ? WHERE user_id = ?", ( sum_games, user_id, )) conn.commit()
def create_answer(hash, quetion, answer): conn, cursor = make_connect() cursor.execute("INSERT INTO quetions VALUES (?,?,?)", ( hash, quetion, answer, )) conn.commit()
def update_user_count_games(user_id): conn, cursor = make_connect() count_games = get_user_information(user_id)[2] + 1 cursor.execute("UPDATE users SET count_games = ? WHERE user_id = ?", ( count_games, user_id, )) conn.commit()
def make_connect(thread_index): global lcd, DoorbellIO cherrypy.thread_data.conn = db.make_connect() lcd = i2c_lcd_smbus.i2c_lcd(0x3f, 1, 2, 1, 0, 4, 5, 6, 7, 3) cherrypy.thread_data.lcd = lcd GPIO.setmode(GPIO.BCM) GPIO.setup(DoorbellIO, GPIO.IN, pull_up_down=GPIO.PUD_UP) GPIO.add_event_detect(DoorbellIO, GPIO.FALLING, callback=TurnOnDisplay, bouncetime=1000) UpdateLCD() TurnOnDisplay(DoorbellIO)
def create_support_quetion(user_id, quetion): conn, cursor = make_connect() cursor.execute("INSERT INTO support VALUES (?,?)", (user_id, quetion)) conn.commit()
def check_unik_quetion(user_id): conn, cursor = make_connect() cursor.execute("SELECT COUNT(*) FROM support WHERE user_id = ?", (user_id, )) return cursor.fetchone()[0] == 0
def get_all_users_inform(): conn, cursor = make_connect() cursor.execute("SELECT * FROM users") return cursor.fetchall()
def delete_non_true_user(user_id): conn, cursor = make_connect() cursor.execute("DELETE FROM nontrueusers WHERE user_id = ?", (user_id, )) conn.commit()
def create_qiwi_popoln(user_id, sum, phone, random_code): conn, cursor = make_connect() cursor.execute("INSERT INTO qiwi_popoln VALUES(?,?,?,?)", (user_id, sum, phone, random_code)) conn.commit()
def get_answer_by_hash(hash): conn, cursor = make_connect() cursor.execute("SELECT * FROM quetions WHERE hash = ?", (hash, )) return cursor.fetchone()
def delete_last_popoln(user_id): conn, cursor = make_connect() cursor.execute("DELETE FROM qiwi_popoln WHERE user_id = ?", (user_id, )) conn.commit()
def get_all_answers(): conn, cursor = make_connect() cursor.execute("SELECT * FROM quetions") return cursor.fetchall()
def add_user_to_ban(user_id): conn, cursor = make_connect() cursor.execute("INSERT INTO ban VALUES (?,?)", (user_id, 0)) conn.commit()
def delete_user_from_ban(user_id): conn, cursor = make_connect() cursor.execute("DELETE FROM ban WHERE user_id = ?", (user_id, )) conn.commit()
def delete_dice_game_by_hash(game_hash): conn, cursor = make_connect() cursor.execute("DELETE FROM dice WHERE hash = ?", (game_hash, )) conn.commit()
def create_new_history(user_id, game_hash, sum_win): conn, cursor = make_connect() cursor.execute("INSERT INTO history_dice VALUES (?,?,?)", (user_id, game_hash, sum_win)) conn.commit()
def get_user_information(user_id): conn, cursor = make_connect() cursor.execute("SELECT * FROM users WHERE user_id = ?", (user_id, )) return cursor.fetchone()
def get_dice_by_hash(game_hash): conn, cursor = make_connect() cursor.execute("SELECT * FROM dice WHERE hash = ?", (game_hash, )) return cursor.fetchone()
}, '/favicon.ico': { 'tools.staticfile.on': True, 'tools.staticfile.filename': os.path.join(current_dir, "favicon.ico") }, '/profile-images': { 'tools.staticdir.on': True, 'tools.staticdir.root': current_dir, 'tools.staticdir.dir': "profile-images" } } cherrypy.tree.mount(NerfAssassin(), "/", config=config) dbconn = db.make_connect() ServerInfo = db.GetConfig(dbconn, ["server_ip","server_port","server_ssl","server_private","server_certificate"]) dbconn.close() cherrypy.config.update({ 'request.error_response': handle_errors, 'error_page.default': error_page, 'server.socket_host': ServerInfo["server_ip"].Value, 'server.socket_port': int(ServerInfo["server_port"].Value)}) if int(ServerInfo["server_ssl"].Value) == 1: cherrypy.config.update({ 'server.ssl_module': 'pyopenssl', 'server.ssl_certificate': ServerInfo["server_certificate"].Value, 'server.ssl_private_key': ServerInfo["server_private"].Value})
def delete_quetion(user_id): conn, cursor = make_connect() cursor.execute("DELETE FROM support WHERE user_id = ?", (user_id, )) conn.commit()
def delete_withdraw(user_id): conn, cursor = make_connect() cursor.execute("DELETE FROM withdraw WHERE user_id = ?", (user_id, )) conn.commit()
def make_connect(thread_index): cherrypy.thread_data.conn = db.make_connect()
def add_non_true_user(user_id): conn, cursor = make_connect() cursor.execute("INSERT INTO nontrueusers VALUES (?,?)", (user_id, 0)) conn.commit()
def delete_answer(hash): conn, cursor = make_connect() cursor.execute("DELETE FROM quetions WHERE hash = ?", (hash, )) conn.commit()
def check_non_true_user(user_id): conn, cursor = make_connect() cursor.execute("SELECT COUNT(*) FROM nontrueusers WHERE user_id = ?", (user_id, )) return cursor.fetchone()[0] == 0
def get_last_popoln(user_id): conn, cursor = make_connect() cursor.execute("SELECT * FROM qiwi_popoln WHERE user_id = ?", (user_id, )) return cursor.fetchone()
def get_all_history(user_id): conn, cursor = make_connect() cursor.execute("SELECT * FROM history_dice WHERE user_id = ?", (user_id, )) return cursor.fetchall()
def check_user_unicless(user_id): conn, cursor = make_connect() cursor.execute("SELECT COUNT(*) FROM users WHERE user_id = ?", (user_id, )) return cursor.fetchone()[0] == 0
def update_user_balanse(user_id, new_balanse): conn, cursor = make_connect() cursor.execute("UPDATE users SET bal = ? WHERE user_id = ?", (new_balanse, user_id)) conn.commit()