Changeset 5

Timestamp:

06/21/06 01:25:32 (3 years ago)

Author:

tim

Message:

Search is starting to work.
Fixed a typo in the database FK constraints.
Going to bed now, really.

Location:

trunk

Files:

• app/controllers/themes_controller.rb (modified) (1 diff)
• app/views/themes/search.rhtml (modified) (2 diffs)
• db/migrate/001_initial_schema.rb (modified) (1 diff)
• db/schema.rb (modified) (1 diff)

trunk/app/controllers/themes_controller.rb

@@ -13 +13 @@
     @versions = [["", ""]]
     @versions += Version.find(:all, :order => "name DESC").collect { |v| [v.name, v.id] }
+
+    unless @params["search"].nil?
+      name = @params["search"]["name"]
+      @themes = Theme.find(:all, :conditions=>["name like ?", "%#{name}%"], :order=>"name ASC")
+    end
   end
 

trunk/app/views/themes/search.rhtml

@@ -1 +1 @@
 <table>
+  <thead>
+<%= form_tag({:action=>"search"}) %>
   <tr>
     <th>Name</th>
@@ -12 +14 @@
                    "version", 
                    @versions) %></td>
-    <td><%= submit_to_remote("submit", "Search") %></td>
+    <td><%= submit_tag("Search") %></td>
   </tr>
+</form>
+  </thead>
+  <tbody>
+    <% unless @themes.nil?
+       @themes.each { |theme| %>
+    <tr>
+      <td><%= link_to theme.name, {:action=>"view", :id=>theme.id } %></td>
+      <td></td>
+      <td></td>
+    </tr>
+    <% } 
+       end %>
+  </tbody>
 </table>

trunk/db/migrate/001_initial_schema.rb

@@ -18 +18 @@
 
       execute "ALTER TABLE themes_versions ADD CONSTRAINT theme_id_fkey FOREIGN KEY (theme_id) REFERENCES themes(id);"
-      execute "ALTER TABLE themes_versions ADD CONSTRAINT version_id_fkey FOREIGN KEY (version_id) REFERENCES themes(id);"
+      execute "ALTER TABLE themes_versions ADD CONSTRAINT version_id_fkey FOREIGN KEY (version_id) REFERENCES versions(id);"
     end
   end

trunk/db/schema.rb

@@ -7 +7 @@
   create_table "themes", :force => true do |t|
     t.column "name", :string
+    t.column "display_name", :string
   end