Python sorting html table

I am looping through a list of servers and connecting with OpenSSL, to retrieve the SSL cert, and grabbing the server name, the date the cert expires, and calculating the number of days until cert expires. I am then building an html table with the data. The columns are Host, Hostname, Expiration Date, and Remaining Days. What is the best way to sort the table by the "Remaining Days" column?

# Update the hosts entry

    ssl_results[str(ip)][0] = host

    ssl_results[str(ip)][1] = server_name

    ssl_results[str(ip)][2] = exp_date

    ssl_results[str(ip)][3] = days_to_expire



    # Loop through the ssl_results entries and generate a email + results file

    try:



        # variable to hold html for email

        SSLCertificates = """<html>

                            <head>

                              <style>

                                    table{width: 1024px;}



                                    table, th, td {

                                        border: 1px solid black;

                                        border-collapse: collapse;

                                    }



                                    th, td {

                                        padding: 5px;

                                        text-align: left;

                                    }



                                    ul:before{

                                      content:attr(data-header);

                                      font-size:120%;

                                      font-weight:bold;

                                      margin-left:-15px;

                                    }

                                </style>

                              </head>

                            <body>

                              <p><h2>Blah, </h2>

                              <h3>SSL Expiration Summary:</h3>

                              <span style="color:red;"><b>Blah Blah Blah.<b></span><br><br>

                              <table id="exp_ssls"><tr><th>Host</th><th>Hostname</th><th>Expiration Date</th><th>Remaining Days</th></tr>

                          """



        for entries in ssl_results:

            SSLCertificates += "<tr><td>" + str(entries) + "</td><td>" + str(ssl_results[entries][1]) + "</td><td>" + str(

                ssl_results[entries][2]) + "</td><td>" + str(ssl_results[entries][3]) + "</td></tr>"



        SSLCertificates += """</body>

                    </html>"""



        f = open('SSLCertificates.html', 'w')

        f.write(SSLCertificates)

        f.close()

        filename = 'SSLCertificates.html'

        attachment = open(filename, 'rb')

edited Nov 15 '18 at 13:38

Brian Tompsett - 汤莱恩

4,2231338101

asked Nov 14 '18 at 19:48

Kevin Roberson

272

1

Put everything into a multi-dimensional list, then sort, then put it into the html table

– SPYBUG96
Nov 14 '18 at 19:52

add a comment |

# Update the hosts entry

    ssl_results[str(ip)][0] = host

    ssl_results[str(ip)][1] = server_name

    ssl_results[str(ip)][2] = exp_date

    ssl_results[str(ip)][3] = days_to_expire



    # Loop through the ssl_results entries and generate a email + results file

    try:



        # variable to hold html for email

        SSLCertificates = """<html>

                            <head>

                              <style>

                                    table{width: 1024px;}



                                    table, th, td {

                                        border: 1px solid black;

                                        border-collapse: collapse;

                                    }



                                    th, td {

                                        padding: 5px;

                                        text-align: left;

                                    }



                                    ul:before{

                                      content:attr(data-header);

                                      font-size:120%;

                                      font-weight:bold;

                                      margin-left:-15px;

                                    }

                                </style>

                              </head>

                            <body>

                              <p><h2>Blah, </h2>

                              <h3>SSL Expiration Summary:</h3>

                              <span style="color:red;"><b>Blah Blah Blah.<b></span><br><br>

                              <table id="exp_ssls"><tr><th>Host</th><th>Hostname</th><th>Expiration Date</th><th>Remaining Days</th></tr>

                          """



        for entries in ssl_results:

            SSLCertificates += "<tr><td>" + str(entries) + "</td><td>" + str(ssl_results[entries][1]) + "</td><td>" + str(

                ssl_results[entries][2]) + "</td><td>" + str(ssl_results[entries][3]) + "</td></tr>"



        SSLCertificates += """</body>

                    </html>"""



        f = open('SSLCertificates.html', 'w')

        f.write(SSLCertificates)

        f.close()

        filename = 'SSLCertificates.html'

        attachment = open(filename, 'rb')

edited Nov 15 '18 at 13:38

Brian Tompsett - 汤莱恩

4,2231338101

asked Nov 14 '18 at 19:48

Kevin Roberson

272

1

Put everything into a multi-dimensional list, then sort, then put it into the html table

– SPYBUG96
Nov 14 '18 at 19:52

add a comment |

