Skip to content

Instantly share code, notes, and snippets.

@romeuhcf
romeuhcf / monomai.rb
Created October 8, 2015 12:07
Parte do sistema de envio referente ao envio de email para fornecedor.
...
mail = Mail.new do
self.content_transfer_encoding = 'quoted-printable'
subject envio_mono.assunto
from hdr.sender
to envio_mono.mail
html_part do
self.content_transfer_encoding = 'quoted-printable'
SELECT top 20 NOMEEMP [EMPRESA] , DCRCC [CENTRO_DE_CUSTO] , CASE WHEN CODINTMLGDD = 6 THEN 'LA' ELSE 'NA' END [TIPO_SMS] , SUM(ISNULL(QTDMLGDD,1)) [VOLUME_PROCESSADO] , SUM(CASE WHEN CODMLGDDSTS IN (12,5) THEN ISNULL(QTDMLGDD,1) ELSE 0 END) [VOLUME_TARIFADO] FROM tbl_mailling_dado MDD WITH (NOLOCK) INNER JOIN tbl_mailling MLG WITH (NOLOCK) ON MDD.codmlg = MLG.codmlg INNER JOIN tbl_empresa EMP WITH (NOLOCK) ON MDD.codemp = EMP.codemp INNER JOIN tbl_centro_custo CC WITH (NOLOCK) ON MLG.codcc = CC.codcc WHERE CODMLGDDSTS IN (12,5) AND (DATAENVMLGDD IS NULL AND DATAINIMLG BETWEEN '2015-11-01 00:00:00' AND '2015-12-01 00:00:00') OR (DATAENVMLGDD BETWEEN '2015-11-01 00:00:00' AND '2015-12-01 00:00:00') GROUP BY NOMEEMP, DCRCC, CODINTMLGDD, CASE WHEN CODINTMLGDD = 6 THEN 'LA' ELSE 'NA' END
/home/romeu/.rvm/gems/ruby-2.3.1@genesis-devise/gems/bundler-1.14.3/lib/bundler/runtime.rb:94:in `rescue in block (2 levels) in require': There was an error while trying to load the gem 'omniauth-gplus'.
Gem Load Error is: private method `warn' called for nil:NilClass
Backtrace for gem load error is:
/home/romeu/.rvm/gems/ruby-2.3.1@genesis-devise/gems/hashie-3.5.2/lib/hashie/mash.rb:334:in `log_built_in_message'
/home/romeu/.rvm/gems/ruby-2.3.1@genesis-devise/gems/hashie-3.5.2/lib/hashie/mash.rb:139:in `custom_writer'
/home/romeu/.rvm/gems/ruby-2.3.1@genesis-devise/gems/hashie-3.5.2/lib/hashie/mash.rb:207:in `block in deep_update'
/home/romeu/.rvm/gems/ruby-2.3.1@genesis-devise/gems/hashie-3.5.2/lib/hashie/mash.rb:200:in `each_pair'
/home/romeu/.rvm/gems/ruby-2.3.1@genesis-devise/gems/hashie-3.5.2/lib/hashie/mash.rb:200:in `deep_update'
/home/romeu/.rvm/gems/ruby-2.3.1@genesis-devise/gems/hashie-3.5.2/lib/hashie/mash.rb:115:in `initialize'
/home/romeu/.rvm/gems/ruby-2.3.1@genesis-devise/gems/omniauth-1.4.1/l
# REFERENCE https://devcenter.heroku.com/articles/direct-to-s3-image-uploads-in-rails
Aws.config.update(region: ENV['AWS_REGION'], credentials: Aws::Credentials.new(ENV['AWS_ACCESS_KEY_ID'], ENV['AWS_SECRET_ACCESS_KEY']))
S3_BUCKET = Aws::S3::Resource.new.bucket(ENV['S3_BUCKET'])
alert('oi');
@romeuhcf
romeuhcf / csv_with_bom.rb
Last active November 14, 2021 00:30
Ruby 2.5 support for opening csv with bom|utf-8
class CSV
def self.open(file, options={}, &block)
encoding = options.delete(:encoding)
File.open(file, "r:#{encoding}") do |fd|
yield CSV.new(fd, options)
end
end
end
set -e
tee /etc/logrotate.d/bluepill << END
/var/log/bluepill.log {
rotate 7
daily
missingok
notifempty
sharedscripts
@romeuhcf
romeuhcf / gist:e59c397b100432543652eeeccd565ffd
Created November 1, 2018 23:37
template-spec-fixture-file.html
<h1>OI {{name}}</h1>
<h2>Hello, {{email}}</h2>
<img src="a.gif"/>
git fetch; git log --pretty=oneline production...origin/HEAD master --first-parent --merges | grep -v master..of | sed "s/.*branch '//; s/'.*//"