Compile Cheetah Template on Windows

Discussion in 'Python' started by brianrpsgt1, Nov 24, 2007.

  1. brianrpsgt1

    brianrpsgt1 Guest

    Newbie here....

    I have been able to successful pull info from a MySQL DB, get the
    results and output them in an HTML format using Cheetah to the screen
    using IDLE. I am doing this on a Windows Laptop, running WinXP,
    Python 2.5 and the latest version of Cheetah.

    I have two questions:
    1. How and where do you compile Cheetah templates in Windows? The
    command in the docs is cheetah compile a, however, I believe that this
    is for Linux. This does nothing in a DOS Prompt. Please provide the
    info for this command in Windows.

    2. How do I output the HTML to a file? I tried the following:

    FILE = open(filename, "wt")

    I get an error though that states that writelines() requires an
    interable argument

    Thnx for any assistance!

    brianrpsgt1, Nov 24, 2007
    1. Advertisements

  2. brianrpsgt1

    Tim Roberts Guest

    The Cheetah installation should have created scripts called "cheetah" and
    "cheetah-compile" in your Python25\Scripts directory. The issue you have
    is that they aren't on your path.

    One answer is to copy Python25\Scripts\cheetah to \Windows\ and
    Python25\Scripts\cheetah-compile to \Windows\ Then you
    can type " compile xxx" or " xxx".

    However, you don't have to compile them in advance. You can do "from
    Cheetah.Template import Template" and compile them on the fly, with
    tmpl = Template( file='page.tmpl' )
    Just use FILE.write( output ).
    Tim Roberts, Nov 26, 2007
    1. Advertisements

  3. brianrpsgt1

    brianrpsgt1 Guest

    Tim, thank you very much for the reply. The 'cheetah' function is now

    I am still having a problem creating the file. I continually get
    errors. I am sure that it is something very simple.

    Below is the code, please guide me in the right direction.... ::

    import psycopg2, psycopg2.extensions
    from Cheetah.Template import Template
    import operator
    import os
    from SafetyNet import SafetyNet

    filename = open("C:\Python25\Lib\site-packages\PSN

    db = psycopg2.connect("dbname='XXX' user='XXX' host='XXX'")

    pocmonitors_cur = db.cursor()
    pocmonitors_cur.execute("""SELECT pocmonitor_name, pocmonitor_sn FROM
    pocmonitor ORDER BY pocmonitor_name""")

    pocmonitors = []

    for i in range(pocmonitors_cur.rowcount) :

    total_results = len(pocmonitors)

    nameSpace = {'title': 'First Cheetah Example', 'pocmonitors':
    pocmonitors, 'total_results': total_results}

    output = Template(file='C:\Python25\Lib\site-packages\PSN
    \SafetyNet.tmpl', searchList=[nameSpace])

    print output


    Thanks for the help!

    brianrpsgt1, Nov 29, 2007
  4. brianrpsgt1

    Tim Roberts Guest

    There are three problems here. First, you have bare backslashes in this
    string. You happened to get lucky with this one, but if your file had been
    called "...\textfile.html", it would have failed because \t is the "tab"
    character. You need to either:
    1. Double all the backslashes (...25\\Lib\\site-...)
    2. Use a raw string (open(r"C:\Python25...))
    3. Use forward slashes (open("C:/Python25/Lib/site-..."))

    Second, later on you try to write to this file, but you have opened it in
    "read" mode.

    Third, you should not be doing your development work inside the Python
    site-packages directory. The only thing in there should be the files from
    the add-on packages you have installed. Remember that, when you upgrade,
    the site-packages folder will go away.

    You need:
    filename = open("C:/Development/InstalledDevices.html", "w")
    What are you trying to do here? If you just want to turn the query results
    into a list, you can just do:

    pocmonitors = pocmonitors_cur.fetchall()
    This string also needs to be escaped.
    Tim Roberts, Nov 30, 2007
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.