def traceConn(self, action):
__debugTrace__ = False
if __debugTrace__:
global __conn_cnt_init__
global __conn_cnt_connect__
global __disconn_cnt_destr__
global __disconn_cnt_disconn__
if action == "INIT":
__conn_cnt_init__ += 1
__conn_cnt__ += 1
if __conn_cnt__ > 1:
logger.info("DB INSTANCE CNT: %d" % __conn_cnt__)
logger.debug(traceback.format_exc())
#print("CONN_CNT_INIT: %d"%__conn_cnt_init__)
elif action == "CONNECT":
__conn_cnt_connect__ += 1
#print("CONN_CNT_CONNECT: %d"%__conn_cnt_connect__)
elif action == "DISCONNECT":
__disconn_cnt_disconn__ += 1
#print("DISCONN_CNT_DISCONN: %d"%__disconn_cnt_disconn__)
bcnt = (__conn_cnt_init__ + __conn_cnt_connect__) - (
__disconn_cnt_destr__ + __disconn_cnt_disconn__)
#print("BALANCE: %d"%bcnt)
elif action == "DESTR":
__conn_cnt__ -= 1
__disconn_cnt_destr__ += 1
def setup(self, paydeskName, syncIp, syncPort):
self.createTables()
logger.info("Check local paydesk: %s, %s:%d" %
(paydeskName, syncIp, syncPort))
paydesk = self.createLocalPaydesk(paydeskName, syncIp, syncPort)
logger.info("Local paydesk: %s" % (str(paydesk)))
return paydesk
def createTables(self):
try:
#r"I:\Eclipse\basar\workspace\Database\test6.sqlitedb"
#if not os.path.exists(self.db_file):
# os.makedirs(os.path.basename(self.db_file))
logger.info("Create/Connect to database " + self.db_file)
#self.conn =sqlite3.connect(self.db_file)
#self.curs=self.conn.cursor()
self.createPaydeskTable()
self.createCartsTable()
self.createArticleTable()
self.createSoldTable()
self.createSettingsTable()
self.createCheckInTable()
except Exception as e:
self.__log__(e)
self.__log__(traceback.format_exc())
raise e
def insertUserList(self, userlist):
stmtList = []
for user in userlist:
if not re.match("^[0-9]+", user[1]):
logger.info("User Invalid: " + str(user))
else:
stmt = "INSERT INTO users (id,number,code,nachname,vorname,tel,created,email)"
stmt += " VALUES (?,?,?,?,?,?,?,?)"
para = (user[0], user[1], user[2], user[3], user[4], user[5],
user[6], user[7])
stmtList.append((stmt, para))
ret = self.dbWriteMultiple(stmtList)
return ret
def createLocalPaydesk(self, name, syncIp, syncPort):
try:
self.requestDbAccessInt()
ret = self.dbQueryOne("SELECT * from 'paydesks' WHERE remote=0")
if ret == None:
self.releaseDbAccessInt()
tnow = str(datetime.now())
paydeskId = uuid.uuid4()
self.requestDbAccessInt()
self.execute("SELECT * from paydesks WHERE paydeskId='%s'" %
paydeskId)
ret = self.curs.fetchone()
if ret == None:
logger.info("Create Local Paydesk %s, %s:%d" %
(name, syncIp, syncPort))
stmt = "INSERT INTO paydesks ('paydeskId', 'name', 'created', 'updated', 'syncIp', 'syncPort', 'remote') "
stmt += "VALUES ('%s','%s','%s','%s','%s',%d,%d)" % (
paydeskId, name, tnow, tnow, syncIp, syncPort, 0)
self.dbWrite(stmt)
else:
if name != ret[1] or syncIp != ret[4] or syncPort != ret[5]:
logger.info("Update Local Paydesk %s, %s:%d" %
(name, syncIp, syncPort))
stmt = "UPDATE paydesks SET 'name'='%s', 'updated'='%s', 'syncIp'='%s', 'syncPort'=%d where remote=0" % (
name, datetime.now(), syncIp, syncPort)
self.dbWrite(stmt)
else:
logger.info("Local Paydesk already exists: %s" % str(ret))
finally:
self.releaseDbAccessInt()
def createRemotePaydesk(self, paydeskId, name, created, updated, syncIp,
syncPort):
try:
ret = self.dbQueryOne(
"SELECT * from paydesks WHERE paydeskId='%s'" % paydeskId)
if ret == None:
stmt = "INSERT INTO paydesks ('paydeskId', 'name', 'created', 'updated', 'syncIp', 'syncPort', 'remote') "
stmt += "VALUES ('%s','%s','%s','%s','%s',%d,%d)" % (
paydeskId, name, created, updated, syncIp, syncPort, 1)
ret = self.dbWrite(stmt)
return self.dbQueryOne(
"SELECT * from paydesks WHERE paydeskId='%s'" % paydeskId)
else:
if name != ret[1] or syncIp != ret[4] or syncPort != ret[
5] or updated != ret[3]:
logger.info("Update Remote Paydesk %s, %s:%d" %
(name, syncIp, syncPort))
stmt = "UPDATE paydesks SET 'name'='%s', 'updated'='%s', 'syncIp'='%s', 'syncPort'=%d where paydeskId='%s'" % (
name, datetime.now(), syncIp, syncPort, paydeskId)
self.dbWrite(stmt)
except Exception as e:
self.__log__(traceback.format_exc())
return None