Contents

namespace :erp_tech_svcs do

  namespace :file_support do

    desc "Sync storage between database and storage location ie (s3 or file system), taskes storage option"
    task :sync_storage, [:storage] => :environment do |t, args|
      file_support = ErpTechSvcs::FileSupport::Base.new(:storage => args.storage.to_sym)

      #sync shared
      puts "Syncing Shared Assets..."
      file_support.sync(File.join(file_support.root, '/images'), CompassAeInstance.find_by_internal_identifier('base'))
      file_support.sync(File.join(file_support.root, '/files'), CompassAeInstance.find_by_internal_identifier('base'))
      puts "Complete"

      #sync websites
      puts "Syncing Websites..."
      Website.all.each do |website|
        file_support.sync(File.join(file_support.root, "/sites/site-#{website.id}/images"), website)
        file_support.sync(File.join(file_support.root, "/sites/site-#{website.id}/files"), website)
      end
      puts "Complete"

      #sync themes
      puts "Syncing Themes..."
      Theme.all.each do |theme|
        file_support.sync(File.join(file_support.root, theme.url), theme)
      end
      puts "Complete"
    end

  end

  namespace :database_support do

    desc "List missing indexes"
    task :list_missing_indexes => :environment do

      connection = ActiveRecord::Base.connection
      connection.tables.collect do |table|
        columns = connection.columns(table).collect(&:name).select { |x| x.ends_with?("_id" || x.ends_with("_type")) || x == 'internal_identifier' }
        indexed_columns = connection.indexes(table).collect(&:columns).flatten.uniq
        unindexed = columns - indexed_columns
        unless unindexed.empty?
          unindexed.each do |column|
            name = "#{table}_#{column}_idx"

            puts "Missing index on #{table} : #{column}"
            puts "Suggested Index"
            puts "add_index :#{table}, :#{column}, :name => '#{name}'"
            puts ""

          end
        end
      end

    end

  end

end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
erp_tech_svcs-4.0.0	lib/tasks/erp_tech_svcs_tasks.rake