leemour

cat db.txt | psql dbname

leemour

require 'bundler/setup'

require 'active_record'

include ActiveRecord::Tasks

db_dir = File.expand_path('../db', __FILE__)
config_dir = File.expand_path('../config', __FILE__)

DatabaseTasks.env = ENV['ENV'] || 'development'

leemour

# Colorizes the output of the standard library logger, depending on the logger level:
# To adjust the colors, look at Logger::Colors::SCHEMA and Logger::Colors::constants

require 'logger' 

class Logger
  module Colors
    VERSION = '1.0.0'

    NOTHING      = '0;0'

leemour

# sudo iptables -t nat -I PREROUTING -p tcp --dport 80 -j REDIRECT --to-ports 3000 
# sudo iptables -t nat -I OUTPUT -p tcp -d 127.0.0.1 --dport 80 -j REDIRECT --to-ports 3000

sudo iptables -t nat -A OUTPUT -d localhost -p tcp --dport 80 -j REDIRECT --to-port 3000

# Save iptables to file
sudo bash -c "iptables-save -c > /etc/iptablesrc"

# Apply localhost redirect saved in iptablesrc on system start
# sudo bash -c "iptables-restore < /etc/iptablesrc"

leemour

for file in $(find `pwd` -name "*.html.slim"); do
  mv "$file" "`dirname $file`/`basename $file .html.slim`.slim"
done

leemour

RAILS_ENV=production rake db:setup
# produces the error below.....hmmm.....it's a no-worky
psql:/yourprojectpath/yourproject/db/structure.sql:29: ERROR:  could not open extension control file "/usr/share/postgresql/9.1/extension/hstore.control": No such file or directory

# hstore postgresql extension needs to be installed, so....
sudo apt-get install postgresql-contrib

# now your extension should be available to enable so log in with psql
psql -d yourproject_production -U yourdbuser -W

leemour

is_expected.to have_link('link_text', href: 'url')
expect(find_link('link_text')[:target]).to eq('_blank')

#=Navigating=
    visit('/projects')
    visit(post_comments_path(post))

#=Clicking links and buttons=
    click_link('id-of-link')
    click_link('Link Text')

leemour

# For a data-only export use COPY.
# You get a file with one table row per line as plain text (not INSERT commands), it's smaller and faster:

COPY (SELECT * FROM nyummy.cimory WHERE city = 'tokio') TO '/path/to/file.csv';

# Import the same to another table of the same structure anywhere with:

COPY other_tbl FROM '/path/to/file.csv';

leemour

# No flash messages are set with this controller.
#
# This is a fairly basic / bare controller which does only the basic CRUD.
class BooksController < ApplicationController
  respond_to :html, :xml, :json

  before_action :set_book, only: [:show, :edit, :update, :destroy]

  def index
    respond_with @books = Book.all

leemour

ActiveRecord::Base.connection.execute("
  UPDATE adverts SET tel = regexp_replace(tel, '\\+78', '7');
")