benmacleod

SELECT s.region_id, s.frequency, s.payment_provider, s.payment_method, s.created_at, s.id, s.email, s.amount_in_local, d.amount_in_local, >
FROM subscriptions s
JOIN donations d ON s.id = d.subscription_id
WHERE d.amount_in_local != s.amount_in_local
AND s.created_at > CURRENT_TIMESTAMP - INTERVAL '3 years'
GROUP BY 1,2,3,4,5,6,7,8,9
ORDER BY 1,2,3,4,5
;

-- Some reasons:

benmacleod

CREATE OR REPLACE FUNCTION yday(time_in TIMESTAMP) RETURNS INTEGER AS $$
DECLARE
  yr INTEGER;
  mnth INTEGER;
  yday INTEGER;
BEGIN
  -- Ensure March 1st and after always have the same day of year across leap-years
  -- by adding 1 to the day of year for months after Feb in non-leap years
  yday := EXTRACT(doy FROM time_in);
  yr := EXTRACT(year FROM time_in);

benmacleod

Master: [DEBUG    Nuvola] master.vala:111: Compositing mode disabled because of WebKitGTK < 2.13.4
Master: [DEBUG      Gtk] Connecting to session manager
Master: [DEBUG    DioriteGtk] DesktopShell.vala:96: Shell: compiz (null), CSD 0, appmenu 1, menubar 0
Master: [DEBUG    Nuvola] WebAppRegistry.vala:169: Found web app Test at /usr/share/nuvolaplayer3/web_apps/test, version 1.0
Master: [DEBUG    Nuvola] WebAppRegistry.vala:169: Found web app 8tracks at /usr/share/nuvolaplayer3/web_apps/8tracks, version 5.1
Master: [DEBUG    Nuvola] WebAppRegistry.vala:169: Found web app Amazon Cloud Player at /usr/share/nuvolaplayer3/web_apps/amazon_cloud_player, version 5.1
Master: [DEBUG    Nuvola] WebAppRegistry.vala:169: Found web app Bandcamp at /usr/share/nuvolaplayer3/web_apps/bandcamp, version 2.1
Master: [DEBUG    Nuvola] WebAppRegistry.vala:169: Found web app Deezer at /usr/share/nuvolaplayer3/web_apps/deezer, version 2.4
Master: [DEBUG    

benmacleod

# Using a datatable as per https://github.com/antillas21/ajax-datatables-rails
app.get '/things'
controller = ThingsController.new
controller.request = app.request
controller.params = ActionController::Parameters.new({search: 'Thing Name'})
datatable = ThingDatatable.new(controller.view_context)
datatable.send(:data)

benmacleod

class Account
  has_many :payment_methods
end

benmacleod

describe 'DELETE #destroy' do
  let(:dummy) { mock('Dummy') }
  it "should find the object with the given ID and destroy it" do
    # set the expectations about the interactions
    Dummy.should_receive(:find).with(99).and_return dummy
    dummy.should_receive(:destroy)
    delete :destroy, id: 99
  end
end

benmacleod

<%= simple_form_for @item do |i| %>
    <%= i.input :name %>
    <%= i.input :description %>
    <%= i.input :price %>
    <%= i.input :zip %> 
    <%= i.input :weight %>
    <%= i.input :volume %>
    <%= i.simple_fields_for :item_images do |image| %>
        <% image.input :image, as: :file %>
    <% end %>

benmacleod

  def self.create_from_parent(parent_type, parent_id, comment_params, current_account)
    parent = parent_type.safe_constantize
    raise ActiveRecord::RecordNotFound unless parent && (parent.reflect_on_association(:comments).klass == self)
    parent.find(parent_id).comments.create(comment_params.merge(account: current_account))
  end

benmacleod

class Contact < ActiveResource::Base
  self.site = 'http://localhost:3000/service/v1/'
  self.user = (a = Account.find(1)).users.first.email
  self.password = a.web_service_key
end

c = Contact.find 1

benmacleod

def password=(password)
  Rails.logger.debug "Called password=#{password}"
  super(password)
end