How to use python code inside html file in cherrypy framework?

Question

I am learning cherrypy framework for my python development.I created a database,inserted some data and now I want to retrieve it and show it in the browser.Data is created in the sqlite database but when displaying the data it simply shows for loop instead of printing the data in the browser.

import sqlite3
import cherrypy

class simple_db(object):
    @cherrypy.expose
    def index(self):
        db = sqlite3.connect('picnic.db')
        c = db.cursor()
        c.execute("SELECT item,quant FROM picnic")
        data = c.fetchone()
        c.close() 
        output = open("data.html")
        return output


if __name__ == '__main__':

    cherrypy.config.update("app.conf")
    cherrypy.quickstart(simple_db())

My html file,

    <h1>Things to bring to our picnic</h1>
    <head>
    <style>
    table {
        border-collapse: collapse;
    }
    </style>
    </head>
    <table border=1>
    <tr><th>Item</th><th>Quantity</th></tr>
    % for row in data: 
        <tr>
        % for col in row: 
            <td>{{col}}</td>
        % endfor 
        </tr>
    % endfor

mhawke · Accepted Answer · 2016-03-31 12:48:15Z

3

Your HTML file is in fact a template (it looks like you're using Mako) which needs to be rendered.

Currently your code is simply opening the template file and returning the file object. This causes cherrypy to return the contents of that file verbatim.

Assuming that you have installed mako the simplest way to render the template is like this:

import sqlite3
import cherrypy
from mako.template import Template

class simple_db(object):
    @cherrypy.expose
    def index(self):
        db = sqlite3.connect('picnic.db')
        c = db.cursor()
        c.execute("SELECT item,quant FROM picnic")
        data = c.fetchall()
        c.close() 
        return Template(filename='data.html').render(data=data)

if __name__ == '__main__':
    cherrypy.config.update("app.conf")
    cherrypy.quickstart(simple_db())

Note that c.fetchall() should be used instead of fetchone().

Also there was an error in the template where col is not being referenced correctly. It should be

        <td>${col}</td>

not

        <td>{{col}}</td>

This is a very simple example. There may be more convenient ways to handle rendering of your templates, e.g. template lookups, so you should read the Mako documentation.

answered Mar 31, 2016 at 12:48

mhawke

87.5k10 gold badges122 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kiran Over a year ago

Thanks this solved my problem,Can u explain what is meant by name='__main'?

mhawke Over a year ago

@Bhanukiran: no problem. You can find out about __main__ in the documentation.

Collectives™ on Stack Overflow

How to use python code inside html file in cherrypy framework?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related