frankyston

Remove MySQL completely

1. Open the Terminal

2. Use mysqldump to backup your databases

3. Check for MySQL processes with: ps -ax | grep mysql

4. Stop and kill any MySQL processes

5. Analyze MySQL on HomeBrew:

brew remove mysql

frankyston

How to reset PG Database on Heroku?

• Step 1: heroku restart
• Step 2: heroku pg:reset DATABASE (no need to change the DATABASE)
• Step 3: heroku run rake db:migrate
• Step 4: heroku run rake db:seed (if you have seed)

One liner

heroku restart; heroku pg:reset DATABASE --confirm APP-NAME; heroku run rake db:migrate

frankyston

# Download rbenv
if [ ! -d ~/.rbenv ]; then
  git clone https://github.com/sstephenson/rbenv.git ~/.rbenv
fi

cd ~/.rbenv
git reset --hard
git pull origin master

frankyston

  desc "Truncate all tables in the database"
  task :truncate_all_tables! => :environment do
    unless Rails.env.production?
      puts "TRUNCATING ALL TABLES in 3 seconds!!!!"
      sleep 3
      ActiveRecord::Base.connection.tables.each do |table|
        unless table == "schema_migrations"
          puts "Truncating #{table}."
          ActiveRecord::Base.connection.execute("TRUNCATE TABLE #{table} RESTART IDENTITY CASCADE;")
        else

frankyston

hash = { 'foo' => 'bar' }

# Version 1
hash = Hash[hash.map { |k, v| [k.to_sym, v] }]

# Version 2
hash = hash.reduce({}) do |memo, (k, v)| 
  memo.tap { |m| m[k.to_sym] = v }
end

frankyston

# 1. Clear retry set

Sidekiq::RetrySet.new.clear

# 2. Clear scheduled jobs 

Sidekiq::ScheduledSet.new.clear

# 3. Clear 'Processed' and 'Failed' jobs

frankyston

# I was using https://github.com/maclover7/trix to do:
#
# f.input :my_input, as: :trix_editor
#
# Its currently been over two weeks since Rails 5.2 was released, and the 
# gem was the only thing preventing me from using it in multiple projects:
# https://github.com/maclover7/trix/pull/61#issuecomment-384312659
#
# So I made this custom simpleform input for my apps to prevent this from happening again in the future.
#

frankyston

Deploying from circleci2.0 to Heroku

Resources:

• circleci 2.0 docs
• Managing SSH Keys on Heroku

Steps:

Prerequisites:

• Heroku CLI installed on your computer
• A project deployed to Heroku

frankyston

#!/bin/bash
# Stop all containers
docker stop $(docker ps -a -q)
# Delete all containers
docker rm $(docker ps -a -q)
# Delete all images
docker rmi $(docker images -q)

frankyston

Active Record

É um design pattern que o Rails implementa a partir da gem ActiveRecord.

Serve para conectar a camada Model da aplicação com tabelas do database, para assim criar um modelo de domínio persistível, onde a lógica (Model) e dados (BD) são apresentados em uma única solução.

Já persiste no BD:

obj.create