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)
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)
row = cur.fetchone()
res = row[0]
cur.close()
return res
def fCodeExists(reg_code):
