Roberto Nogueira  
BSd EE, MSd CE
Solution Integrator Experienced - Certified by Ericsson

Rails Site Manager

About

This is in order to help the working CLI(Object Oriented Bash style) daily activities. It shows live relevant rails project information in the cli such as rvm, env, db and git domains, services and databases information.

Advantages:

• Development Flux and Environment seamlessly integrated.
• Live rvm, env, db and git domains, services and databases information.
• Support local and remote databases setups, remote import and download databases.
• Support start/stop services at once with consolidated logs.
• Better db consoles for mysql, postgresql and redis.
• Support for RDD and Skylab console servers.

Dependences:

• Packages: ack, ansi,cowsay, fping, iredis, mycli, pgcli, pv, wget, xidel and pup.
• Gem: foreman.

Se References below for further info.

Here it is shown possible CLI commands(relevant ones) according to the previous picture following CLI styles e.g. OO and usual bash which can be used interchangeably.

$ site.methods
methods|help|init|name|print|start|stop|version

$ vpn.methods
methods|help|init|connected|loop|print

$ rvm.domain.methods
methods|help|init|development|print|test

$ env.domain.methods
methods|help|init|development|print|test

$ dbs.domain.methods
methods|help|init|local|multi|print|remote

$ git.domain.methods
methods|help|init|justworks.init|justworks|gmail.init|gmail|print
:
$ services.methods
methods|help|init|start|stop|print

$ services.mysql.methods
methods|help|init|console|list|restart|start|stop

$ services.redis.methods
methods|help|init|console|list|restart|start|stop

$ skylab.methods
methods|help|init|instances|sandbox|staging|prod|control|console|print

$ dbs.methods
methods|help|init|archives|console|current|create|refresh|delete|rebuild_test|print

$ dumps.methods
methods|help|init|download|import|print|activate|deactivate

Example of uses:

1. Setup Local DB

Here it is show a Setup of a Local DB e.g. Download/Import a DB from Skylab and then accessing it with mycli.

Note: In order to Download the DB from Skylab, the AWS VPN Client has to be connected.

# this has to be performed just once
$ cp config/database.yml config/database.yml.local

$ site dbs.domain local

$ site dumps download
==> Downloading  clockwork_sanitized_no_excluded_tables.sql.gz
100%[============..==========>]  18.46G  4.62MB/s    in 62m 51
==> Renaming to  2022-07-21_09-05-00.clockwork_web.sql.gz

$ site dumps import 
==> Dropping  databases
==> Creating  databases
==> Importing 2022-07-21_09-05-00.clockwork_web.sql.gz
19.2GiB 6:31:39 [ 858KiB/s] [============..===========] 100%

$ site dbs rebuild_test
==> Running rebuild_test.sh
==> Running dbs.init

$ site dbs console
Connecting to socket /tmp/mysql.sock, owned by user robertonogueira
MySQL
mycli 1.25.0
Home: http://mycli.net
Bug tracker: https://github.com/dbcli/mycli/issues
Thanks to the contributor - cxbig
MySQL root@(none):clockwork_dev> exit

$ site
site: clockwork_web  - AWS VPN Client
  rvm domain [email protected]
  env domain development test
  dbs domain local remote multi
  git domain gmail justworks
services:
  redis      localhost:6379 58714
  mysql      localhost:3306 34946
  postgresql localhost:5432 11503
  assets, worker, web
dbs:
  clockwork_dev  485 807877204
  clockwork_test 485 3413
dumps:
  2022-07-21_09-05-00.clockwork_web.sql.gz

2. Setup Remote DB

Here it is show a Setup of a Remote DB e.g. Creation aDB in Sanitize-db and then accessing it with mycli.

Note: In order to Create/Accesssin the DB in Sanitize-db, the AWS VPN Client has to be connected. Here it is show a check with Archives, a Creation of a remote DB in Sanitized-db, and a connection to the underlying DB by using mycli console. Once the Sanitized-db is created, an email is sent with the credentials and the database.yml for Remote use. So downloaded them and move to config directory under the Site as showed below.

