Re: [web2py] Graphs

[FERNANDO VILLARROEL]

Dear.

I am trying to make a graph temperature vs time with NVD3.js

But it's my first experience with D3 and JsON and i think i am wrong because i 
can't show graphic.

I am getting data from a database:

My controller:

def grafico_temp():
       
rows=db(db.temperaturas).select(db.temperaturas.fecha,db.temperaturas.temp).as_list()
        return dict(rows=rows)

My view:

{{extend 'layout.html'}}

<link href="https://raw.github.com/novus/nvd3/master/src/nv.d3.css"; 
rel="stylesheet"/>
<script type="text/javascript" 
src="https://raw.github.com/novus/nvd3/master/lib/d3.v2.min.js";></script>
<script type="text/javascript" 
src="https://raw.github.com/novus/nvd3/master/nv.d3.min.js";></script>

<style>
#chart svg {
  height: 400px;
}
</style>

<div id="chart">
  <svg></svg>
</div>



<script type="text/javascript">

        nv.addGraph(function() {
          var chart = nv.models.lineChart();

          chart.xAxis
              .axisLabel('Fecha')
              .tickFormat(d3.format(',r'));

          chart.yAxis
              .axisLabel('Temperatura')
              .tickFormat(d3.format('.02f'));

          d3.select('#chart svg')
              .datum(data())
            .transition().duration(500)
              .call(chart);

          nv.utils.windowResize(function() { d3.select('#chart 
svg').call(chart) });

         return chart;
        });    



        function data() {

          var camara1 =  {{=response.json(rows)}} //[];
          //var t = {{=len(rows)}};
          //{{for r in rows:}}
          //  var f = {{r.fecha}}, t = {{r.temp}};      
          //for (var i = 0; i <= t; i++) {
          //  camara1.push({x: f, y: t});
            //cos.push({x: i, y: .5 * Math.cos(i/10)});
          //{{pass}}
          }

          return [
            {
              values: camara1,
              key: 'Camara 1'
              color: '#ff7f0e'
            },
          ];
        }
    </script>


I appreciated you help.

--- On Thu, 8/16/12, Andrew <awillima...@gmail.com> wrote:

> From: Andrew <awillima...@gmail.com>
> Subject: Re: [web2py] Graphs
> To: web2py@googlegroups.com
> Date: Thursday, August 16, 2012, 7:41 AM
> I plan to do one, but you simply
> provide a json or csv service / URL with web2py, and then
> use it in a view with the d3 JavaScript code.  D3 takes
> some learning, and I still have a long way to go.
> 
> -- 
> 
> 
> 
> 

-- 

--- 
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.