Rails Code Quarry

Smooth Scroll Select Menu Jquery Plugin

2011-03-06T00:00:00-08:00

This plugin was created in order to style select tags with extremely large amounts of options.

Features

Changes select and option tags to a ul with lis tied to a hidden input.
Scrolls page down to the top of select to allow the greatest number of options to show on page.
Adds scroll lis to the top and bottom of the list if the list is too big for the page.
Includes click to scroll and hover to scroll behaviors. Hover is the default.
Allows hover to scroll time to be adjusted.
Supports after select and after open callbacks.
Select classes and Id are transferred to new div wrapper.
Mouse wheel will scroll list.
Degrades gracefully when javascript is disabled.

Basic hover to scroll example

$('select.jq_hoverToScroll').jq_smoothScrollSelect();

Change hover scroll speed example

$('select.jq_changeScrollSpeed').jq_smoothScrollSelect({
	scrollTime: 80
});

Click to scroll example

$('select.jq_clickToScroll').jq_smoothScrollSelect({
	scrollEvent: 'click'
});

After open callback example

$('select.jq_afterOpenExample').jq_smoothScrollSelect({
	scrollTime: 200,
	afterOpen: function(wrapper){
		wrapper.find('li').each(function(index, element){
			var colors = ['red', 'white', 'blue']
			$(element).css('background-color', colors[index % 3]);
		})
	}
});

After select callback example

$('select.jq_afterSelectExample').jq_smoothScrollSelect({
	afterSelect: function(clicked_li){
		alert('You selected ' + clicked_li.html() + '!');
	}
});

Small select that doesn’t trigger scroll lis

$('select.jq_smallSelectExample').jq_smoothScrollSelect();

Requirements

Download

On GitHub: https://github.com/BrentW/smooth-scroll-select-menu

Thank You

Karl Swedberg – provided the smooth scrolling functionality.
https://github.com/kswedberg/jquery-smooth-scroll

Kyle Haskins – set the crazy requirements for such a plugin to be created.
http://www.kylehaskins.com

Brandon Dewitt – suggested this code be pluginized.
http://twitter.com/abrandoned

Lightning Fast Sql Selects Via Rails

2009-09-01T00:00:00-07:00

I’ve got this situation. And it calls for lightning fast selects across multiple
tables. Problem is, I’m not familiar with sql commands.

That’s fine. I’ll show you how you can leverage ActiveRecord to do the syntax for you. You know ruby right?

Here’s the gist of what I want:

ranked_list = Character.all.sort do |character_a, character_b|
  character_b.empire.total_cities <=> character_a.empire.total_cities
end

ranked_list[0..9]

If you’re squirming at all, it means you know this looks terrible.
It is. We’re obviously generating a top 10 ranking of characters by total cities.
But we’re doing it in the slowest way possible.

Here’s the resulting log.

  Character Load (0.021489)   SELECT * FROM "characters" 
==> Got Buildings:2000145 from cache. (0.00039)
  Buildings Load (0.001349)   SELECT * FROM "empires" WHERE ("empires"."character_id" = 2000145) LIMIT 1
==> Set Buildings:2000145 to cache. (0.00056)
==> Got Buildings:2000155 from cache. (0.00028)
  Buildings Load (0.000908)   SELECT * FROM "empires" WHERE ("empires"."character_id" = 2000155) LIMIT 1
==> Set Buildings:2000155 to cache. (0.00050)
==> Got Buildings:2000185 from cache. (0.00030)
  Buildings Load (0.000894)   SELECT * FROM "empires" WHERE ("empires"."character_id" = 2000185) LIMIT 1
==> Set Buildings:2000185 to cache. (0.00048)
==> Got Buildings:2000028 from cache. (0.00027)
  Buildings Load (0.000920)   SELECT * FROM "empires" WHERE ("empires"."character_id" = 2000028) LIMIT 1
==> Set Buildings:2000028 to cache. (0.00049)
==> Got Buildings:1840428 from cache. (0.00027)

... etc ... for every character ...

So, we’re instantiating all characters into ruby objects, as well as looping through each one and creating ruby objects for all the empires just to compare the number of cities?

What will your 199,990 active users (who didn’t get on the list) think when their game is interrupted for 10 minutes to give nods to the biggest, go-getting jerks on the system?

Alright. We’ll make it quicker, okay?

ranked_list = Character.find(:all, 
                :limit => 10,
                :order => 'empires.total_cities DESC',
                :joins => :empires
              )

