Ruby on rails authlogic config (get rid of capitalization check)

Posted by bandhunt on Stack Overflow See other posts from Stack Overflow or by bandhunt
Published on 2010-05-21T05:18:09Z Indexed on 2010/05/21 5:20 UTC
Read the original article Hit count: 357

Filed under:

ruby-on-rails

|

authlogic

|

ruby

The authlogic rails gem is doing a LOWER in the sql query.

SELECT * FROM `users` WHERE (LOWER(`users`.email) = '[email protected]') LIMIT 1

I want to get rid of the LOWER part since it seems to be slowing down the query by quite a bit. I'd prefer to just lower the case in the code since this query seems to be expensive.

I'm not sure where to change this behavior in authlogic.

Thanks!

© Stack Overflow or respective owner

Related posts about ruby-on-rails

Ruby on Rails - How can I start? [closed]

as seen on Programmers - Search for 'Programmers'
I have misconception in understanding the relationship between Ruby language and Ruby on Rails Framework. Because of 'I am an absolute beginner' in web development I have no idea if I have to grasp the fundamentals of Ruby before I go with Ruby on Rails! I also want to ask who is behind both Ruby… >>> More
Ruby on rails: Image downloads with Authentication/Authorization/Time outs

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys, I'm having few doubts on implementing file downloads. I'm creating an app where I use attachment_fu with Amazon s3 to upload files. Things are working pretty well so far on uploading side. Now its the time to start the file downloads. Here is what I need, a logged in user search and browse… >>> More
DES3 decryption in Ruby on Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
My RoR server receives a string, that was encrypted in C++ application using des3 with base64 encoding The cipher object is created so: cipher = OpenSSL::Cipher::Cipher::new("des3") cipher.key = key_str cipher.iv = iv_str key_str and iv_str: are string representations of key and initialization… >>> More
Ruby on Rails deployment, on "thin" server with lot of attachments

as seen on Stack Overflow - Search for 'Stack Overflow'
A lot of PDFs are stored inside MySQL as a BLOB field for each PDF file. The average file size is 500K each. The Rails app will stream the :binary data as file downloads, where there is a user click on the download link. Assume there is a maximum of 5 users downloading 5 PDFs concurrently, what… >>> More
Apply Behavior Driven Development to Ruby on Rails with Rspec

as seen on Internet.com - Search for 'Internet.com'
Applying the Behavior Driven Development (BDD) methodology to your Rails development takes you beyond traditional Test Driven Development. Learn how to do it with the Ruby-based BDD framework RSpec. >>> More

Related posts about authlogic

Authlogic and functional tests - Authlogic::Session::Activation::NotActivatedError: You must activat

as seen on Stack Overflow - Search for 'Stack Overflow'
Im getting the errors below despite following the documentation. In test_helper.rb ENV["RAILS_ENV"] = "test" require File.expand_path(File.dirname(__FILE__) + "/../config/environment") require "authlogic/test_case" require 'test_help' require 'shoulda' require File.dirname(__FILE__) + "/factories" In… >>> More
Problem with Authlogic and Unit/Functional Tests in Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm learning how unit testing is done in Rails, and I've run into a problem involving Authlogic. According to the Documentation there are a few things required to use Authlogic stuff in your tests: test_helper.rb: require "authlogic/test_case" class ActiveSupport::TestCase setup :activate_authlogic end Then… >>> More
"uninitialized constant Authlogic"

as seen on Stack Overflow - Search for 'Stack Overflow'
Just followed the Authlogic tutorial. I am getting "uninitialized constant Authlogic" when I try run the app. After searching, I can see that it has to do with gems/plugins but I can't find a solution. Edit: My UserSession model is: class UserSession < Authlogic::Session::Base end >>> More
Problem with sessions subdomains and authlogic in Rails.

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a rails app with authlogic authentication and a username.domain.com structure built with subdomain-fu. But my session breaks when going from domain.com to username.domain.com. I've tried to add config.action_controller.session = {:domain => '.localhost:3000'} to my development.rb but… >>> More
Session bug using facebook-connect-with-authlogic in Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to follow this article: http://ryanbigg.com/2010/03/testing-facebook, but I'm stuck. I think the problem is with my session, in that the current_usermethod comes up with nil for session[:facebook_session]. According to the original authlogic, it says to use the active_record_store for… >>> More