X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Fcommon%2Fdavical_plugin.rb;h=8684cca9e830a5005e98ef82c7ac916f511decf6;hp=a1dcba07b690b1f07eace23804597d9c61db977b;hb=df4e02ebf6a4e28a58abcb298a4442a245ad0b15;hpb=72696d3f6e95ef773af9727e9c3459b9038b0fc2 diff --git a/lib/common/davical_plugin.rb b/lib/common/davical_plugin.rb index a1dcba0..8684cca 100644 --- a/lib/common/davical_plugin.rb +++ b/lib/common/davical_plugin.rb @@ -1,10 +1,18 @@ require 'common/plugin' +require 'common/user' +# Code that all DAViCal plugins ({DavicalPrune}, {DavicalRm}, and +# {DavicalMv}) will share. +# module DavicalPlugin - # Code that all Davical plugins (Prune, Rm, Mv...) will share. That - # is, we implement the Plugin interface. + + # We implement the Plugin "interface." include Plugin + # Initialize this DAViCal {Plugin} with values in *cfg*. + # + # @param cfg [Configuration] the configuration for this plugin. + # def initialize(cfg) @db_host = cfg.davical_dbhost @db_port = cfg.davical_dbport @@ -16,85 +24,76 @@ module DavicalPlugin end - def describe_domain(domain) - # DAViCal doesn't have a concept of domains. - return domain - end - - + # Describe the given DAViCal user who is assumed to exist. + # + # @param user [User] the {User} object whose description we want. + # + # @return [String] a String describing the given *user* in terms + # of his DAViCal "Principal ID". + # def describe_user(user) principal_id = self.get_principal_id(user) - - if principal_id.nil? - return 'User not found' - else - return "Principal ID: #{principal_id}" - end + return "Principal ID: #{principal_id}" end - protected; - - def get_principal_id(user) - principal_id = nil + # + # Produce a list of DAViCal users. + # + # This method remains public for use in testing. + # + # @return [Array] an array of {User} objects, one for each + # user found in the DAViCal database. + # + def list_users() + usernames = [] - begin - connection = PGconn.connect(@db_host, - @db_port, - @db_opts, - @db_tty, - @db_name, - @db_user, - @db_pass) - - sql_query = "SELECT principal.principal_id " - sql_query += "FROM (principal INNER JOIN usr " - sql_query += " ON principal.user_no = usr.user_no) " - sql_query += "WHERE usr.username = $1;" - - connection.query(sql_query, [user]) do |result| - if result.num_tuples > 0 - principal_id = result[0]['principal_id'] - end - end + connection = PGconn.connect(@db_host, @db_port, @db_opts, @db_tty, + @db_name, @db_user, @db_pass) - connection.close() + # User #1 is the super-user, and not tied to an email address. + sql_query = 'SELECT username FROM usr WHERE user_no > 1' - rescue PGError => e - # Pretend like we're database-agnostic in case we ever are. - raise DatabaseError.new(e) + connection.query(sql_query) do |result| + usernames = result.field_values('username') end - return principal_id + connection.close() + + return usernames.map{ |u| User.new(u) } end - def list_users() - usernames = [] + protected; + - begin - connection = PGconn.connect(@db_host, - @db_port, - @db_opts, - @db_tty, - @db_name, - @db_user, - @db_pass) + # Find the "Principal ID" of the given user. + # + # @param user [User] the user whose Principal ID we want. + # + # @return [Fixnum] an integer representing the user's Principal ID + # that we obtained from the DAViCal database. + # + def get_principal_id(user) + principal_id = nil - # User #1 is the super-user, and not tied to an email address. - sql_query = "SELECT username FROM usr WHERE user_no > 1" + connection = PGconn.connect(@db_host, @db_port, @db_opts, @db_tty, + @db_name, @db_user, @db_pass) - connection.query(sql_query) do |result| - usernames = result.field_values('username') - end + sql_query = 'SELECT principal.principal_id ' + sql_query += 'FROM (principal INNER JOIN usr ' + sql_query += ' ON principal.user_no = usr.user_no) ' + sql_query += 'WHERE usr.username = $1;' - connection.close() - rescue PGError => e - # Pretend like we're database-agnostic in case we ever are. - raise DatabaseError.new(e) + connection.query(sql_query, [user.to_s()]) do |result| + if result.num_tuples > 0 + principal_id = result[0]['principal_id'] + end end - return usernames + connection.close() + + return principal_id end end