Google visualization from python

So I was hacking away at a turbogears project and thought 'how cool would it be to visualize this?' That thought lead to a short example of how to get the graphing visualization from google finance into your app. I used cherrypy to do the web serving for the example. Code after the break (sorry if wordpress formats it poorly).

#!/usr/bin/env python
# encoding: utf-8
"""
chart_example.py

Dynamic example of chart visualization

Created by Adam Hitchcock on 2009-05-05.
Copyright (c) 2009 __NorthIsUp__. All rights reserved.
"""

import sys
import os
import string
import subprocess
import cherrypy

body = """

"""

class DataTable():
    def __init__(self):
        """columns [{'name':'aname', 'type':'JStype'}]"""

        self.columns = []
        self.values = []
        pass

    def render(self):
        s = """




"""
        return s + body

    def add_column(self, name, jstype):
        self.columns.append({'name':name, 'jstype':jstype})

    def add_value(self, row, column, value):
        """docstring for add_value"""
        self.values.append({'row':row, 'column':column, 'value':value})

class chart_example(object):

    def index(self):
        d = DataTable()
        columns = [
        {'jstype':'date',   'name':'Date'},
        {'jstype':'number', 'name':'Sold Pencils'},
        {'jstype':'string', 'name':'title1'},
        {'jstype':'string', 'name':'text1'},
        {'jstype':'number', 'name':'Sold Pens'},
        {'jstype':'string', 'name':'title2'},
        {'jstype':'string', 'name':'text2'},
        ]

        values = [
        [{'column':0, 'value':"new Date(2008, 1 ,1)"},
        {'column':1, 'value':"30000"},
        {'column':4, 'value':"40645"},],

        [{'column':0, 'value':"new Date(2008, 1 ,2)"},
        {'column':1, 'value':"14045"},
        {'column':4, 'value':"20374"},],

        [{'column':0, 'value':"new Date(2008, 1 ,3)"},
        {'column':1, 'value':"55022"},
        {'column':4, 'value':"50766"},],

        [{'column':0, 'value':"new Date(2008, 1 ,4)"},
        {'column':1, 'value':"75284"},
        {'column':4, 'value':"14334"},
        {'column':5, 'value':"'Out of Stock'"},
        {'column':6, 'value':"'Ran out of stock on pens at 4pm'"},],

        [{'column':0, 'value':"new Date(2008, 1 ,5)"},
        {'column':1, 'value':"41476"},
        {'column':2, 'value':"'Bought Pens'"},
        {'column':3, 'value':"'Bought 200k pens'"},
        {'column':4, 'value':"66467"},],

        [{'column':0, 'value':"new Date(2008, 1 ,6)"},
        {'column':1, 'value':"33322"},
        {'column':4, 'value':"39463"},
        {'column':2, 'value':"'Bought Pens2'"},
        {'column':3, 'value':"'Bought 200k pens2'"},
        {'column':4, 'value':"66467"},],

        [{'column':0, 'value':"new Date(2008, 1 ,7)"},
        {'column':1, 'value':"33322"},
        {'column':4, 'value':"39463"}]
        ,]

        for c in columns:
            d.add_column(c['name'], c['jstype'])

        for vals, i in zip(values, range(len(values))):
            for v in vals:
                d.add_value(i, v['column'], v['value'])
        return d.render()
    index.exposed = True

class sub_wrapper(object):
    def renext(self, next):
        print next

    def doit(self, popenargs):
        result = subprocess.Popen(popenargs, stdout=subprocess.PIPE, stderr=subprocess.PIPE)
        return result

cherrypy.config.update({'server.socket_host': '127.0.0.1', 'server.socket_port': 8080, })
cherrypy.quickstart(chart_example())