def getDbName(): dbName = multiUserSupport.getServerDatabaseName() return dbName
# Copyright: Krzysztof Kowalczyk # Owner: Krzysztof Kowalczyk # # Purpose: # Import data from *.csv file with reg codes generated by infoman_gen_reg_codes.py # into a database so that the server can properly authenticate users. import sys, os, MySQLdb, _mysql_exceptions import infoman_gen_reg_codes import multiUserSupport g_conn = MySQLdb.Connect(host='localhost', user=multiUserSupport.getServerUser(), passwd='infoman', db=multiUserSupport.getServerDatabaseName()) g_cur = g_conn.cursor() def dbEscape(txt): # it's silly that we need connection just for escaping strings global g_conn return g_conn.escape_string(txt) def sql_qq(txt): return dbEscape(txt) def getOneResult(conn, query): cur = conn.cursor() cur.execute(query)
# Copyright: Krzysztof Kowalczyk # Owner: Krzysztof Kowalczyk # # Purpose: # Import data from *.csv file with reg codes generated by infoman_gen_reg_codes.py # into a database so that the server can properly authenticate users. import sys,os,MySQLdb,_mysql_exceptions import infoman_gen_reg_codes import multiUserSupport g_conn = MySQLdb.Connect(host='localhost', user = multiUserSupport.getServerUser(), passwd='infoman', db = multiUserSupport.getServerDatabaseName()) g_cur = g_conn.cursor() def dbEscape(txt): # it's silly that we need connection just for escaping strings global g_conn return g_conn.escape_string(txt) def sql_qq(txt): return dbEscape(txt) def getOneResult(conn,query): cur = conn.cursor() cur.execute(query) row = cur.fetchone() res = row[0] cur.close() return res def fCodeExists(reg_code):