def reporteTabla():
f = open("./Reportes/Reporte_TablaSimbolos.html", "w")
f.write("<!DOCTYPE html>\n")
f.write("<html>\n")
f.write(" <head>\n")
f.write(' <meta charset="UTF-8">\n')
f.write(
' <meta name="viewport" content="width=device-width, initial-scale=1.0">'
)
f.write(" <title>Reporte de tabla simbolos</title>\n")
f.write(' <link rel="stylesheet" href="style.css">\n')
f.write(" </head>\n")
f.write(" <body>\n")
f.write(" <p><b>Reporte Tabla de Simbolos<b></p>\n")
f.write(" <div>\n")
for a in datos.tablaSimbolos:
f.write(" <div>\n")
f.write(" <p class='base'>BASE DE DATOS: ")
f.write(a)
f.write("</p>\n")
owner = datos.tablaSimbolos[a]['owner']
for table in datos.tablaSimbolos[a]['tablas']:
columnas = []
for column in datos.tablaSimbolos[a]['tablas'][table]['columns']:
cc = ""
try:
cc = column['name']
except:
cc = column.name
nombre = cc
tt = ""
try:
tt = column.type
except:
tt = column['type']
tipo = tt
yy = ""
try:
yy = column.size
except:
yy = column['size']
size = yy
c = fila(nombre, tipo, size)
ff = ""
try:
ff = column['pk']
except:
ff = column.pk
if ff != None:
c.setPK()
gg = ""
try:
gg = column['fk']
except:
gg = column.fk
if gg != None:
c.setFK()
aa = ""
try:
aa = column['unique']
except:
aa = column.unique
if aa != None:
c.setUnique()
bb = ""
try:
bb = column['default']
except:
bb = column.default
if bb == None:
c.setDefault('None')
else:
c.setDefault(column.default)
columnas.append(c)
f.write("<p class='tabla'>Tabla: ")
f.write(table)
f.write("</p>")
f.write(" <table>\n")
f.write(
" <tr class='titulo'> <td><b>Nombre</b></td> <td><b>Tipo</b></td> <td><b>Size</b></td> <td><b>PK</b></td> <td><b>FK</b></td> <td><b>Unique</b></td> <td><b>Default</b></td> </tr>\n"
)
for col in columnas:
f.write(" <tr><td>")
f.write(col.nombre)
f.write("</td><td>")
f.write(col.tipo)
f.write("</td><td>")
f.write(str(col.size))
f.write("</td><td>")
if col.PK == False:
f.write("False")
else:
f.write("True")
f.write("</td><td>")
if col.FK == False:
f.write("False")
else:
f.write("True")
f.write("</td><td>")
if col.unique == False:
f.write("False")
else:
f.write("True")
f.write("</td><td>")
f.write(col.default)
f.write("</td></tr>\n")
f.write(" </table>\n")
f.write(" </div>\n")
f.write(" </div>\n")
f.write(" </body>\n")
f.write("</html>\n")
f.close()
def reporteTabla( datos):
f = open("./Reportes/Reporte_TablaSimbolos.html", "w")
f.write("<!DOCTYPE html>\n")
f.write("<html>\n")
f.write(" <head>\n")
f.write(' <meta charset="UTF-8">\n')
f.write(' <meta name="viewport" content="width=device-width, initial-scale=1.0">')
f.write(" <title>Reporte de tabla simbolos</title>\n")
f.write(' <link rel="stylesheet" href="style.css">\n')
f.write(" </head>\n")
f.write(" <body>\n")
f.write(" <p><b>Reporte Tabla de Simbolos<b></p>\n")
f.write(" <div>\n")
for a in datos.tablaSimbolos:
if a == 'funciones_':
f.write("<div>\n")
f.write("<p class='base'>Funciones/Procedimientos</p>")
f.write("<center>\n")
f.write("<table>\n")
f.write("<tr class='titulo'> <td><b>Nombre</b></td> <td><b>Return</b></td> <td><b>Tipo</b></td></tr>\n")
for func in datos.tablaSimbolos['funciones_']:
if func['drop'] == 1:
f.write(" <tr><td>")
f.write(func['name'])
f.write("</td><td>")
if func['return'] == None or func['return'] == '':
f.write("None")
else:
f.write(func['return'])
f.write("</td><td>")
f.write(func['tipo'])
f.write("</td></tr>\n")
f.write("</table>\n")
f.write("</center>\n")
continue
f.write(" <div>\n")
f.write("<p>BASE DE DATOS: ")
f.write(a)
f.write("</p>\n")
owner = datos.tablaSimbolos[a]['owner']
for table in datos.tablaSimbolos[a]['tablas']:
columnas = []
for column in datos.tablaSimbolos[a]['tablas'][table]['columns']:
cc = ""
try:
cc = column['name']
except:
cc = column.name
nombre = cc
tt = ""
try:
tt = column.type
except:
tt = column['type']
tipo = tt
yy = ""
try:
yy = column.size
except:
yy = column['size']
size = yy
c = fila(nombre, tipo, size)
ff = ""
try:
ff = column['pk']
except:
ff = column.pk
if ff != None:
c.setPK()
gg = ""
try:
for fkAS in column['fk']:
if fkAS == None:
gg = False
else:
gg = True
except:
for fkAS in column.fk:
if fkAS == None:
gg = False
else:
gg = True
c.setFK()
c.FK = gg
aa = ""
try:
aa = column['unique']
except:
aa = column.unique
if aa != None:
c.setUnique()
bb = ""
try:
bb = column['default']
except:
bb = column.default
if bb == None:
c.setDefault('None')
else:
c.setDefault(column.default)
columnas.append(c)
f.write("<p class='tabla'>Tabla: ")
f.write(table)
f.write("</p>")
f.write("<center>")
f.write(" <table>\n")
f.write(" <tr class='titulo'> <td><b>Nombre</b></td> <td><b>Tipo</b></td> <td><b>Size</b></td> <td><b>PK</b></td> <td><b>FK</b></td> <td><b>Unique</b></td> <td><b>Default</b></td> </tr>\n")
for col in columnas:
f.write(" <tr><td>")
f.write(col.nombre)
f.write("</td><td>")
f.write(col.tipo)
f.write("</td><td>")
f.write(str(col.size))
f.write("</td><td>")
if col.PK == False:
f.write("False")
else:
f.write("True")
f.write("</td><td>")
if col.FK == False:
f.write("False")
else:
f.write("True")
f.write("</td><td>")
if col.unique == False:
f.write("False")
else:
f.write("True")
f.write("</td><td>")
f.write(col.default)
f.write("</td></tr>\n")
f.write(" </table>\n")
f.write("</center>\n")
f.write("</div>")
if 'index' in datos.tablaSimbolos[a]:
f.write("<div>")
f.write("<center>\n")
for column in datos.tablaSimbolos[a]['index']:
f.write("<p class='i'>Indice :")
f.write(column.name)
f.write("<li>")
f.write("<ol>Nombre: ")
f.write(column.name)
f.write("</ol></li><li>Columnas: ")
try:
tc = ("<ul>")
tc += ("Tabla ->")
tc += (column.table)
tc += (" Columna ->")
tc += (column.columns.id)
tc += (" Tipo ->")
if column.columns.option:
tc += ('Hash')
else:
tc += ('lower')
tc += ("</ul>\n")
f.write(tc)
except:
for h in column.columns:
tc = ("<ul>")
tc += ("Tabla ->")
tc += (column.table)
tc += (" Columna ->")
tc += (h.column)
tc += ("</ul>\n")
f.write(tc)
f.write("</li><li>Orden: ")
f.write(column.order)
f.write("</p>\n")
f.write("/<center>\n")
f.write(" </div>\n")
f.write(" </div>\n")
f.write(" </body>\n")
f.write("</html>\n")
f.close()