+# == Schema Information
+#
+# Table name: acls
+#
+# id :bigint(8) not null, primary key
+# address :inet
+# k :string not null
+# v :string
+# domain :string
+# mx :string
+#
+# Indexes
+#
+# acls_k_idx (k)
+# index_acls_on_address (address) USING gist
+# index_acls_on_domain (domain)
+# index_acls_on_mx (mx)
+#
+
class Acl < ActiveRecord::Base
- def self.find_by_address(address, options)
- self.with_scope(:find => {:conditions => ["#{inet_aton} & netmask = address", address]}) do
- return self.find(:first, options)
- end
+ validates :k, :presence => true
+
+ def self.match(address, options = {})
+ acls = Acl.where("address >>= ?", address)
+
+ acls = acls.or(Acl.where(:domain => options[:domain])) if options[:domain]
+ acls = acls.or(Acl.where(:mx => options[:mx])) if options[:mx]
+
+ acls
end
- def self.find_all_by_address(address, options)
- self.with_scope(:find => {:conditions => ["#{inet_aton} & netmask = address", address]}) do
- return self.find(:all, options)
- end
+ def self.no_account_creation(address, options = {})
+ match(address, options).where(:k => "no_account_creation").exists?
end
-private
+ def self.no_note_comment(address, domain = nil)
+ match(address, :domain => domain).where(:k => "no_note_comment").exists?
+ end
- def self.inet_aton
- if self.connection.adapter_name == "MySQL"
- "inet_aton(?)"
- else
- "?"
- end
+ def self.no_trace_download(address, domain = nil)
+ match(address, :domain => domain).where(:k => "no_trace_download").exists?
end
end