attilahorvath

class MigrateToUtf8mb4 < ActiveRecord::Migration
  def change
    execute "ALTER DATABASE `#{ActiveRecord::Base.connection.current_database}` CHARACTER SET utf8mb4;"

    ActiveRecord::Base.connection.tables.each do |table|
      execute "ALTER TABLE `#{table}` CHARACTER SET = utf8mb4 COLLATE utf8mb4_unicode_ci;"
      ActiveRecord::Base.connection.columns(table).each do |column|
        if column.sql_type =~ /varchar\((\d+)\)/
          limit = $1.to_i
          limit = 191 if ActiveRecord::Base.connection.indexes(table).any?{|i| i.columns.include? column.name} && limit > 191

attilahorvath

# compress
tar -czvf archive.tar.gz directory

# extract
tar -xzvf archive.tar.gz

# flags:
# (c)reate
# e(x)tract
# use g(z)ip

attilahorvath

# dump
mysqldump -u user -p database --default-character-set=utf8mb4 --result-file=dump.sql

# restore
mysql -u user -p database < dump.sql

attilahorvath

# Capfile
require "whenever/capistrano"

# deploy.rb
set :whenever_environment, -> { fetch(:stage) }
set :whenever_identifier, -> { "#{fetch(:application)}_#{fetch(:stage)}" }

# schedule.rb
case @environment
when "staging"

attilahorvath

# /etc/apache2/users/user.conf
NameVirtualHost *:80

<Directory "/path/to/rails/apps/">
  Options Indexes Multiviews Includes
  AllowOverride All
  Order allow,deny
  Allow from all
</Directory>

attilahorvath

# config/initializers/active_record_patch.rb

require 'active_record/connection_adapters/abstract_mysql_adapter'

module ActiveRecord
  module ConnectionAdapters
    class AbstractMysqlAdapter
      NATIVE_DATABASE_TYPES[:string] = { name: "varchar", limit: 191 }
    end
  end

attilahorvath

{
	"caret_extra_width": 1,
	"caret_style": "phase",
	"color_scheme": "Packages/Predawn Twilight Theme/Predawn Twilight.tmTheme",
	"detect_indentation": false,
	"draw_minimap_border": true,
	"findreplace_small": true,
	"font_size": 13,
	"highlight_line": true,
	"ignored_packages":

attilahorvath

# To fix 'command not found: bin/delayed_job' error on Capistrano deploy, execute this on the server
bundle exec rails generate delayed_job

attilahorvath

# Method to get the cover image URL for a YouTube video by its ID
# There are several cover images avaiable for every video, you can specify which one you need through the type parameter
# For a list of possible cover types see http://stackoverflow.com/a/2068371/3463845
# The returned URL will be protocol-relative, so it should work on sides loaded through HTTP and HTTPS as well
def youtube_cover_for(id, type = :default)
  "//img.youtube.com/vi/#{id}/#{type}.jpg"
end

# Method to extract the video ID from a YouTube embed code
# This very simple regex works by exploiting the fact that the YouTube video IDs are always 11 characters long

attilahorvath

# config/deploy.rb
# Using Capistrano 3
# Set the current environment for Whenever and avoid name collisions
set :whenever_environment, -> { fetch(:stage) }
set :whenever_identifier, -> { "#{fetch(:application)}_#{fetch(:stage)}" }

# config/schedule.rb
every "@reboot" do
  # If the app is using Puma
  command "cd #{path} && bundle exec puma -e #{@environment}"