| #!/usr/bin/env bash -x | |
| VIRTUALBOX_DOWNLOAD_URL="http://download.virtualbox.org/virtualbox/4.3.28/VirtualBox-4.3.28-100309-OSX.dmg" | |
| VIRTUALBOX_DOWNLOAD_PATH="/Users/$USER/Downloads/virtualbox.dmg" | |
| VIRTUALBOX_INSTALLER_PKG="/Volumes/VirtualBox/VirtualBox.pkg" | |
| VIRTUALBOX_INSTALLER_TARGET=/Volumes/Macintosh\ HD | |
| DOCKER_DOWNLOAD_URL="https://get.docker.com/builds/Darwin/x86_64/docker-latest" | |
| DOCKER_DOWNLOAD_PATH="/usr/local/bin/docker" | |
| DOCKER_MACHINE_DOWNLOAD_URL="https://github.com/docker/machine/releases/download/v0.2.0/docker-machine_darwin-amd64" | |
| DOCKER_MACHINE_DOWNLOAD_PATH="/usr/local/bin/docker-machine" |
| SELECT organizations.name, | |
| organizations.id, | |
| organizations.ancestry, | |
| tmp.average_activated_time_of_children from organizations | |
| JOIN ( | |
| SELECT org.ancestry, | |
| AVG(org.updated_at - org.created_at) as average_activated_time_of_children, | |
| CAST(substring(org.ancestry from '\d+(?!\/)$') as integer) as organization_id | |
| FROM organizations org | |
| INNER JOIN accounts acc ON acc.organization_id=org.id |
| <?xml version="1.0" encoding="UTF-8"?> | |
| <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> | |
| <plist version="1.0"> | |
| <dict> | |
| <key>Ansi 0 Color</key> | |
| <dict> | |
| <key>Blue Component</key> | |
| <real>0.078821629285812378</real> | |
| <key>Green Component</key> | |
| <real>0.07883714884519577</real> |
This gist assumes: