edwinlab

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

edwinlab

module ActiveRecord
  class Base
    class << self
      #
      # SELECT  "payments".* 
      # FROM "payments"  
      # WHERE "payments"."id" = <id> 
      #   AND ("payments"."created_at" BETWEEN '<start month>' AND '<end month>')  
      # ORDER BY "payments"."id" ASC LIMIT 1
      #

edwinlab

Docker Cheat Sheet

Table of Contents

• Why Docker
• Prerequisites
• Installation
• Containers
• Images
• Networks

edwinlab

Contributing

When contributing to this repository, please first discuss the change you wish to make via issue, email, or any other method with the owners of this repository before making a change.

Please note we have a code of conduct, please follow it in all your interactions with the project.

Pull Request Process

1. Ensure any install or build dependencies are removed before the end of the layer when doing a

edwinlab

Project Title

One Paragraph of project description goes here

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.

Prerequisites

edwinlab

AppBarLayout appBar = (AppBarLayout) rootView.findViewById(R.id.app_bar);
appBar.addOnOffsetChangedListener(new AppBarLayout.OnOffsetChangedListener() {
    @Override
    public void onOffsetChanged(AppBarLayout appBarLayout, int verticalOffset) {
    }
});

edwinlab

Rails Migration

http://guides.rubyonrails.org/migrations.html

Migrations methods:

• add_column
• add_index
• change_column
• change_table
• create_table
• drop_table

edwinlab

class Person
  has_many :accounts
  has_many :computers, through: :accounts
end

class Account
  belongs_to :person
  belongs_to :computer

  scope :administrators, -> { where(role: 'administrator') }

edwinlab

module Validate
  class Activity
    include ActiveModel::Validations

    attr_accessor :latitude, :longitude

    validates :latitude, presence: true, numericality: true
    validates :longitude, presence: true, numericality: true

    def initialize(params={})

edwinlab

def self.escape_characters_in_string(string)
  pattern = /(\'|\"|\.|\*|\/|\-|\\|\)|\$|\+|\(|\^|\?|\!|\~|\`)/
  string.gsub(pattern){|match|"\\"  + match}
end