X-Git-Url: http://gitweb.michael.orlitzky.com/?a=blobdiff_plain;f=lib%2Fcommon%2Fagendav_plugin.rb;h=187df6e92a695a85aba3091bded527a8ac751038;hb=853aaef812f6e23f17d3e24db99dfbaadafdbddf;hp=c5e7d7719178dd5035f46b39a2c8cf79c78399ae;hpb=579a22471329c71552bcb4077a0590d60cdec784;p=mailshears.git diff --git a/lib/common/agendav_plugin.rb b/lib/common/agendav_plugin.rb index c5e7d77..187df6e 100644 --- a/lib/common/agendav_plugin.rb +++ b/lib/common/agendav_plugin.rb @@ -18,7 +18,6 @@ module AgendavPlugin :host => cfg.agendav_dbhost, :port => cfg.agendav_dbport, :options => cfg.agendav_dbopts, - :tty => cfg.agendav_dbtty, :dbname => cfg.agendav_dbname, :user => cfg.agendav_dbuser, :password => cfg.agendav_dbpass } @@ -42,7 +41,7 @@ module AgendavPlugin sql_query = 'SELECT username FROM prefs;' begin - connection.query(sql_query) do |result| + connection.sync_exec(sql_query) do |result| users = result.field_values('username') end ensure @@ -53,4 +52,27 @@ module AgendavPlugin return users.map{ |u| User.new(u) } end + + # Count the number of rows in the "shares" table. Used only for + # testing. + # + # @return [Fixnum] the number of rows in the "shares" table. + # + def count_shares() + count = nil + connection = PG::Connection.new(@db_hash) + + sql_query = 'SELECT count(*) FROM shares;' + begin + connection.sync_exec(sql_query) do |result| + count = result.getvalue(0,0).to_i() + end + ensure + # Make sure the connection gets closed even if the query explodes. + connection.close() + end + + return count + end + end