Google charts plugin added

[Tim Richardson]

I added a google charts plugin 

http://www.web2pyslices.com/slice/show/1721/google-charts-plugin

[Dave S]

On Thursday, October 3, 2013 4:03:09 PM UTC-7, Tim Richardson wrote:

I added a google charts plugin 

http://www.web2pyslices.com/slice/show/1721/google-charts-plugin

Thanks!

/dps

 

[Sarbjit]

Thanks Tim,

I have a question:

In your example, data is present in controller itself, how can I store the data effectively in database and then use that data for plotting graphs?

Can you please provide an example of how this can be stored/retrieved from db? I searched the net and found people suggesting pickle/json for storing/retrieving from db, but I'm not having any experience with both. Can you please help.

def plugin_return_data():
    data = [['Year','Sales','Expenses'],["2004",1000,400],["2005",1100,440],["2006",1200,600],
            ["2007",1500,800],["2008",1600,850],["2009",1800,900]]
    return dict(data=data)

-Sarbjit

[Tim Richardson]

All you need to do is return data as an list. That's all the controller does.

So you need to learn how to retrieve data using the DAL, and put it into an list.

For example, you can get rows from a query, and iterate over the returned rows, building up the list. 

The DAL also offers syntax for retrieving data directly as a list.