gistfile1.rb

    verify_attributes = <<-SQL
      SELECT  count(*)
      FROM    projects p, project_configurations pc
      WHERE   p.id = pc.provider_id
      AND     pc.provider_type='Project'
      AND     (p.show_weather                     <>  pc.show_weather
          OR  p.uploaded_images_approved          <>  pc.uploaded_images_approved
          OR  p.emailed_images_uploaded           <>  pc.emailed_images_uploaded
          OR  p.emailed_images_approved           <>  pc.emailed_images_approved
          OR  p.emailed_images_from_any_address   <>  pc.emailed_images_from_any_address
          OR  p.communication_theads_private_default <> pc.communication_theads_private_default
          OR  p.display_task_names_with_full_outline_path <> pc.display_task_names_with_full_outline_path
          OR  p.task_filtering_by_subproject      <>  pc.task_filtering_by_subproject
          OR  p.require_reasons_in_ms_project     <>  pc.require_reasons_in_ms_project
          OR  p.daily_log_mods                    <>  pc.daily_log_mods
          OR  p.project_integration               <>  pc.project_integration
          OR  p.allow_private_rfis                <>  pc.allow_private_rfis
          OR  p.all_rfis_private_by_default       <>  pc.all_rfis_private_by_default
          OR  p.hide_national_weather_data        <>  pc.hide_national_weather_data
          OR  p.new_change_orders_private_by_default <> pc.new_change_orders_private_by_default
          OR  p.documents_private_by_default      <>  pc.documents_private_by_default
          OR  p.multiple_question_rfis            <>  pc.multiple_question_rfis
          OR  p.show_historical_meeting_comments  <>  pc.show_historical_meeting_comments
          OR  p.contracts_private_by_default      <>  pc.contracts_private_by_default
          OR  p.submittal_logs_private_by_default <>  pc.submittal_logs_private_by_default
          OR  p.use_company_cost_codes            <>  pc.use_company_cost_codes
          OR  p.include_questions_in_rfi_log      <>  pc.include_questions_in_rfi_log
          OR  p.submittal_log_notify_distribution_members <> pc.submittal_log_notify_distribution_members
          OR  p.show_schedule                     <>  pc.show_schedule
          OR  p.show_milestones                   <>  pc.show_milestones
          OR  p.default_manpower_log_hours        <>  pc.default_manpower_log_hours
          OR  p.show_line_items_on_change_orders  <>  pc.show_line_items_on_change_orders
          OR  p.number_of_previous_meeting_minutes_shown_on_pdf <>  pc.number_of_previous_meeting_minutes_shown_on_pdf
          OR  p.show_created_by_on_logs           <>  pc.show_created_by_on_logs
          OR  p.enable_related_to_in_daily_log    <>  pc.enable_related_to_in_daily_log
          OR  p.allow_markups_default             <>  pc.allow_markups_default
          OR  p.allow_payment_applications_default <> pc.allow_payment_applications_default
          OR  p.allow_payments_default            <>  pc.allow_payments_default
          OR  p.allow_comments_default            <>  pc.allow_comments_default);
    SQL
    
    puts execute(verify_attributes).result