X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Fcommon%2Fdavical_plugin.rb;h=557c1dd1b3bf18e012cdf234e6400b05d4de7925;hp=e4bef48ac41239f49b7aa3656adbce782f25bd00;hb=f819b178c5c1cb8adda0182c610e5c52fad8bea7;hpb=e3826d8926e11763837a591986d453e9ef5d9dec;ds=sidebyside diff --git a/lib/common/davical_plugin.rb b/lib/common/davical_plugin.rb index e4bef48..557c1dd 100644 --- a/lib/common/davical_plugin.rb +++ b/lib/common/davical_plugin.rb @@ -1,12 +1,12 @@ require 'common/plugin' +require 'common/user' module DavicalPlugin # Code that all Davical plugins (Prune, Rm, Mv...) will share. That # is, we implement the Plugin interface. include Plugin - def initialize() - cfg = Configuration.new() + def initialize(cfg) @db_host = cfg.davical_dbhost @db_port = cfg.davical_dbport @db_opts = cfg.davical_dbopts @@ -19,12 +19,12 @@ module DavicalPlugin def describe_domain(domain) # DAViCal doesn't have a concept of domains. - return 'N/A' + return domain.to_s() end - def describe_account(account) - principal_id = self.get_principal_id(account) + def describe_user(user) + principal_id = self.get_principal_id(user) if principal_id.nil? return 'User not found' @@ -34,9 +34,42 @@ module DavicalPlugin end + def list_users() + # + # Produce a list of DAViCal users. This is public because it's + # useful for testing. + # + usernames = [] + + begin + connection = PGconn.connect(@db_host, + @db_port, + @db_opts, + @db_tty, + @db_name, + @db_user, + @db_pass) + + # User #1 is the super-user, and not tied to an email address. + sql_query = "SELECT username FROM usr WHERE user_no > 1" + + connection.query(sql_query) do |result| + usernames = result.field_values('username') + end + + connection.close() + rescue PGError => e + # Pretend like we're database-agnostic in case we ever are. + raise DatabaseError.new(e) + end + + return usernames.map{ |u| User.new(u) } + end + + protected; - def get_principal_id(account) + def get_principal_id(user) principal_id = nil begin @@ -53,7 +86,7 @@ module DavicalPlugin sql_query += " ON principal.user_no = usr.user_no) " sql_query += "WHERE usr.username = $1;" - connection.query(sql_query, [account]) do |result| + connection.query(sql_query, [user.to_s()]) do |result| if result.num_tuples > 0 principal_id = result[0]['principal_id'] end @@ -69,5 +102,4 @@ module DavicalPlugin return principal_id end - end