package dataProfileWebSite; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Timestamp; import java.text.DateFormat; import java.text.DecimalFormat; import java.text.SimpleDateFormat; import java.util.Calendar; import dataWarehousingTools.LogFile; import dataWarehousingTools.Configuration; import dataWarehousingTools.DashboardFile; public class Patterns { public Patterns ( Configuration configuration, Connection connection, LogFile logFile, int databaseLinkId, String databaseName, String schemaName, String tableName, int rowCount, int tableProfileId, int columnProfileId, String columnName, Timestamp dateTimeStatisticsCollected ) { Statement statement = null; ResultSet resultSet = null; String pattern; int frequency; DashboardFile patternsFile; XmlElement xmlElement; Calendar today; DateFormat longDateFormat; DecimalFormat integerFormat; int rowNumber; today = Calendar.getInstance(); longDateFormat = new SimpleDateFormat("EEE, dd-MMM-yyyy HH:mm:ss"); longDateFormat.format(today.getTime()); integerFormat = new DecimalFormat("###,###,###,###,###"); patternsFile = new DashboardFile ( configuration.getHtmlFileLocation() + "Pattern" + columnProfileId + ".htm" ); patternsFile.PutLine(""); patternsFile.PutLine(""); patternsFile.PutLine(" "); patternsFile.PutLine ( " " ); xmlElement = new XmlElement(2, "title", "", "Patterns for Column: " + columnName); patternsFile.PutLine(xmlElement.getXmlElement()); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine("
DatabaseSchemaTableRow CountColumnDate Statistics Collected
" + databaseName + "" + schemaName + "" + tableName + "" + integerFormat.format(rowCount) + "" + columnName + "" + longDateFormat.format(dateTimeStatisticsCollected.getTime()) + "
"); xmlElement = new XmlElement ( 6, "a", "href=\"" + "index.html\"", "Back to List of Databases" ); patternsFile.PutLine("

" + xmlElement.getXmlElement() + "

"); xmlElement = new XmlElement ( 6, "a", "href=\"" + "Schema" + databaseLinkId + ".htm\"", "Back to List of Tables" ); patternsFile.PutLine("

" + xmlElement.getXmlElement() + "

"); xmlElement = new XmlElement ( 6, "a", "href=\"" + "TableProfile" + tableProfileId + ".htm\"", "Back to List of Columns" ); patternsFile.PutLine("

" + xmlElement.getXmlElement() + "

"); xmlElement = new XmlElement(4, "h4", "", "Published: " + longDateFormat.format(today.getTime()) + " GMT"); patternsFile.PutLine(xmlElement.getXmlElement()); patternsFile.PutLine(""); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); try { statement = connection.createStatement(); } catch(SQLException sqle) { logFile.logMessage(sqle.toString()); } try { resultSet = statement.executeQuery ( "select " + "id as pattern_id, " + "frequency, " + "pattern " + "from " + "pattern " + "where " + "column_profile_id = " + columnProfileId + "order by " + "frequency desc " + "limit 50" ); } catch(SQLException sqle) { logFile.logMessage(sqle.toString()); } rowNumber = 1; try { while (resultSet.next()) { frequency = resultSet.getInt("frequency"); pattern = new String(resultSet.getString("pattern")); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); switch (rowNumber) { case 1: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 2: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 3: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 4: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 5: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 6: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 7: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 8: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 9: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 10: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; default: patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; } patternsFile.PutLine(" "); rowNumber++; } } catch (SQLException sqle) { logFile.logMessage(sqle.toString()); } for ( ; rowNumber < 11; rowNumber++) { patternsFile.PutLine(" "); switch (rowNumber) { case 1: patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 2: patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 3: patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 4: patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 5: patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 6: patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 7: patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 8: patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 9: patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; case 10: patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); patternsFile.PutLine(" "); break; } patternsFile.PutLine(" "); } patternsFile.PutLine("
PatternFrequency Legend
" + pattern + "" + integerFormat.format(frequency) + " CodeMeaningAAn alphabetic character9A numeric charactersA normal space (U+0020)!A punctuation mark$A currency symboléAn accented letter+A mathematical or other symbol^A control characterbA non-breaking space (U+00a0)
CodeMeaning AAn alphabetic character 9A numeric character sA normal space (U+0020) !A punctuation mark $A currency symbol éAn accented letter +A mathematical or other symbol ^A control character bA non-breaking space (U+00a0)
"); xmlElement = new XmlElement(4, "h4", "", "Published: " + longDateFormat.format(today.getTime()) + " GMT"); patternsFile.PutLine(xmlElement.getXmlElement()); patternsFile.PutLine(" "); patternsFile.Close(); } }