Crypt keeper decrypted fields in large queries

gistfile1.txt

# Not a very elegant solution. I'd love to build something along these lines but more automated into crypt_keeper when I have more time.

module EncryptionHelper
  def self.mysql_decrypted_field(field_name, options = {})
    options[:as] = "#{field_name.gsub('.','_')}_decrypted" unless options[:as] == false

    decrypt_query = "AES_DECRYPT(from_base64(#{field_name}), '#{MyApp::Application.config.crypt_passphrase}')"
    decrypt_query << " AS #{options[:as]}" unless options[:as] == false

    decrypt_query
  end
end


# Then when building a query...
.select(... other fields ...,
              EncryptionHelper.mysql_decrypted_field('users.first_name'),
              EncryptionHelper.mysql_decrypted_field('users.last_name'),
              EncryptionHelper.mysql_decrypted_field('users.email'),