X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Frm%2Fplugins%2Fagendav.rb;h=921bfe0687e2610401f2997dfe25cc09b3cfa6b1;hp=4bf6bc4aca11a2427c10e40151310bbeca452ea6;hb=9736c1e9209b5d0868aa70aed86d31aa78bf159b;hpb=f77d8736406afb1fcf017dbc6b2ce780f5cde5be diff --git a/lib/rm/plugins/agendav.rb b/lib/rm/plugins/agendav.rb index 4bf6bc4..921bfe0 100644 --- a/lib/rm/plugins/agendav.rb +++ b/lib/rm/plugins/agendav.rb @@ -16,11 +16,17 @@ class AgendavRm # Remove *user* from the Agendav database. This should remove him # from _every_ table in which he is referenced. # + # We do not raise an error if the user doesn't exist. This is due to + # an unfortunate problem with the "user exists" check in AgenDAV. + # The AgenDAV "shares" table is not tied directly to a username, so + # we are forced to use a regexp match to decide what rows to delete + # from that table. We do so regardless of whether or not the username + # exists in the "prefs" table, because that table stores only non- + # default preferences -- not all users' preferences. + # # @param user [User] the user to remove. # def remove_user(user) - raise NonexistentUserError.new(user.to_s()) if not user_exists(user) - sql_queries = ['DELETE FROM prefs WHERE username = $1;'] # The "shares" table contains principal URLs, and the "@" symbol @@ -35,8 +41,8 @@ class AgendavRm # of the user's email address in the "calendar" field happens when # he is also the owner, so the calendar does get deleted in the # normal situation. - sql_queries << "DELETE FROM shares WHERE REPLACE(owner, '%40', '@') ~ $1;" - sql_queries << "DELETE FROM shares WHERE REPLACE(with, '%40', '@') ~ $1;" + sql_queries << "DELETE FROM shares WHERE REPLACE(owner,'%40','@') ~ $1;" + sql_queries << "DELETE FROM shares WHERE REPLACE(\"with\",'%40','@') ~ $1;" connection = PG::Connection.new(@db_hash) begin