X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Fmv%2Fplugins%2Fagendav.rb;h=9623c4076c5cdd7f4cb535ccccea445699d25a64;hp=ad1e9c2bfcf9f88b6fb67cf893a4c0ecb4d0348a;hb=b947ef8844f090eedd50be0383abe417d910bb1a;hpb=20b843bddcd73833d41f98ff79d92ef59bb4d81e diff --git a/lib/mv/plugins/agendav.rb b/lib/mv/plugins/agendav.rb index ad1e9c2..9623c40 100644 --- a/lib/mv/plugins/agendav.rb +++ b/lib/mv/plugins/agendav.rb @@ -3,32 +3,44 @@ 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) - # It's obviously an error if the source user does not exist. It - # would also be an error if the destination domain didn't exist; - # however, Agendav doesn't know about domains, so we let that slide. raise NonexistentUserError.new(src.to_s()) if not user_exists(src) - - # And it's an error if the destination user exists already. raise UserAlreadyExistsError.new(dst.to_s()) if user_exists(dst) sql_queries = ['UPDATE prefs SET username = $1 WHERE username = $2;'] sql_queries << 'UPDATE shared SET user_from = $1 WHERE user_from = $2;' sql_queries << 'UPDATE shared SET user_which = $1 WHERE user_which = $2;' - connection = PGconn.connect(@db_host, @db_port, @db_opts, @db_tty, - @db_name, @db_user, @db_pass) - - sql_queries.each do |sql_query| - connection.query(sql_query, [dst.to_s(), src.to_s()]) + connection = PG::Connection.new(@db_hash) + begin + sql_queries.each do |sql_query| + connection.query(sql_query, [dst.to_s(), src.to_s()]) + end + ensure + # Make sure the connection gets closed even if a query explodes. + connection.close() end - - connection.close() end end