X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Fmv%2Fplugins%2Fdavical.rb;h=58287b3b69937eaa32b2823d3ffd62f13de83566;hp=a7cfe80c5337ae3d87f99fd26f3c72bb350239aa;hb=df4e02ebf6a4e28a58abcb298a4442a245ad0b15;hpb=8a3e804a4c5f33bee1d80243be6b139e45f07a48 diff --git a/lib/mv/plugins/davical.rb b/lib/mv/plugins/davical.rb index a7cfe80..58287b3 100644 --- a/lib/mv/plugins/davical.rb +++ b/lib/mv/plugins/davical.rb @@ -3,46 +3,42 @@ require 'pg' require 'common/davical_plugin' require 'rm/rm_plugin' +# Handle moving (renaming) DAViCal users in its database. DAViCal has +# no concept of domains. +# class DavicalMv - # - # DAViCal only supports Postgres, so even if we ever are - # database-agnostic, this plugin can't be. - # include DavicalPlugin include MvPlugin - def mv_domain(from, to) - # DAViCal doesn't have a concept of domains. - end - + # Move the user *src* to *dst* within the DAViCal database. This + # should "rename" him in _every_ table where he is referenced. + # DAViCal uses foreign keys properly, so we let the ON UPDATE + # CASCADE trigger handle most of the work. + # + # 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 DAViCal 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) - def mv_user(from, to) - # Switch the given usernames. DAViCal uses foreign keys properly - # and only supports postgres, so we let the ON UPDATE CASCADE - # trigger handle most of the work. sql_queries = ['UPDATE usr SET username = $1 WHERE username = $2'] - begin - 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, [to, from]) - end - - connection.close() + connection = PGconn.connect(@db_host, @db_port, @db_opts, @db_tty, + @db_name, @db_user, @db_pass) - rescue PGError => e - # Pretend like we're database-agnostic in case we ever are. - raise DatabaseError.new(e) + sql_queries.each do |sql_query| + connection.query(sql_query, [dst.to_s(), src.to_s()]) end + connection.close() end end