# Update the hosts entry

    ssl_results[str(ip)][0] = host

    ssl_results[str(ip)][1] = server_name

    ssl_results[str(ip)][2] = exp_date

    ssl_results[str(ip)][3] = days_to_expire



    # Loop through the ssl_results entries and generate a email + results file

    try:



        # variable to hold html for email

        SSLCertificates = """<html>

                            <head>

                              <style>

                                    table{width: 1024px;}



                                    table, th, td {

                                        border: 1px solid black;

                                        border-collapse: collapse;

                                    }



                                    th, td {

                                        padding: 5px;

                                        text-align: left;

                                    }



                                    ul:before{

                                      content:attr(data-header);

                                      font-size:120%;

                                      font-weight:bold;

                                      margin-left:-15px;

                                    }

                                </style>

                              </head>

                            <body>

                              <p><h2>Blah, </h2>

                              <h3>SSL Expiration Summary:</h3>

                              <span style="color:red;"><b>Blah Blah Blah.<b></span><br><br>

                              <table id="exp_ssls"><tr><th>Host</th><th>Hostname</th><th>Expiration Date</th><th>Remaining Days</th></tr>

                          """



        for entries in ssl_results:

            SSLCertificates += "<tr><td>" + str(entries) + "</td><td>" + str(ssl_results[entries][1]) + "</td><td>" + str(

                ssl_results[entries][2]) + "</td><td>" + str(ssl_results[entries][3]) + "</td></tr>"



        SSLCertificates += """</body>

                    </html>"""



        f = open('SSLCertificates.html', 'w')

        f.write(SSLCertificates)

        f.close()

        filename = 'SSLCertificates.html'

        attachment = open(filename, 'rb')

edited Nov 15 '18 at 13:38

Brian Tompsett - 汤莱恩

4,2231338101

asked Nov 14 '18 at 19:48

Kevin Roberson

272

# Update the hosts entry

    ssl_results[str(ip)][0] = host

    ssl_results[str(ip)][1] = server_name

    ssl_results[str(ip)][2] = exp_date

    ssl_results[str(ip)][3] = days_to_expire



    # Loop through the ssl_results entries and generate a email + results file

    try:



        # variable to hold html for email

        SSLCertificates = """<html>

                            <head>

                              <style>

                                    table{width: 1024px;}



                                    table, th, td {

                                        border: 1px solid black;

                                        border-collapse: collapse;

                                    }



                                    th, td {

                                        padding: 5px;

                                        text-align: left;

                                    }



                                    ul:before{

                                      content:attr(data-header);

                                      font-size:120%;

                                      font-weight:bold;

                                      margin-left:-15px;

                                    }

                                </style>

                              </head>

                            <body>

                              <p><h2>Blah, </h2>

                              <h3>SSL Expiration Summary:</h3>

                              <span style="color:red;"><b>Blah Blah Blah.<b></span><br><br>

                              <table id="exp_ssls"><tr><th>Host</th><th>Hostname</th><th>Expiration Date</th><th>Remaining Days</th></tr>

                          """



        for entries in ssl_results:

            SSLCertificates += "<tr><td>" + str(entries) + "</td><td>" + str(ssl_results[entries][1]) + "</td><td>" + str(

                ssl_results[entries][2]) + "</td><td>" + str(ssl_results[entries][3]) + "</td></tr>"



        SSLCertificates += """</body>

                    </html>"""



        f = open('SSLCertificates.html', 'w')

        f.write(SSLCertificates)

        f.close()

        filename = 'SSLCertificates.html'

        attachment = open(filename, 'rb')

python sorting html-table

edited Nov 15 '18 at 13:38

Brian Tompsett - 汤莱恩

4,2231338101

asked Nov 14 '18 at 19:48

Kevin Roberson

272

edited Nov 15 '18 at 13:38

Brian Tompsett - 汤莱恩

4,2231338101

asked Nov 14 '18 at 19:48

Kevin Roberson

272

edited Nov 15 '18 at 13:38

Brian Tompsett - 汤莱恩

4,2231338101

edited Nov 15 '18 at 13:38

Brian Tompsett - 汤莱恩

4,2231338101

edited Nov 15 '18 at 13:38

Brian Tompsett - 汤莱恩

4,2231338101

asked Nov 14 '18 at 19:48

Kevin Roberson

272

asked Nov 14 '18 at 19:48

Kevin Roberson

272

asked Nov 14 '18 at 19:48

Kevin Roberson

272

1

Put everything into a multi-dimensional list, then sort, then put it into the html table

– SPYBUG96
Nov 14 '18 at 19:52

add a comment |

1

Put everything into a multi-dimensional list, then sort, then put it into the html table

– SPYBUG96
Nov 14 '18 at 19:52

Put everything into a multi-dimensional list, then sort, then put it into the html table

– SPYBUG96
Nov 14 '18 at 19:52

add a comment |

1 Answer
1

active

oldest

