Contents

module Para
  class PostgresExtensionsChecker
    class << self
      def check_all
        %w(hstore unaccent).each do |extname|
          unless extension_exists?(extname)
            # Could not use Rails.logger here, using puts as a temporary
            # solution.
            puts "[Warning] PostgreSQL \"#{ extname }\" extension is not " +
                 "installed in your database. This means that you " +
                 "missing some migrations that you can install " +
                 "with the following command : " +
                 "`rake para_engine:install:migrations` and then migrate."
          end
        end
      end

      private

      def extension_exists?(extname)
        ActiveRecord::Base.connection.execute(
          "SELECT COUNT(*) FROM pg_catalog.pg_extension " +
          "WHERE extname = '#{ extname }'"
        ).first['count'].to_i > 0
      rescue ActiveRecord::NoDatabaseError
        true # Do not issue warning when no database is installed
      end
    end
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
para-0.7.1	lib/para/postgres_extensions_checker.rb
para-0.7.0	lib/para/postgres_extensions_checker.rb
para-0.6.9	lib/para/postgres_extensions_checker.rb
para-0.6.8	lib/para/postgres_extensions_checker.rb
para-0.6.7	lib/para/postgres_extensions_checker.rb
para-0.6.3	lib/para/postgres_extensions_checker.rb
para-0.6.2	lib/para/postgres_extensions_checker.rb