what the recommended way to generate static html files based on a database structure, for example 1000 product pages. i would like to specify s template and embed css styles. i use rails 3.1 thanx -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Sep 19, 2:10 pm, "Jochen Kächelin - 8frogs.de" <i...-eFRsi8EyIYSzQB+pC5nmwQ@public.gmane.org> wrote:> what the recommended way to generate static html files based on a database structure, for example 1000 product pages. > > i would like to specify s template and embed css styles. > > i use rails 3.1 > > thanxI''d look into using factory girl. http://rubygems.org/gems/factory_girl Dan Nachbar -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
"\"Jochen Kächelin - 8frogs.de\"" <info-eFRsi8EyIYSzQB+pC5nmwQ@public.gmane.org> wrote in post #1022809:> what the recommended way to generate static html files based on a > database structure, for example 1000 product pages. > > i would like to specify s template and embed css styles. > > i use rails 3.1 > > thanxerb templates are part of the ruby language, as is the ability to query a database. So you can write a ruby program that creates an erb template, and you can query the database to fill in values in the template, and then write the results to a bunch of files. -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Here is an example: require ''erb'' require ''sqlite3'' template = ERB.new <<"END_OF_TEMPLATE" <html> <head> <title><%= name %></title> <style type="text/css"> div {color:blue;} </style> </head> <body> <div>Name: <%= name %></div> <div>Color: <%= color %></div> </body> </html> END_OF_TEMPLATE db = SQLite3::Database.new( "my_db.db" ) table = "test" db.execute( "select * from #{table}" ) do |row| name, color = row File.open("#{name}.html", "w") do |f| f.puts template.result(binding) #binding gathers up the variables and their values end end --output:-- hammer.html: <html> <head> <title>hammer</title> <style type="text/css"> div {color:blue;} </style> </head> <body> <div>Name: hammer</div> <div>Color: black</div> </body> </html> -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.