def alterTable(self, mtd1, mtd2, key):
util = FLUtil()
oldMTD = None
newMTD = None
doc = QDomDocument("doc")
docElem = None
if not util.docDocumentSetContect(doc, mtd1):
print("FLManager::alterTable : " +
qApp.tr("Error al cargar los metadatos."))
else:
docElem = doc.documentElement()
oldMTD = self.db_.manager().metadata(docElem, True)
if oldMTD and oldMTD.isQuery():
return True
if not util.docDocumentSetContect(doc, mtd2):
print("FLManager::alterTable : " +
qApp.tr("Error al cargar los metadatos."))
return False
else:
docElem = doc.documentElement()
newMTD = self.db_.manager().metadata(docElem, True)
if not oldMTD:
oldMTD = newMTD
if not oldMTD.name() == newMTD.name():
print("FLManager::alterTable : " +
qApp.tr("Los nombres de las tablas nueva y vieja difieren."))
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
oldPK = oldMTD.primaryKey()
newPK = newMTD.primaryKey()
if not oldPK == newPK:
print("FLManager::alterTable : " +
qApp.tr("Los nombres de las claves primarias difieren."))
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
if not self.db_.manager().checkMetaData(oldMTD, newMTD):
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return True
if not self.db_.manager().existsTable(oldMTD.name()):
print("FLManager::alterTable : " + qApp.tr(
"La tabla %1 antigua de donde importar los registros no existe."
).arg(oldMTD.name()))
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
fieldList = oldMTD.fieldList()
oldField = None
if not fieldList:
print("FLManager::alterTable : " +
qApp.tr("Los antiguos metadatos no tienen campos."))
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
renameOld = "%salteredtable%s" % (oldMTD.name()[0:5], QDateTime(
).currentDateTime().toString("ddhhssz"))
if not self.db_.dbAux():
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
self.db_.dbAux().transaction()
if key and len(key) == 40:
c = FLSqlCursor("flfiles", True, self.db_.dbAux())
c.setForwardOnly(True)
c.setFilter("nombre = '%s.mtd'" % renameOld)
c.select()
if not c.next():
buffer = c.primeInsert()
buffer.setValue("nombre", "%s.mtd" % renameOld)
buffer.setValue("contenido", mtd1)
buffer.setValue("sha", key)
c.insert()
q = FLSqlQuery("", self.db_.dbAux())
if not q.exec_("CREATE TABLE %s AS SELECT * FROM %s;" %
(renameOld, oldMTD.name())) or not q.exec_(
"DROP TABLE %s;" % oldMTD.name()):
print("FLManager::alterTable : " +
qApp.tr("No se ha podido renombrar la tabla antigua."))
self.db_.dbAux().rollback()
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
if not self.db_.manager().createTable(newMTD):
self.db_.dbAux().rollback()
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
oldCursor = FLSqlCursor(renameOld, True, self.db_.dbAux())
oldCursor.setModeAccess(oldCursor.Browse)
newCursor = FLSqlCursor(newMTD.name(), True, self.db_.dbAux())
newCursor.setMode(newCursor.Insert)
oldCursor.select()
totalSteps = oldCursor.size()
progress = QProgressDialog(
qApp.tr("Reestructurando registros para %1...").arg(
newMTD.alias()), qApp.tr("Cancelar"), 0, totalSteps)
progress.setLabelText(qApp.tr("Tabla modificada"))
step = 0
newBuffer = None
# sequence = ""
fieldList = newMTD.fieldList()
newField = None
if not fieldList:
print("FLManager::alterTable : " +
qApp.tr("Los nuevos metadatos no tienen campos."))
self.db_.dbAux().rollback()
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
v = None
ok = True
while oldCursor.next():
v = None
newBuffer = newCursor.primeInsert()
for it in fieldList:
oldField = oldMTD.field(newField.name())
if not oldField or not oldCursor.field(oldField.name()):
if not oldField:
oldField = newField
v = newField.defaultValue()
else:
v = oldCursor.value(newField.name())
if (not oldField.allowNull()
or not newField.allowNull()) and (v is None):
defVal = newField.defaultValue()
if defVal is not None:
v = defVal
if not newBuffer.field(
newField.name()).type() == newField.type():
print("FLManager::alterTable : " + qApp.tr(
"Los tipos del campo %1 no son compatibles. Se introducirá un valor nulo."
).arg(newField.name()))
if not oldField.allowNull(
) or not newField.allowNull() and v is not None:
if oldField.type() in ("int", "serial", "uint", "bool",
"unlock"):
v = 0
elif oldField.type() == "double":
v = 0.0
elif oldField.type() == "time":
v = QTime().currentTime()
elif oldField.type() == "date":
v = QDate().currentDate()
else:
v = "NULL"[0:newField.length()]
newBuffer.setValue(newField.name(), v)
if not newCursor.insert():
ok = False
break
step = step + 1
progress.setProgress(step)
progress.setProgress(totalSteps)
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
if ok:
self.db_.dbAux().commit()
else:
self.db_.dbAux().rollback()
return False
return True
def alterTable(self, mtd1, mtd2, key):
util = FLUtil()
oldMTD = None
newMTD = None
doc = QDomDocument("doc")
docElem = None
if not util.docDocumentSetContect(doc, mtd1):
print("FLManager::alterTable : " +
qApp.tr("Error al cargar los metadatos."))
else:
docElem = doc.documentElement()
oldMTD = self.db_.manager().metadata(docElem, True)
if oldMTD and oldMTD.isQuery():
return True
if not util.docDocumentSetContect(doc, mtd2):
print("FLManager::alterTable : " +
qApp.tr("Error al cargar los metadatos."))
return False
else:
docElem = doc.documentElement()
newMTD = self.db_.manager().metadata(docElem, True)
if not oldMTD:
oldMTD = newMTD
if not oldMTD.name() == newMTD.name():
print("FLManager::alterTable : " +
qApp.tr("Los nombres de las tablas nueva y vieja difieren."))
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
oldPK = oldMTD.primaryKey()
newPK = newMTD.primaryKey()
if not oldPK == newPK:
print("FLManager::alterTable : " +
qApp.tr("Los nombres de las claves primarias difieren."))
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
if not self.db_.manager().checkMetaData(oldMTD, newMTD):
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return True
if not self.db_.manager().existsTable(oldMTD.name()):
print("FLManager::alterTable : " + qApp.tr(
"La tabla %1 antigua de donde importar los registros no existe.").arg(oldMTD.name()))
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
fieldList = oldMTD.fieldList()
oldField = None
if not fieldList:
print("FLManager::alterTable : " +
qApp.tr("Los antiguos metadatos no tienen campos."))
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
renameOld = "%salteredtable%s" % (
oldMTD.name()[0:5], QDateTime().currentDateTime().toString("ddhhssz"))
if not self.db_.dbAux():
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
self.db_.dbAux().transaction()
if key and len(key) == 40:
c = FLSqlCursor("flfiles", True, self.db_.dbAux())
c.setForwardOnly(True)
c.setFilter("nombre = '%s.mtd'" % renameOld)
c.select()
if not c.next():
buffer = c.primeInsert()
buffer.setValue("nombre", "%s.mtd" % renameOld)
buffer.setValue("contenido", mtd1)
buffer.setValue("sha", key)
c.insert()
q = FLSqlQuery("", self.db_.dbAux())
if not q.exec_("CREATE TABLE %s AS SELECT * FROM %s;" % (renameOld, oldMTD.name())) or not q.exec_("DROP TABLE %s;" % oldMTD.name()):
print("FLManager::alterTable : " +
qApp.tr("No se ha podido renombrar la tabla antigua."))
self.db_.dbAux().rollback()
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
if not self.db_.manager().createTable(newMTD):
self.db_.dbAux().rollback()
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
oldCursor = FLSqlCursor(renameOld, True, self.db_.dbAux())
oldCursor.setModeAccess(oldCursor.Browse)
newCursor = FLSqlCursor(newMTD.name(), True, self.db_.dbAux())
newCursor.setMode(newCursor.Insert)
oldCursor.select()
totalSteps = oldCursor.size()
progress = QProgressDialog(qApp.tr("Reestructurando registros para %1...").arg(
newMTD.alias()), qApp.tr("Cancelar"), 0, totalSteps)
progress.setLabelText(qApp.tr("Tabla modificada"))
step = 0
newBuffer = None
# sequence = ""
fieldList = newMTD.fieldList()
newField = None
if not fieldList:
print("FLManager::alterTable : " +
qApp.tr("Los nuevos metadatos no tienen campos."))
self.db_.dbAux().rollback()
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
return False
v = None
ok = True
while oldCursor.next():
v = None
newBuffer = newCursor.primeInsert()
for it in fieldList:
oldField = oldMTD.field(newField.name())
if not oldField or not oldCursor.field(oldField.name()):
if not oldField:
oldField = newField
v = newField.defaultValue()
else:
v = oldCursor.value(newField.name())
if (not oldField.allowNull() or not newField.allowNull()) and (v is None):
defVal = newField.defaultValue()
if defVal is not None:
v = defVal
if not newBuffer.field(newField.name()).type() == newField.type():
print("FLManager::alterTable : " + qApp.tr("Los tipos del campo %1 no son compatibles. Se introducirá un valor nulo.")
.arg(newField.name()))
if not oldField.allowNull() or not newField.allowNull() and v is not None:
if oldField.type() in ("int", "serial", "uint", "bool", "unlock"):
v = 0
elif oldField.type() == "double":
v = 0.0
elif oldField.type() == "time":
v = QTime().currentTime()
elif oldField.type() == "date":
v = QDate().currentDate()
else:
v = "NULL"[0:newField.length()]
newBuffer.setValue(newField.name(), v)
if not newCursor.insert():
ok = False
break
step = step + 1
progress.setProgress(step)
progress.setProgress(totalSteps)
if oldMTD and not oldMTD == newMTD:
del oldMTD
if newMTD:
del newMTD
if ok:
self.db_.dbAux().commit()
else:
self.db_.dbAux().rollback()
return False
return True
