X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Fcommon%2Fagendav_plugin.rb;h=d8ef6d60c8445fab529bf4560cae4c578904ff3c;hp=c5e7d7719178dd5035f46b39a2c8cf79c78399ae;hb=93f4125437702363b25b6825d6f20e98b1e319a9;hpb=d0f4b13d82c158238329dbdfc5b26be410e2e727 diff --git a/lib/common/agendav_plugin.rb b/lib/common/agendav_plugin.rb index c5e7d77..d8ef6d6 100644 --- a/lib/common/agendav_plugin.rb +++ b/lib/common/agendav_plugin.rb @@ -53,4 +53,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.query(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