Matplotlib in pyramid-pylons app with sqlalchemy

Question

Am in a stage in my application where am trying to comeup with a statistics interface(graphs,charts) based on the data in the sqlalchemy database am using. However I came across matplotlib and i am trying to get along along with it but still failing to implement it. Am using Mako templates. Am requesting on how to go about this.Thanks heres sam view's code.

@view_config(route_name="d", renderer="./templates/d.mako")
def d(request):
    try:
       rows = DBSession.query(Song.duration, Song.price).all()
       duration,price = zip(*rows)
       plt.plot(duration,price)
       ##show()
    except DBAPIError:
    return Response(conn_err_msg, content_type='text/plain', status_int=500)
return { 'project': 'beatstore'}

If you post some code and an explanation of what you want it to do, and what is going wrong we can start to help you. — Chef1075, Feb 12 '15 at 09:09
I have edited it, my issue is returning plotted results on mako template — Maurice Elagu, Feb 12 '15 at 10:22

score 0 · Answer 1 · edited May 23 '17 at 10:24

0

See here for how to save a map after generating it, then just put it inside static and render as an image with your template.

edited May 23 '17 at 10:24

Community

1
1

answered Feb 18 '15 at 14:29

crooksey

8,521
6
30
52

Matplotlib in pyramid-pylons app with sqlalchemy

1 Answers1