$ site dbs archives
Archive data        File Name                               Ts     File Size
2022-06-26 23:22:29 light/latest/backup_light_latest.tar.gz latest 53 GB
:

$ site dbs create

$ mv ~/Downloads/database.yml.remote config/
$ mv ~/Downloads/database.yml.multi config/

$ site dbs.domain remote

$ site dbs rebuild_test
==> Running rebuild_test.sh
==> Running dbs.init

$ site dbs console
MySQL
mycli 1.25.0
Home: http://mycli.net
Bug tracker: https://github.com/dbcli/mycli/issues
Thanks to the contributor - Jonathan Slenders
clockwork_dev> exit

$ site
site: clockwork_web  - AWS VPN Client
  rvm domain [email protected]
  env domain development test
  dbs domain remote local multi
  git domain gmail justworks
services:
  redis      localhost:6379 58714
  mysql      https://sanitized-db.justworks.com
  postgresql localhost:5432 11503
  assets, worker, web
dbs:
  clockwork_dev  493 843986809
  clockwork_test 485 3412
dumps:
  2022-07-21_09-05-00.clockwork_web.sql.gz

3. Start/Stop Services

Here it is show the Start/Stop the underlying site services.

$ site start
03:54:44 web.1    | started with pid 83120
03:54:44 worker.1 | started with pid 83121
03:54:44 assets.1 | started with pid 83122
:

# from another terminal
$ sitesite: clockwork_web  - AWS VPN Client
  rvm domain [email protected]
  env domain development test
  dbs domain remote local multi
  git domain gmail justworks
services:
  redis      localhost:6379 633
  mysql      https://sanitized-db.justworks.com
  postgresql localhost:5432 643
  assets     yarn.js watch  10671
  worker     http://localhost:3000/sidekiq 10670
  web        http://localhost:3000 10669
dbs:
  clockwork_dev  493 843986809
  clockwork_test 485 3412
dumps:
  2022-07-21_09-05-00.clockwork_web.sql.gz

$ site stop
:

4. Connect to Skylab servers

Note: In order to connect to the skylab servers the AWS VPN Client has to be connected. If it is required the PUPPET PASSWORD is in Clibboard (so just paste it e.g. <command+v>).

$ site skylab sandbox
:
==> Instance 'sandbox-app-104' is pinging!

$ site skylab
  skylab         https://skylab.justworks.com sandbox-app-104

$ skylab.console
rnogueira@sandbox-app-104:~$ sudo su -
[sudo] password for rnogueira: <command+v>
# cd /var/www/current
/var/www/current# RAILS_ENV=sandbox bundle exec rails console
Loading sandbox environment (Rails 5.2.7)
2.7.5 :001 >

For further help:

Crafted (c) 2021~23 by Encora - We are stronger together
Site v1.0.29

site    [branches|commit|issues|master|print|start|stop|update|version]
vpn    [connected|loop|print]
::
rvm.domain    [print]
env.domain    [print|development|test]
dbs.domain    [print|local|remote|multi]
git.domain    [print|justworks|gmail]
::
dbs    [print|create|refresh|delete|rebuild_test]
dumps  [print|download|import|activate|deactivate]
rdd    [check|print|set|unset]
::
services    [print|start|stop]
services.mysql    [console|list|restart|start|stop]
services.redis    [console|list|restart|start|stop]
::
skylab    [instances|sandbox|staging|prod|control|console|print]
::
homepage https://github.com/enogrob/rails-site-manager

Installation:

# change shell to bash
chsh -s /bin/bash
echo 'export BASH_SILENCE_DEPRECATION_WARNING=1' >> ~/.bash_profile

# install site and its deps
pushd /tmp
mkdir -p ~/Projects
git clone [email protected]:enogrob/rails-site-manager.git
cd rails-site-manager
brew bundle --no-upgrade
cd ..
curl -OL git.io/ansi
chmod 755 ansi
sudo mv ansi /usr/local/bin/
mv rails-site-manager ~/Projects
popd

