antoniosmgatto

#!/bin/bash

# errexit -> exit when any command fails
set -o errexit

# will fails exit if an pipe command fails
set -o pipefail

# nounset -> exit when an unsed variable is used
set -o nounset

antoniosmgatto

#!/bin/bash

WORKSPACE_DIR="/tmp/postgres_bkp"
DB_URL="$1"
BACKUP_FILENAME="$2"
S3_CMD=$(which s3cmd)
SPACES_BUCKET="your-bucket-here"

if [ -z "$DB_URL" ] || [ -z "$BACKUP_FILENAME" ]; then
  echo "You must set database connection and output filename !!!";

antoniosmgatto

require "capistrano/setup"
require "capistrano/deploy"
require "capistrano/bundler"
require "capistrano/scm/git"
require "capistrano/rails/assets"
require "capistrano/rails/migrations"
require "capistrano/data_migrate"
require "capistrano/rbenv"

antoniosmgatto

String

In this introductory challenge, your task is to use each of the above three methods to return the text Hello World and others!

def single_quote
  # single quote string here
    'Hello World and others!'
end

antoniosmgatto

SQL tips

from Rails Conf 2017 - The Secret Life of SQL

An index is a copy

Rules

1. Any columns involved in queries should be covered by an index

• but avoid redundant and unused index.

antoniosmgatto

\set PROMPT1 '%M:%[%033[1;31m%]%>%[%033[0m%] %n@%/%R%#%x '
\set ON_ERROR_ROLLBACK interactive
\set COMP_KEYWORD_CASE upper
\set HISTFILE ~/.psql/history- :DBNAME
\timing
\x auto
\pset pager off
\pset null '(null)'

antoniosmgatto

Postgres tips

DML = Data Manipulation language (INSERT, UPDATE, DELETE and SELECT) DDL = Data definition Language (CREATE, ALTER, DROP)

smallserial, serial and bigserial columns are autoincrement

psql commands

Show roles: \du

antoniosmgatto

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lor

antoniosmgatto

foo bar

antoniosmgatto

# create a new express app
express clubeincentivo-api -v pug