You can achieve this way.
Controller.py
import pygal
def chart():
response.files.append(URL('default','static/js/pygal-tooltips.min.js'))
response.headers['Content-Type']='image/svg+xml'
import pygal
from pygal.style import Style
custom_style = Style(
background='transparent',
plot_background='transparent',
foreground='#53E89B',
foreground_strong='#53A0E8',
foreground_subtle='#630C0D',
opacity='.6',
opacity_hover='.9',
transition='400ms ease-in',
colors=('#E853A0', '#E8537A', '#E95355', '#E87653', '#E89B53')
)
chart = pygal.StackedLine(fill=True, interpolate='cubic',
style=custom_style, )
* data = db(db. my_tracker).select() chart.add('A', [i.weight for i
in data])*
return chart.render()
def index():
chart= URL('default', 'chart')
form = SQLFORM(db.my_tracker, submit_button=T('Submit')).process()
form.element('input[name=weight]')['_style']='width:60px;height:30px;'
return dict(chart = chart,form=form)
#View/index.html
{{extend 'layout.html'}}
<figure>
<embed type="image/svg+xml" src="{{=chart}}" />
</figure>
<h1>{{=form}}</h1>
You can change style according to your convenience
Thanks
SP
On Fri, Dec 21, 2018 at 7:23 AM Maurice Waka <[email protected]> wrote:
> I've come across this
> <http://www.web2pyslices.com/slice/show/1634/beauty-graphics-and-charts-with-pygal-updated>
> site
> where one can create charts and graphs.
> However I have a challenge of using the database as I don't know how to
> link to it. For example, i want to track a variable like weight. The user
> inputs the values on a regular basis with the trend showing on the graph.
> How do I connect to the database and track it daily?
> So far, my code is this:
> model
> db.define_table('my_tracker',
> Field('weight','double',),
> Field('created_by','reference auth_user',default = auth.
> user_id, readable = False, writable = False))
>
> Controller:
> row = db(db.tracker.created_by == auth.user_id).select().first()
> if not row:
> form = SQLFORM(db.my_tracker, submit_button=T('Submit'))
> form.element('input[name=weight]')['_style']=
> 'width:60px;height:30px;'
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
