document.write('') document.write('
\n \n \n \n \n\n
\n
\n \n \n \n 
set<\/span> :sync_directories<\/span>,<\/span> [<\/span>"assets"<\/span>,<\/span> "galleries"<\/span>]<\/span><\/div>
set<\/span> :sync_backups<\/span>,<\/span> 3<\/span><\/div><\/pre><\/div>\n          \n        <\/div>\n\n        
\n          view raw<\/a>\n          deploy.rb<\/a>\n          This Gist<\/a> brought to you by GitHub<\/a>.\n        <\/div>\n      <\/div>\n    \n            \n\n      
\n        
\n          \n          \n          \n            
require<\/span> 'yaml'<\/span><\/div>
 <\/div>
#<\/span><\/div>
# Capistrano sync.rb task for syncing databases and directories between the<\/span><\/div>
# local development environment and different multi_stage environments. You<\/span><\/div>
# cannot sync directly between two multi_stage environments, always use your<\/span><\/div>
# local machine as loop way.<\/span><\/div>
#<\/span><\/div>
# Author: Michael Kessler aka netzpirat<\/span><\/div>
# Gist:   111597<\/span><\/div>
# <\/span><\/div>
# Released under the MIT license. <\/span><\/div>
# Kindly sponsored by Screen Concept, www.screenconcept.ch<\/span><\/div>
#<\/span><\/div>
namespace<\/span> :sync<\/span> do<\/span><\/div>
 <\/div>
  after<\/span> "deploy:setup"<\/span>,<\/span> "sync:setup"<\/span><\/div>
  <\/div>
  desc<\/span> <<-<\/span>DESC<\/span><\/div>
    Creates the sync dir in shared path. The sync directory is used to keep<\/span><\/div>
    backups of database dumps and archives from synced directories. This task will<\/span><\/div>
    be called on 'deploy:setup'<\/span><\/div>
  DESC<\/span><\/div>
  task<\/span> :setup<\/span> do<\/span><\/div>
    run<\/span> "cd <\/span>#{<\/span>shared_path<\/span>}<\/span>; mkdir sync"<\/span><\/div>
  end<\/span><\/div>
 <\/div>
  namespace<\/span> :down<\/span> do<\/span><\/div>
 <\/div>
    desc<\/span> <<-<\/span>DESC<\/span><\/div>
      Syncs the database and declared directories from the selected multi_stage environment <\/span><\/div>
      to the local development environment. This task simply calls both the 'sync:down:db' and <\/span><\/div>
      'sync:down:fs' tasks.<\/span><\/div>
    DESC<\/span><\/div>
    task<\/span> :default<\/span> do<\/span><\/div>
      db<\/span> and<\/span> fs<\/span><\/div>
    end<\/span><\/div>
 <\/div>
    desc<\/span> <<-<\/span>DESC<\/span><\/div>
      Syncs database from the selected mutli_stage environement to the local develoment environment.<\/span><\/div>
      The database credentials will be read from your local config/database.yml file and a copy of the<\/span><\/div>
      dump will be kept within the shared sync directory. The amount of backups that will be kept is<\/span><\/div>
      declared in the sync_backups variable and defaults to 5.<\/span><\/div>
    DESC<\/span><\/div>
    task<\/span> :db<\/span>,<\/span> :roles<\/span> =><\/span> :db<\/span>,<\/span> :only<\/span> =><\/span> {<\/span> :primary<\/span> =><\/span> true<\/span> }<\/span> do<\/span><\/div>
 <\/div>
      filename<\/span> =<\/span> "database.<\/span>#{<\/span>stage<\/span>}<\/span>.<\/span>#{<\/span>Time<\/span>.<\/span>now<\/span>.<\/span>strftime<\/span> '%Y-%m-%d_%H:%M:%S'<\/span>}<\/span>.sql"<\/span><\/div>
      on_rollback<\/span> {<\/span> delete<\/span> "<\/span>#{<\/span>shared_path<\/span>}<\/span>/sync/<\/span>#{<\/span>filename<\/span>}<\/span>"<\/span> }<\/span><\/div>
 <\/div>
      # Remote DB dump<\/span><\/div>
      username<\/span>,<\/span> password<\/span>,<\/span> database<\/span> =<\/span> database_config<\/span>(<\/span>stage<\/span>)<\/span><\/div>
      run<\/span> "mysqldump -u <\/span>#{<\/span>username<\/span>}<\/span> --password='<\/span>#{<\/span>password<\/span>}<\/span>' <\/span>#{<\/span>database<\/span>}<\/span> > <\/span>#{<\/span>shared_path<\/span>}<\/span>/sync/<\/span>#{<\/span>filename<\/span>}<\/span>"<\/span> do<\/span> |<\/span>channel<\/span>,<\/span> stream<\/span>,<\/span> data<\/span>|<\/span><\/div>
        puts<\/span> data<\/span><\/div>
      end<\/span><\/div>
      purge_old_backups<\/span> "database"<\/span><\/div>
 <\/div>
      # Download dump<\/span><\/div>
      download<\/span> "<\/span>#{<\/span>shared_path<\/span>}<\/span>/sync/<\/span>#{<\/span>filename<\/span>}<\/span>"<\/span>,<\/span> filename<\/span><\/div>
 <\/div>
      # Local DB import<\/span><\/div>
      username<\/span>,<\/span> password<\/span>,<\/span> database<\/span> =<\/span> database_config<\/span>(<\/span>'development'<\/span>)<\/span><\/div>
      system<\/span> "mysql -u <\/span>#{<\/span>username<\/span>}<\/span> --password='<\/span>#{<\/span>password<\/span>}<\/span>' <\/span>#{<\/span>database<\/span>}<\/span> < <\/span>#{<\/span>filename<\/span>}<\/span>; rm -f <\/span>#{<\/span>filename<\/span>}<\/span>"<\/span><\/div>
      <\/div>
      logger<\/span>.<\/span>important<\/span> "sync database from the stage '<\/span>#{<\/span>stage<\/span>}<\/span>' to local finished"<\/span><\/div>
    end<\/span><\/div>
      <\/div>
    desc<\/span> <<-<\/span>DESC<\/span><\/div>
      Sync declared shared directories from the selected multi_stage environment to the local development<\/span><\/div>
      environment. The synced directories must be declared as an array of Strings with the sync_directories <\/span><\/div>
      variable and all entries will be prefixed with 'public'.<\/span><\/div>
    DESC<\/span><\/div>
    task<\/span> :fs<\/span>,<\/span> :roles<\/span> =><\/span> :web<\/span>,<\/span> :once<\/span> =><\/span> true<\/span> do<\/span><\/div>
      <\/div>
      server<\/span>,<\/span> port<\/span> =<\/span> host_and_port<\/span><\/div>
      <\/div>
      Array<\/span>(<\/span>fetch<\/span>(<\/span>:sync_directories<\/span>,<\/span> []<\/span>))<\/span>.<\/span>each<\/span> do<\/span> |<\/span>syncdir<\/span>|<\/span><\/div>
        unless<\/span> File<\/span>.<\/span>directory?<\/span> "public/<\/span>#{<\/span>syncdir<\/span>}<\/span>"<\/span><\/div>
          logger<\/span>.<\/span>info<\/span> "create local '<\/span>#{<\/span>syncdir<\/span>}<\/span>' folder"<\/span><\/div>
          Dir<\/span>.<\/span>mkdir<\/span> "public/<\/span>#{<\/span>syncdir<\/span>}<\/span>"<\/span>	  <\/div>
        end<\/span><\/div>
        logger<\/span>.<\/span>info<\/span> "sync public/<\/span>#{<\/span>syncdir<\/span>}<\/span> from <\/span>#{<\/span>server<\/span>}<\/span>:<\/span>#{<\/span>port<\/span>}<\/span> to local"<\/span><\/div>
        system<\/span> "rsync -e 'ssh -p <\/span>#{<\/span>port<\/span>}<\/span>' -avl --delete --stats <\/span>#{<\/span>server<\/span>}<\/span>:<\/span>#{<\/span>shared_path<\/span>}<\/span>/<\/span>#{<\/span>syncdir<\/span>}<\/span> public"<\/span><\/div>
      end<\/span><\/div>
      <\/div>
      logger<\/span>.<\/span>important<\/span> "sync filesystem from the stage '<\/span>#{<\/span>stage<\/span>}<\/span>' to local finished"<\/span><\/div>
    end<\/span><\/div>
 <\/div>
  end<\/span><\/div>
 <\/div>
  namespace<\/span> :up<\/span> do<\/span><\/div>
 <\/div>
    desc<\/span> <<-<\/span>DESC<\/span><\/div>
      Syncs the database and declared directories from the local development environment<\/span><\/div>
      to the selected multi_stage environment. This task simply calls both the 'sync:up:db' and <\/span><\/div>
      'sync:up:fs' tasks.<\/span><\/div>
    DESC<\/span><\/div>
    task<\/span> :default<\/span> do<\/span><\/div>
      db<\/span> and<\/span> fs<\/span><\/div>
    end<\/span><\/div>
 <\/div>
    desc<\/span> <<-<\/span>DESC<\/span><\/div>
      Syncs database from the local develoment environment to the selected mutli_stage environement.<\/span><\/div>
      The database credentials will be read from your local config/database.yml file and a copy of the<\/span><\/div>
      dump will be kept within the shared sync directory. The amount of backups that will be kept is<\/span><\/div>
      declared in the sync_backups variable and defaults to 5.<\/span><\/div>
    DESC<\/span><\/div>
    task<\/span> :db<\/span>,<\/span> :roles<\/span> =><\/span> :db<\/span>,<\/span> :only<\/span> =><\/span> {<\/span> :primary<\/span> =><\/span> true<\/span> }<\/span> do<\/span><\/div>
 <\/div>
      filename<\/span> =<\/span> "database.<\/span>#{<\/span>stage<\/span>}<\/span>.<\/span>#{<\/span>Time<\/span>.<\/span>now<\/span>.<\/span>strftime<\/span> '%Y-%m-%d_%H:%M:%S'<\/span>}<\/span>.sql"<\/span><\/div>
 <\/div>
      on_rollback<\/span> do<\/span><\/div>
        delete<\/span> "<\/span>#{<\/span>shared_path<\/span>}<\/span>/sync/<\/span>#{<\/span>filename<\/span>}<\/span>"<\/span><\/div>
        system<\/span> "rm -f <\/span>#{<\/span>filename<\/span>}<\/span>"<\/span><\/div>
      end<\/span><\/div>
 <\/div>
      # Make a backup before importing<\/span><\/div>
      username<\/span>,<\/span> password<\/span>,<\/span> database<\/span> =<\/span> database_config<\/span>(<\/span>stage<\/span>)<\/span><\/div>
      run<\/span> "mysqldump -u <\/span>#{<\/span>username<\/span>}<\/span> --password='<\/span>#{<\/span>password<\/span>}<\/span>' <\/span>#{<\/span>database<\/span>}<\/span> > <\/span>#{<\/span>shared_path<\/span>}<\/span>/sync/<\/span>#{<\/span>filename<\/span>}<\/span>"<\/span> do<\/span> |<\/span>channel<\/span>,<\/span> stream<\/span>,<\/span> data<\/span>|<\/span><\/div>
        puts<\/span> data<\/span><\/div>
      end<\/span><\/div>
 <\/div>
      # Local DB export<\/span><\/div>
      filename<\/span> =<\/span> "dump.local.<\/span>#{<\/span>Time<\/span>.<\/span>now<\/span>.<\/span>strftime<\/span> '%Y-%m-%d_%H:%M:%S'<\/span>}<\/span>.sql"<\/span><\/div>
      username<\/span>,<\/span> password<\/span>,<\/span> database<\/span> =<\/span> database_config<\/span>(<\/span>'development'<\/span>)<\/span><\/div>
      system<\/span> "mysqldump -u <\/span>#{<\/span>username<\/span>}<\/span> --password='<\/span>#{<\/span>password<\/span>}<\/span>' <\/span>#{<\/span>database<\/span>}<\/span> > <\/span>#{<\/span>filename<\/span>}<\/span>"<\/span><\/div>
      upload<\/span> filename<\/span>,<\/span> "<\/span>#{<\/span>shared_path<\/span>}<\/span>/sync/<\/span>#{<\/span>filename<\/span>}<\/span>"<\/span><\/div>
      system<\/span> "rm -f <\/span>#{<\/span>filename<\/span>}<\/span>"<\/span><\/div>
      <\/div>
      # Remote DB import<\/span><\/div>
      username<\/span>,<\/span> password<\/span>,<\/span> database<\/span> =<\/span> database_config<\/span>(<\/span>stage<\/span>)<\/span><\/div>
      run<\/span> "mysql -u <\/span>#{<\/span>username<\/span>}<\/span> --password='<\/span>#{<\/span>password<\/span>}<\/span>' <\/span>#{<\/span>database<\/span>}<\/span> < <\/span>#{<\/span>shared_path<\/span>}<\/span>/sync/<\/span>#{<\/span>filename<\/span>}<\/span>; rm -f <\/span>#{<\/span>shared_path<\/span>}<\/span>/sync/<\/span>#{<\/span>filename<\/span>}<\/span>"<\/span><\/div>
      purge_old_backups<\/span> "database"<\/span><\/div>
 <\/div>
      logger<\/span>.<\/span>important<\/span> "sync database from local to the stage '<\/span>#{<\/span>stage<\/span>}<\/span>' finished"<\/span><\/div>
    end<\/span><\/div>
      <\/div>
    desc<\/span> <<-<\/span>DESC<\/span><\/div>
      Sync declared shared directories from the local development environement to the selected multi_stage<\/span><\/div>
      environment. The synced directories must be declared as an array of Strings with the sync_directories <\/span><\/div>
      variable and all entries will be prefixed with 'public'.<\/span><\/div>
    DESC<\/span><\/div>
    task<\/span> :fs<\/span>,<\/span> :roles<\/span> =><\/span> :web<\/span>,<\/span> :once<\/span> =><\/span> true<\/span> do<\/span><\/div>
      <\/div>
      server<\/span>,<\/span> port<\/span> =<\/span> host_and_port<\/span><\/div>
      Array<\/span>(<\/span>fetch<\/span>(<\/span>:sync_directories<\/span>,<\/span> []<\/span>))<\/span>.<\/span>each<\/span> do<\/span> |<\/span>syncdir<\/span>|<\/span><\/div>
        if<\/span> File<\/span>.<\/span>directory?<\/span> "public/<\/span>#{<\/span>syncdir<\/span>}<\/span>"<\/span><\/div>
          # Make a backup<\/span><\/div>
          logger<\/span>.<\/span>info<\/span> "backup <\/span>#{<\/span>syncdir<\/span>}<\/span>"<\/span><\/div>
          run<\/span> "tar cf <\/span>#{<\/span>shared_path<\/span>}<\/span>/sync/<\/span>#{<\/span>syncdir<\/span>}<\/span>.<\/span>#{<\/span>Time<\/span>.<\/span>now<\/span>.<\/span>strftime<\/span> '%Y-%m-%d_%H:%M:%S'<\/span>}<\/span>.tar <\/span>#{<\/span>shared_path<\/span>}<\/span>/<\/span>#{<\/span>syncdir<\/span>}<\/span>"<\/span><\/div>
          purge_old_backups<\/span> "<\/span>#{<\/span>syncdir<\/span>}<\/span>"<\/span><\/div>
        else<\/span><\/div>
          logger<\/span>.<\/span>info<\/span> "Create shared '<\/span>#{<\/span>syncdir<\/span>}<\/span>' directory"<\/span><\/div>
          run<\/span> "mkdir <\/span>#{<\/span>shared_path<\/span>}<\/span>/<\/span>#{<\/span>syncdir<\/span>}<\/span>"<\/span><\/div>
        end<\/span><\/div>
          <\/div>
        # Sync directory up<\/span><\/div>
        logger<\/span>.<\/span>info<\/span> "sync public/<\/span>#{<\/span>syncdir<\/span>}<\/span> to <\/span>#{<\/span>server<\/span>}<\/span>:<\/span>#{<\/span>port<\/span>}<\/span> from local"<\/span><\/div>
        system<\/span> "rsync -avlze 'ssh -p <\/span>#{<\/span>port<\/span>}<\/span>' public/<\/span>#{<\/span>syncdir<\/span>}<\/span> <\/span>#{<\/span>server<\/span>}<\/span>:<\/span>#{<\/span>shared_path<\/span>}<\/span>"<\/span><\/div>
      end<\/span><\/div>
      logger<\/span>.<\/span>important<\/span> "sync filesystem from local to the stage '<\/span>#{<\/span>stage<\/span>}<\/span>' finished"<\/span><\/div>
    end<\/span><\/div>
          <\/div>
  end<\/span><\/div>
  <\/div>
  #<\/span><\/div>
  # Reads the database credentials from the local config/database.yml file<\/span><\/div>
  # +db+ the name of the environment to get the credentials for<\/span><\/div>
  # Returns username, password, database<\/span><\/div>
  #<\/span><\/div>
  def<\/span> database_config<\/span>(<\/span>db<\/span>)<\/span><\/div>
    database<\/span> =<\/span> YAML<\/span>::<\/span>load_file<\/span>(<\/span>'config/database.yml'<\/span>)<\/span><\/div>
    return<\/span> database<\/span>[<\/span>"<\/span>#{<\/span>db<\/span>}<\/span>"<\/span>][<\/span>'username'<\/span>]<\/span>,<\/span> database<\/span>[<\/span>"<\/span>#{<\/span>db<\/span>}<\/span>"<\/span>][<\/span>'password'<\/span>]<\/span>,<\/span> database<\/span>[<\/span>"<\/span>#{<\/span>db<\/span>}<\/span>"<\/span>][<\/span>'database'<\/span>]<\/span><\/div>
  end<\/span><\/div>
  <\/div>
  #<\/span><\/div>
  # Returns the actual host name to sync and port<\/span><\/div>
  #<\/span><\/div>
  def<\/span> host_and_port<\/span><\/div>
    return<\/span> roles<\/span>[<\/span>:web<\/span>].<\/span>servers<\/span>.<\/span>first<\/span>.<\/span>host<\/span>,<\/span> ssh_options<\/span>[<\/span>:port<\/span>]<\/span> ||<\/span> roles<\/span>[<\/span>:web<\/span>].<\/span>servers<\/span>.<\/span>first<\/span>.<\/span>port<\/span> ||<\/span> 22<\/span><\/div>
  end<\/span><\/div>
  <\/div>
  #<\/span><\/div>
  # Purge old backups within the shared sync directory<\/span><\/div>
  #<\/span><\/div>
  def<\/span> purge_old_backups<\/span>(<\/span>base<\/span>)<\/span><\/div>
    count<\/span> =<\/span> fetch<\/span>(<\/span>:sync_backups<\/span>,<\/span> 5<\/span>)<\/span>.<\/span>to_i<\/span><\/div>
    backup_files<\/span> =<\/span> capture<\/span>(<\/span>"ls -xt <\/span>#{<\/span>shared_path<\/span>}<\/span>/sync/<\/span>#{<\/span>base<\/span>}<\/span>*"<\/span>)<\/span>.<\/span>split<\/span>.<\/span>reverse<\/span><\/div>
    if<\/span> count<\/span> >=<\/span> backup_files<\/span>.<\/span>length<\/span><\/div>
      logger<\/span>.<\/span>important<\/span> "no old backups to clean up"<\/span><\/div>
    else<\/span><\/div>
      logger<\/span>.<\/span>info<\/span> "keeping <\/span>#{<\/span>count<\/span>}<\/span> of <\/span>#{<\/span>backup_files<\/span>.<\/span>length<\/span>}<\/span> sync backups"<\/span><\/div>
      delete_backups<\/span> =<\/span> (<\/span>backup_files<\/span> -<\/span> backup_files<\/span>.<\/span>last<\/span>(<\/span>count<\/span>))<\/span>.<\/span>join<\/span>(<\/span>" "<\/span>)<\/span><\/div>
      try_sudo<\/span> "rm -rf <\/span>#{<\/span>delete_backups<\/span>}<\/span>"<\/span><\/div>
    end<\/span><\/div>
  end<\/span><\/div>