public void replaceFileStat(fileStatistics file)
{
int foundPackageID = getPackageId(file.getPackageName());
int foundClassID = getClassId(file.getClassName());
String sql = String.Format(updateFileStatPrefix,
statsTable, uniqueKeywords, file.getUniqueKeywords(),
uniqueUDIs, file.getUniqueUdis(),
uniqueConstants, file.getUniqueConstants(),
uniqueSpecialChars, file.getUniqueSpecialChars(),
totalKeywords, file.getTotalKeywords(),
totalUDIs, file.getTotalUdis(),
totalConstants, file.getTotalConstants(),
totalSpecialChars, file.getTotalSpecialChars(),
totalChars, file.getTotalChars(),
totalWhiteSpace, file.getTotalWhiteSpace(),
totalComments, file.getTotalCommentChars(),
percentWhitespace, file.getTotalWhiteSpace(),
percentComments, file.getPercentCommentsChars(),
filePath, file.getFilepath(),
packageID, foundPackageID,
classID, foundClassID);
Console.WriteLine("Sql String: " + sql);
executeSqlNonQuery(sql);
}
public void addFileStat(fileStatistics file)
{
int foundPackageID = getPackageId(file.getPackageName());
int foundClassID = getClassId(file.getClassName());
if (foundPackageID > 0 && foundClassID > 0)
{
String sql = String.Format(insertFileStatPrefix,
statsTable, packageID, classID, uniqueKeywords, uniqueUDIs, uniqueConstants,
uniqueSpecialChars, totalKeywords, totalUDIs, totalConstants, totalSpecialChars, totalChars,
totalWhiteSpace, totalComments, percentWhitespace, percentComments, filePath,
foundPackageID, foundClassID, file.getUniqueKeywords(), file.getUniqueUdis(),
file.getUniqueConstants(), file.getUniqueSpecialChars(), file.getTotalKeywords(),
file.getTotalUdis(), file.getTotalConstants(), file.getTotalSpecialChars(), file.getTotalChars(),
file.getTotalWhiteSpace(), file.getTotalCommentChars(), file.getPercentWhitespace(),
file.getPercentCommentsChars(), file.getFilepath());
Console.WriteLine("Sql String: " + sql);
executeSqlNonQuery(sql);
}
else
{
Console.WriteLine("ERROR in addFileStat: Package or Class ID are invalid.");
}
}
public void addRowToViewTable(fileStatistics file)
{
this.statsViewTable.Rows.Add(
file.getPackageName(),
file.getClassName(),
file.getUniqueKeywords(),
file.getUniqueUdis(),
file.getUniqueConstants(),
file.getUniqueSpecialChars(),
file.getTotalKeywords(),
file.getTotalUdis(),
file.getTotalConstants(),
file.getTotalSpecialChars(),
file.getTotalChars(),
file.getTotalWhiteSpace(),
file.getTotalCommentChars(),
file.getPercentWhitespace(),
file.getPercentCommentsChars(),
file.getFilepath());
}
