X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Fcommon%2Fdavical_plugin.rb;h=a1dcba07b690b1f07eace23804597d9c61db977b;hp=e4bef48ac41239f49b7aa3656adbce782f25bd00;hb=72696d3f6e95ef773af9727e9c3459b9038b0fc2;hpb=e3826d8926e11763837a591986d453e9ef5d9dec diff --git a/lib/common/davical_plugin.rb b/lib/common/davical_plugin.rb index e4bef48..a1dcba0 100644 --- a/lib/common/davical_plugin.rb +++ b/lib/common/davical_plugin.rb @@ -5,8 +5,7 @@ module DavicalPlugin # 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 +18,12 @@ module DavicalPlugin def describe_domain(domain) # DAViCal doesn't have a concept of domains. - return 'N/A' + return domain 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' @@ -36,7 +35,7 @@ module DavicalPlugin protected; - def get_principal_id(account) + def get_principal_id(user) principal_id = nil begin @@ -53,7 +52,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]) do |result| if result.num_tuples > 0 principal_id = result[0]['principal_id'] end @@ -70,4 +69,32 @@ module DavicalPlugin end + def list_users() + 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 + end + end