Rails is a great environment, but its conventions can sometimes cause you headaches. I’ve had one such headache for the last week or so now. I am trying load html content out of the database, based on the URI. In most environments this is easy. In rails it is easy too (ridiculously easy).
It is as simple as this:
a table:
routes.rb:
-
ActionController::Routing::Routes.draw do |map|
-
# Add your own custom routes here.
-
# The priority is based upon order of creation: first created -> highest priority.
-
-
map.connect ‘:controller/:action/:id’
-
-
# default catch-all for URLs
-
map.connect ‘:url’, :controller => ‘page’, :action => ‘view’, :requirements => { :url => /.*/ }
-
-
end
A model:
And a controller:
-
class PageController < ApplicationController
-
-
def view
-
render :text => view_page(params[‘uri’]), :layout => true
-
end
-
-
private
-
def view_page(page_name = “”)
-
@pages = Page.find_by_sql [“select * from pages where name=?”, page_name]
-
if @pages.first
-
@pages.first.html
-
else
-
“Could not find page ‘#{page_name}’”
-
end
-
end
-
end
Post a Comment