linko

describe 'SomethingMailer' do
  include Rails.application.routes.url_helpers
  let(:something) { create :something }
 
  describe 'accepted' do
    let(:mail) { SomethingMailer.accepted(something) }
 
    it 'renders the subject' do
      mail.subject.should == 'Subject Accepted'
    end

linko

pg_dump <db_name> > <bkup_name>.dump -U <user> -Fc -h localhost
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U <user> -d <db_name> <bkup_name>.dump

linko

DROP FUNCTION fn_determine_60_day_message_count_emv(in_target_profileble_id integer, in_service_name text);
CREATE FUNCTION fn_determine_60_day_message_count_emv(in_target_profileble_id integer, in_service_name text) RETURNS integer
    LANGUAGE plpgsql
    AS $$

DECLARE
      
      var_message_count_emv int := null;