This looks a lot better – prettier too. Find takes several useful options. Hopefully, you’re already aware of the :limit and :order options. If not take some time to glance at find in the api. This page will become very familiar to you…

Gloriously, no sql is needed for simple queries! Find’s :joins key takes symbols (or an array of symbols if you’re joining more than one table) for table names and by default inner joins the tables. Inner joins are usually what you’re after. In this case, an inner join would give me all the characters who already have an empire associated with them.

You may be tempted to use an :include instead of a :joins in this situation. Stick with the :joins for now, and I will exlain later on why the :include is slower.

ActiveRecord also allows for different types of joins, but you need to use a longer route. Say you wanted a list of all characters without the limit and ordered by total cities. You also want all the characters without empires and without cities in the list. This would be a left outer join and would look a lot like:

ranked_list = Character.find(:all, 
                :order => 'empires.total_cities DESC',
                :joins => "LEFT OUTER JOIN empires ON characters.id = empires.character_id"
              )

So you have to spell out some basic sql. Not too hard. For more info on other types of joins, check out The Basic of JOINs from Pinal Dave. As you can see, he’s an authority in this area.

Anyhow, lets look at the log of the previous select.

  Character Load (0.007788)   SELECT "characters".* FROM "characters" LEFT JOIN empires ON characters.id = empires.character_id ORDER BY empires.total_cities DESC LIMIT 10

As the numbers (the 0.007788, etc) indicate, this entire operation runs in about a third of the time as the first trial’s character select. Beyond that, the first trial also has to load all of the empires.

Believe it or not, we can get this faster still. The only data shown on the page, the only data we need, is the characters’ names and city counts. ActiveRecord, was being nice and assumed you wanted all the data columns. Well, we don’t.

It’s easy to change that behavior.

    Character.find(:all, 
      :limit => 10,
      :order => 'total_cities DESC',
      :joins => :empires,
      :select => "empires.character_id, empires.total_cities as total_cities, characters.name, characters.id"
    )

Don’t forget the join needs the character ids from each table to be in the select as well.

I’ll take a moment to clear up the :joins versus :include issue now. Includes are for eager loading. If we eager loaded (through an include) an empire with a character find,

    Character.find(:all, :include => :empires)

when we called that character.empire, rails would magically already have it loaded. No database calls. This sounds good, but the problem is that rails does not apply select statements to eagerly loaded columns. In other words, we’d be loading up the entire empire, not just the city count.

The solution is to select columns on joined column as methods (ie: as total_cities above). This way you can call the method on the character and have it return the value from the joined table. Here, character_instance.total_cities would return the correct number.

You now have the 3 values you needed for a ranking: the order (index in the character array), the name (character.name), and the count (character.total_cities).

Let’s see how the database handled it.

  Character Load (0.002742)   SELECT empires.character_id, empires.total_cities, characters.name, characters.id FROM "characters" INNER JOIN "empires" ON empires.character_id = characters.id ORDER BY empires.total_cities DESC LIMIT 10

Good God! We’ve brought the request down to under 3 milliseconds.

This should give you enough to time to do your ranking by population
and your ranking by soldiers
and your ranking by technology points
and your ranking by kills
and your ranking by economy
and your ranking by hit points
and your ranking by number of collected cracked sashes
and your etc. etc.. etc…

Creating Custom Rails Console Methods

2009-08-26T00:00:00-07:00

Tired of typing the same commands in console every time you
fire it up?

The straw that breaks my back is “Character.find_by_name(‘super_long_nameski’)”

Using method missing, I’m going to make typing super_long_nameski
return its character.

One way to do this is to add methods to your .irbrc or .railsrc file.

However, knowing that everyone in my project will use this code, I’ve
decided to go ahead and add it to the project.

All code in the directory /config/initializers is run when rails starts, so
make a new file there.

/config/initializers/object.rb

  class Object
    def method_missing(*args)
      method = args[0].to_s
      if @controller.class == ApplicationController && #ensures it is in console
      character = Character.find_by_name(method)
          character
        else
          super
        end
      end
    end
  end

Yes, we’re adding a method to all objects; however,
“@controller.class == ApplicationController” ensures it’s being called
on the console main object.

If method_missing finds a character, it returns it. If not or if the command
is called outside of console, it returns the super value (probably an error).

  >> super_long_nameski
  => #<Character id: 2000297, salted_password: "f3a7bc8b40bb0256178", 
  email: "super_long_email@example.com", name: 'super_long_nameski', ...>

Finally!