X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Fmv%2Fplugins%2Fagendav.rb;h=a2fb05438dd0cb5808b45d9d64f80d323fa0b037;hp=4bf65834da5de2d071c664fee9d00bc826b6da15;hb=HEAD;hpb=f77d8736406afb1fcf017dbc6b2ce780f5cde5be diff --git a/lib/mv/plugins/agendav.rb b/lib/mv/plugins/agendav.rb deleted file mode 100644 index 4bf6583..0000000 --- a/lib/mv/plugins/agendav.rb +++ /dev/null @@ -1,61 +0,0 @@ -require 'pg' - -require 'common/agendav_plugin' -require 'mv/mv_plugin' - - -# Handle moving (renaming) Agendav users in its database. Agendav has -# no concept of domains. -# -class AgendavMv - - include AgendavPlugin - include MvPlugin - - # Move the user *src* to *dst* within the Agendav database. This - # should "rename" him in _every_ table where he is referenced. - # - # This can fail is *src* does not exist, or if *dst* already exists - # before the move. It should also be an error if the destination - # domain doesn't exist. But Agendav doesn't know about domains, so - # we let that slide. - # - # @param src [User] the source user to be moved. - # - # @param dst [User] the destination user being moved to. - # - def mv_user(src, dst) - raise NonexistentUserError.new(src.to_s()) if not user_exists(src) - raise UserAlreadyExistsError.new(dst.to_s()) if user_exists(dst) - - connection = PG::Connection.new(@db_hash) - begin - # The "prefs" table uses the normal username as a key... - sql_query = 'UPDATE prefs SET username = $1 WHERE username = $2;' - connection.query(sql_query, [dst.to_s(), src.to_s()]) - - # But the "shares" table uses encoded principal URLs. For the - # "shares" table, we need to do a find/replace on the username - # with its "@" symbol translated to a "%40". - encoded_src = src.to_s()['@'] = '%40' - encoded_dst = dst.to_s()['@'] = '%40' - - # Unlike in the "rm" plugin, we do modify the "calendar" field - # here. That's because in the usual legitimate use case, the - # calendar URL will change when a user moves. This will ALSO - # affect people who name their calendars something like - # "user%40example.com", but screw those people. - sql_queries << 'UPDATE shares SET owner=REPLACE(owner, $2, $1);' - sql_queries << 'UPDATE shares SET calendar=REPLACE(calendar, $2, $1);' - sql_queries << 'UPDATE shares SET with=REPLACE(with, $2, $1);' - - sql_queries.each do |sql_query| - connection.query(sql_query, [encoded_dst, encoded_src]) - end - ensure - # Make sure the connection gets closed even if a query explodes. - connection.close() - end - end - -end