# install foreman gem
pushd ~/Projects/clockwork_web
gem install foreman --no-document
popd

Configuration

Add the source of the Rails Site Manager, the Puppet Credentials and the some initial values for emails(change to yours) are set in ~/.bashrc.

# rails site manager
export PUPPET_USER=<user login>
export PEPPET_PASS=<password>
test -f  "$HOME/Projects/rails-site-manager/site" && source "$HOME/Projects/rails-site-manager/site"
git.domain.justworks.init "<name>" "<justworks email>"
git.domain.gmail.init "<name>" "<gmail email>" 

Also the database.yml.remote, database.yml.multi and database.yml.local have to be placed in config directory in Rails project directory tree e.g. clockwork_web.

Note: The files database.yml.remote and database.yml.multi are downloaded from the sanitized DB email. Check if the test db connections points to the remote db instead of local, if not updated it.

pushd ~/Projects/clockwork_web
cp config/database.yml config/database.yml.local
mv ~/Downloads/database.yml.remote config/
mv ~/Downloads/database.yml.multi config/
popd

Once all that is performed just source the ~/.bashrc, and one is ready to go!

source ~/.bashrc

Note: This underlying project is still under development so mind to keep its local repo updated.

pushd ~/Projects/rails-site-manager
git pull
popd

or just

site update

Changes log

• 1.0.30 dbs.instances_db_remote method created add new method.
• 1.0.29 dbs.change_refresh_schedule method created method updated.
• 1.0.28 update-master script updated.
• 1.0.27 site.branches,site.commit,site.issues are created.
• 1.0.26 site.master is created.
• 1.0.25 site.update is updated.
• 1.0.24 dbs.rebuild_test for remote.
• 1.0.23 Correct dumps.activate of dumps namespace.
• 1.0.22 Add site.print_domains to consolidate domains.
• 1.0.21 Clipboard loaded for skylab.console.
• 1.0.20 Method site.print just prints dumps when local.
• 1.0.19 Correct site with zero param namespaces.
• 1.0.18 Refactor dumps as activable.
• 1.0.17 Refactor dumps as namespace.
• 1.0.16 Refactor skylab namespace.
• 1.0.15 Add namespace rdd.
• 1.0.14 Namespace skylab now is seem as a service.
• 1.0.13 Emails git.domain now is initialized in ~/.bashrc.
• 1.0.12 Add namespace skylab.
• 1.0.11 Add methods start|stop to site.
• 1.0.10 Improve method print_up to services.
• 1.0.09 Add method notify to site.
• 1.0.08 Add method archives to dbs.
• 1.0.07 Add method rebuild_test to dbs.
• 1.0.06 Refactor git.domain and add methods create|refresh|delete to dbs.
• 1.0.05 Add vpn namespace.
• 1.0.04 Refactor dbs.import.
• 1.0.03 Refactor dbs.domain as a really namespace.
• 1.0.02 Improve dbs.domain.print and corrected dbs.init.
• 1.0.01 Implement methods console|list|restart|start|stop for services.msql and services.redis.
• 1.0.00 First release.

Refs:

Based on: research-obras-devtools - Obras Development process, development utilities and support for Foreman, Docker and editors VsCode and Rubymine.

• ack - grep-like source code search tool.
• ansi - Escape codes in pure bash.
• cowsay - Configurable talking characters in ASCII art.
• foreman - Manage Procfile-based applications.
• fping - Scriptable ping program for checking if multiple hosts are up.
• iredis - A Terminal Client for Redis with AutoCompletion and Syntax Highligting.
• mycli - A Terminal Client for Mysql with AutoCompletion and Syntax Highligting.
• pgcli - A Terminal Client for Postgresql with AutoCompletion and Syntax Highligting.
• pv - Pipe Viewer.
• wget - The noninteractive downloading utility.
• xidel - Command line tool to download and extract data from HTML/XML pages or JSON-APIs.