votes

Sort the dict before you form the html tags. then Iterate thru the dict and print it using html tags. Use sorted() to sort your dict before you iterate thru it.

import operator

x = {1: 2, 3: 4, 4: 3, 2: 1, 0: 0}

sorted_x = sorted(x.items(), key=operator.itemgetter(1))

sorted_x will be a list of tuples sorted by the second element in each tuple. dict(sorted_x) == x.

answered Nov 15 '18 at 13:51

Sekar Ramu

164110

Thanks Sekar. That worked. The code I used: sorted_results = sorted(ssl_results.items(), key=lambda k: k[1]['days_to_expire'], reverse=False)

– Kevin Roberson
Nov 16 '18 at 19:35

Thanks for letting us know the results:)

– Sekar Ramu
Nov 16 '18 at 19:39

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53307754%2fpython-sorting-html-table%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

Sort the dict before you form the html tags. then Iterate thru the dict and print it using html tags. Use sorted() to sort your dict before you iterate thru it.

import operator

x = {1: 2, 3: 4, 4: 3, 2: 1, 0: 0}

sorted_x = sorted(x.items(), key=operator.itemgetter(1))

sorted_x will be a list of tuples sorted by the second element in each tuple. dict(sorted_x) == x.

answered Nov 15 '18 at 13:51

Sekar Ramu

164110

Thanks Sekar. That worked. The code I used: sorted_results = sorted(ssl_results.items(), key=lambda k: k[1]['days_to_expire'], reverse=False)

– Kevin Roberson
Nov 16 '18 at 19:35

Thanks for letting us know the results:)

– Sekar Ramu
Nov 16 '18 at 19:39

add a comment |

Sort the dict before you form the html tags. then Iterate thru the dict and print it using html tags. Use sorted() to sort your dict before you iterate thru it.

import operator

x = {1: 2, 3: 4, 4: 3, 2: 1, 0: 0}

sorted_x = sorted(x.items(), key=operator.itemgetter(1))

sorted_x will be a list of tuples sorted by the second element in each tuple. dict(sorted_x) == x.

answered Nov 15 '18 at 13:51

Sekar Ramu

164110

Thanks Sekar. That worked. The code I used: sorted_results = sorted(ssl_results.items(), key=lambda k: k[1]['days_to_expire'], reverse=False)

– Kevin Roberson
Nov 16 '18 at 19:35

Thanks for letting us know the results:)

– Sekar Ramu
Nov 16 '18 at 19:39

add a comment |

Sort the dict before you form the html tags. then Iterate thru the dict and print it using html tags. Use sorted() to sort your dict before you iterate thru it.

import operator

x = {1: 2, 3: 4, 4: 3, 2: 1, 0: 0}

sorted_x = sorted(x.items(), key=operator.itemgetter(1))

sorted_x will be a list of tuples sorted by the second element in each tuple. dict(sorted_x) == x.

answered Nov 15 '18 at 13:51

Sekar Ramu

164110

Sort the dict before you form the html tags. then Iterate thru the dict and print it using html tags. Use sorted() to sort your dict before you iterate thru it.

import operator

x = {1: 2, 3: 4, 4: 3, 2: 1, 0: 0}

sorted_x = sorted(x.items(), key=operator.itemgetter(1))

sorted_x will be a list of tuples sorted by the second element in each tuple. dict(sorted_x) == x.

answered Nov 15 '18 at 13:51

Sekar Ramu

164110

answered Nov 15 '18 at 13:51

Sekar Ramu

164110

answered Nov 15 '18 at 13:51

Sekar Ramu

164110

answered Nov 15 '18 at 13:51

Sekar Ramu

164110

Thanks Sekar. That worked. The code I used: sorted_results = sorted(ssl_results.items(), key=lambda k: k[1]['days_to_expire'], reverse=False)

– Kevin Roberson
Nov 16 '18 at 19:35

Thanks for letting us know the results:)

– Sekar Ramu
Nov 16 '18 at 19:39

add a comment |

Thanks Sekar. That worked. The code I used: sorted_results = sorted(ssl_results.items(), key=lambda k: k[1]['days_to_expire'], reverse=False)

– Kevin Roberson
Nov 16 '18 at 19:35

Thanks for letting us know the results:)

– Sekar Ramu
Nov 16 '18 at 19:39

Thanks Sekar. That worked. The code I used: sorted_results = sorted(ssl_results.items(), key=lambda k: k[1]['days_to_expire'], reverse=False)

– Kevin Roberson
Nov 16 '18 at 19:35

Thanks for letting us know the results:)

– Sekar Ramu
Nov 16 '18 at 19:39

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Ndtyjky