def contentStatic(self, n):
str_ret = FLStaticLoader.content(n, self.staticBdInfo_)
if str_ret:
from pineboolib.fllegacy.FLUtil import FLUtil
util = FLUtil()
sha = util.sha1(str_ret)
if n in self.dictKeyFiles.keys():
s = self.dictKeyFiles[n]
if self.dictKeyFiles and s == sha:
return None
elif self.dictKeyFiles and n.find(".qs") > -1:
self.dictKeyFiles[n] = sha
if n.endswith(".mtd"):
from PyQt5.QtXml import QDomDocument
doc = QDomDocument(n)
if util.domDocumentSetContent(doc, str_ret):
mng = self.conn_.manager()
docElem = doc.documentElement()
mtd = mng.metadata(docElem, True)
if not mtd or mtd.isQuery():
return str_ret
if not mng.existTable(mtd.name()):
mng.createTable(mng)
elif (self.conn_.canRegenTables()):
self.conn_.regenTable(mtd.name(), mtd)
return str_ret
def recordInfo(self, tablename_or_query):
if not self.isOpen():
return None
info = []
if isinstance(tablename_or_query, str):
tablename = tablename_or_query
doc = QDomDocument(tablename)
stream = self.db_.managerModules().contentCached("%s.mtd" % tablename)
util = FLUtil()
if not util.domDocumentSetContent(doc, stream):
print("FLManager : " + qApp.tr("Error al cargar los metadatos para la tabla") + tablename)
return self.recordInfo2(tablename)
docElem = doc.documentElement()
mtd = self.db_.manager().metadata(docElem, True)
if not mtd:
return self.recordInfo2(tablename)
fL = mtd.fieldList()
if not fL:
del mtd
return self.recordInfo2(tablename)
for f in mtd.fieldsNames():
field = mtd.field(f)
info.append([field.name(), field.type(), not field.allowNull(), field.length(
), field.partDecimal(), field.defaultValue(), field.isPrimaryKey()])
del mtd
return info
def recordInfo(self, tablename_or_query):
if not self.isOpen():
return None
info = []
if isinstance(tablename_or_query, str):
tablename = tablename_or_query
doc = QDomDocument(tablename)
stream = self.db_.managerModules().contentCached("%s.mtd" % tablename)
util = FLUtil()
if not util.domDocumentSetContent(doc, stream):
print(
"FLManager : " + qApp.tr("Error al cargar los metadatos para la tabla %1").arg(tablename))
return self.recordInfo2(tablename)
docElem = doc.documentElement()
mtd = self.db_.manager().metadata(docElem, True)
if not mtd:
return self.recordInfo2(tablename)
fL = mtd.fieldList()
if not fL:
del mtd
return self.recordInfo2(tablename)
for f in mtd.fieldsNames():
field = mtd.field(f)
info.append([field.name(), field.type(), not field.allowNull(), field.length(
), field.partDecimal(), field.defaultValue(), field.isPrimaryKey()])
del mtd
return info
def createSystemTable(self, n):
util = FLUtil()
if not self.existsTable(n):
doc = QDomDocument()
_path = filedir("..", "share", "pineboo", "tables")
dir = qsatype.Dir(_path)
_tables = dir.entryList("%s.mtd" % n)
for f in _tables:
path = "%s/%s" % (_path, f)
_file = QtCore.QFile(path)
_file.open(QtCore.QIODevice.ReadOnly)
_in = QtCore.QTextStream(_file)
_data = _in.readAll()
if not util.domDocumentSetContent(doc, _data):
print(
"FLManager::createSystemTable :",
util.tr(
"Error al cargar los metadatos para la tabla %1").
arg(n))
return False
else:
docElem = doc.documentElement()
mtd = self.createTable(self.metadata(docElem, True))
return mtd
f.close()
return False
def recordInfo(self, tablename_or_query):
if not self.isOpen():
return None
info = []
if isinstance(tablename_or_query, str):
tablename = tablename_or_query
doc = QDomDocument(tablename)
stream = self.db_.managerModules().contentCached("%s.mtd" %
tablename)
util = FLUtil()
if not util.domDocumentSetContent(doc, stream):
print("FLManager : " +
qApp.tr("Error al cargar los metadatos para la tabla %1"
).arg(tablename))
return self.recordInfo2(tablename)
docElem = doc.documentElement()
mtd = self.db_.manager().metadata(docElem, True)
if not mtd:
return self.recordInfo2(tablename)
fL = mtd.fieldList()
if not fL:
del mtd
return self.recordInfo2(tablename)
for f in mtd.fieldsNames():
field = mtd.field(f)
info.append([
field.name(),
field.type(), not field.allowNull(),
field.length(),
field.partDecimal(),
field.defaultValue(),
field.isPrimaryKey()
])
del mtd
return info
else:
for columns in tablename_or_query:
fName = columns[1]
fType = columns[2]
fSize = 0
fAllowNull = (columns[3] == 0)
if fType.find("VARCHAR(") > -1:
fSize = int(fType[fType.find("(") + 1:len(fType) - 1])
info.append(
[fName,
self.decodeSqlType(fType), not fAllowNull, fSize])
return info
def init_(self, aclXml=None):
"""
Lee el fichero "acl.xml" y establece una nueva lista de control de acceso.
Si el fichero "acl.xml" no se puede leer, la lista de control de acceso queda vacía y
no se procesará ningún control de acceso sobre ningún objeto.
@param aclXml Contenido XML con la definición de la lista de control de acceso.
"""
util = FLUtil()
if aclXml is None:
aclXml = self._prj.conn.managerModules().content("acl.xml")
doc = QDomDocument("ACL")
if self.accessControlList_:
self.accessControlList_.clear()
del self.accessControlList_
self.accessControlList_ = {}
if aclXml and not util.domDocumentSetContent(doc, aclXml):
logger.error("Lista de control de acceso errónea")
return
self.accessControlList_ = {}
# self.accessControlList_.setAutoDelete(True)
docElem = doc.documentElement()
no = docElem.firstChild()
while not no.isNull():
e = no.toElement()
if e:
if e.tagName() == "name":
self.name_ = e.text()
no = no.nextSibling()
continue
ac = FLAccessControlFactory().create(e.tagName())
if ac:
ac.set(e)
logger.debug("****************** %s %s %s", ac.type(),
ac.name(), ac.user(), ac)
self.accessControlList_["%s::%s::%s" %
(ac.type(), ac.name(),
ac.user())] = ac
no = no.nextSibling()
continue
no = no.nextSibling()
def recordInfo(self, tablename_or_query):
if not self.isOpen():
return None
info = []
if isinstance(tablename_or_query, str):
tablename = tablename_or_query
doc = QDomDocument(tablename)
stream = self.db_.managerModules().contentCached("%s.mtd" % tablename)
util = FLUtil()
if not util.domDocumentSetContent(doc, stream):
print(
"FLManager : " + qApp.tr("Error al cargar los metadatos para la tabla %1").arg(tablename))
return self.recordInfo2(tablename)
docElem = doc.documentElement()
mtd = self.db_.manager().metadata(docElem, True)
if not mtd:
return self.recordInfo2(tablename)
fL = mtd.fieldList()
if not fL:
del mtd
return self.recordInfo2(tablename)
for f in mtd.fieldsNames():
field = mtd.field(f)
info.append([field.name(), field.type(), not field.allowNull(), field.length(
), field.partDecimal(), field.defaultValue(), field.isPrimaryKey()])
del mtd
return info
else:
for columns in tablename_or_query:
fName = columns[1]
fType = columns[2]
fSize = 0
fAllowNull = (columns[3] == 0)
if fType.find("VARCHAR(") > -1:
fSize = int(fType[fType.find("(") + 1: len(fType) - 1])
info.append([fName, self.decodeSqlType(
fType), not fAllowNull, fSize])
return info
def init_(self, aclXml=None):
"""
Lee el fichero "acl.xml" y establece una nueva lista de control de acceso.
Si el fichero "acl.xml" no se puede leer, la lista de control de acceso queda vacía y
no se procesará ningún control de acceso sobre ningún objeto.
@param aclXml Contenido XML con la definición de la lista de control de acceso.
"""
util = FLUtil()
if aclXml is None:
aclXml = pineboolib.project.conn.managerModules().content("acl.xml")
doc = QDomDocument("ACL")
if self.accessControlList_:
self.accessControlList_.clear()
del self.accessControlList_
self.accessControlList_ = {}
if aclXml and not util.domDocumentSetContent(doc, aclXml):
logger.error("Lista de control de acceso errónea")
return
self.accessControlList_ = {}
# self.accessControlList_.setAutoDelete(True)
docElem = doc.documentElement()
no = docElem.firstChild()
while not no.isNull():
e = no.toElement()
if e:
if e.tagName() == "name":
self.name_ = e.text()
no = no.nextSibling()
continue
ac = FLAccessControlFactory().create(e.tagName())
if ac:
ac.set(e)
logger.debug("****************** %s %s %s", ac.type(), ac.name(), ac.user(), ac)
self.accessControlList_["%s::%s::%s" %
(ac.type(), ac.name(), ac.user())] = ac
no = no.nextSibling()
continue
no = no.nextSibling()
def init(self, aclXml=None):
util = FLUtil()
if not aclXml:
self.init(self.database().managerModules().content("acl.xml"))
return
doc = QDomDocument("ACL")
if self.accessControlList_:
self.accessControlList_.clear()
del self.accessControlList_
self.accessControlList_ = {}
if not util.domDocumentSetContent(doc, aclXml):
qWarning("FLAccessControlList : " +
util.tr("Lista de control de acceso vacia o errónea"))
return
self.accessControlList_ = {}
self.accessControlList_.setAutoDelete(True)
docElem = doc.documentElement()
no = docElem.firstChild()
while no:
e = no.toElement()
if e:
if e.tagName() == "name":
self.name_ = e.text()
no = no.nextSibling()
continue
ac = FLAccessControlFactory.create(e.tagName())
if ac:
ac.set(e)
self.accessControlList_.replace(
"%s::%s::%s" % (ac.type(), ac.name(), ac.user()), ac)
no = no.nextSibling()
continue
no = no.nextSibling()
def createSystemTable(self, n):
"""
Crea una tabla del sistema.
Este método lee directamente de disco el fichero con la descripción de una tabla
del sistema y la crea en la base de datos. Su uso normal es para inicializar
el sistema con tablas iniciales.
@param n Nombre de la tabla.
@return Un objeto FLTableMetaData con los metadatos de la tabla que se ha creado, o
False si no se pudo crear la tabla o ya existía
"""
util = FLUtil()
if not self.existsTable(n):
doc = QDomDocument()
_path = filedir("..", "share", "pineboo", "tables")
dir = qsatype.Dir_Class(_path)
_tables = dir.entryList("%s.mtd" % n)
for f in _tables:
path = "%s/%s" % (_path, f)
_file = QtCore.QFile(path)
_file.open(QtCore.QIODevice.ReadOnly)
_in = QtCore.QTextStream(_file)
_data = _in.readAll()
if not util.domDocumentSetContent(doc, _data):
logger.warn(
"FLManager::createSystemTable: %s",
util.tr(
"Error al cargar los metadatos para la tabla %1").
arg(n))
return False
else:
docElem = doc.documentElement()
mtd = self.createTable(self.metadata(docElem, True))
return mtd
f.close()
return False
def metadata(self, n, quick=False):
"""
Para obtener definicion de una tabla de la base de datos, a partir de un fichero XML.
El nombre de la tabla corresponde con el nombre del fichero mas la extensión ".mtd"
que contiene en XML la descripción de la tablas. Este método escanea el fichero
y construye/devuelve el objeto FLTableMetaData correspondiente, además
realiza una copia de estos metadatos en una tabla de la misma base de datos
para poder determinar cuando ha sido modificados y así, si es necesario, reconstruir
la tabla para que se adapte a la nuevos metadatos. NO SE HACEN
CHEQUEOS DE ERRORES SINTÁCTICOS EN EL XML.
IMPORTANTE :Para que estos métodos funcionen correctamente, es estrictamente
necesario haber creado la base de datos en PostgreSQL con codificación
UNICODE; "createdb -E UNICODE abanq".
@param n Nombre de la tabla de la base de datos de la que obtener los metadatos
@param quick Si TRUE no realiza chequeos, usar con cuidado
@return Un objeto FLTableMetaData con los metadatos de la tabla solicitada
"""
util = FLUtil()
if not n:
return None
if isinstance(n, str):
if not n or not self.db_.dbAux():
return None
ret = False
acl = False
key = n
stream = None
isSysTable = (n[0:3] == "sys" or self.isSystemTable(n))
if not isSysTable:
stream = self.db_.managerModules().contentCached("%s.mtd" %
key)
if not stream:
qWarning(
"FLManager : Error al cargar los metadatos para la tabla %s"
% n)
return None
# if not key:
# key = n
if not isSysTable:
for fi in self.cacheMetaData_:
if fi.name() == key:
ret = fi
break
else:
for fi in self.cacheMetaDataSys_:
if fi.name() == key:
ret = fi
break
if not ret:
if isSysTable:
stream = self.db_.managerModules().contentCached("%s.mtd" %
n)
if not stream:
qWarning("FLManager : " + util.tr(
"Error al cargar los metadatos para la tabla %s" %
n))
return None
doc = QDomDocument(n)
if not util.domDocumentSetContent(doc, stream):
qWarning("FLManager : " + util.tr(
"Error al cargar los metadatos para la tabla %s" % n))
return None
docElem = doc.documentElement()
ret = self.metadata(docElem, quick)
if not ret:
return None
if not isSysTable and not ret.isQuery():
self.cacheMetaData_.append(ret)
elif isSysTable:
self.cacheMetaDataSys_.append(ret)
else:
acl = self._prj.acl()
if ret.fieldsNamesUnlock():
ret = FLTableMetaData(ret)
if acl:
acl.process(ret)
if not quick and not isSysTable and self._prj.consoleShown(
) and not ret.isQuery() and self.db_.mismatchedTable(n, ret):
msg = util.translate(
"application",
"La estructura de los metadatos de la tabla '%1' y su estructura interna en la base de datos no coinciden.\n"
"Debe regenerar la base de datos.").replace("%1", n)
logger.warn(msg)
# throwMsgWarning(self.db_, msg)
return ret
else:
# QDomDoc
name = None
q = None
a = None
ftsfun = None
v = True
ed = True
cw = False
dl = False
no = n.firstChild()
while not no.isNull():
e = no.toElement()
if not e.isNull():
if e.tagName() == "field":
no = no.nextSibling()
continue
if e.tagName() == "name":
name = e.text()
no = no.nextSibling()
continue
if e.tagName() == "query":
q = e.text()
no = no.nextSibling()
continue
if e.tagName() == "alias":
a = auto_qt_translate_text(e.text())
a = util.translate("Metadata", a)
no = no.nextSibling()
continue
if e.tagName() == "visible":
v = (e.text() == "true")
no = no.nextSibling()
continue
if e.tagName() == "editable":
ed = (e.text() == "true")
no = no.nextSibling()
continue
if e.tagName() == "concurWarn":
cw = (e.text() == "true")
no = no.nextSibling()
continue
if e.tagName() == "detectLocks":
dl = (e.text() == "true")
no = no.nextSibling()
continue
if e.tagName() == "FTSFunction":
ftsfun = (e.text() == "true")
no = no.nextSibling()
continue
no = no.nextSibling()
tmd = FLTableMetaData(name, a, q)
cK = None
assocs = []
tmd.setFTSFunction(ftsfun)
tmd.setConcurWarn(cw)
tmd.setDetectLocks(dl)
no = n.firstChild()
while not no.isNull():
e = no.toElement()
if not e.isNull():
if e.tagName() == "field":
f = self.metadataField(e, v, ed)
if not tmd:
tmd = FLTableMetaData(name, a, q)
tmd.addFieldMD(f)
if f.isCompoundKey():
if not cK:
cK = FLCompoundKey()
cK.addFieldMD(f)
if f.associatedFieldName():
assocs.append(f.associatedFieldName())
assocs.append(f.associatedFieldFilterTo())
assocs.append(f.name())
no = no.nextSibling()
continue
no = no.nextSibling()
tmd.setCompoundKey(cK)
aWith = None
aBy = None
for it in assocs:
if not aWith:
aWith = it
continue
if not aBy:
aBy = it
continue
if not tmd.field(it):
continue
tmd.field(it).setAssociatedField(tmd.field(aWith), aBy)
if q and not quick:
qry = self.query(q, tmd)
if qry:
fL = qry.fieldList()
table = None
field = None
fields = tmd.fieldsNames()
# .split(",")
fieldsEmpty = (not fields)
for it in fL:
pos = it.find(".")
if pos > -1:
table = it[:pos]
field = it[pos + 1:]
else:
field = it
# if not (not fieldsEmpty and table == name and fields.find(field.lower())) != fields.end():
# print("Tabla %s nombre %s campo %s buscando en %s" % (table, name, field, fields))
# if not fieldsEmpty and table == name and (field.lower() in fields): Asi esta en Eneboo, pero incluye campos repetidos
if not fieldsEmpty and (field.lower() in fields):
continue
mtdAux = self.metadata(table, True)
if mtdAux:
fmtdAux = mtdAux.field(field)
if mtdAux:
isForeignKey = False
if fmtdAux.isPrimaryKey(
) and not table == name:
fmtdAux = FLFieldMetaData(fmtdAux)
fmtdAux.setIsPrimaryKey(False)
fmtdAux.setEditable(False)
# newRef = (not isForeignKey)
fmtdAuxName = fmtdAux.name().lower()
if fmtdAuxName.find(".") == -1:
# fieldsAux = tmd.fieldsNames().split(",")
fieldsAux = tmd.fieldsNames()
# if not fieldsAux.find(fmtdAuxName) == fieldsAux.end():
if fmtdAuxName not in fieldsAux:
if not isForeignKey:
FLFieldMetaData(fmtdAux)
# fmtdAux.setName("%s.%s" % (table, field))
# if newRef:
# fmtdAux.ref()
tmd.addFieldMD(fmtdAux)
del qry
acl = self._prj.acl()
if acl:
acl.process(tmd)
return tmd
def metadata(self, n, quick=False):
util = FLUtil()
if not n:
return None
if isinstance(n, str):
if not n or not self.db_.dbAux():
return None
ret = False
acl = False
key = n
stream = None
isSysTable = (n[0:3] == "sys" or self.isSystemTable(n))
if not isSysTable:
stream = self.db_.managerModules().contentCached("%s.mtd" %
key)
if not stream:
qWarning(
"FLManager : Error al cargar los metadatos para la tabla %s"
% n)
return None
# if not key:
# key = n
if not isSysTable:
for fi in self.cacheMetaData_:
if fi.name() == key:
ret = fi
break
else:
for fi in self.cacheMetaDataSys_:
if fi.name() == key:
ret = fi
break
if not ret:
if isSysTable:
stream = self.db_.managerModules().contentCached("%s.mtd" %
n)
if not stream:
qWarning("FLManager : " + util.tr(
"Error al cargar los metadatos para la tabla %s" %
n))
return None
doc = QDomDocument(n)
if not util.domDocumentSetContent(doc, stream):
qWarning("FLManager : " + util.tr(
"Error al cargar los metadatos para la tabla %s" % n))
return None
docElem = doc.documentElement()
ret = self.metadata(docElem, quick)
if not ret:
return None
if not isSysTable and not ret.isQuery():
self.cacheMetaData_.append(ret)
elif isSysTable:
self.cacheMetaDataSys_.append(ret)
else:
acl = self._prj.acl()
if ret.fieldsNamesUnlock():
ret = FLTableMetaData(ret)
if acl:
acl.process(ret)
if not quick and not isSysTable and self._prj.consoleShown(
) and not ret.isQuery() and self.db_.mismatchedTable(n, ret):
msg = util.tr(
"La estructura de los metadatos de la tabla '%1' y su "
"estructura interna en la base de datos no coinciden. "
"Debe regenerar la base de datos.").arg(n)
throwMsgWarning(self.db_, msg)
return ret
else:
#QDomDoc
name = None
q = None
a = None
ftsfun = None
v = True
ed = True
cw = False
dl = False
no = n.firstChild()
while not no.isNull():
e = no.toElement()
if not e.isNull():
if e.tagName() == "field":
no = no.nextSibling()
continue
if e.tagName() == "name":
name = e.text()
no = no.nextSibling()
continue
if e.tagName() == "query":
q = e.text()
no = no.nextSibling()
continue
if e.tagName() == "alias":
a = auto_qt_translate_text(e.text())
a = util.translate("Metadata", a)
no = no.nextSibling()
continue
if e.tagName() == "visible":
v = (e.text() == "true")
no = no.nextSibling()
continue
if e.tagName() == "editable":
ed = (e.text() == "true")
no = no.nextSibling()
continue
if e.tagName() == "concurWarn":
cw = (e.text() == "true")
no = no.nextSibling()
continue
if e.tagName() == "detectLocks":
dl = (e.text() == "true")
no = no.nextSibling()
continue
if e.tagName() == "FTSFunction":
ftsfun = (e.text() == "true")
no = no.nextSibling()
continue
no = no.nextSibling()
tmd = FLTableMetaData(name, a, q)
cK = None
assocs = []
tmd.setFTSFunction(ftsfun)
tmd.setConcurWarn(cw)
tmd.setDetectLocks(dl)
no = n.firstChild()
while not no.isNull():
e = no.toElement()
if not e.isNull():
if e.tagName() == "field":
f = self.metadataField(e, v, ed)
if not tmd:
tmd = FLTableMetaData(name, a, q)
tmd.addFieldMD(f)
if f.isCompoundKey():
if not cK:
cK = FLCompoundKey()
cK.addFieldMD(f)
if f.associatedFieldName():
assocs.append(f.associatedFieldName())
assocs.append(f.associatedFieldFilterTo())
assocs.append(f.name())
no = no.nextSibling()
continue
no = no.nextSibling()
tmd.setCompoundKey(cK)
aWith = None
aBy = None
for it in assocs:
if not aWith:
aWith = it
continue
if not aBy:
aBy = it
continue
tmd.field(it).setAssociatedField(tmd.field(aWith), aBy)
if q and not quick:
qry = self.query(q, tmd)
if qry:
fL = qry.fieldList()
table = None
field = None
fields = tmd.fieldsNames().split(",")
fieldsEmpty = (not fields)
for it in fL:
pos = it.find(".")
if pos > -1:
table = it[:pos]
field = it[:pos]
else:
field = it
if not (not fieldsEmpty and table == name and
fields.find(field.lower())) == fields.end():
continue
mtdAux = self.metadata(table, True)
if mtdAux:
fmtdAux = mtdAux.field(field)
if mtdAux:
isForeignKey = False
if fmtdAux.isPrimaryKey(
) and not table == name:
fmtdAux = FLFieldMetaData(fmtdAux)
fmtdAux.setIsprimaryKey(False)
fmtdAux.setEditable(False)
newRef = (not isForeignKey)
fmtdAuxName = fmtdAux.name().lower()
if fmtdAuxName.find(".") == -1:
fieldsAux = tmd.fieldsNames().split(",")
if not fieldsAux.find(
fmtdAuxName) == fieldsAux.end():
if not isForeignKey:
fmdtAux = FLFieldMetaData(fmtdAux)
fmtdAux.setName("%s.%s" %
(tambe, field))
newRef = False
if newRef:
fmtdAux.ref()
tmd.addFieldMD(fmtdAux)
qry.deleteLater()
acl = self._prj.acl()
if acl:
acl.process(tmd)
return tmd
