I am very new to programming and would like to configure the following:
I want to configure a page that displayes some graphs. These graphs pull its data from a sql table. What I would like to do is configure a view .erb to have a search field that will take text and inject it to part of a pre-configured sql query I have setup in a model. I will try to explain as best I can with code.
Specifically I would like to set a view form that will take the text and pass that text value to the class vars i have defined (@@hostname, @@start_time and @@end_time). Once the VARs have user inputted values the code will run and result to display. I think I am going to be dealing with form_tags adn I have attemped this way but with no luck. I hope I explained this correctly as again I am a programming newbie. Thanks in advanced for any input.
Model:
class Health < ActiveRecord::Base def self.sql_select_graph(hostname, start_time, end_time) connection.execute("set @c = 0") find_by_sql("select *, @c FROM healths WHERE router_hostname = '#{hostname}' AND created_at >= '#{start_time}' AND created_at <= '#{ end_time}' HAVING (@c:=@c+1)%12=0 ORDER BY id")
end end
Controller:
class BandwidthController < ApplicationController @@hostname = 'cps-6-elem-2790-rtr-01' @@start_time = '2008-04-04 17:000:00' @@end_time = '2008-04-04 18:00:00' ... ... def rtr_bandwidth
g = Graph.new @f = Health.sql_select_graph(@@hostname, @@start_time, @@end_time)
... ... end
