cloud66_copy_live_db.rb

#!/usr/bin/env ruby

require 'typhoeus'
require 'json'

NAME = 'MY_APP_NAME'
TOKEN = File.read("~/.cloud66/token")
STACK_ID = 'MY_CLOUD66_STACK_ID'

# Get backups
request = Typhoeus::Request.new("https://app.cloud66.com/api/3/stacks/#{STACK_ID}/backups.json", method: :get, headers: { Authorization: "Bearer #{TOKEN}" })
request.run
response = request.response
resp = JSON.parse(response.body)
backup_id = resp['response'][0]['id']

# Get backup files
request = Typhoeus::Request.new("https://app.cloud66.com/api/3/stacks/#{STACK_ID}/backups/#{backup_id}/files.json", method: :get, headers: { Authorization: "Bearer #{TOKEN}" })
request.run
response = request.response
resp = JSON.parse(response.body)
file_id = resp['response'][0]['id']

# Get backup file url
request = Typhoeus::Request.new("https://app.cloud66.com/api/3/stacks/#{STACK_ID}/backups/#{backup_id}/files/#{file_id}.json", method: :get, headers: { Authorization: "Bearer #{TOKEN}" })
request.run
response = request.response
resp = JSON.parse(response.body)
public_url = resp['response']['public_url']

`cd backups; wget #{public_url}`