class TypeCheckerReport(object):
def __init__(self):
self._typeChecker = TypeChecker()
self._data = ''
self.generateReport()
report = open('typeChecker.dot', 'w')
report.write(self._data)
report.close()
os.system('dot -Tpng typeChecker.dot -o typeChecker.png')
def generateReport(self):
self._data = 'digraph {\n\ttbl [\n\tshape=plaintext\n\tlabel=<'
self._data += '\n\t\t<table border=\'0\' cellborder=\'1\' color=\'#324960\' cellspacing=\'0\'>'
self.generateDatabases()
self._data += '\n\t\t</table>\n\t>];\n}'
def generateDatabases(self):
databases = self._typeChecker.getList()
for db in databases:
self._data += '\n\t\t\t<tr>\n\t\t\t\t<td bgcolor="#324960" colspan=\'2\'>'
self._data += f"\n\t\t\t\t\t<font color=\"white\">DATABASE: {db.name}</font>"
self._data += '\n\t\t\t\t</td>\n\t\t\t</tr>'
self.generateTables(db)
self._data += '\n\t\t\t<tr>\n\t\t\t\t<td colspan=\'2\' SIDES="T"> </td>\n\t\t\t</tr>'
def generateTables(self, database):
for tb in database.tables:
self._data += '\n\t\t\t<tr>\n\t\t\t\t<td bgcolor="#4fc3a1" colspan=\'2\' SIDES="LR">'
self._data += f"\n\t\t\t\t\t<font color=\"white\">TABLE: {tb.name}</font>"
self._data += '\n\t\t\t\t</td>\n\t\t\t</tr>'
self.generateColumns(tb)
def generateColumns(self, table):
for col in table.columns:
self.dataCol('Name', col.name)
self.dataCol('Data Type', col.dataType)
self.dataCol('Length', col.length)
self.dataCol('Not Null', col.notNull)
#self.dataCol('Primary Key', col.primaryKey)
self._data += f"\n\t\t\t<tr>\n\t\t\t\t<td SIDES=\"LB\" ALIGN=\"RIGHT\"><b>Primary Key: </b></td>"
self._data += f"\n\t\t\t\t<td SIDES=\"RB\" ALIGN=\"LEFT\">{col.primaryKey}</td>\n\t\t\t</tr>"
def dataCol(self, name, data):
self._data += f"\n\t\t\t<tr>\n\t\t\t\t<td SIDES=\"L\" ALIGN=\"RIGHT\"><b>{name}:</b></td>"
self._data += f"\n\t\t\t\t<td SIDES=\"R\" ALIGN=\"LEFT\">{data}</td>\n\t\t\t</tr>"
class TypeCheckerReport(object):
def __init__(self):
self._typeChecker = TypeChecker()
self._data = ''
self.generateReport()
report = open('typeChecker.dot', 'w')
report.write(self._data)
report.close()
os.system('dot -Tpdf typeChecker.dot -o typeChecker.pdf')
# os.startfile('typeChecker.pdf')
def generateReport(self):
self._data = 'digraph {\n\ttbl [\n\tshape=plaintext\n\tlabel=<'
self._data += '\n\t\t<table border=\'0\' cellborder=\'1\' color=\'#324960\' cellspacing=\'0\'>'
self.generateDatabases()
self._data += '\n\t\t</table>\n\t>];\n}'
def generateDatabases(self):
databases = self._typeChecker.getList()
for db in databases:
self._data += '\n\t\t\t<tr>'
self._data += '\n\t\t\t\t<td bgcolor="#324960" colspan=\'10\' SIDES=\"TB\">'
self._data += f"\n\t\t\t\t\t<font color=\"white\">DATABASE: {db.name}</font>"
self._data += '\n\t\t\t\t</td>'
self._data += '\n\t\t\t\t<td bgcolor="#324960" colspan=\'1\' SIDES=\"TB\">'
self._data += f"\n\t\t\t\t\t<font color=\"white\">MODE: {db.mode}</font>"
self._data += '\n\t\t\t\t</td>'
self._data += '\n\t\t\t</tr>'
self.generateTables(db)
self._data += '\n\t\t\t<tr>\n\t\t\t\t<td colspan=\'11\' SIDES="T"> </td>\n\t\t\t</tr>'
def generateTables(self, database):
for tb in database.tables:
self._data += '\n\t\t\t<tr>\n\t\t\t\t<td bgcolor="#4fc3a1" colspan=\'11\' SIDES="LR">'
self._data += f"\n\t\t\t\t\t<font color=\"white\">TABLE: {tb.name}</font>"
self._data += '\n\t\t\t\t</td>\n\t\t\t</tr>'
self.generateColumns(tb)
def generateColumns(self, table):
self._data += '\n\t\t\t<tr>'
self.dataHeaderCol('Number')
self.dataHeaderCol('Name')
self.dataHeaderCol('Data Type')
self.dataHeaderCol('Length')
self.dataHeaderCol('Default')
self.dataHeaderCol('Not Null')
self.dataHeaderCol('Unique')
self.dataHeaderCol('Constraint')
self.dataHeaderCol('Check')
# self.dataHeaderCol('Auto Increment')
self.dataHeaderCol('Primary Key')
self.dataHeaderCol('Foreign Key')
self._data += '\n\t\t\t</tr>'
for col in table.columns:
self._data += '\n\t\t\t<tr>'
self.dataCol(col.number)
self.dataCol(col.name)
self.dataCol(col.dataType)
self.dataCol(col.length)
self.dataCol(col.default)
self.dataCol(col.notNull)
self.dataCol(col.unique)
self.dataCol(col.constraint)
self.dataCol(col.check)
# self.dataCol(col.autoincrement)
self.dataCol(col.primaryKey)
self.dataCol(col.foreignKey)
self._data += '\n\t\t\t</tr>'
def dataHeaderCol(self, name):
self._data += f"\n\t\t\t\t<td SIDES=\"B\"><b> {name} </b></td>"
def dataCol(self, data):
self._data += f"\n\t\t\t\t<td SIDES=\"B\">{data}</td>"
