Add some extra indexes for ACL lookups

[rails.git] / app / models / acl.rb

diff --git a/app/models/acl.rb b/app/models/acl.rb
index e2f163ea585bf8bd5453208c7da72dc24d360548..ea19c74b0f0082302ed9b740525377c58bd15b6c 100644 (file)
--- a/app/models/acl.rb
+++ b/app/models/acl.rb
@@ -1,21 +1,40 @@
+# == Schema Information
+#
+# Table name: acls
+#
+#  id      :integer          not null, primary key
+#  address :inet
+#  k       :string           not null
+#  v       :string
+#  domain  :string
+#
+# Indexes
+#
+#  acls_k_idx             (k)
+#  index_acls_on_address  (address) USING gist
+#  index_acls_on_domain   (domain)
+#
+

 class Acl < ActiveRecord::Base
 class Acl < ActiveRecord::Base

+  validates :k, :presence => true
+

   def self.match(address, domain = nil)
     if domain
   def self.match(address, domain = nil)
     if domain

-      condition = Acl.where("address >>= ? OR domain = ?", address, domain)
+      Acl.where("address >>= ? OR domain = ?", address, domain)

     else
     else

-      condition = Acl.where("address >>= ?", address)
+      Acl.where("address >>= ?", address)

     end
   end
 
   def self.no_account_creation(address, domain = nil)
     end
   end
 
   def self.no_account_creation(address, domain = nil)

-    self.match(address, domain).where(:k => "no_account_creation").exists?
+    match(address, domain).where(:k => "no_account_creation").exists?

   end
 
   def self.no_note_comment(address, domain = nil)
   end
 
   def self.no_note_comment(address, domain = nil)

-    self.match(address, domain).where(:k => "no_note_comment").exists?
+    match(address, domain).where(:k => "no_note_comment").exists?

   end
 
   def self.no_trace_download(address, domain = nil)
   end
 
   def self.no_trace_download(address, domain = nil)

-    self.match(address, domain).where(:k => "no_trace_download").exists?
+    match(address, domain).where(:k => "no_trace_download").exists?

   end
 end
   end
 end