convertHTML-AWRToExcel/main.py at master · CT13/convertHTML-AWRToExcel · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
"import requeired packages and class"
import urllib.request  as urllib2
import matplotlib.pyplot as plt
from bs4 import BeautifulSoup
import pandas as pd
import numpy as np
import xlsxwriter
from openpyxl.reader.excel import load_workbook
import env
import addmevent
import ioprofile
import sqlstats
import sgatarget

class Main:
    "This is main class for this application and whole program stats from here"

    def __init__ (self):
        "Constructor"

    def main (self):
        awrReportFile = str(input ("Enter the AWR report file name to be analyzed: "))

        try:
            fName = open (awrReportFile)
        except IOError:
            print ("Entered file is not accecible. Please entry correct AWR report.")
            exit ()
        finally:
            fName.close()

        htmlFile = open(awrReportFile, 'r', encoding='utf-8')
        sourceCode = htmlFile.read()
        soup = BeautifulSoup(sourceCode,"lxml")

        "Call DB, host and snap detail fetch class by defininig object"
        envDetail = env.Env()
        envDetail.extractenvinfo(soup)
        "Call ADDM and Foreground detail fetch class by defininig object"
        addmEventDetails = addmevent.AddmEvent()
        addmEventDetails.Addm(soup)
        "Call IO profile detail fetch class by defininig object"
        ioProfileDetails = ioprofile.IOProfile()
        ioProfileDetails.ioprofile(soup)
        "Call SQL Order by CPU detail fetch class by defininig object"
        cpuOrderByDetails = sqlstats.SqlStats()
        cpuOrderByDetails.sqlstatistics(soup)
        "Call SQL Order by Elapsed Time detail fetch class by defininig object"
        elapsedTimeOrderByDetails = sqlstats.SqlStats()
        elapsedTimeOrderByDetails.elapsedsqlstatistics(soup)
        "Call SQL Order by User IO detail fetch class by defininig object"
        userIOOrderByDetails = sqlstats.SqlStats()
        userIOOrderByDetails.iowaitsqlstatistics(soup)
        "Call SQL Order by Gets detail fetch class by defininig object"
        getsOrderByDetails = sqlstats.SqlStats()
        getsOrderByDetails.getssqlstatistics(soup)
        "Call SQL Order by Physical Reads detail fetch class by defininig object"
        pReadsOrderByDetails = sqlstats.SqlStats()
        pReadsOrderByDetails.preadssqlstatistics(soup)
        "Call SGA Target Advisory method to conclude"
        sgaTargetAdvise = sgatarget.SgaAdvisryTarget()
        sgaTargetAdvise.sgatargetadvisory(soup)

"Call main class and necessary functions"
fi = Main ()
fi.main()