Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am jdguzman on github.
  • I am jdguzman (https://keybase.io/jdguzman) on keybase.
  • I have a public key ASAxBn0Sy8uz30d6qjEHzXqFAoA3EHmoXDU0FG9P89fPpAo

To claim this, I am signing this object:

Loading development environment (Rails 3.2.17)
2.0.0-p353 :001 > Account.group_by_week(:created_at).count
(64.5ms) SELECT COUNT(*) AS count_all, CONVERT_TZ(DATE_FORMAT(CONVERT_TZ(DATE_SUB(created_at, INTERVAL ((1 + WEEKDAY(CONVERT_TZ(created_at, '+00:00', 'America/Chicago') - INTERVAL 0 HOUR)) % 7) DAY) - INTERVAL 0 HOUR, '+00:00', 'America/Chicago'), '%Y-%m-%d 00:00:00') + INTERVAL 0 HOUR, 'America/Chicago', '+00:00') AS week FROM `accounts` WHERE (created_at IS NOT NULL) GROUP BY CONVERT_TZ(DATE_FORMAT(CONVERT_TZ(DATE_SUB(created_at, INTERVAL ((1 + WEEKDAY(CONVERT_TZ(created_at, '+00:00', 'America/Chicago') - INTERVAL 0 HOUR)) % 7) DAY) - INTERVAL 0 HOUR, '+00:00', 'America/Chicago'), '%Y-%m-%d 00:00:00') + INTERVAL 0 HOUR, 'America/Chicago', '+00:00')
RuntimeError: Be sure to install time zone support - https://github.com/ankane/groupdate#for-mysql
from /Users/jguzman/.rvm/gems/ruby-2.0.0-p353/gems/groupdate-2.4.0/lib/groupdate/magic.rb:140:in `rescue in perform'
from /Users/jguzman/.rvm/gems/ruby-2.
PassengerRoot /var/lib/gems/1.9.1/gems/passenger-4.0.23
PassengerDefaultRuby /usr/bin/ruby
PassengerMaxPoolSize 8
PassengerMaxInstancesPerApp 1
require_relative 'open_jdk_6'
packaged :solr, provides: :search do
description 'Apache Solr'
apt 'solr-tomcat'
source "http://archive.apache.org/dist/lucene/solr/#{opts['version']}/apache-solr-#{opts['version']}.tgz" do
archives '/usr/share/solr/archives'
builds '/usr/share/solr/archives'
bundle exec rake test
Running custom db:structure:load from /Users/jdg/Dolan/ssl-master/lib/tasks/databases.rake
DEPRECATION WARNING: ActionDispatch::ShowExceptions.rescue_responses is deprecated. Please configure your exceptions using a railtie or in your application config instead. (called from <top (required)> at /Users/jdg/Dolan/ssl-master/config/environment.rb:14)
# Run options: --seed 62866
Started
ActionController::TestCase
ActionDispatch::IntegrationTest
@jdguzman
jdguzman / gist:6367902
Created August 28, 2013 16:15
webistrano error 2
Problem listing tasks of stage 1: Anonymous modules have no name to be referenced by - /var/www/webistrano/vendor/bundler/ruby/1.9.1/gems/activesupport-2.3.11/lib/active_support/dependencies.rb:611:in `to_constant_name'
/var/www/webistrano/vendor/bundler/ruby/1.9.1/gems/activesupport-2.3.11/lib/active_support/dependencies.rb:417:in `qualified_name_for'
/var/www/webistrano/vendor/bundler/ruby/1.9.1/gems/activesupport-2.3.11/lib/active_support/dependencies.rb:130:in `rescue in const_missing'
/var/www/webistrano/vendor/bundler/ruby/1.9.1/gems/activesupport-2.3.11/lib/active_support/dependencies.rb:120:in `const_missing'
<eval>:3:in `load'
/var/www/webistrano/vendor/bundler/ruby/1.9.1/gems/capistrano-2.6.0/lib/capistrano/configuration/loading.rb:93:in `instance_eval'
/var/www/webistrano/vendor/bundler/ruby/1.9.1/gems/capistrano-2.6.0/lib/capistrano/configuration/loading.rb:93:in `load'
/var/www/webistrano/lib/webistrano/deployer.rb:168:in `block in load_stage_custom_recipes'
/var/www/webistrano/vendor/bundler/rub
@jdguzman
jdguzman / gist:6367883
Created August 28, 2013 16:13
webistrano error
Problem listing tasks of stage 1: Problem loading custom recipe: cannot load such file -- fog - /var/www/webistrano/lib/webistrano/deployer.rb:171:in `rescue in load_stage_custom_recipes'
/var/www/webistrano/lib/webistrano/deployer.rb:165:in `load_stage_custom_recipes'
/var/www/webistrano/lib/webistrano/deployer.rb:119:in `set_up_config'
/var/www/webistrano/lib/webistrano/deployer.rb:292:in `list_tasks'
/var/www/webistrano/app/models/stage.rb:127:in `list_tasks'
/var/www/webistrano/app/controllers/stages_controller.rb:17:in `show'
/var/www/webistrano/vendor/bundler/ruby/1.9.1/gems/actionpack-2.3.11/lib/action_controller/base.rb:1333:in `perform_action'
/var/www/webistrano/vendor/bundler/ruby/1.9.1/gems/actionpack-2.3.11/lib/action_controller/filters.rb:617:in `call_filters'
/var/www/webistrano/vendor/bundler/ruby/1.9.1/gems/actionpack-2.3.11/lib/action_controller/filters.rb:638:in `block in run_before_filters'
/var/www/webistrano/app/controllers/application_controller.rb:24:in `set_timezone'
http://www.senate.mo.gov/13info/BTS_Amendments/default.aspx?SessionType=R&BillID=16944728&__VIEWSTATE=%2FwEPDwUIMjkwOTU5MjYPZBYCAgEPZBYGAgMPDxYCHgRUZXh0BTlTQiAxIC0gTW9kaWZpZXMgdGhlIGxhdyByZWxhdGluZyB0byB3b3JrZXJzJyBjb21wZW5zYXRpb25kZAIHDzwrAAsBAA8WCB4IRGF0YUtleXMWAB4LXyFJdGVtQ291bnQCEx4JUGFnZUNvdW50AgEeFV8hRGF0YVNvdXJjZUl0ZW1Db3VudAITZBYCZg9kFiYCAQ9kFghmD2QWAgIBDw8WAh8ABQI3N2RkAgEPZBYCAgEPDxYCHwAFCzAyMjVTMDIuMTFTZGQCAw9kFgICAQ8PFgIfAAUSMi80LzIwMTMgLSBBZG9wdGVkZGQCBQ9kFgICAQ8PFgIfAAVAMi80LzIwMTMgLSBTQSAxIHRvIFNDUyBTIG9mZmVyZWQgJiBhZG9wdGVkIChSdXBwKS0tKDAyMjVTMDIuMTFTKWRkAgIPZBYIZg9kFgICAQ8PFgIfAAUCNzhkZAIBD2QWAgIBDw8WAh8ABQswMjI1UzAyLjEwU2RkAgMPZBYCAgEPDxYCHwAFFDIvNS8yMDEzIC0gV2l0aGRyYXduZGQCBQ9kFgICAQ8PFgIfAAU2Mi80LzIwMTMgLSBTQSAyIHRvIFNDUyBTIG9mZmVyZWQgKFJ1cHApLS0oMDIyNVMwMi4xMFMpZGQCAw9kFghmD2QWAgIBDw8WAh8ABQI4MGRkAgEPZBYCAgEPDxYCHwAFCzAyMjVTMDIuMDFmZGQCAw9kFgICAQ8PFgIfAAUSMi80LzIwMTMgLSBPZmZlcmVkZGQCBQ9kFgICAQ8PFgIfAAVBMi80LzIwMTMgLSBTQSAxIHRvIFNBIDIgdG8gU0NTIFMgb2ZmZXJlZCAoSG9sc21hbiktLSgwMjI1UzAyLjAxRil
def channels
@channels = {}
chs = Channel.all
@channels["channels"] = chs
chs.each do |ch|
service_id = ch.virgin_id.to_s
now_and_next = Program.where(:service_id => service_id, :end_unix.gte => Time.now.to_i).limit(2)
tmp = []
def channels
@channels = Channel.all
respond_to do |format|
format.xml { render :xml => @channels }
format.json { render :json => @channels }
end
end