def globalCommit(paramsDictionary, db, lock):
try:
socket = paramsDictionary["SOCKET"]
servers = socket.receive_message()
logger.logInfo(NAME + "Mam serwery " + servers)
servers = servers.split(":")
servers.append(paramsDictionary["CLIENT_ADDRESS"])
logger.logImportant(NAME + "Uczestnik zaakceptowal operacje")
db.executeQueryWithoutTransaction(generateInsertToDataVersions(paramsDictionary))
db.executeQueryWithoutTransaction(COMMIT)
insertNewDataVersions(servers, paramsDictionary)
ticket = socket.receive_message()
TicketUtil.setNextExpectedTicket(ticket)
socket.send_message(OK)
if lock.is_locked:
lock.release()
except Exception, e:
logger.logError(NAME + e.message)
if lock.is_locked:
lock.release()
# TICKET_PARAM = "ticketServer"
#
#logger.logImportant("nowy log")
# tempProcessor = FileProcessor("/home/dur/Projects/ServerSide/config/tempParams.conf")
# tempProcessor.lockFile()
# params = tempProcessor.readFile()
# tempProcessor.unlockFile()
#import utils.Logger as logger
# tempProcessor = FileProcessor("/home/dur/Projects/ServerSide/config/tempParams.conf")
# tempProcessor.lockFile()
# params = tempProcessor.readFile()
# print(params)
# tempProcessor.unlockFile()
#logger.logError("Error message")
from database.utils1 import TicketUtil
TicketUtil.setNextExpectedTicket(1)
cursor.execute(command)
command = command.replace('\'', '\\\'')
logger.logInfo(NAME + "Komenda po transformacji " + command)
insert = "INSERT INTO " + dbParamsDict["versionsTableName"] + " VALUES(" + str(version) + ",\'" + command + "\')"
logger.logInfo(NAME + "Wykonuje: " + insert)
cursor.execute(insert)
logger.logInfo(NAME + "wykonano inserta")
currentVersion = version
version = connection.get_message()
logger.logInfo(NAME + "zamykanie polaczenia z baza danych")
cursor.execute("commit")
ticket = connection.get_message()
ticket = int(ticket) - 1
TicketUtil.setNextExpectedTicket(ticket)
except MySQLdb.Error, e:
logger.logError("%d %s" % (e.args[0], e.args[1]))
cursor.execute("rollback")
except Exception, ee:
logger.logError(ee.message)
cursor.execute("rollback")
if lock.is_locked:
lock.release()
versionsFile.lockFile()
dataVersions = versionsFile.readFile()
dataVersions[LOCALHOST_NAME] = currentVersion
versionsFile.writeToFile(dataVersions)
versionsFile.unlockFile()
logger.logImportant(NAME + "Dane sa spojne")
