Hello Sandeep, The form appears well, but the chart area doesn't show any chart, looks a small box at the top left side of the page. Trying to show it shows a message: 'insufficient privileges'. Regards
On Fri, Dec 21, 2018 at 9:58 AM sandeep patel <[email protected]> wrote: > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/dGkepqrPY0g/unsubscribe. > To unsubscribe from this group and all its topics, 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.
