package dataProfileWebSite; import java.sql.Connection; import java.text.DateFormat; import java.text.DecimalFormat; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.ListIterator; import dataWarehousingTools.LogFile; import dataWarehousingTools.Configuration; import dataWarehousingTools.DashboardFile; public class DatabaseIndex { public DatabaseIndex(Configuration configuration, Connection connection, LogFile logFile, DatabaseList databaseList, String database) { XmlElement xmlElement; ListIterator iterator; Calendar today; DateFormat longDateFormat; DecimalFormat integerFormat; DashboardFile databaseIndexFile; DatabaseElement databaseElement; TableList tableProfileList; databaseIndexFile = new DashboardFile ( configuration.getHtmlFileLocation() + "index" + ".html" ); today = Calendar.getInstance(); longDateFormat = new SimpleDateFormat("EEE dd-MMM-yyyy HH:mm:ss"); longDateFormat.format(today.getTime()); integerFormat = new DecimalFormat("###,###,###,###,###"); databaseIndexFile.PutLine(""); databaseIndexFile.PutLine(""); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine ( " " ); xmlElement = new XmlElement(2, "title", "", "List of Databases Profiled"); databaseIndexFile.PutLine(xmlElement.getXmlElement()); databaseIndexFile.PutLine(""); databaseIndexFile.PutLine(" "); xmlElement = new XmlElement(4, "h1", "", "List of Databases Profiled"); databaseIndexFile.PutLine(xmlElement.getXmlElement()); xmlElement = new XmlElement(4, "h4", "", "Published: " + longDateFormat.format(today.getTime()) + " GMT"); databaseIndexFile.PutLine(xmlElement.getXmlElement()); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(" "); for (iterator = databaseList.listIterator(); iterator.hasNext();) { databaseElement = (DatabaseElement) iterator.next(); databaseIndexFile.PutLine(" "); // suppress database name if same as previous databaseIndexFile.PutLine ( " " ); xmlElement = new XmlElement ( 6, "a", "href=\"" + "Schema" + databaseElement.getDatabaseLinkId() + ".htm\"", databaseElement.getSchemaName() ); databaseIndexFile.PutLine ( " " ); databaseIndexFile.PutLine ( " " ); databaseIndexFile.PutLine ( " " ); databaseIndexFile.PutLine(" "); if (database.isEmpty() || database.equalsIgnoreCase(databaseElement.getDatabaseName())) { tableProfileList = new TableList ( connection, logFile, databaseElement.getDatabaseName(), databaseElement.getSchemaName(), databaseElement.getDatabaseLinkId() ); new TableIndex ( configuration, connection, logFile, tableProfileList, databaseElement.getDatabaseName(), databaseElement.getDatabaseLinkId() ); } } databaseIndexFile.PutLine("

Database	Schema	Number of Tables Profiled	Date of Latest Profile
" + databaseElement.getDatabaseName() + "	" + xmlElement.getXmlElement() + "	" + integerFormat.format(databaseElement.getTableCount()) + "	" + longDateFormat.format(databaseElement.getLatestProfile()) + "

"); xmlElement = new XmlElement(4, "h4", "", "Published: " + longDateFormat.format(today.getTime()) + " GMT"); databaseIndexFile.PutLine(xmlElement.getXmlElement()); databaseIndexFile.PutLine(" "); databaseIndexFile.PutLine(""); databaseIndexFile.Close(); } }