robertomiranda

##
# Find latest *n* tweets, but don't repeat tweets by users.
# Example:
#
# If we have the following table:
#
# id  |   user_id   |   created_at
# 1   |     1       |     3 days ago
# 2   |     2       |     3 days ago
# 3   |     1       |     2 days ago

robertomiranda

class Tournament < ActiveRecord::Base
    #SELECT "players".* 
    #FROM "players" 
    #WHERE "players"."id" IN (
      #SELECT "players"."id" 
      #FROM "players" 
      #INNER JOIN "pairs" 
      #ON ("pairs"."player_id" = "players"."id" OR "pairs"."partner_id" = "players"."id") AND "pairs"."tournament_id" = 4)
  def player
    players = Player.arel_table

robertomiranda

Rails 3.0.pre on App Engine¶ ↑

You can Rails 3 on App Engine, but it won’t be especially useful until bundler 10. You should try these instead:

• Rails 2.3.5: DataMapper version: gist.github.com/268192

• Rails 2.3.5: TinyDS version: gist.github.com/269075

Install the Development Environment¶ ↑

The gems for the development environment include a pre-release appengine-tools gem that provides a pre-release version of jruby-rack.

robertomiranda

#"SELECT "matches".* FROM "matches" WHERE "matches"."id" 
#IN (
#	SELECT MIN("matches"."id") AS min_id FROM "pairs" INNER JOIN "matches" 
#		ON ("pairs"."player_id" = 14 OR "pairs"."partner_id" = 14) AND ("pairs"."id" =      #"matches"."first_pair_id" OR "pairs"."id" = "matches"."second_pair_id") AND "matches"."winner_pair" IS NULL AND 			#"matches"."wo_pair" IS NULL AND ("matches"."start_date" IS NULL OR "matches"."start_date" >= '2011-10-30 #21:09:48.398210') GROUP BY "matches"."category_id")" 
class Player < ActiveRecord::Base 
 def planning_matches
    matches = Match.arel_table
    pairs = Pair.arel_table
    condition = (pairs[:player_id].eq(self.id).or(pairs[:partner_id].eq(self.id)))
                .and(pairs[:id].eq(matches[:first_pair_id]).or(pairs[:id].eq(matches[:second_pair_id]))

robertomiranda

# Inspired by http://verboselogging.com/2010/07/30/auto-scale-your-resque-workers-on-heroku

module HerokuAutoscale
  module Scaler
    class << self
      @@heroku = Heroku::Client.new(ENV['HEROKU_USER'], ENV['HEROKU_PASS'])

      def workers
        @@heroku.info(ENV['HEROKU_APP'])[:workers].to_i
      end

robertomiranda

def suggested_rivals_facebook
    friend_user_ids = []
    if authentications.size > 0 && authentications.map(&:provider).include?("facebook")
      auth = authentications.where(:provider => 'facebook').map.first
      friends_application = FbGraph::Query.new("SELECT uid FROM user WHERE is_app_user=1 and uid IN (SELECT uid2 FROM friend WHERE uid1 = #{auth.uid})").fetch("#{auth.access_token}")
      friends_application.collect! {|par| par["uid"].to_s}
      friend_user_ids = User.where("authentications.provider" => "facebook").any_in("authentications.uid" => friends_application).not_in("_id" => rivals.map(&:competitor)).map
    end
    friend_user_ids
  end

robertomiranda

#"SELECT "activities".* FROM "activities" WHERE "activities"."member_id" IN (SELECT "members"."id" 
#FROM "members" 
#INNER JOIN "member_followers" ON "member_followers"."following_member_id" = "members"."id" 
#WHERE "member_followers"."follower_id" = 1491)"  

  def time_line
    members = Member.arel_table
    member_followers = MemberFollower.arel_table
    condition=(member_followers[:follower_id].eq(self.id))
    Activity.where(:member_id =>Member.select(members[:id]).joins(:member_followers).on(member_followers[:following_member_id].eq(members[:id])).where(condition))

robertomiranda

require 'net/http'
require 'json'
require "ostruct"

module Facebook
  class Post< OpenStruct
    @@url = "http://graph.facebook.com"
    class << self

      def find(id)

robertomiranda

Factory.define :item do |f|
  include ActionDispatch::TestProcess

  f.name "Macbook Pro 15"
  f.price_in_dollars 1500
  f.photo Rack::Test::UploadedFile.new(File.join(Rails.root, 'spec', 'support', 'rails.png'), 'image/png')
end

robertomiranda

require 'net/http'
require "nokogiri"
require 'open-uri'

module Scrapper
  def get_images_from(url)
    images = []
    doc = Nokogiri::HTML(open(url))
    doc.xpath("/html/body//img[@src[ not(contains(.,'\.gif'))
                                    and contains(.,'://')