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
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
