# The "prefs" table uses the normal username as a key...
# This should be harmless if the source user does not exist.
sql_query0 = 'UPDATE prefs SET username = $1 WHERE username = $2;'
- connection.query(sql_query0, [dst.to_s(), src.to_s()])
+ connection.sync_exec_params(sql_query0, [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
sql_queries << 'UPDATE shares SET "with"=REPLACE("with", $2, $1);'
sql_queries.each do |sql_query|
- connection.query(sql_query, [encoded_dst, encoded_src])
+ connection.sync_exec_params(sql_query, [encoded_dst, encoded_src])
end
ensure
# Make sure the connection gets closed even if a query explodes.